article thumbnail

Data Modeling 201 for the cloud: designing databases for data warehouses

erwin

I published my first book in 2003 showcasing how I used Ralph’s technique to create a large data warehouse in the Oracle database. Don’t obstruct the optimizer from seeing it’s a star schema. Many database optimizers recognize the star schema and have code to optimize their execution by orders of magnitude. Operational.