Some aspects of a physical database design and reorganisation tool (PDRT)

摘要

In the last few years there have been many attempts at automating database but very few of them have paid more than lip service to performance issues. Algorithms and methods are available for performance related aspects of design such as index selection, clustering of data and query optimisation. However, these are scattered widely through the literature. The tool described in this paper aims to bring these together in a single coherent approach to database design which complements logical design tools from other sources. The paper describes a method for capturing user requirements on a database and converting them into a load graph representation which can be used for data placement by a physical database design and reorganisation tool (PDRT).