COMPUTER-AIDED PHYSICAL DATABASE DESIGN METHODOLOGY.

J. V. Carlis, S. T. March

Research output: Contribution to journalArticlepeer-review

14 Scopus citations

Abstract

A methodology to aid in the task of physical database design is described. The methodology provides a multiple level descriptive model for formally expressing logical database problems and their physical solutions and a set of software procedures to aid in the design process. The logical structure and volume of the data and the user processing requirements are input to the design software which interactively generates alternative database schemes, transform user processing requirements into activities on those schemas, produces efficient access paths to support these activities and supports the selection of a database design from among those produced. Output from the software is a database design and an estimate for the operating cost of that design. The software itself is comprised of a combination of heuristic, probabilistic estimation and mathematical optimization procedures.

Original languageEnglish (US)
Pages (from-to)198-214
Number of pages17
JournalComputer performance
Volume4
Issue number4
StatePublished - Jan 1 1983

Fingerprint Dive into the research topics of 'COMPUTER-AIDED PHYSICAL DATABASE DESIGN METHODOLOGY.'. Together they form a unique fingerprint.

Cite this