A categorical entity-relationship model of databases

Author

Bleyberg, Maria Zamfir

Author_Institution

Dept. of Comput. & Inf. Sci., Kansas State Univ., Manhattan, KS, USA

fYear

1991

fDate

3-5 Apr 1991

Firstpage

156

Lastpage

166

Abstract

The major objective of the author is to develop a highly abstract model for databases: the categorical entity-relationship (CER) model. This model is based on a unified view of the entity-relationship and relational database models. Central to the CER model is the concept of an entity-relationship (ER) object. The concept of a key defines the identity of an ER-object. An ER-object with an atomic key represents a database entity; an ER-object with a composite key represents a database relationship. The concept of a schema represents the type of an ER-object. Operations are defined on ER-objects. The role is to define the structure of a database, to update a database, and to derive information from a database. This model provides a sufficiently rich basis for designing and implementing entity-relationship and relational databases as object-oriented systems

Keywords

database theory; object-oriented databases; relational databases; CER model; ER-object; atomic key; categorical entity-relationship; composite key; database entity; database relationship; highly abstract model; object-oriented systems; relational database models; schema; Algebra; Application software; Data models; Database systems; Design automation; Erbium; Object oriented databases; Object oriented modeling; Product design; Relational databases;

fLanguage

English

Publisher

ieee

Conference_Titel

Applied Computing, 1991., [Proceedings of the 1991] Symposium on

Conference_Location

Kansas City, MO

Print_ISBN

0-8186-2136-2

Type

conf

DOI

10.1109/SOAC.1991.143868

Filename

143868