See this document in CiteSeerX!

Semantic Integrity Support in SQL-99 and Commercial (Object-)Relational Database Management Systems (2000)  (Make Corrections)  
Can Türker, Michael Gertz



  Home/Search   Context   Related

 
View or download:
ucdavis.edu/papers/TG00.ps
Cached:  PS.gz  PS  PDF   Image  Update  Help

From:  ucdavis.edu/papers/ (more)
(Enter author homepages)

Rate this article: (best)
  Comment on this article  
(Enter summary)

Abstract: . The correctness of the data managed by database systems is vital to any application utilizing 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 such semantic integrity constraints at database run-time. In this... (Update)

Active bibliography (related documents):   More   All
0.8:   Nested Transactions with Integrity Constraints - Doucet, Gançarski..   (Correct)
0.5:   Semantic Caching and Query Processing - Ren, Dunham (1998)   (Correct)
0.5:   Modification Semantics in Now-Relative Databases - Torp, Jensen, Snodgrass (1999)   (Correct)

Similar documents based on text:   More   All
0.3:   Integrating Scientific Data through External, Concept-based.. - Gertz, Sattler   (Correct)
0.3:   A Model and Architecture for Conceptualized Data - Gertz, Sattler (2001)   (Correct)
0.2:   Data Integration Techniques based on Data Quality Aspects - Gertz, Schmitt   (Correct)

BibTeX entry:   (Update)

@misc{ rker-semantic,
  author = "Can Türker and Michael Gertz",
  title = "Semantic Integrity Support in SQL-99 and Commercial (Object-)Relational
    Database Management Systems",
  url = "citeseer.ist.psu.edu/413320.html" }
Citations (may not include all citations):
981   Principles of Database and Knowledge-Base Systems (context) - Ullman - 1989
981   Principles of Database and Knowledge-Base Systems (context) - Ullman - 1988
775   Foundations of Databases (context) - Abiteboul, Hull et al. - 1995
481   Fundamentals of Database Systems (context) - Elmasri, Navathe - 1994
434   An Introduction to Database Systems (context) - Date - 1995
345   Notes on Data Base Operating Systems (context) - Gray - 1978
311   Principles of Distributed Database Systems (context) - Ozsu, Valduriez - 1999
263   Database System Concepts (context) - Silberschatz, Korth et al. - 1997
194   Active Database Systems --- Triggers and Rules for Advanced .. (context) - Widom, Ceri - 1996
150   Understanding the New SQL --- A Complete Guide (context) - Melton, Simon - 1993
134   Extending the Database Relational Model to Capture More Mean.. (context) - Codd - 1979
106   A Guide to the SQL Standard (context) - Date, Darwen - 1997
95   Logic for Improving Integrity Checking in Relational Data Ba.. (context) - Nicolas - 1982
65   Implementation of Integrity Constraints and Views by Query M.. (context) - Stonebraker - 1975
41   Foundations of Aggregation Constraints - Ross, Srivastava et al. - 1998
40   Rational Software Corporation (context) - Booch, Jacobson et al. - 1997
38   Processing Conjunctive Predicates and Queries (context) - Rosenkrantz - 1980
37   Implementing Temporal Integrity Constraints Using an Active .. - Chomicki, Toman - 1995
35   Subsumption and Indexing in Constraint Query Languages with .. - Srivastava - 1993
34   Automatic Generation of Production Rules for Integrity Maint.. (context) - Ceri, Fraternali et al. - 1994
33   Typed Sets as a Basis for Object-Oriented Database Schemas - Balsters, de By et al. - 1993
26   Integrity Control in Relational Database Systems --- An Over.. (context) - Grefen, Apers - 1993
24   Active Object Systems (context) - Buchmann - 1994
17   Better Termination Analysis for Active Databases (context) - Baralis, Ceri et al. - 1993
17   Functional Specifications of a Subsystem for Data Base Integ.. (context) - Eswaran, Chamberlin - 1975
16   Behaviour of Database Production Rules: Termination (context) - Aiken, Widom et al. - 1992
16   Diagnosis and Repair of Constraint Violations in Database Sy.. (context) - Gertz - 1996
14   Achievements of Relational Database Schema Design Theory Rev.. - Biskup - 1998
12   Active Database Features in SQL (context) - Kulkarni, Mattos et al. - 1999
12   Deriving Optimized Integrity Monitoring Triggers from Dynami.. - Gertz, Lipeck - 1996
11   Microsoft SQL Server (context) - Corporation - 1999
10   An Extended Entity-Relationship Model --- Fundamentals and P.. (context) - Gogolla - 1994
9   Fast Methods for Testing Quantified Relational Calculus Asse.. (context) - Bernstein, Blaustein - 1982
8   Solving Satisfiability and Implication Problems in Database .. (context) - Guo, Sun et al. - 1996
7   and Implication Problems Involving Conjunctive Queries in Da.. (context) - Guo, Sun et al. - 1996
6   Database Systems - Concepts (context) - Atzeni, Ceri et al. - 1999
6   Semantic Integrity in a Relational Data Base System (context) - Hammer, McLeod - 1975
6   INFORMIX-Universal Server: Informix Guide to SQL: Syntax (context) - Software, Menlo et al. - 1997
5   SQL3 --- Implementing the SQL Foundation Standard (context) - Fortier - 1999
4   Foundations of Semantic Databases (context) - de Brock - 1995
4   IEEE Transactions on Software Engineering (context) - Sun, Kamel et al. - 1989
4   Semantic Integrity Constraints in Federated Database Schemat.. (context) - Turker - 1999
4   Deriving Production Rules for Constraint Management (context) - Ceri, Widom - 1990
4   Correctness of Semantic Integrity Checking in Database Manag.. (context) - Bertino, Musto - 1988
3   Ordering and Selecting Production Rules for Constraint Maint.. (context) - Fraternali, Paraboschi - 1997
2   Specification and Verification of Data Base Semantic Integri.. (context) - Brodie - 1978
2   Integrity Maintenance in an OODB (context) - Jagadish, Qian - 1992
2   Oraclei SQL Reference (context) - Oracle, Release - 1999
2   International Thomson Publishing (context) - Saake, Schmitt et al. - 1997
2   Semantic Integrity in Advanced Database Management Systems (context) - Deloch - 1993
2   International Thomson Publishing (context) - Heuer, Saake et al. - 1995
2   Understanding SQL's Stored Procedures --- A Complete Guide t.. (context) - Melton - 1998
1   Integrity Constraints in Relational Databases -- Foundations.. (context) - Neumann - 1999
1   Introduction into Language Kernel of SQL (context) - Panny, Taudes - 2000
1   Transact-SQL User Guide (context) - Inc - 1999
1   Integrity Constraints and Specialization in Object Databases (context) - Turker - 1999
1   SQL by Design: Good Database Dsign Starts with the Right Pri.. (context) - Poolet - 1999
1   A Rule System for Integrity Maintenance in Active Relational.. (context) - Reinert - 1996
1   A Rule-based Test Data Generator for Rapid Prototyping of Da.. (context) - Reuter, Rohrle - 1994
1   ISO International Standard: Database Language SQL - Part 2: .. (context) - for, ISO et al. - 1999
1   Dissertationen zu Datenbanken und Informationssystemen (context) - Klettke, Integrity et al. - 1998
1   Active Mechanisms for Consistency Enforcement in Federations.. (context) - Kudra - 1997
1   Efficient Consistency Checking in Database Systems (context) - Herzog - 1996
1   Semantic Integrity Support in SQL-99 and Commercial DBMS (context) - Maier, of et al. - 1983
1   IBM DB2 Universal Database: SQL Reference (context) - Corporation - 1999
1   Automatic Generation of Test Data for Relational Queries (context) - Mannila, Raiha - 1989
1   Ingres Database Administrator's Guide (context) - Corporation - 1999

Documents on the same site (http://www.db.cs.ucdavis.edu/papers/):   More
Discovery of Multi-Level Security Policies - Chung, Gertz, Levitt   (Correct)
Bend, Don't Break: Using Reconfiguration to Achieve.. - Wolf, Heimbigner..   (Correct)
Managing Data Quality and Integrity in Federated Databases - Gertz (1996)   (Correct)

Online articles have much greater impact   More about CiteSeer.IST   Add search form to your site   Submit documents   Feedback  

CiteSeer.IST - Copyright Penn State and NEC