Skip to main content

A Unified Model and Methodology for Conceptual Database Design

  • Chapter
Book cover On Conceptual Modelling

Part of the book series: Topics in Information Systems ((TINF))

Abstract

The event model integrates a set of data structuring and manipulation primitives with a database schema design and evolution methodology. A number of database research efforts have concentrated on expanding the expressiveness of database modelling mechanisms in order to increase the understandability and usability of database conceptual schemas. The event model includes a simple set of such high-level “semantic” modelling constructs; an associated methodology provides prescriptive assistance in the task of specifying and maintaining a conceptual schema. A primary goal of this approach is to reduce the expertise required to design, evolve, and access databases. An interactive database design and evolution system based upon the event model has been implemented and is in use on an experimental basis.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 84.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 109.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Bell, M.L., D.C. Bixler, M.E. Dyer, “An Extendible Approach to Computer-Aided Software Requirements Engineering,”IEEE Transactions on Software Engineering, Vol. SE-3, No. 1, January 1977.

    Google Scholar 

  2. Brodie, M.L., “On Modelling Behavioural Semantics of Data,”Proc. 7th International Conference on Very Large Databases, Cannes, France, September 1981.

    Google Scholar 

  3. Chen, P.P.S., “The Entity-Relationship Model: Toward a Unified View of Data,”ACM Transactions on Database Systems, Vol. 1, No. 1, March 1976.

    Google Scholar 

  4. Chen, P.P.S.,The Entity-Relationship Approach to Logical Database Design, Monograph No. 6, QED Information Sciences, Wellesley, Mass., 1978.

    Google Scholar 

  5. Codd, E.F., “Extending the Database Relational Model to Capture More Meaning,”ACM Transactions on Database Systems, Vol. 4, No. 4, December 1979, pp. 397–434; IBM Research Report RJ2599, San Jose, Calif., August 1979.

    Google Scholar 

  6. Davis, C.G., C.R. Vick, “The Software Development System,”IEEE Transactions on Software Engineering, Vol. SE-3, No. 1, January 1977.

    Google Scholar 

  7. Earley, J., “Toward an Understanding of Data Structures,”Communications of the ACM, Vol. 14, No. 10, October 1971, pp. 617–627.

    Article  MATH  Google Scholar 

  8. Falkenberg, E.D., “Conceptualization of Data,”Infotech State-of-the-Art Report on Data Design, Pergamon Infotech Limited, London, 1980.

    Google Scholar 

  9. Gapes, C.P., “Data Design in Structured System Analysis,” in P. Freeman, A.I. Wasserman (eds.),Tutorial on Software Design Techniques, 1980.

    Google Scholar 

  10. Housel, B.C., V. Waddle, S.B. Yao, “The Functional Dependency Model for Logical Database Design,”Proc. 5th International Conference on Very Large Databases, Rio de Janeiro, Brazil, October 1979.

    Google Scholar 

  11. King, R., “A Semantics-Based Methodology for Database Design and Evolution,” Ph.D. thesis (Technical Report), Computer Science Dept., Univ. of Southern California, October 1982.

    Google Scholar 

  12. King, R., D. McLeod, “Semantic Database Models,” in S.B. Yao (ed.), Principles of Database Design, Prentice-Hall, Englewood Cliffs, N.J. (to appear).

    Google Scholar 

  13. King, R., D. McLeod, “The Event Database Specification Model,” Proc. Second International Conference on Databases: Improving Usability and Responsiveness, Jerusalem, Israel, June 1982.

    Google Scholar 

  14. King, R., D. McLeod, “A Methodology and Tool for Database Life-Cycle Management,” Technical Report, Computer Science Dept., Univ. of Southern California, November 1982 (submitted for publication).

    Google Scholar 

  15. Mylopoulos, J., P.A. Bernstein, H.K.T. along, “A Language Facility for Designing Interactive Database-Intensive Applications,” ACM Transactions on Database Systems, Vol. 5, No. 2, June 1980, pp. 185–207.

    Article  Google Scholar 

  16. Ross, D.T., “Structured Analysis (SA): A Language for Communicating Ideas,” IEEE Transactions on Software Engineering, Vol. SE-3, No. 1, January 1977.

    Google Scholar 

  17. Rosser, B.J., “Highlights of the History of the Lambda-Calculus,” Conference Record ACM Symposium on Lisp and Functional Programming, Plymouth, Mass., August 1982.

    Google Scholar 

  18. Shipman, D. W., “The Functional Data Model and the Data Language DAPLEX,” ACM Transactions on Database Systems, Vol. 6, No. 1, March 1981.

    Google Scholar 

  19. Smith, J. M., D.C.P. Smith, “Database Abstractions: Aggregation and Generalization,” ACM Transactions on Database Systems, Vol. 2, No. 2, June 1977, pp. 105–133

    Article  Google Scholar 

  20. Smith, J.M., D.C.P. Smith, “Principles of Conceptual Database Design,” Proc. NYU Symposium on Database Design, New York, May 1978.

    Google Scholar 

  21. Su, S. Y. W., D. H. Lo, “A Semantic Association Model for Conceptual Database Design,” Proc. International Conference on the Entity-Relationship Approach to Systems Analysis and Design, Los Angeles, Calif., December 1979.

    Google Scholar 

  22. Teichroew, D., E.A. Hershey, “PSA/PSL: A Computer-Aided Technique for Structured Documentation and Analysis of Information Processing Systems,” IEEE Transactions on Software Engineering, Vol. SE-3, No. 1, January 1977.

    Google Scholar 

  23. Teorey, T.J., J.P. Fry, “The Logical Record Access Approach to Database Design,” Computing Surveys, Vol. 12, No. 2, June 1980.

    Google Scholar 

  24. Wiederhold, G., R. El-Masri, “The Structural Model for Database Design,” Proc. International Conference on the Entity-Relationship Approach to Systems Analysis and Design, Los Angeles, Calif., December 1979.

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 1984 Springer-Verlag New York Inc.

About this chapter

Cite this chapter

King, R., McLeod, D. (1984). A Unified Model and Methodology for Conceptual Database Design. In: Brodie, M.L., Mylopoulos, J., Schmidt, J.W. (eds) On Conceptual Modelling. Topics in Information Systems. Springer, New York, NY. https://doi.org/10.1007/978-1-4612-5196-5_11

Download citation

  • DOI: https://doi.org/10.1007/978-1-4612-5196-5_11

  • Publisher Name: Springer, New York, NY

  • Print ISBN: 978-1-4612-9732-1

  • Online ISBN: 978-1-4612-5196-5

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics