Abstract
The trend of producing databases which do not satisfy organizational requirements can be attributed to the fact that the database designer is required to simultaneously consider many design constraints and does not have a comprehensive methodology to follow. A new decomposition of the logical database design process in which each level satisfies a single design objective is developed. In this decomposition, the requirements process and logical database design process are integrated to ensure that organizational requirements are satisfied. A structured logical database design methodology called LDDM that is based on this decomposition has been developed. LDDM consists of six design steps: Requirements Step, Entity Step, Relationship Step, Entity Structure Step, Refinement Step and DBMS Accommodation Step. LDDM including its constituent steps and techniques is presented. The utilization of LDDM will result in increased designer productivity, better documentation and a high quality logical database.
Preview
Unable to display preview. Download preview PDF.
Bibliography
Aurdal, Eivind, "A Multi-Level Procedure for Design of File Organization," CASCADE Working Paper 36, Institute for Data Base Handling, University of Trudheim, Norway, 6 May 1975.
Bernstein, Philip A., "Synthesizing Third Normal Form Relations from Functional Dependencies," Transactions on Database Systems, (December 1976).
Bubenko, J.A. Jr., Derild, S., Lindencrona-Ohlin, E. and Nachmen, R., "From Information Requirements to DBTG-data Structures," Proceedings of Conference on Data: Abstraction, Definition and Structure, Salt Lake City, Utah, March 1976.
Hartman, W., Matthes, H., Proeme, A., Management Information Systems Handbook, (New York: McGraw-Hill Book Co., 1968).
Kahn, Beverly K., "A Method for Describing the Information Required by the Database Design Process," Proceedings of SIGMOD, Washington, D.C., June 1976.
Kahn, Beverly K., "A Structured Logical Database Design Methodology," Ph.D. Dissertation, The University of Michigan, August, 1979.
Novak, Donald O., and Fry, James P., "The State of the Art of Database Design," Technical Report 76 DE 7, The University of Michigan, August 1976.
Smith, John M., and Smith, Diane C. "Data Base Abstraction," Proceedings of ACM Conference on Data: Abstraction, Definition and Structure, Salt Lake City, Utah, March 1976.
Teichroew, Daniel, "Improvements in the System Life Cycle," Proceedings of IFIP, Stockholm, August 1974 (Amsterdam: North-Holland Pub. Co., 1974).
Teichroew, D., and Winters, E., "Recent Developments in System Analysis and Design," ISDOS Working Paper No. 153, University of Michigan, July 1976.
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1982 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Kahn, B.K. (1982). LDDM — A structured logical database design methodology. In: Yao, S.B., Navathe, S.B., Weldon, J.L., Kunii, T.L. (eds) Data Base Design Techniques I:. DBDT 1978. Lecture Notes in Computer Science, vol 132. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-11214-6_2
Download citation
DOI: https://doi.org/10.1007/3-540-11214-6_2
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-11214-3
Online ISBN: 978-3-540-39051-0
eBook Packages: Springer Book Archive