Architecture of a Highly Scalable Data Warehouse Appliance Integrated to Mainframe Database Systems.
Knut Stolze, Felix Beier, Kai-Uwe Sattler, Sebastian Sprenger, Carlos Caballero Grolimund, Marco Czech · 2011
Main memory processing and data compression are valuable techniques to address the new challenges of data warehousing regarding scalability, large data volumes, near realtime response times, and the tight connection to OLTP. The IBM Smart Analytics Optimizer (ISAOPT) is a data warehouse appliance that implements a main memory database system for OLAP workloads using a cluster-based architecture. It is tightly integrated with IBM DB2 for z/OS (DB2) to speed up complex queries issued against DB2. In this paper, we focus on autonomic cluster management, high availability, and incremental update mechanisms for data maintenance in ISAOPT. 1