Performance Management Must Evolve to Meet Changing Data Warehouse Demands
by Craig S. Mullins
As businesses push to reduce the data latency between analytical systems and operational systems, data warehouses begin to take on more of the character of a transactional system. For a data warehouse to deliver near real-
But even if the same data is accessed for both transactional and analytical applications, real-
Another challenge is that many data warehouse queries need to access aggregated data. With a separate data warehouse environment, database administrators can denormalize physical database structures to create aggregate tables, which contain redundant data summarized from other data. The purpose of the aggregate tables is to optimize performance and increase data availability — both noble goals. However, these tables add to the size of the data warehouse and the complexity of managing the environment.
The major relational database systems support aggregation in a more easy-
As data warehouses evolve to meet real-
From Database Trends and Applications, October 2012.
© 2012 Craig S. Mullins,