Managing Data in Motion

Chapter 16

Data Warehousing with Real-Time Updates

Information in this Chapter

Corporate information factory 

Operational data store 

Master data moving to the data warehouse 

Interview with an expert: Krish Krishnan on real-time data warehousing updates 

Corporate information factory

Bill Inmon defines a data warehouse as “a subject-oriented, integrated, time-variant, nonvolatile collection of data in support of management’s decision-making process” (Inmon, 1992). Data warehouses are usually populated periodically (daily, weekly, or monthly) with updates and snapshots from the master data and transaction processing applications in the organization. Figure 16.1 depicts the architecture of a data warehouse and business intelligence solution that ...