The VLDB Journal

, Volume 10, Issue 4, pp 241–269

Semantic integrity support in SQL:1999 and commercial (object-)relational database management systems

  • Can Türker
  • Michael Gertz
Regular contribution

DOI: 10.1007/s007780100050

Cite this article as:
Türker, C. & Gertz, M. The VLDB Journal (2001) 10: 241. doi:10.1007/s007780100050

Abstract.

The correctness of the data managed by database systems is vital to any application that utilizes data for business, research, and decision-making purposes. To guard databases against erroneous data not reflecting real-world data or business rules, semantic integrity constraints can be specified during database design. Current commercial database management systems provide various means to implement mechanisms to enforce semantic integrity constraints at database run-time.

In this paper, we give an overview of the semantic integrity support in the most recent SQL-standard SQL:1999, and we show to what extent the different concepts and language constructs proposed in this standard can be found in major commercial (object-)relational database management systems. In addition, we discuss general design guidelines that point out how the semantic integrity features provided by these systems should be utilized in order to implement an effective integrity enforcing subsystem for a database.

Key words:Semantic integrity constraints – SQL:1999 – Object-relational databases – Constraint enforcement 

Copyright information

© Springer-Verlag Berlin Heidelberg 2001

Authors and Affiliations

  • Can Türker
    • 1
  • Michael Gertz
    • 2
  1. 1.Swiss Federal Institute of Technology (ETH) Zurich, Institute of Information Systems, ETH Zentrum, 8092 Zurich, Switzerland; E-mail: tuerker@inf.ethz.chCH
  2. 2.University of California, Davis, Department of Computer Science, One Shields Avenue, Davis, CA 95616, USA; E-mail: gertz@cs.ucdavis.eduUS

Personalised recommendations