Optimization of DWH load in 10 steps
Track
Best Practicies & Success Stories
Date and time
Wednesday, 18. October 2023., 12:50
Room
Hall C
Duration
45'
Although the hardware has progressed quite a bit in recent years, the amount of data that is loaded into DWH is getting bigger and bigger every day. With the increase in the amount of data, the time required to load and process that data also increases, once bringing business operation to a critical risk - "time to market" increased drastically.Using examples from practice, I will present you a couple of cases with slow load of daily and monthly data into DWH, and some steps to speed them up - from 3 hours to 20 minutes, and from 16 hours to 2 hours.
Lecture details
About speaker
Dejan Topalović, author
Dejan is an Oracle Certified Master and Oracle ACE. He is working as an independent database consultant - started with MySQL in 1997 and then moved to Oracle in 2003. Dejan has been involved in DBA, design and development work for several multi-national companies on projects ranging from SQL & PL/SQL development, maintaining a couple of hundreds of databases and implementing high availability solutions using Data Guard & RAC. He strives to seize the best features and options out of the Oracle technologies.
T-Shirt Sponsor
Venue Sponsor
Media Sponsor
HrOUG.hr
The conference is organized by the Croatian Association of Oracle users. More about the association can be found at Hroug.hr.