Entity-Relationship Views over Uninterpreted Enterprise Schemas.

@inproceedings{DBLP:conf/er/Klug79,
  author    = {Anthony C. Klug},
  editor    = {Peter P. Chen},
  title     = {Entity-Relationship Views over Uninterpreted Enterprise Schemas},
  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     = {39-60},
  ee        = {db/conf/er/Klug79.html},
  crossref  = {DBLP:conf/er/79},
  bibsource = {DBLP, http://dblp.uni-trier.de}
}

Abstract

Information models using constructs such as entities and relation-ships give the enterprise administrator high level tools for enterprise description. However, it is still possible that with a diverse group of administrators, managers analysts, programmers, etc., a single information model may not be the one desired by all personnel. In addition, a database management system would be much more flexible if it could offer several conceptual data model options.

This paper shows how a database management system can use an underlying conceptual schema consisting of uninterpreted objects, in this case, relations, key declarations (functional dependencies) and subset constraints to provide semantic views involving entities and relation-ships and a host of other views depending on one's preference.

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]

Dennis Tsichritzis, Anthony C. Klug: The ANSI/X3/SPARC DBMS Framework Report of the Study Group on Dabatase Management Systems. Inf. Syst. 3(3): 173-191(1978)

[3]

Charles W. Bachman, Manilal Daya: The Role Concept in Data Models. VLDB 1977: 464-476

[4]

Giampio Bracchi, Paolo Paolini, Giuseppe Pelagatti: Binary Logical Associations in Data Modelling. IFIP Working Conference on Modelling in Data Base Management Systems 1976: 125-148

[5]

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

[6]

E. F. Codd: A Relational Model of Data for Large Shared Data Banks. Commun. ACM 13(6): 377-387(1970)

[7]

E. F. Codd: Extending the Data Base Relational Model to Capture More Meaning (Abstract). SIGMOD Conference 1979: 161

[8]

Ronald Fagin: Normal Forms and Relational Database Operators. SIGMOD Conference 1979: 153-160

[9]

Patrick A. V. Hall, J. Owlett, Stephen Todd: Relations and Entities. IFIP Working Conference on Modelling in Data Base Management Systems 1976: 201-220

[10]

G. M. Nijssen: A Gross Architecture for the Next Generation Database Management System. IFIP Working Conference on Modelling in Data Base Management Systems 1976: 1-24

[11]

Nick Roussopoulos, John Mylopoulos: Using Semantic Networks for Database Management. VLDB 1975: 144-172

[12]

...

Referenced by

1. Arnon Rosenthal, David S. Reiner: Tools and Transformations - Rigorous and Otherwise - for Practical Database Design. ACM Trans. Database Syst. 19(2): 167-211(1994)
2. Marie Duzi: Semantic Information Connected with Data. ICDT 1992: 376-390
3. Arnon Rosenthal, David S. Reiner: Database Design Tools: Combining Theory, Guesswork, and User Interaction. ER 1989: 187-201
4. Johann A. Makowsky, Victor M. Markowitz, Nimrod Rotics: Entity-Relationship Consistency for Relational Schemas. ICDT 1986: 306-322
5. David S. Reiner, Gretchen Brown, Mark Friedell, John Lehman, Richard McKee, Penny Rheingans, Arnon Rosenthal: A Database Designer's Workbench. ER 1986: 347-360
6. Amílcar Sernadas, Cristina Sernadas: The Use of E-R Abstractions for Knowledge Representation. ER 1985: 224-231
7. Richard Hull: Relative Information Capacity of Simple Relational Database Schemata. PODS 1984: 97-109
8. Marco A. Casanova, Jose E. Amaral de Sa: Designing Entity-Relationship Schemes for Conventional Information Systems. ER 1983: 265-277
9. David S. Johnson, Anthony C. Klug: Testing Containment of Conjunctive Queries Under Functional and Inclusion Dependencies. PODS 1982: 164-169
10. Marco A. Casanova, Ronald Fagin, Christos H. Papadimitriou: Inclusion Dependencies and Their Interaction with Functional Dependencies. PODS 1982: 171-176
11. Marco A. Casanova: A Theory of Data Dependencies over Relational Expressions. PODS 1982: 189-198
12. Peter P. Chen: Recent Literature on the Entity-Relationship Approach. ER 1979: 3-12