Entity-Relationship Approach to the Conceptual Schema Design.

Hirotaka Sakai: Entity-Relationship Approach to the Conceptual Schema Design. SIGMOD Conference 1980: 1-8

@inproceedings{DBLP:conf/sigmod/Sakai80,
  author    = {Hirotaka Sakai},
  editor    = {Peter P. Chen and
               R. Clay Sprowls},
  title     = {Entity-Relationship Approach to the Conceptual Schema Design},
  booktitle = {Proceedings of the 1980 ACM SIGMOD International Conference on
               Management of Data, Santa Monica, California, May 14-16, 1980},
  publisher = {ACM Press},
  year      = {1980},
  pages     = {1-8},
  ee        = {http://doi.acm.org/10.1145/582250.582252, db/conf/sigmod/Sakai80.html},
  crossref  = {DBLP:conf/sigmod/80},
  bibsource = {DBLP, http://dblp.uni-trier.de}
}

BibTeX

Abstract

The purpose of this paper is to present a systematic approach to the conceptual schema design. The entity-relationship model is used as the conceptual schema model. The entity-relationship schema, a formal description of the model, is defined to explicitly state the dependency structures such as the functional dependencies, the transitive dependencies, and the hierarchical decompositions. Based upon the analysis of these structural properties, the schema is iteratively transformed into the refined form. The notion of the access weight matrix is also introduced as a measure to evaluate the schemas.

Copyright © 1980 by the ACM, Inc., used by permission. Permission to make digital or hard copies is granted provided that copies are not made or distributed for profit or direct commercial advantage, and that copies show this notice on the first page or initial screen of a display along with the full citation.

ACM SIGMOD Anthology

Online Version (ACM WWW Account required): Full Text in PDF Format

CDROM Version: Load the CDROM "Volume 1 Issue 2, SIGMOD '75-'92" and ...

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/smod7592 or /cdrom

DVD Version: Load ACM SIGMOD Anthology DVD 1" and ...

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

BibTeX

Printed Edition

Peter P. Chen, R. Clay Sprowls (Eds.): Proceedings of the 1980 ACM SIGMOD International Conference on Management of Data, Santa Monica, California, May 14-16, 1980. ACM Press 1980 BibTeX
Contents

Online Edition: ACM Digital Library

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]: ...
[4]: ...
[5]: Claude Delobel: Normalization and Hierarchical Dependencies in the Relational Data Model. ACM Trans. Database Syst. 3(3): 201-222(1978) BibTeX
[6]: Hirotaka Sakai: A Unified Approach to the Logical Design of a Hierarchical Data Model. ER 1979: 61-74 BibTeX
[7]: Jorma Rissanen: Independent Components of Relations. ACM Trans. Database Syst. 2(4): 317-325(1977) BibTeX
[8]: Peter Scheuermann, Gerd Schiffner, H. Weber: Abstraction Capabilities and Invariant Properties Modelling within the Entity-Relationship Approach. ER 1979: 121-140 BibTeX

Referenced by

Hirotaka Sakai, Hajime Horiuchi: A Method for Behavior Modeling in Data Oriented Approach to System Design. ICDE 1984: 492-499
Tzyy-Long Jiang, Y. H. Chin: A Friendly Logical Database Design Tool for the Humming-Bird System. ICDE 1984: 526-533
Hirotaka Sakai: Entity-Relationship Approach to Logical Database Design. ER 1983: 155-188
Ben Shneiderman, Glenn Thomas: An Architecture for Automatic Relational Database System Conversion. ACM Trans. Database Syst. 7(2): 235-257(1982)
Hirotaka Sakai: A Method for Defining Information Structures and Transactions in Conceptual Schema Design. VLDB 1981: 225-234
Hirotaka Sakai, Hidefumi Kondo, Zenshiro Kawasaki: A Development of a Conceptual Schema Design Aid in the Entity-Relationship Model. ER 1981: 411-428
Asuman Dogac, Peter P. Chen: Entity-Relationship Model in the ANSI/SPARC Framework. ER 1981: 357-374
Ilchoo Chung, Fumio Nakamura, Peter P. Chen: A Decomposition of Relations Using the Entity-Relationship Approach. ER 1981: 149-171

BibTeX

ACM SIGMOD Anthology - DBLP: [Home | Search: Author, Title | Conferences | Journals]