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, ...

Get Information Modeling and Relational Databases, 2nd Edition 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.