Storage Layout and I/O Performance in Data Warehouses

8 years 6 months ago
Storage Layout and I/O Performance in Data Warehouses
Defining data placement and allocation in the disk subsystem can have a significant impact on data warehouse performance. However, our experiences with data warehouse implementations show that the database storage layout is often subject to vague or even invalid assumptions about I/O performance trade-offs. Clear guidelines for the assignment of database objects to disks are a very common request from data warehouse DBAs and consultants. We review best practices suggested by storage and database vendors, and present two sets of performance measurements that compare storage layout alternatives and their implications. The first set used a TPC-H benchmark workload with DB2 UDB, the other a star schema/star join scenario with IBM Red Brick Data Warehouse.
Matthias Nicola, Haider Rizvi
Added 31 Oct 2010
Updated 31 Oct 2010
Type Conference
Year 2003
Where DMDW
Authors Matthias Nicola, Haider Rizvi
Comments (0)