Session Number: 8108
Track: Big Data & Data Warehousing
Sub-Categorization: Cloud Data Warehouse
Session Type: Tips, Techniques and Tuning
Primary Presenter: Dani Schnider [Senior Principal Consultant - Trivadis AG]
Time: Jun 26, 2019 (03:30 PM - 04:30 PM)
Room: 310, Level 3
Speaker Bio: Dani Schnider works as a senior principal consultant and data warehouse lead architect for Trivadis, a Swiss IT consulting company. He finished his studies in computer science at ETH Zurich in 1990. Since 1994, he has been developing data models and applications with Oracle databases (version 6 to 12c), focusing mainly on data warehousing projects since 1997.
Most of Dani’s time is spent doing jobs for customers in design, data modeling, ETL development, architecture reviews, and performance optimization of Oracle data warehouses. He is the teacher of several Oracle trainings at Trivadis and co-author of the German books Data Warehousing mit Oracle—Business Intelligence in der Praxis (January 2011, ISBN 978-3446425620) and Data Warehouse Blueprints (September 2016, ISBN 978-3446450752).
Dani is an Oracle ACE and writes about data warehousing with Oracle on his blog, publishes articles and white papers, and gives presentations at conferences.
Technologies or Products Used: Oracle Autonomous Data Warehouse Cloud
Session Summary for Attendees: 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 giving it a look or not.