论文信息 - Database Integrity: Fundamental and Current Implementations

Database Integrity: Fundamental and Current Implementations

In Part I, this chapter survyes the state of the art of the semantic integrity constraints in some relational and object relational available database systems. In Part II, it also provides an overview of the SQL standard integrity issues and describes semantic integrity support in the following DBMSs: Oracle, IBM DB2, Informix, sybase and PostgreSQL.The major differences and similarities among these systems are analyzed in relation to the definition, semantics and fidelity to the SQL standard prescriptions.

Jorge Horacio Doorn | Laura C. Rivero | Viviana E. Ferraggine

[1] C. J. Date. An introduction to database systems (7. ed.) , 1999 .

[2] Michael Gertz,et al. Semantic integrity support in SQL:1999 and commercial (object-)relational database management systems , 2001, The VLDB Journal.

[3] Hamid Pirahesh,et al. Integrating Triggers and Declarative Constraints in SQL Database Systems , 1996, VLDB.

[4] Jorge Horacio Doorn,et al. Static detection of sources of dynamic anomalies in a network of referential integrity restrictions , 2000, SAC '00.

[5] Donald D. Chamberlin,et al. A Complete Guide to DB2 Universal Database , 1998 .

[6] Jennifer Widom,et al. Practical Applications of Triggers and Constraints: Success and Lingering Issues (10-Year Award) , 2000, VLDB.

[7] Christos Faloutsos,et al. Advanced Database Systems , 1997, Lecture Notes in Computer Science.

[8] Stefano Ceri,et al. Designing Database Applications with Objects and Rules: The IDEA Methodology , 1997 .

[9] C. J. Date. Relational Database - Selected Writings , 1986 .

[10] Opher Etzion. PARDES: a data-driven oriented active database model , 1993, SGMD.

[11] E. F. Codd,et al. The Relational Model for Database Management, Version 2 , 1990 .

[12] Carolyn E. Begg,et al. Database Systems: A Practical Approach to Design, Implementation and Management , 1998 .

[13] Victor M. Markowitz. Safe referential integrity and null constraint structures in relational databases , 1994, Inf. Syst..