Problems underlying the use of referential integrity mechanisms in relational database management systems

Conference · Sat Dec 01 00:00:00 EST 1990

OSTI ID:10106374

Markowitz, V M

Referential integrity is used in relational data-bases for expressing existence dependencies between tuples. Relational database management systems (RDBMS) provide diverse referential integrity capabilities. Thus, is some RDBMSs referential integrity constraints can be specified non-procedurally (declaratively), while in other RDBMSs they must be specified procedurally. Moreover, some RDBMSs restrict the class of allowed referential integrity constraints. We examine in this paper the main problems underlying the use of referential integrity mechanisms in three representative RDBMSs, DB2, SYBASE, and INGRES. 11 refs.

• Research Organization: Lawrence Berkeley Lab., CA (United States)
• Sponsoring Organization: USDOE, Washington, DC (United States)
• DOE Contract Number: AC03-76SF00098
• OSTI ID: 10106374
• Report Number(s): LBL-30104; CONF-9104321-1; ON: DE92004304
• Resource Relation: Conference: 7. IEEE international conference on data engineering,Kobe (Japan),8-12 Apr 1991; Other Information: PBD: Dec 1990
• Country of Publication: United States
• Language: English

Related Subjects

99 GENERAL AND MISCELLANEOUS//MATHEMATICS, COMPUTING, AND INFORMATION SCIENCE
DATA BASE MANAGEMENT
ALGORITHMS
990300
INFORMATION HANDLING