LDDM — A structured logical database design methodology
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.
KeywordsProcessing Requirement Database Management System Database Design Requirement Document Type Description
Unable to display preview. Download preview PDF.
- 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.Google Scholar
- Bernstein, Philip A., "Synthesizing Third Normal Form Relations from Functional Dependencies," Transactions on Database Systems, (December 1976).Google Scholar
- 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.Google Scholar
- Hartman, W., Matthes, H., Proeme, A., Management Information Systems Handbook, (New York: McGraw-Hill Book Co., 1968).Google Scholar
- Kahn, Beverly K., "A Method for Describing the Information Required by the Database Design Process," Proceedings of SIGMOD, Washington, D.C., June 1976.Google Scholar
- Kahn, Beverly K., "A Structured Logical Database Design Methodology," Ph.D. Dissertation, The University of Michigan, August, 1979.Google Scholar
- 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.Google Scholar
- 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.Google Scholar
- Teichroew, Daniel, "Improvements in the System Life Cycle," Proceedings of IFIP, Stockholm, August 1974 (Amsterdam: North-Holland Pub. Co., 1974).Google Scholar
- Teichroew, D., and Winters, E., "Recent Developments in System Analysis and Design," ISDOS Working Paper No. 153, University of Michigan, July 1976.Google Scholar