ITOUG Tech Day Milano

Milano – 30th Jan 2019

After four extraordinary events, the Italian Oracle User Group is proud to announce two new events in 2019: 30th Jan Milan, 1st Feb Rome. Two days full of technical content with two parallel Streams Database e Analytics & Big Data! The events are completely FREE!

Scroll Down for full details of the event and subscription!

The Milan event will include presentations from a wide set of exceptional speakers including

The Oracle ACE Directors

  • Christian Antognini (Senior Principal Consultant at Trivadis)
  • Christian Berg (Managing Director of Dimensionality)
  • Heli Helskyaho (CEO of Miracle Finland Oy)
  • Kent Graziano (Chief Technical Evangelist of Snowflake Computing)
  • Michael Rainey (Senior Solutions Architect of Snowflake Computing)

The Oracle ACE and Associate

  • Gianni Ceresa (Managing Director of DATAlysis GmbH) 
  • Francesco Tisiot (BI Tech Lead at Rittman Mead)
  • Nikitas Xenakis (Platfom Specialist-Architect  at Co-op)

The event is made possible by:

Main Sponsor

oracle_logo

ITOUG Partners

mediamente

Logo R1 Group_CMYK

ITOUG Tech Day Milano

Milano – 30 Gennaio 2019

Dopo quattro straordinari eventi, grazie alla vostra partecipazione, l’Italian Oracle User Group è lieto di organizzare altri due eventi quest’inverno: il 30 Gennaio a Milano e il 1 Febbraio a Roma. Entrambi saranno nuovamente dal contenuto prettamente tecnico e la partecipazione sarà ancora una volta completamente gratuita! In entrambi gli eventi saranno presenti gli stream Database e Analytics & Big Data!

Per l’evento a Milano, ci saranno speaker d’eccezione che includono, tra gli altri, gli Oracle ACE Directors

  • Christian Antognini (Senior Principal Consultant at Trivadis)
  • Christian Berg (Managing Director of Dimensionality)
  • Heli Helskyaho (CEO of Miracle Finland Oy)
  • Kent Graziano (Chief Technical Evangelist of Snowflake Computing)
  • Michael Rainey (Senior Solutions Architect of Snowflake Computing)

E gli Oracle ACE e Associate

  • Gianni Ceresa (Managing Director of DATAlysis GmbH) 
  • Francesco Tisiot (BI Tech Lead at Rittman Mead)
  • Nikitas Xenakis (Platfom Specialist-Architect  at Co-op)

L’evento è reso possibile da:

Main Sponsor

oracle_logo

ITOUG Partners

mediamente

Logo R1 Group_CMYK

Informazioni

Data: Mercoledi 30 Gennaio 2019
Luogo: Oracle Italia, Viale Fulvio Testi, 136, 20126 Cinisello Balsamo MI
Prezzo: Gratis! (previa disponibilità posti)

Agenda

Agenda

NOTA: L’agenda è semi-definitiva, potrebbero esserci cambiamenti minori che non altereranno la qualità dell’evento.

Luogo: Oracle Italia, Viale Fulvio Testi, 136, 20126 Cinisello Balsamo MI
Data: Mercoledi 30 Gennaio 2019

Inizio Fine Sessione Durata
08:45 09:15 Registration & Socializing 00:30
09:15 09:30 Messaggio di benvenuto 00:15
09:30 10:15 Lasse Jenssen
Instrumentation 2.0: “Performance is a feature”
00:45
10:15 11:00 Francesco Renne – Donatello Settembrino
Hash Join Use Memory Optimization
00:45
11:00 11:15 Pausa 00:15
11:15 12:00 Heli Helskyaho
Design your databases using Oracle SQL Developer Data Modeler
00:45
12:00 12:45 Christian Antognini
How Well Do Relational Database Engines Support JSON?
00:45
12:45 13:45 Lunch 01:00
13:45 14:30 Dimitri Gielis
Bringing your Oracle Database alive with APEX
00:45
14:30 15:15 Christian Antognini
How Autonomous is the Oracle Autonomous Data Warehouse?
00:45
15:15 15:30 Pausa 00:15
15:30 16:15 Enrico Cairo
Proxy Authentication
00:45
16:15 17:00 Paolo Gaggia – Matteo Mattei
Blockchain beyond the Hype
00:45
17:00 17:15 Conclusione 00:15

Agenda

NOTA: L’agenda è semi-definitiva, potrebbero esserci cambiamenti minori che non altereranno la qualità dell’evento.

Luogo: Oracle Italia, Viale Fulvio Testi, 136, 20126 Cinisello Balsamo MI
Data: Mercoledi 30 Gennaio 2019

Inizio Fine Sessione Durata
08:45 09:15 Registration & Socializing 00:30
09:15 09:30 Messaggio di benvenuto 00:15
09:30 10:15 Gianni Ceresa
Graph Database: from scratch in 45 minutes
00:45
10:15 11:00 Kent Graziano
Introduction to Data Vault 2.0
00:45
11:00 11:15 Pausa 00:15
11:15 11:45 Christian Berg – Francesco Tisiot
Starting an Oracle Analytics Cloud Journey from 0
00:30
11:45 12:00 Joel Acha
Near Real Time Data Warehousing – The Next Frontier
00:15
12:00 12:45 Michael Rainey
Continuous Data Replication into Cloud Storage with Oracle GoldenGate
00:45
12:45 13:45 Lunch 01:00
13:45 14:30 Kent Graziano
Making Sense of Schema-On-Read
00:45
14:30 15:15 Heli Helskyaho
Real life use cases for Machine Learning
00:45
15:15 15:30 Pausa 00:15
15:30 15:55 Graziano Fracasso, Alberto Visentin
From zero to (Advanced) Analytics: a case study
00:25
15:55 16:15 Alessandro Oggianu
From (near) zero to Advanced Database Security: critical issues and common resolution paths
00:20
16:15 17:00 Mirko Menecali, Federico Fontana
Oracle Autonomous DataWarehouse Cloud & Oracle Analytics: A real Italian use case of Autonomous adoption
00:45
17:00 17:15 Conclusione 00:15

Kent Graziano

Kent Graziano is the Chief Technical Evangelist for Snowflake Computing. His is an award winning author, speaker, and trainer, in the areas of data modeling, data architecture, and data warehousing. He is a certified Data Vault Master and Data Vault 2.0 Practitioner (CDVP2), an Oracle ACE Director (Alumni), member of the OakTable Network, expert data modeler and solution architect with more than 30 years of experience, including over two decades doing data warehousing and business intelligence (in multiple industries). He is an internationally recognized expert in Data Vault, Oracle SQL Developer Data Modeler and Agile Data Warehousing. Mr. Graziano has created and led many successful software and data warehouse implementation teams, including multiple agile DW/BI teams. He has written numerous articles, authored three Kindle book (available on Amazon.com), co-authored four books (including the 1st Edition of The Data Model Resource Book), and has given hundreds of presentations, nationally and internationally. He was a co-author on the first book on Data Vault, and the technical editor for Super Charge Your Data Warehouse. In 2014, he was voted one of the best presenters at OUGF14 in Helsinki, Finland. You can follow Kent on twitter @KentGraziano or on his blog The Data Warrior (http://kentgraziano.com).

Gianni Ceresa

Gianni is an OBIEE enthusiast more widely interested in BA/DW/EPM solutions with a special focus on Oracle products and solutions. Oracle ACE, owner of DATAlysis GmbH, a consulting company in Switzerland, he has more than 10 years of experience in multiple project roles like architect, analyst, team lead and developer, bridging together the business and the technical side of the BA world. His other activities include OBIEE/OAC training delivery, R&D, blogging and supporting the Oracle community on the Oracle forums.

Francesco Renne – Donatello Settembrino

I’m an Oracle senior consultant specialized in troubleshooting performance problems. I work in the performance Team of ICTeam – Lutech Group and I also specialized in Oracle instance assessment, database design for good performance, know very well SQL and PL / SQL.

Lasse Jenssen

An Oracle geak which worked as an Oracle DBA (since version 7) for several years, spending a lot of his time firefighting performance issues. Getting tired of the firefighting, he moved from operation towards development, spending his last 10 years working as an database resource in Java projects. The speaker strongly believes that performance is a feature, and must be built into the application. He has several years of experience with using the Oracle end-to-end metrics actively in the daily performance work – both in development and in production.

Dimitri Gielis

Dimitri Gielis is a director of APEX R&D, a company specializing in Oracle Application Express and founder of APEX Office Print (AOP). Dimitri is a frequent presenter at all the major Oracle conferences, an Oracle ACE Director, and received several awards among Oracle APEX Developer of the Year.

Christian Antognini

Christian Antognini is a strong believer that at the core it is all about the data, and on how effectively companies process and take advantage of it. For that reason, since 1995 he has focused on the efficient use of database engines. His main interests include logical and physical database design, query optimizers, and basically everything else related to data processing and 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 databases, he is somewhere lecturing on application performance management or database performance features. In addition to classes and seminars organized by Trivadis, since 2001 he has presented at 100+ conferences and user-group meetings in two dozen countries. He is a proud member of the OakTable Network and is 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/2016).

Geertjan Wielenga

Geertjan is a Principal Product Manager in Oracle, focused on free and open source tools and technologies, such as Oracle JET (oraclejet.org) and Apache NetBeans (netbeans.apache.org). He is based in Amsterdam, the Netherlands.

Joel Acha

Joel has worked with Oracle products throughout his professional career and has spent the last 6 years working as an independent Oracle Analytics Consultant for a variety of clients throughout the UK and Europe. In his spare time, Joel can be found on the Oracle Developer Community and the #obihackers irc channel.

Christian Berg

Working with OBI since the day of nQuire’s acquisition by Siebel Systems in 2001, Christian Berg has 17 years of business analytics project work in all industries. His architect work spans the value chain of business analytics from source systems through ETL, logical modelling, and graphical representation, as well as infrastructure/environment work and dev-ops. Areas of predilection include physical and logical modeling -be it on-prem, in cloud or nowadays also very locally on the desktop. Christian also teaches Oracle Analytics for Oracle University and other integrators and end clients.

Francesco Tisiot

Francesco is the BI Tech Lead at Rittman Mead and an Analytics enthusiast. Analyst, architect and developer, he built expertise in the Data Integration and Business Analytics over the years. He also delivers Oracle trainings for Rittman Mead. Francesco is involved in the Oracle Analytics community by providing support on ODC forums, blogging on the Rittman Mead website, speaking at various conferences – including Kscope and European OUGs – and being part of various Oracle beta program. Fields of expertise : Dimensional Modeling, ETL and Business Analytics, ML.

Michael Rainey

As Senior Solutions Architect at Snowflake Computing, Michael provides technical expertise and training to Snowflake customers. Michael’s expertise in data integration software and methodologies allows him to provide a unique perspective during training and implementation. In his spare time, he enjoys sharing his data integration knowledge on his blog, as a speaker at various other conferences, and via webinars and podcasts. Michael loves the outdoors and enjoys riding his bike along the Columbia River, running, hiking and spending time with his lovely wife and son.

Enrico Cairo

DBA senior Oracle, MySQL e SQL Server, attualmente dipendente di Aubay Italia come focal point dba b.u. Telco e committato in ambito Operation presso data center di importante provider di telecomunicazioni. Gestisco il blog personale http://www.ask-dba-for.info/

Paolo Gaggia
Paolo Gaggia, Solution Architect dedicato all’integrazione di soluzioni software per la gestione e analisi dei dati.Sviluppa nel 2009 interesse per le tecnologie alla base delle cryptovalute e da ormai 3 anni sviluppa le sue conoscenze sulla blockchain vedendone un interessante framework per soluzioni Enterprise. Dal 2004 docente per conto di una delle maggiori multinazionali statunitense comprendo buona parte dei prodotti “Core”.
Matteo Mattei, si è districato per 10 anni nella fitta ragnatela dell’Intelligence Militare come analista per le minacce cibernetiche (Cyber Threat Intelligence Analyst).
Capo dell’Incident Response della Difesa italiana, ha sempre avuto la passione per la crittografia e le architetture di rete complesse e da oramai 4 anni, ha portato le sue conoscenze verso la blockchain, una tecnologia dai contesti non solo puramente tecnici ma con riflessi sociologici e culturali importanti.
Attualmente copre l’incarico di Client Engineer e Blockchain champ presso una delle maggiori multinazionali del settore informatico statunitense.

Graziano Fracasso
Graziano works at Mediamente Consulting – based in Turin – and he is experienced in analytics, both at a back and front end side. By using traditional and new technologies, he fights every day with data to get real insights to our customers. Full stack developer, he knows in depth the whole Oracle environment. Engaged in big data projects to give them a “voice” through new analytical tools.

Alberto Visentin
Alberto works at Mediamente Consulting as Analytics Team Manager. Experienced in project management, previously as Business Intelligence Manager in a manufacturing company, he is focused on covering at best the specific customer needs in terms of insights, analysis, data visualization.

Alessandro Oggianu
Alessandro is an expert database security consultant. In recent years he has participated in several security projects, focusing on Enterprise User Security, Database Vault, Data Encryption and Data Masking. Founder of Janus Professional Services, he collaborates with Mediamente on database security issues, definition of database infrastructures, performance analysis and tuning.

Christian Antognini – How Autonomous is the Oracle Autonomous Data Warehouse?

With its Autonomous Data Warehouse Cloud (ADWC), Oracle promises a self-configuring, fast, secure, and scalable platform for data warehouses. The installation takes place with few mouse clicks, and a much easier development and operation of a data warehouse is assured. Things like upgrades and patches, backups, performance optimization, scaling, indexing and partitioning, materialized views, optimizer statistics, and other “”trivia”” are no longer a concern of the customer.
The marketing statements sound tempting – or scary, depending on the starting position. But what is really behind it? What happens when we run our data warehouses with ADWC? Which tasks are simplified or superfluous? What effects does the self-configuring cloud solution have on database design, ETL processes, and BI queries?
Based on various typical applications from the data warehouse area, we tested the ADWC to know where in the future we still need, or can, influence ADWC and which tasks in the construction and operation of a data warehouse will be eliminated or simplified.
The aim of the presentation is to help prospective customers determine whether it’s worth for them giving it a look or not.”
How Well Do Relational Database Engines Support JSON? “Once upon a time, decent JSON support was provided by NoSQL database engines only. But, since the database engines providing that support missed other critical features, it was difficult to choose a single database engine that provided all the expected features. Times have changed. In fact, today, a number of relational databases provide JSON support. But how good it is?
The aim of this presentation is to review JSON-related features provided by the most commonly used open source and commercial database engines. Challenges and possibilities related to the use of the JSON-related features as well as adherence with the SQL standard is discussed.

Christian Antognini – How Well Do Relational Database Engines Support JSON?
Once upon a time, decent JSON support was provided by NoSQL database engines only. But, since the database engines providing that support missed other critical features, it was difficult to choose a single database engine that provided all the expected features. Times have changed. In fact, today, a number of relational databases provide JSON support. But how good it is?
The aim of this presentation is to review JSON-related features provided by the most commonly used open source and commercial database engines. Challenges and possibilities related to the use of the JSON-related features as well as adherence with the SQL standard is discussed.

Lasse Jenssen – Instrumentation 2.0: “Performance is a feature”
Performance does not happen by accident. Performance is a feature which must be implemented into your application. This presentation will look at how you can instrument your code using Oracle End-to-end metrics. From database version 12c Oracle gives you even more choices, and introduces some new tags, for instance ECID and DBOP. In this presentation we’ll explore how we can use these tags together with the MONITOR hint, the dbms_monitor package and the v$sql_monitor view. Instrumenting your application can easily become the key feature for achieving performance.

Francesco Renne & Donatello Settembrino – Hash Join Memory Optimization
HASH JOIN is one of the two most common methods used by the Oracle engine to resolve Join operation between two tables. The Oracle optimizer has different (not one) access options to solve a HASH JOIN, which is the most performing one from a PGA consumption point of view? The purpose of the presentation is to illustrate the various possible trees used to solve a HASH JOIN and the impact that each of them involves on the consumption of PGA. Some examples will be illustrated on how to correct those situations when the optimizer is misled or downwards estimate the PGA allocation needed to optimize accesses to join operations.

Gianni Ceresa – Graph Database: from scratch in 45 minutes
You often hear theoretical talks about Graph Databases, either with just theory or with some potential use cases. But how to do it for real? How to practically get started with Graph Databases?
This session is going to show you “live” how you can practically get started with Oracle Graph Databases, by going from a sample dataset to creating and loading a graph, to doing analysis on it to get insights into it.
All you need to get started with graph databases by yourself with confidence right after the session.

Geertjan Wielenga – Visualizing and Analyzing Data with Oracle JET
Oracle JavaScript Extension Toolkit (Oracle JET) is Oracle’s free and open source JavaScript toolbox that provides everything you need to quickly and efficiently create dashboards for visualizing and analyzing big data. In this session, you will be introduced to Oracle JET and you’ll see live demos that show you from scratch how to use it to quickly visualize data in your JavaScript applications.

Joel Acha – Near Real Time Data Warehousing – The Next Frontier
Businesses are looking at Analytics as a means of gaining competitive advantage. With the advent of exponentially larger data volumes in conjunction with the increased variety of data sources, there has never been a greater need to provide the ability to access this wealth of information in a timely fashion in order to have an impact on the way these businesses operate and improving operational efficiencies. A number of real time data integration products provide end-to-end automation which quickens the time to market of these solutions within an agile development framework.
The aim of this paper is to provide a high level overview of the need for near real time data warehousing. The paper also aims to debunk the “Data Warehousing is dead” myth.

Christian Berg – Francesco Tisiot – Starting an Oracle Analytics Cloud Journey from 0
Even though cloud solutions are become more pervasive and common, taking the initial step and actually going to the cloud with your analytical solution can seem like a hurdle.
How to get started? What product to choose? Where to get the data from? How to secure things and take them beyond just a personal playground?
This session will lead you through the process of getting started with your Oracle Analytics Cloud solution. You will learn about the options and possibilities of all the current product offerings and be able to have a fully working setup of your own.

Michael Rainey – Continuous Data Replication into Cloud Storage with Oracle GoldenGate

Continuous flow. Streaming. Near real-time. These are all terms used to identify the business’s need for quick access to data. It’s a common request, even if the data must flow from on-premises to the cloud. Oracle GoldenGate is the data replication solution built for fast data. In this session, we’ll look at how GoldenGate can be configured to extract transactions from the Oracle database and load them into a cloud object store, such as Amazon S3. There are many different use cases for this type of continuous load of data into the cloud. We’ll explore these solutions and the various tools that can be used to access and analyze the data from the cloud object store, leaving attendees with ideas for implementing a full source-to-cloud data replication solution.

Kent Graziano – Making Sense of Schema-On-Read

With the increasing prevalence of semi-structured data from IoT devices, web logs, and other sources, data architects and modelers have to learn how to interpret and project data from things like JSON. While the concept of loading data without upfront modeling is appealing to many, ultimately, in order to make sense of the data and use it to drive business value, we have to turn that schema-on-read data into a real schema! That means data modeling! In this session I will walk through both simple and complex JSON documents, decompose them, then turn them into a representative data model using Oracle SQL Developer Data Modeler. I will show you how they might look using both traditional 3NF and data vault styles of modeling.

1. See what a JSON document looks like
2. Understand how to read it
3. Learn how to convert it to a standard data model

Dimitri Gielis – Bringing your Oracle Database alive with APEX

Tired of getting requests to run queries? Ever wondered what the fastest way is to make your data available in a web application? I’ll show you in minutes how you can build an APEX app that can not only filter the data in different ways, but is also able to insert and update the data.

Know what the fastest way is to create your database objects? QuickSQL, I’ll demonstrate this language to let it do all the work for you to create your tables, history and audit columns and much more. Once created we will build an app on top of that.

If you have any question on Oracle APEX, I’m happy to answer it during my session.

 

Heli Helskyaho – Design your databases using Oracle SQL Developer Data Modeler

Oracle SQL Developer Data Modeler is one of the leading database design tools in the market. The amount of data is growing and everybody is starting to understand the value of good quality data for their business. The only way to have good quality data and to understand your data is to design your databases. To be able to design them you need a tool, paper and pen is not enough anymore. What is database designing and how to design databases using Oracle SQL Developer Data Modeler?

Heli Helskyaho – Real life use cases for Machine Learning

Machine Learning is used ”everywhere”. In this presentation we will see some examples of machine learning used in real life. For example how does Facebook use ML, what business areas could take advantage of chatbots and how can Oracle SQL Developer be used to find the potential customers.

Enrico Cairo – Proxy Authentication

Mi capita spesso che mi chiedano di creare utenze individuali in grado di agire su più schemi e sono quindi costretto a fornire permessi potenzialmente dannosi, tipo il ‘drop any table‘.
Questo perché, altrimenti, dovrei fornire permessi puntuali sugli oggetti (es. tutte permettere a ‘jane‘ di accedere in lettura e modifica a tutte le tabelle dello schema ‘john‘), compresi quelli creati successivamente. Per ovviare a problemi quali il drop indesiderato della tabella sbagliata sullo schema sbagliato e venire comunque incontro alle richieste degli utenti di poter accedere ad altri schemi, possiamo sfruttare una caratteristica poco conosciuta ed introdotta con la versione 9i da Oracle, ovvero la proxy authentication. Tale metodo di autenticazione è sicuro e tracciabile e si può risalire facilmente a “chi fa cosa”

Mirko Menecali, Federico Fontana – Oracle Autonomous DataWarehouse Cloud & Oracle Analytics: A real Italian use case of Autonomous adoption
Oracle Autonomous DataWarehouse together with Oracle Data Visualization Desktop and Oracle Analytics Cloud has given us the opportunity to fully exploit the potential of the fidelity card of our Customer, an Italian leader in GDO of Electronic equipments and domestic appliances.
We will present our technical experience & demonstrate on site the difference between analyzing data in Cloud versus on premises”, discussing about data granularity analysis, execution details, speed of analysis, differences in using Oracle Data Visualization or Oracle Analytics and many more from a real use case developed with our Customer’s Marketing data scientist.

Paolo Gaggia, Matteo Mattei – Blockchain beyond the Hype
In questa sessione parleremo della nascita ed evoluzione delle blockchain da Bitcoin fino alle nuove implementazioni Enterprise Oriented. Con l’utilizzo del servizio Oracle Blockchain Cloud vedremo come poter costruire e utilizzare applicazioni enterprise che ne sfruttino le potenzialità e indagheremo sulle problematiche di sicurezza.
Graziano Fracasso, Alberto Visentin – From zero to (Advanced) Analytics: a case study
The “Mediamente Way” to carry out a global project for a radio broadcasting corporation, with the goal to show and leverage real time insights about audience, people engagement, trends etc.

Alessandro Oggianu – From (near) zero to Advanced Database Security: critical issues and common resolution paths
Five Ws and How and Oracle Database Security. How to enable database security in order to be able to answer the 6 basic questions about data access.

Registrazione

Registrations are closed