DB2 Design Advisor: Integrated Automatic Physical Database Design

The DB2 Design Advisor in IBM® DB2® Universal Database™ (DB2 UDB) Version 8.2 for Linux®, UNIX® and Windows® is a tool that, for a given workload, automatically recommends physical design features that are any subset of indexes, materialized query tables (also called materialized views), shared-nothing database partitionings, and multidimensional clustering of tables. Our work is the very first industrial-strength tool that covers the design of as many as four different features, a significant advance to existing tools, which support no more than just indexes and materialized views. Building such a tool is challenging, because of not only the large search space introduced by the interactions among features, but also the extensibility needed by the tool to support additional features in the future. We adopt a novel “hybrid” approach in the Design Advisor that allows us to take important interdependencies into account as well as to encapsulate design features as separate comp...

• Type: Conference
• Year: 2004
• Where: VLDB
• Authors: Daniel C. Zilio, Jun Rao, Sam Lightstone, Guy M. Lohman, Adam J. Storm, Christian Garcia-Arellano, Scott Fadden
• Keywords: Database, DB2 Design Advisor, Design Advisor, Tool, VLDB 2004