Database design: a survey of logical and physical design techniques

ABSTRACT

This paper summarizes a study conducted by the authors which investigated methodologies presently available to assist in the process of database design. The study also examined the current status of database design in a variety of organizations (manufacturing, financial government, service, and other). The findings show that familiarity with logical design methodologies is fairly high, but that actual use of these techniques is quite low. Familiarity with physical design methodologies is less than that with logical design methodologies and so too is actual use of these physical techniques.

REFERENCES

• 1: Hsiao, D. K., "Data Base Machines Are Coming, Data Base Machines Are Coming!" Guest Editor's Introduction to IEEE Computer Society Computer 12; No. 3: Special Issue on Database Machines (March 1979).
• 2: Beverly K. Kahn, A method for describing information required by the database design process, Proceedings of the 1976 ACM SIGMOD international conference on Management of data, June 02-04, 1976, Washington, D.C.
• 3: Toby J. Teorey , James P. Fry, The Logical Record Access Approach to Database Design, ACM Computing Surveys (CSUR), v.12 n.2, p.179-211, June 1980 [doi>10.1145/356810.356815]
• 4: S. Bing Yao , Shamkant B. Navathe , Jay-Louise Weldon, An Integrated Approach to Database Design, Proceedings of the NYU Symposium on Data Base Design Techniques I: Requirements and Logical Structures, p.1-30, May 01, 1978