An operational data store (or “ODS”) is a database designed to integrate data from multiple sources for additional operations on the data. The data is then passed back to operational systems for further operations and to the data warehouse for reporting. Because the data originates from multiple sources, the
Operational Source Systems are the systems of record that capture the transactions of the business. The source systems are usually different than the data warehouse because presumably we have little to no control over the content and format of the data in these operational legacy systems.
In Ralph Kimball’s book “The Data Warehouse Toolkit” he describes the basic elements of a data warehouse. There are essentially four main components: Operational Source Systems, Data Staging Area, Data Presentation Area, and Data Access Tools. Although Operational Source Systems is part of the model, Kimball states “The source systems should really [...]
- 2,102 feed subscribers
Tags2008 Analysis Analytics Article Big Data Book Business Intelligence Charts Cognos Dashboards Data Data Warehouse Design Dimensional Flow Elements Fusion Tables Google Humor IBM Install Learning Logical Market Microsoft Model Modeling Operational Predictive Programming Python Ralph Kimball Reporting Science Server SQL SSIS Statistics TED Tools Tutorial Unstructured Video Visualization Warehousing Windows