NASA Logo

NTRS

NTRS - NASA Technical Reports Server

Back to Results
A structure-based model of semantic integrity constraints for relational data basesData base management systems (DBMSs) are in widespread use because of the ease and flexibility with which users access large volumes of data. Ensuring data accuracy through integrity constraints is a central aspect of DBMS use. However, many DBMSs still lack adequate integrity support. In additon, a comprehensive theoretical basis for such support the role of a constraint classification system - has yet to be developed. This paper presents a formalism that classifies semantic integrity constraints based on the structure of the relational model. Integrity constraints are characterized by the portion of the data base structure they access, whether one or more relations, attributes, or tuples. Thus, the model is completely general, allowing the arbitrary specification of any constraint. Examples of each type of constraint are illustrated using a small engineering data base, and various implementation issues are discussed.
Document ID
19870049922
Acquisition Source
Legacy CDMS
Document Type
Reprint (Version printed in journal)
External Source(s)
Authors
Rasdorf, William J.
(North Carolina State Univ. Raleigh, NC, United States)
Ulberg, Karen J.
(North Carolina State University Raleigh, United States)
Baugh, John W., Jr.
(Carnegie-Mellon University Pittsburgh, PA, United States)
Date Acquired
August 13, 2013
Publication Date
January 1, 1987
Publication Information
Publication: Engineering with Computers
Volume: 2
Issue: 1 19
ISSN: 0177-0667
Subject Category
Computer Programming And Software
Accession Number
87A37196
Funding Number(s)
CONTRACT_GRANT: NAG1-503
CONTRACT_GRANT: NAG1-604
Distribution Limits
Public
Copyright
Other

Available Downloads

There are no available downloads for this record.
No Preview Available