Abstraction Capabilities and Invariant Properties Modelling within the Entity-Relationship Approach.

@inproceedings{DBLP:conf/er/ScheuermannSW79,
  author    = {Peter Scheuermann and
               Gerd Schiffner and
               H. Weber},
  editor    = {Peter P. Chen},
  title     = {Abstraction Capabilities and Invariant Properties Modelling within
               the Entity-Relationship Approach},
  booktitle = {Entity-Relationship Approach to Systems Analysis and Design.
                Proc. 1st International Conference on the Entity-Relationship
               Approach},
  publisher = {North-Holland},
  year      = {1979},
  isbn      = {0-444-85487-8},
  pages     = {121-140},
  ee        = {db/conf/er/ScheuermannSW79.html},
  crossref  = {DBLP:conf/er/79},
  bibsource = {DBLP, http://dblp.uni-trier.de}
}

Abstract

The E-R model provides a good framework for the modelling of a conceptual schema for a database. One drawback of the original model was its lack of capability to express abstractions. We show in this paper that not only aggregates and generalization, but also relationships between relationships, can be incorporated quite naturally in the original model.

Next, we further enhance the E-R model with a number of intensional constructs necessary to express several elementary integrity constraints. In this class of intensional constructs, we include partial and total relationships and weak relationships of two types. Associated with these intensional constructs are different invariant properties which must be preserved during update operations. We show that the type of update operation and the type of invariant property (i.e. intensional construct) uniquely determine the way updates may propagate through the database. Finally, we show that within the module concept where data and operations are defined together, we also have the capability to automatically enforce the sequence of operations due to invariant properties.

ACM SIGMOD Anthology

• Windows: Click the letter of your CD drive
  A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
• Mac: Click here
• UNIX/LINUX: mount the CD and click on the path of your mount point:
  /Anthology/An2-1 or /cdrom

• Windows: Click the letter of your CD drive
  A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
• Mac: Click here
• UNIX/LINUX: mount the DVD and click on the path of your mount point:
  /Anthology/aDVD1 or /dvd

References

[1]

...

[2]

Peter P. Chen: The Entity-Relationship Model - Toward a Unified View of Data. ACM Trans. Database Syst. 1(1): 9-36(1976) BibTeX

[3]

Peter P. Chen: The Entity-Relationship Model - A basis for the Enterprise View of Data. AFIPS National Computer Conference 1977: 77-84 BibTeX

[4]

Michael Hammer, Dennis McLeod: The Semantic Data Model: A Modelling Mechanism for Data Base Applications. SIGMOD Conference 1978: 26-36 BibTeX

[5]

Larry Kerschberg, Anthony C. Klug, Dennis Tsichritzis: A Taxonomy of Data Models. VLDB 1976: 43-64 BibTeX

[6]

...

[7]

...

[8]

Gerd Schiffner, Peter Scheuermann: Multiple Views and Abstractions with an Extended-Entity-Relationship Model. Comput. Lang. 4(3-4): 139-154(1979) BibTeX

[9]

Hans Albrecht Schmid, J. Richard Swenson: On the Semantics of the Relational Data Model. SIGMOD Conference 1975: 211-223 BibTeX

[10]

John Miles Smith, Diane C. P. Smith: Database Abstractions: Aggregation. Commun. ACM 20(6): 405-413(1977) BibTeX

[11]

John Miles Smith, Diane C. P. Smith: Database Abstractions: Aggregation and Generalization. ACM Trans. Database Syst. 2(2): 105-133(1977) BibTeX

[12]

John Miles Smith: Comments on the paper "Data Base Design in Theory and Practice" by Bo Sundgren. VLDB Surveys 1978: 31-32 BibTeX

[13]

...

[14]

Herbert Weber: Modularity in Data Base System Design: A Software Engineering View of Data Base Systems. VLDB Surveys 1978: 65-91 BibTeX

[15]

S. Bing Yao, Shamkant B. Navathe, Jay-Louise Weldon: An Integrated Approach to Database Design. Data Base Design Techniques I 1978: 1-30 BibTeX