Diagram of a generic star schema with a central fact table, three representative dimension tables, and two representative materialized views. Dimensions, levels, and attributes are instantiated in dimension tables. Measures are instantiated in fact tables and materialized views. The fact table is related to the dimension table through their primary keys. The materialized views are for a particular combination of levels.