Materialization [database design]

Author

Goldstein, Robert C. ; Storey, Veda C.

Author_Institution

Fac. of Commerce & Bus. Adm., British Columbia Univ., Vancouver, BC, Canada

Volume

6

Issue

5

fYear

1994

fDate

10/1/1994 12:00:00 AM

Firstpage

835

Lastpage

842

Abstract

A new data abstraction, called Materialization, is introduced to model a situation that occurs frequently in the real world and has important implications for database design. Materialization is the relationship between two entity types, one that represents a conceptual object, for example, a TV Model, and one that represents its corresponding concrete objects, in this case, actual TV Sets. The Materialization construct is formally defined and contrasted with other well-known data abstractions. Its design implications are presented in terms of the entity-relationship model and its translation into a relational model. Guidelines are offered for the proper employment of this relationship in database design methodologies, and a discussion is provided of why this constitutes an important data modeling construct

Keywords

data structures; entity-relationship modelling; relational databases; Materialization; TV Model; conceptual object; data abstraction; data modeling construct; database design; entity types; entity-relationship model; relational model; Business; Concrete; Data models; Lattices; Machine learning; Motion pictures; Packaging machines; Pattern recognition; Relational databases; TV;

fLanguage

English

Journal_Title

Knowledge and Data Engineering, IEEE Transactions on

Publisher

ieee

ISSN

1041-4347

Type

jour

DOI

10.1109/69.317711

Filename

317711