Database Integrity: Fundamentals and Current implementations

Abstract

In Part I, this chapter surveys 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.