Chapter 6
Star Schema Template
The star schema represents data as facts that are bound to dimensions. A fact measures the performance of a business or some aspect of a business; examples include sales, budget, revenue, profit, and inventory. A dimension specifies one of the bases for facts; examples include date, location, product, customer, and salesperson.
The star schema is the usual approach to data warehouse applications. A data warehouse takes the disjointed, functional applications of a business and integrates them, putting their data in one database and storing data in a common format for reporting purposes. The simple structure of the star schema makes it easier to write ad-hoc queries that mine data and gain insight into an enterprise. ...
Get Patterns of Data Modeling now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
