Physical database design system

摘要

A physical database designer which generates a physical database design. The designer follows a process which includes the steps of (a) entering a logical schema representing the database to be designed; (b) entering a hierarchial definition of the workload experienced by the database, which includes, for each level of a hierarchy of operations, a separate specification of workload; and (c) applying expert rules to the logical schema and the workload definition to generate the physical database design.