ITOUG Tech Day
Milano – 8 Giugno 2017
Lo scorso 8 Giugno l’Italian Oracle User Group ha promosso la terza edizione del suo Tech Day che, per l’occasione ha visto due streams distinti: Database e BI & Analytics. L’evento, della durata di una giornata, ha dato priorità come al solito al contenuto tecnico e ha visto la partecipazione di speaker di fama internazionale. Ancora una volta, la partecipazione è stata completamente gratuita!
Stream Database: Christian Antognini (Senior Principal Consultant, Trainer and Partner at Trivadis, Oracle ACE Director), Ludovico Caldara (Senior Consultant at Trivadis, Oracle ACE Director), Francesco Renne (CEO at ICTeam SpA, Oracle Specialist), Gerald Venzl (Senior Principal Product Manager presso Oracle Corporation, direttamente da Redwood Shores!), Franck Pachot (Oracle ACE Director e Technology Leader presso dbi-services) e Donatello Settembrino (Oracle Specialist, ICTeam Spa).
Stream BI & Analytics: Hans Viehmann (Product Manager EMEA presso Oracle Corporation), Gianni Ceresa (Managing Director at DATAlysis Gmbh), Christian Berg (Oracle ACE, Managing Director at Dimensionality), Federico Venturin (Consultant presso Rittman Mead), Marco Vignoli (Business Analytics Team Leader presso Iconsulting S.p.A.), Roberto Falcinelli (Business Analytics Sales Consulting Senior Manager presso Oracle) e Francesco Coccia (Manager at Reply Technology).
L’evento (sale conferenze e catering) è stato sponsorizzato da:
|Data:||Giovedì 8 Giugno 2017|
|Luogo:||UNA Hotel Century, Via Fabio Filzi, 25/b, 20124 Milano|
|Prezzo:||Gratis! (previa disponibilità posti)|
NOTA: L’agenda è semi-definitiva, potrebbero esserci cambiamenti minori che non altereranno la qualità dell’evento.
Luogo: Una Hotel Century, Via Fabio Filzi, 25/b, 20124 Milano
Data: Giovedì 8 Giugno 2017
|Inizio||Fine||Stream Database||Stream BI & Analytics||Durata|
|08:45||09:15||Registration & Socializing||00:30|
|09:15||09:30||Messaggio di benvenuto||00:15|
|09:30||10:15||[ITA] AWR Analysis
Francesco Renne (CEO at ICTeam SpA, Oracle Specialist)
|[ITA] How to Cook a BI Story
Federico Venturin (Consultant at Rittman Mead)
|10:15||11:00||[ENG] What’s new for developers in Oracle Database 12c Release 2
Gerald Venzl (Senior Principal Product Manager at Oracle Corporation)
|[ITA] Oracle Analytics Cloud: The most comprehensive analytics in the cloud
Roberto Falcinelli (Business Analytics Sales Consulting Senior Manager at Oracle)
|11:15||12:00||[ITA] Indexes: Structure, Splits and Free Space Management Internals
Christian Antognini (Senior Principal Consultant, Trainer and Partner at Trivadis, Oracle ACE Director)
|[ENG] Graph Databases and Graph Analytics – Just a Hype or the End of the Relational World?
Hans Viehmann (Product Manager EMEA at ORACLE Corporation)
|12:00||12:45||[ITA] Oracle Client Failover – Under The Hood
Ludovico Caldara (Senior Consultant at Trivadis, Oracle ACE Director)
|[ITA] Geospatial Analytics su OBIEE per l’analisi del rischio, la simulazione e il monitoraggio del territorio
Marco Vignoli (Business Analytics Team Leader at Iconsulting S.p.A.)
|13:45||14:30||[ITA] Adaptive Cursor Sharing (ACS), Extended Cursor Sharing (ECS) and Cardinality/Statistics feedback
Donatello Settembrino (Oracle Specialist at ICTeam SpA)
|[ITA] Data Visualization on Hana – OBIEE 12c and SAP Hana Integration
Francesco Coccia (Manager at Reply Technology)
|14:30||15:15||[ENG] Single-Tenant in 12.2: the multitenant features without option
Franck Pachot (Technology Leader at dbi-services, Oracle ACE Director)
|[ITA] OBIEE DevOps with Containers: How and Why
Gianni Ceresa (Managing Director at DATAlysis GmbH)
|15:30||16:15||[ENG] Supercharge your code to get optimal Database performance
Gerald Venzl (Senior Principal Product Manager at Oracle Corporation)
|[ENG] Doing Oracle Analytics Cloud or on-premises this way? STOP IT!
Christian Berg (Managing Director at Dimensionality, Oracle ACE)
|16:15||17:00||[ITA] Approximate Query Processing
Christian Antognini (Senior Principal Consultant, Trainer and Partner at Trivadis, Oracle ACE Director)
|[ITA] (Still) No Silver Bullets: OBIEE 12c Performance in the Real World
Federico Venturin (Consultant at Rittman Mead)
Since 1995, Christian Antognini has focused on understanding how the Oracle database engine works. His main interests include logical and physical database design, the integration of databases with Java applications, the query optimizer and basically everything else related to application performance management. He is currently working as a senior principal consultant and trainer at Trivadis in Zürich, Switzerland. If Christian is not helping one of his customers get the most out of Oracle, he is somewhere lecturing on application performance management or new Oracle Database features for developers. In addition to classes and seminars organized by Trivadis, he regularly presents at conferences and user-group meetings. He is a proud member of the OakTable Network and an Oracle ACE Director. Christian is the author of Troubleshooting Oracle Performance (Apress, 2008/2014) and the co-author of Der Oracle DBA (Hanser, 2011).
Working with Oracle Analytics since the day of nQuire’s acquisition by Siebel Systems in 2001, Christian Berg has 16 years of business analytics experience in all industries. His architect work spans the value chain of business analytics from source systems through ETL/streaming, physical or logical modeling and graphical representation as well as infrastructure/environment work, performance tuning, platform sanity reviews and dev-ops. Christian also teaches for Oracle University and other integrators.
Ludovico is a database specialist with more than 16 years of experience on the full Oracle stack (Clusterware, DataGuard, RAC, ASM, EM) but he also has deep knowledge of MySQL and other DBMS engines. He has administered literally thousands of databases in big datacenters so he has developed a natural leaning to automatization, monitoring and high availability. He is certified on Oracle (OCP 12c, OCE) and MySQL (OCP). He is a blogger and a confirmed community contributor, with the “RAC Attack 12c” project and his RACSIG, ITOUG and SOUG board membership. Ludovico is currently working as a senior consultant at Trivadis in Lausanne, Switzerland, where he can cultivate his passion for technology, bike, snowboard and family.
An OBIEE enthusiast more widely interested in BI/DW/EPM solutions with a special focus on Oracle products and solutions. Owner of DATAlysis GmbH, a consulting company in Switzerland, he has more than 8 years of experience in multiple project roles like architect, analyst, team lead and developer, bridging together the business and the technical side of the BI world. His other activities include OBIEE training delivery, R&D, blogging and supporting the Oracle community on the OTN forums.
Francesco is a Manager for Technology Reply.
He started working on major projects involving Oracle architectures in 2007 and Oracle Business Intelligence has always been a key platform in its job. He designed solutions around OBIEE with a focus on the user experience whose requirements are well known by Francesco thanks to the big experience learned “on the field”. Since 2015 he leads the Big Data & Machine Learning Business Unit.
He lives in a peaceful town near Turin with his beloved family (guitars included).
Joined Oracle in October 1997, held during the years various pre-sales positions inside the Technology Sales Business Unit, always focusing on supporting and developing the business on Oracle Business Intelligence & Data Warehousing products.
He helped to successfully design and sell Analytics Solutions to important customers in several industries and presented Oracle Business Analytics solutions to internal and external events and conventions.
Across the years, he has been recognized as a reliable and respected technical and functional reference point on Business Analytics topic, inside the company and even beyond the country level.
Currently responsible for pre-sales activities in the country, leading a group of specialists, supporting the sales of the wide Oracle Business Analytics product portfolio, spanning from Business Intelligence and Data Visualization to Big Data Discovery and Analytics, to Real Time Decisioning solutions.
Franck has over 20 years of experience in Oracle databases in all areas from development, data modeling, performance, administration and training. Oracle Certified Master 11g and 12c and Oracle ACE Director, he is also co-author of Oracle 12cR2 Multitenant (Oracle Press).
Franck blogs (blog.pachot.net) and he is active on Twitter (https://twitter.com/FranckPachot)
Francesco was born in 1962 in Como, Italy. He studied computer sciences at the University of Milan, and after graduating, he joined Olivetti, working on the development of the Unix operating system. Francesco has been interested in performance since the beginning of his professional career and has worked on Unix internals and Oracle environments in order to achieve the best possible performance in different environments (new products, benchmarks, international real applications on production, and so on). In 1994, he joined the Banca Popolare di Bergamo, the only bank in Italy that has rewritten its entire information system using Unix and Oracle. He has made major contributions to improve performance over the whole platform. In 1999, he co-founded ICTeam and is now the company’s CEO. He continues to work on performance, especially on Oracle data warehouse environments, for some of the largest companies in Italy. Francesco lives near Bergamo, Italy, with his wife, Adria, and their two daughters, Viola and Veronica. When not striving to improve something, he enjoys staying with his family, listening to progressive music, and taking pictures.
Donatello è un consulente specializzato in risoluzione di problemi legati alle performance su Database Oracle. Dopo avere maturato una pluriennale esperienza come sviluppatore software, nel 2001 ha intrapreso l’attività di consulente nell’ambito delle performance Oracle a partire dalla versione 8i.
Dal 2013 è parte attiva del Performance Team di ICTeam Spa, si occupa prevalentemente di tematiche connesse all’ottimizzazione delle prestazioni e al database design. Vivo è il suo interesse nel seguire le costanti evoluzioni del Query Optimizer Oracle per studiarne le peculiarità e verificarne al meglio le modalità di applicazione.
Federico è un Business Intelligence Consultant presso Rittman Mead, in Inghilterra.
Lavora in ambiente Business Intelligence dal 2010 con particolare attenzione ad Oracle BIEE. Si occupa della progettazione, configurazione, implementazione e collaudo di piattaforme di Data Warehousing e Business Intelligence, con particolare attenzione allo sviluppo di dashboard attraenti e alla ricerca di soluzioni per migliorare la user experience.
Nel tempo libero ama leggere, viaggiare e provare cibi nuovi.
Gerald Venzl is a Senior Principal Product Manager for Oracle. During his career he has worked as a Developer, DBA, Performance Tuner, Software Architect, Consultant and Enterprise Architect prior to his current role. This allowed Gerald to live several different lives in the IT sector, providing him with a solid understanding of the concerns in those individual areas while gaining a holistic view overall. In his current role, Gerald focuses on evangelizing how to build systems that provide flexibility yet still meet the business needs.
Hans Viehmann is working for ORACLE Corporation as Product Manager for the Oracle Spatial and Graph technologies both on the database as well as the Big Data platforms.
He holds a degree in Physics from Hamburg University and started his career in Research before joining ORACLE over twenty years ago. After various positions in Presales and Business Development he joined the Product Management Team in 2011 and since then represents the Oracle Spatial and Graph Development Team in Europe, Middle East and Africa. In this role he is looking after strategic projects and partnerships, the marketing activities, as well as the internal awareness around the Spatial and Graph technologies in the region. He is working closely with various Oracle User Groups and helped establish Spatial and Graph Special Interest Groups in several countries. He is a regular speaker at conferences and user group events and serves on the advisory board of InGeoForum, Germany.
Marco is a Business Analytics Team Leader for ICONSULTING, since 2010 he has been working on several Data Warehousing, Business Intelligence and Geospatial Analytics projects on both Public and Private sector, covering different industries including utilities, telco, facility management, manufacturing, transportation, public safety, healthcare, social services, betting and gaming.
Indexes: Structure, Splits and Free Space Management Internals
The most common redundant access structure used in relation databases is a B-tree index. This holds true also for Oracle Database.
But, despite the common usage of B-tree indexes, a number of misconceptions and myths surrounds them. The aim of this
presentation, after reviewing some basic concepts, is to explain in detail how Oracle Database carries out splits and reuses
Approximate Query Processing
There are situations where approximate results are superior to exact results. It’s for example the case with exploratory queries or when results are displayed in a visual manner that don’t convey small differences.
Oracle Database 12.2 introduces a number of functions as well as a query transformation that allows an application to take advantage of the new features without requiring code changes.
The aim of this presentation is to describe how the approximate query processing capabilities works.
Doing Oracle Analytics Cloud or on-premises this way? STOP IT!
Turning the standard best-practice/how-to presentation format on its head, this presentation will look at some real-life OACS or OBI implementations and where it all went wrong. We’ll look at the worst, the weirdest, the most absurd and the wackiest ways the Oracle Analytics tool is abused: – How did projects get to these points? – What were the original misconceptions? – How to counter these misconceptions? – Why are “it works” and “it fulfills the requirements” not only not enough but rather dangerous pitfalls? – Can I actually jeopardize the future of my BI system by choosing a cheap quick and dirty approach? – Is it ever OK to simply execute without comprehension?
This session will give attendees a deeper understanding of the impact seemingly innocuous design and implementation decisions can have on the stability and success of an entire Analytics system. An end-to-end view of the stack will be taken, covering areas including logical modelling, analysis design, and architectural topics. The importance of a holistic view and an appreciation of alternatives will be emphasized as well as the need to understand, comprehend and reflect on the implications of a “best practice” being followed as well as the technology stack simply being misunderstood. Attendees will be in a position to better weigh and judge implementation options knowing their long-term effect and impacts in terms of – user experience – performance – upgrade capability – ease-of-use – reproduciblity – overall ROI
Oracle Client Failover – Under The Hood
Are your Oracle databases highly available? You have deployed Real Application Clusters (RAC), DataGuard, or Failover Clusters and are well protected against server failures? Great – the prerequisites for a highly available environment are given. However, to assure that backend infrastructure failures also remain transparent to the client, an appropriate configuration is a prerequisite.
This lecture will discuss the Oracle technologies that can be used to achieve automatic client failover functionality. What are the advantages, but also the limitations of these technologies?
OBIEE DevOps with Containers: How and Why
Provisioning developers’ sandboxes or regression testings and continuous integration in OBIEE, some common DevOps tasks which often take time and resources. Containers technology provides a quick and flexible answer to these growing needs and as opposed to virtual machines require less resources (storage and memory). You will learn about containers (Docker) and how OBIEE can fit into it and be managed easily to fulfil these common tasks. Having nightmares thinking at your next upgrade or patch? OBIEE in a container can be a solution for having sweet dreams every night. Need a new sandbox for the new feature you are developing? One command, 5-10 minutes and you are ready to go. Works both on prem and cloud (OCCS or others).
Data Visualization on Hana – OBIEE 12c and SAP Hana Integration
Data Visualization is the “swiss army knife” provided by Oracle to the Business
It is equipped with many connectors out of the box… but SAP Hana!
We experienced a couple of ways to integrate Hana in an Oracle-based
Data Visualization System using ODI 11g and OBIEE 12c. We believe you will be
more than curious to discover how we answered to a common question: how can I
leverage the analytic power of Oracle BIEE & Oracle DV by connecting them to
Hana as a data source?
Oracle Analytics Cloud: The most comprehensive analytics in the cloud
Oracle Analytics Cloud is a single platform that empowers your entire organization to ask any question of any data using any device in any environment.
Collaborative, creating collective intelligence from people, places, and machines to power proactive analytics and change the way you work
Connected, bringing the power of your data and analytics to every process, interaction, and decision, anytime, anywhere
Complete, meeting your needs with comprehensive capabilities, from self-service data discovery to powerful predictive analytics, enterprise-class reporting, and easy what-if analysis
Choice, putting you in charge of your data and your destiny with analytics at any scale, in any environment – cloud, premises, or both
Single-Tenant in 12.2: the multitenant features without option
Multitenant architecture is available without multitenant option. Let’s have a look at the overhead and the new features so that you can choose among single-tenant or non-CDB. Agility in Data Movement, Easy flashback, Fast upgrade. Let’s show the features that will change your mind.
Come comprendere lo stato di salute di un database attraverso il report AWR:
• dal macroscopico (sistema e database) al microscopico (singola query o singolo evento di wait)
• vantaggi e limiti del report AWR
• come accorgersi se un database è malato
• AWR e ASH, l’unione fa la forza
Adaptive Cursor Sharing (ACS), Extended Cursor Sharing (ECS) and Cardinality/Statistics feedback
Da quali parametri sono regolati i comportamenti di Adaptive Cursor Sharing, Extended Cursor Sharing e Cardinality feedback?
Come varia il loro comportamento al variare dei valori degli hidden parameter a loro riservati? cosa succede in presenza o
assenza di istogrammi? Cardinality/Statistics Feedback può influenzare il comportamento di ACS (Adaptive Cursor Sharing)/ECS
(Extended Cursor Sharing) ? Ci sono comportamenti differenti tra la versione 11g e la nuova 12c? La presentazione cercherà
di chiarire i vari comportamenti fornendo i risultati di un test case.
How to Cook a BI Story
Bad dashboard design can have a profound impact on user adoption and overall system performance. Unfortunately, the standard practice for laying out most dashboards and reports is often to simply fit everything on the page in muddled mass of information.
This presentation looks at the process of building a BI story from scratch in OBIEE. It discusses good practices for understanding end user requirements, selecting meaningful content, creating effective visualisations, and designing attractive dashboard layouts. It includes discussion of suboptimal practices and features that should be avoided with additional emphasis on designing layouts that also work on mobile devices, and automating the whole process using web services.
(Still) No Silver Bullets: OBIEE 12c Performance in the Real World
Are you involved in the design and development of OBIEE systems and want to know the best way to go about ensuring good performance? Maybe you’ve an existing OBIEE system with performance “challenges” that you need to diagnose?
This presentation looks at the practical elements of diagnosing the causes of performance issues in OBIEE, and discusses good practices to observe when developing new systems. It includes discussion of OBIEE 12c and with additional emphasis on analysis of Usage Tracking data for the accurate profiling and diagnosis of issues.
What’s new for developers in Oracle Database 12c Release 2
With the rise of the cloud, databases can be provisioned and are ready to go with just a few clicks. No more waiting for hardware or having to configure a database first—the cloud provides all of that within seconds. What becomes much more important is what you can actually do with databases in the cloud. Why is it different to use Oracle Database in the cloud compared with any other database? It is what you can build on top of Oracle Database that makes it the #1 database in the cloud and on premises. In this session, you will learn what innovations Oracle has put into the next generation of Oracle Database that make it not only the best-of-breed database in the cloud but also in your application.
Supercharge your code to get optimal Database performance
Everybody agrees that programming languages are lightning-fast and powerful. Yet performance quickly hits a bottleneck when a database is part of the stack. For years and years, databases have been seen as the slow, monolithic back ends that limit your application’s throughput. Yet the reality is that most of the time, it is the code interacting with the database that limits your throughput. Autocommit, parallelization at the wrong level, and too many network round-trips are some of the culprits that will limit your throughput. Yet all of those can easily be avoided with some simple tricks and refactoring of your code. In this session, learn how to apply tricks that will supercharge your application. Never wait for a reply from your DBA again.
Graph Databases and Graph Analytics – Just a Hype or the End of the Relational World?
Graph databases have become increasingly popular over the last few years, largely because graph structures are highly flexible and provide a simple and intuitive way of modeling data which subsequently can be queried easily. In graph databases data is held in a graph consisting of a set of nodes with links between them rather than keeping data records in tables as is the case in relational technologies. Since 2015 Oracle offers a graph database based on the concept of property graphs as part of Oracle Big Data Spatial and Graph. The actual data store can either be Oracle NoSQL or Apache HBase and an in-memory engine for data analysis is delivered with the product. For data access it uses an API based on the open source Apache Tinkerpop project, which has evolved into the industry standard in these kinds of environments. Besides this it includes a query language which is designed for pattern matching and comes with a large number of algorithms for graph analysis already built-in.
In this paper we will explain the fundamentals of property graph databases and highlight use cases in which property graph implementations are superior to relational technologies. Besides looking into the architecture and query language of Oracle Big Data Spatial and Graph we will show which kinds of applications can benefit from specific algorithms. We will cover the conversion of relational tables to graph structures, as well as the visualization of property graph data using commercial and open source tools. And finally, we will look into a series of benchmarks based on typical datasets which have been conducted against similar technologies.
Geospatial Analytics su OBIEE per l’analisi del rischio, la simulazione e il monitoraggio del territorio
La soluzione di Location Intelligence sviluppata per una azienda leader nel settore delle utility consente di analizzare il patrimonio informativo aziendale (asset lineare) arricchito con dati esterni (demografia ISTAT, punti di interesse, eventi naturali, …) allo scopo di individuare il potenziale impatto sulla popolazione in caso di incidenti.
Partendo dall’analisi della situazione reale, la piattaforma di analytics implementata supporta la definizione guidata di scenari di simulazione, per analizzare gli effetti del cambiamento delle condizioni sottostanti il modello di rischio sociale, tramite ad esempio la variazione da parte dell’utente della posizione dei tratti dell’asset lineare o delle condizioni fisiche che li caratterizzano, oppure la presenza di nuovi edifici popolati (es. ospedali) nelle vicinanze.
Inoltre, è disponibile una funzionalità di creazione automatica di nuovi scenari simulati, ottenuti mediante l’applicazione di un algoritmo di ottimizzazione a partire da uno scenario esistente (Prescriptive Analytics), in cui è possibile specificare i vincoli (parametri) su cui basare l’elaborazione.
La soluzione consente infine di svolgere un’analisi di confronto tra due scenari presenti a sistema, evidenziando le differenze esistenti in termine di maggiore o minore rischio sociale, e fornisce cruscotti di monitoraggio dell’evoluzione temporale.
Questa piattaforma, che integra in un unico ambiente funzionalità di Linear Referencing System, Spatial analysis e Advanced Analytics, è rivolta ad un target di utenti decisori che si occupano di asset planning, fornendo la possibilità di ridurre il rischio sociale individuando e intervenendo sulle principali criticità della propria rete lineare, tenendo in considerazione sia la probabilità di incidenti (determinata dalle caratteristiche fisiche della rete) sia le possibili conseguenze, considerando quindi il territorio circostante e la popolazione residente e gravitante.
L’architettura tecnologica adottata si basa su uno stack full Oracle: Oracle Database 12c, Oracle Spatial and Graph, Oracle Fusion Middleware MapViewer, e Oracle Business Intelligence Enterprise Edition 12c.