Abstract
The design and implementation of data bases involve four major phases: deriving the business model, achieved by analysing the structure of an organisation and its information requirements; the formulation of the conceptual model, achieved by identifying entities, attributes and relationships; the logical mapping of the conceptual model onto the data structure of the target data base management system, and the physical mapping of this model into the access methods and storage structures used by that data base management system. The mapping between phases should be such that there is no loss of information. The accuracy of both the logical and physical mapping determine the performance of the resulting system. This paper describes algorithms and software tools which have been designed to facilitate the implementation of data bases. Some programs help as documentation aids. Others automate aspects of the processes. In particular rules for automatically mapping the conceptual data model to relational data bases are described, and algorithms are developed for implementing these models on Ingres and Mimer. Copies of the programs can be obtained directly from the authors.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Avison, D.E. (1985): Information Systems Development: A Data Base Approach, Blackwell Scientific, Oxford, 1985.
Avison D.E. and Chaudhuri, J (1987): Implementing Codasyl Data Bases: Automating the Mapping Processors, not yet published.
Chaudhuri, J and Esendal, H.T. (1986): A Preprocessor Package to Facilitate Data Base Design, Fourth IASTED International Symposium on Applied Mathematics, Innsbruck.
Chen, P.P.S (1976): The Entity-Relationship Model - Towards a Unified View of Data ACM Transactions on Database Systems, 1, 1, March 1976.
Codasyl (1971): Codasyl Data Base Task Group April 1971 Report, ACM, New York.
Codasyl (1978): Codasyl Data Description Language Journal of Development, Material Data Management Branch, Department of Supply and Services, Ottawa, Ontario.
Lusk, E.L. and Overbeek, R.A. (1981): A Practical Design Methodology for the Implementation of IMS Database using Entity-Relationship Model, ACM-Sigmod International Conference on Management of Data, Santa Monica, May 1981.
Sakai, H (1980): Entity Relationship Approach to the Conceptual Schema Design, ACM-Sigmod International Conference on Management of Data, May 1980.
Severance, D.G and Carlis, J.V (1977): A Practical Approach to Selecting Record Access Paths, ACM Computing Surveys, 9, 4.
Tsao, J.H. (1980): Enterprise Schema: An Approach to IMS Logical Data Base Design, ACM-Sigmod International Conference on Management of Data, May 1980.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 1988 Plenum Press, New York
About this chapter
Cite this chapter
Avison, D.E., Chaudhuri, J. (1988). Implementing Relational Data Bases: Automating the Mapping Processes. In: Benyon, D., Skidmore, S. (eds) Automating Systems Development. Springer, Boston, MA. https://doi.org/10.1007/978-1-4613-1033-4_9
Download citation
DOI: https://doi.org/10.1007/978-1-4613-1033-4_9
Publisher Name: Springer, Boston, MA
Print ISBN: 978-1-4612-8302-7
Online ISBN: 978-1-4613-1033-4
eBook Packages: Springer Book Archive