Abstract
We describe a tool for physical database design based on a combination of theoretical and pragmatic approaches. The tool takes as input a relational schema, the workload defined on the schema, and some additional database characteristics and produces as output a physical schema. For the time being, the tool is tuned towards Ingres.
Preview
Unable to display preview. Download preview PDF.
References
ADS-manuals version 6.0, Aion Corporation, 1991.
Choenni, R., On the Automation of Physical Database Design, Ph.D thesis, University of Twente, The Netherlands, 1995.
Choenni, R., Blanken, H.M., Chang, S.C., On the Automation of Physical Database Design, In: Proc. ACM/SIGAPP Symp. on Applied Computing 93, 1993, 358–368.
Dabrowski, C.E., Jefferson, K.J., A Knowledge-Based System for Physical Database Design, NBS Special Publication 500-151, 1988, 51p.
Finkelstein, S., Schkolnick, M., Tiberio, P., Physical Database Design for Relational Databases. ACM Trans. on Database Systems 13(1), 1988, 91–128.
Ingres DBA-guide, Alameda, Relational Technology Inc., 1990.
Navathe, S., Ceri, S., Wiederhold, G., Dou, J., Vertical Partitioning Algorithms for Database Design. ACM Trans. on Database Systems 9(4), 1989, 680–710.
Rozen, S., Automating Physical Database Design, Ph.D thesis, University of New-York, USA, 1993.
Shafer, G., A Mathematical Theory of Evidence, Princeton University Press, 1976.
Wagterveld, H., TOPYDE: Een Kennissysteem voor een tool ter ondersteuning van fysiek database ontwerp, M.Sc. thesis, University of Twente, The Netherlands, 1994.
Whang, K., Wiederhold, G., Sagalowicz, D., Separability — An approach to physical database design, In: Proc. 7th Int. Conf on Very Large Data Bases, 487–500, 1981.
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1995 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Choenni, S., Wagterveld, H., Blanken, H.M., Chang, T. (1995). TOPYDE: A tool for physical database design. In: Revell, N., Tjoa, A.M. (eds) Database and Expert Systems Applications. DEXA 1995. Lecture Notes in Computer Science, vol 978. Springer, Berlin, Heidelberg. https://doi.org/10.1007/BFb0049147
Download citation
DOI: https://doi.org/10.1007/BFb0049147
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-60303-0
Online ISBN: 978-3-540-44790-0
eBook Packages: Springer Book Archive