July 2010
Intermediate to advanced
976 pages
30h 19m
English
Content preview from Information Modeling and Relational Databases, 2nd Edition
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
16.9. Summary
Online transaction processing (OLTP) systems are used for typical database applications involving frequent updates and queries. A data warehouse is updated only on a scheduled basis from online sources and is used in read-only mode for enterprise-wide analysis of trends by management. Data marts are departmental subsets derived from the data warehouse but focused on a single subject area. Data marts are often denormalized for performance reasons and are often based on a ”star schema” structure with one central “fact” table, referenced by dimension tables. Data warehouses and data marts are used for Online Analytical Processing (OLAP) and data mining. Often a star schema is used to construct a multidimensional structure, or cube, ...