A Framework for Automating Physical Database Design

  title={A Framework for Automating Physical Database Design},
  author={Steve Rozen and Dennis Shasha},
We propose a two-pha.se algorithm for physical database design. In phase one the algorithm, for each logical query, loses rules to determine characteristics of a physical design (such as indexes) that would be beneficial to the query, and selects a physical design that yields a low cost estimate for that query. In phase two we use a notion of compromase between physical database designs. St,arting from the physical designs selected in phase one, the algorit,hm looks for a compromise physical… CONTINUE READING
Highly Cited
This paper has 42 citations. REVIEW CITATIONS


Publications referenced by this paper.
Showing 1-10 of 21 references

Int,egrat,ing a knowledge-based component into a physical dat,abase design system

  • C. E. Dabrowski, D. I. Jefferson, J. V. Ca.rlis, S. T. Ma.rch
  • Info. & Mnnnge?,real,
  • 1989

An object-oriented database system for .engineering applica.tions

  • A. Kernper, P. C. Lockemann, M. Wallrath
  • In SIGMOD,
  • 1987

Freyt.ag. A rule-ba.sed view of query opt.imization

  • J C.
  • In SIGMOD,
  • 1987

Similar Papers

Loading similar papers…