Chapter 11Modeling for Analytical Databases
Key Skills & Concepts
• Modeling Analytical Data Structures
• Loading Data into Analytical Databases
Before we look at data modeling for analytical databases, a conceptual overview is in order. Starting in the 1980s, businesses recognized the need for keeping historical data and using it for analysis to assist in decision making. It was soon apparent that data organized for use by day-to-day business transactions was not as useful for analysis. In fact, storing significant amounts of history in an operational database (a database designed to support the day-today transactions of an organization) could have serious detrimental effects on performance. William H. (Bill) Inmon ...
Get Data Modeling, A Beginner's Guide 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.
