Adjoined Dimension Column Clustering (ADC Clustering) to Improve Data Warehouse Query Performance

Data warehouses are typically made up of multiple star schemas, called data marts. A star schema, with a central Fact table and four dimension tables. Queries on star schemas usually restrict columns in the dimension tables to retrieve rows from the central fact table. Star Schemas were first devised by Red Brick Systems to speed up queries on data loaded from operational databases at intervals of about a day, with no updates between loads. Variant designs (allowing some updates) were adopted by Oracle, DB2, Sybase IQ and recently Vertica.