Database analysis and design
Extending the database relational model to capture more meaning
ACM Transactions on Database Systems (TODS)
Relational database: a practical foundation for productivity
Communications of the ACM
Principles of Database Design: Logical Organizations
Principles of Database Design: Logical Organizations
| Hi-index | 0.00 |
This paper examines the integrity problem in light of what can be accomplished using the syntax of major main-frame DBMSs. The data, entity, and referential integrity problems are examined as they pertain to the relational model. Some suggestions proposed in current literature are examined as a basis for possible solutions. Three major DBMSs, IBM's DB2 (SQL/DS), Cullinet's IDMS/R, and Cincom's Supra are examined and solutions to the data, entity, and referential integrity problems are presented for each system. The proposed solutions cover a spectrum of approaches that could be used in a real world environment. DB2 requires complete individual problem by problem attention by the DBA, IDMS/R requires encoding of constraints by the DBA at schema compilation time, and Supra has system support.