UKOUG Apps 18 Conference, Liverpool

UKOUG Technology Conference 2018 - Liverpool, 3 - 5 December

I will be speaking at the UKOUG Tech18 conference on Tuesday 4th December.

How Not to Build a Data Warehouse: There are features in the Oracle database that are specifically designed to optimize the performance of data warehouse queries. If get you data model correct, and therefore you build your data warehouse according to the generally accepted principles of good data warehouse design, then you should naturally take advantage of them. If you don't, then the database is likely to have to do a lot more work to execute your queries. In this session, we will look at star-schemas, star transformation and bloom filters. We will look at how they work, and taking examples from real life, what sort of thing is often done that stop the database using these optimisations.