Skip to main content
SpringerLink
Log in

Relative constraints in ER data models

  • Conference paper
  • First Online:
Book cover Entity-Relationship Approach — ER '93 (ER 1993)

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 823))

Included in the following conference series:

Abstract

Practical extensions to the Entity-Relationship (ER) model to support inter-entity constraints, referred to as relative constraints, are described and analyzed. Relative constraints are business model integrity constraints and rules captured in the business analysis. They specify existence and value relations among predicates. The constraints are specified in a proposed declarative language based on First Order Logic. They can then be translated into the relational algebra and SQL.

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

Access this chapter

Log in via an institution

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Ackley, D., Carasik, R., Soon, T., Tyron, D., Tsou, E., Tsur, S., and Zaniolo, C., “Systems Analysis for Deductive Database Environments: an Enhanced Role for Aggregate Entities,” Proceedings of the 9th International Conference on the Entity Relationship Approach, Lausanne, Oct. 8–10, 1990, pp. 129–142.

    Google Scholar 

  2. Baumann, Peter., “Valences: A New Relationship Concept for the Entity-Relationship Model,” Proceedings of the 8th International Conference on the Entity Relationship Approach, Toronto, Oct. 18–20, 1989, pp. 218–231.

    Google Scholar 

  3. Borgida, Alexander., “Language Features for Flexible Handling of Exceptions in Information Systems,” ACM Transactions on Database Systems, Vol. 10, No. 4, December 1985, pp. 565–603

    Article  Google Scholar 

  4. Cazin, J., Jacquart, R., and Michel, P., “An Extension of the Entity-Relationship Model using the First Order Logic,” Proceedings of the 4th International Conference on the Entity Relationship Approach, Chicago, IEEE Computer Society Press, Silver Springs, Maryland, 1985, pp. 216–233.

    Google Scholar 

  5. Ceri, S., Gottlob, G., and Tanca, L., “What You Always Wanted to Know About Datalog (And Never Dared to Ask)”, IEEE Transactions on Knowledge and Data Engineering, Vol. 1, No. 1, March 1989.

    Google Scholar 

  6. Chen, P.P., “The Entity-Relationship Model — Toward a Unified View of Data.”, ACM Transactions on Database Systems, Vol.1, No. 1, March 1976, pp. 9–36.

    Article  Google Scholar 

  7. Codd, E.F., “Extending the Relational Database Model to Capture More Meaning,” ACM Transactions on Database Systems, Vol. 4, No. 4, Dec. 1979, pp. 397–434.

    Article  Google Scholar 

  8. Codd, E.F., The Relational Model for Database Management-Version 2, Addison-Wesley Publishing, 1990.

    Google Scholar 

  9. Davis, James P. and Bonnell, Ronald D., “Modeling Semantics with Concept Abstraction in the EARL Data Model”, Proceedings of the 8th International Conference on Entity Relationship Approach, Toronto, Oct. 18–20, 1989, pp. 102–117.

    Google Scholar 

  10. Hainaut, J. “A Generic Entity-Relationship Model”, IFIP 1989, Elsevier Science Publishers B. V., E.D. Falkenberg and P. Lindgreen (Editors).

    Google Scholar 

  11. Jagannathan, D., et. al., “SIM: A Database System Based on the Semantic Data Model”, ACM Publication 0-89791-268-3, 1988, pp. 46–55.

    Google Scholar 

  12. KnowledgeWare ADW Analysis Workstation User's Guide, KnowledgeWare Incorporated, 1992 [To be published].

    Google Scholar 

  13. Lazimy, Rafael., “E2R Model and Object-Oriented Representation For Data Management, Process Modeling, and Decision Support,” Proceedings of the 8th International Conference on the Entity Relationship Approach, Toronto, October 18–20, 1989, pp. 136–156.

    Google Scholar 

  14. Maier, D., Stein, J., Otis, A., Purdy, A., “Development of an Object-Oriented DBMS”, OOPSLA 1986 Proceedings, September 1986, pp.472–482.

    Google Scholar 

  15. Malhotra, A., et. al., “An Entity-Relationship Programming Language,” IEEE Transactions on Software Engineering, Vol. 15, No. 9, September 1989, pp. 1120–1130.

    Article  Google Scholar 

  16. Oren, Olc., “Integrity Constraints in the Conceptual Schema Language SYSDOC”, Proceedings of the 4th International Conference on the Entity Relationship Approach, Chicago, IEEE Computer Society Press, Silver Springs, Maryland, 1985, pp. 288–294.

    Google Scholar 

  17. Qian, Xiaolei and Wiederhold, Gio, “Data Definition Facility of CRITIAS,” Proceedings of the 4th International Conference on the Entity Relationship Approach, Chicago, IEEE Computer Society Press, Silver Springs, Maryland, 1985, pp. 46–55.

    Google Scholar 

  18. Rochfeld, A., Morejon, J., and Negros, P., “Inter-Relationship Links in E-R Model”, Baumann, Peter., “Valences: A New Relationship Concept for the Entity-Relationship Model,” Proceedings of the 9th International Conference on the Entity Relationship Approach, Lausanne, Oct. 8–10, 1990, pp. 143–156.

    Google Scholar 

  19. Schunck, B., Laird, J.E., Durfee, E, “Course Notes: Introduction to Artificial Intelligence”, University of Michigan, Department of Electrical Engineering and Computer Science, 1989.

    Google Scholar 

  20. Shipman, David, “The Functional Data Model and te Data Language DAPLEX,” ACM Transactions on Database Systems, Vol. 6, No. 1, March 1981, pp. 140–173.

    Article  Google Scholar 

  21. SQL Language Reference Manual, ORACLE, Version 5.1.

    Google Scholar 

  22. Su, S.Y.W. “SAM*: A Semantic Association Model for Corporate and Scientific-Statistical Databases,” Journal of Information Sciences 29, 1983, pp. 151–199.

    Article  Google Scholar 

  23. Su, S.Y.W., Krishnamurthy, V., and Lam,H. “An Object-Oriented Semantic Association Model OSAM*,” Artificial Intelligence Manufacturing Theory and Practice, S. Kumara et al (eds.), American Institute of Indus. Engr., 1989, Chap. 17, pp. 463–494.

    Google Scholar 

  24. Sudkamp, N. and Kandzia, P., “Enforcement of Integrity Constraints in a Semantic Data Model,” CSL 88 — 2nd Workshop on Computer Science Logic Proceedings, 1989, pp. 313–328.

    Google Scholar 

  25. Teorey, T.J., Yang, D., and Fry, J.P., “A Logical Design Methodology for Relational Databases Using the Extended Entity-Relationship Model,” ACM Computing Surveys, Vol. 18, No. 2, 1986, pp. 197–222.

    Article  Google Scholar 

  26. Teorey, T.J., Database Modeling and Design-The Entity-Relationship Approach, Morgan-Kaufmann Publishers, Inc., 1990.

    Google Scholar 

  27. Ullman, J., Principles of Database and KnowledgeBase Systems-Volume 1, Computer Science Press, 1988.

    Google Scholar 

  28. Wei, G. and Teorey, T.J., “The ORAC Model: A Unified View of Data Abstractions,” Proceedings of the 10th International Conference on the Entity Relationship Approach, San Mateo, California, USA, Oct. 23–25, 1991, pp. 31–58.

    Google Scholar 

  29. Winter, K.A., “Virtual Fact Names,” Private Communication, 1991.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. KnowledgeWare, USA

    James B. Behm

  2. University of Michigan, USA

    Toby J. Teorey

Authors
  1. James B. Behm
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Toby J. Teorey
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Ramez A. Elmasri Vram Kouramajian Bernhard Thalheim

Rights and permissions

Reprints and permissions

Copyright information

© 1994 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Behm, J.B., Teorey, T.J. (1994). Relative constraints in ER data models. In: Elmasri, R.A., Kouramajian, V., Thalheim, B. (eds) Entity-Relationship Approach — ER '93. ER 1993. Lecture Notes in Computer Science, vol 823. Springer, Berlin, Heidelberg. https://doi.org/10.1007/BFb0024356

Download citation

  • DOI: https://doi.org/10.1007/BFb0024356

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-58217-5

  • Online ISBN: 978-3-540-48575-9

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation