Make Your Oracle Data Warehouse Fast: Comparing Performance Features
Track
Baza podataka i infrasturktura
Datum i vrijeme
srijeda, 18. listopad 2023., 11:00
Dvorana
Dvorana B
Trajanje
45'
For many developers, creating indexes is the preferred method to improve the performance of SQL queries. But in data warehouses, this is not the only solution – and often not the best one. Typical queries in a data warehouse are different to those in OLTP systems. This has an impact on the strategy for performance tuning.This presentation gives an overview of the common performance features for Oracle data warehouses: Partitioning, bitmap indexes, materialized views and the In-Memory option. Each of these features has different benefits for good performance. Combined properly, they can help to reduce load times and improve query performance in data warehouses.With examples and live demos, you will see how you can setup a fast and modern data warehouse with Oracle technology.
Detalji o predavanju
O predavaču
Dani Schnider, autor
Dani Schnider works as Principal Oracle & DWH Consultant for Callista, a Swiss IT service provider for consulting and engineering. He has been working in database consulting for over 20 years, from 1999 to 2022 for Trivadis in Switzerland. Dani works with Oracle databases since 1994, since 1997 mainly in data warehouse projects. His tasks include DWH architecture reviews, data modeling, ETL development and performance optimization in Oracle databases. Dani is Oracle ACE Director and co-author of the books Data Warehousing mit Oracle ? Business Intelligence in der Praxis and Data Warehouse Blueprints, both published in German by Hanser-Verlag. On his blog, he writes about design and performance topics related to Oracle data warehouses. He is a regular speaker at international Oracle user group conferences.
T-Shirt pokrovitelj
Pokrovitelj lokacije
Medijski pokrovitelj
HrOUG.hr
Konferenciju organizira Hrvatska udruga Oracle korisnika. Više o udruzi možete saznati na Hroug.hr.