About cookies on this site Our websites require some cookies to function properly (required). In addition, other cookies may be used with your consent to analyze site usage, improve the user experience and for advertising. For more information, please review your options. By visiting our website, you agree to our processing of information as described in IBM’sprivacy statement. To provide a smooth navigation, your cookie preferences will be shared across the IBM web domains listed here.
Publication
INDIN 2003
Conference paper
Trends in automating physical database design
Abstract
A database administrator (DBA) must make many decisions about what is the best decision for a database and its users including what is the best physical DB design decision, The DBA must determine what auxiliary data structures to create such as indexes and materialized views as well as the optimal way to partition each table in a shared-nothing partitioned system, to maximize workload performance while minimizing any increase in disk space or maintenance costs. Given the number oj possible configurations. the possible interactions between each choice, and the associated constraints on the decision, the problem of selecting an optimal design is daunting for even the most skilled DBA. It has long been recognized that DBAs need tools to help them make these complex decisions, but until recently little progress was made. In this paper, we present our vision for the future of automating physical DB design, and contrast it with previous attempts at solving this problem.