A guide to the SQL standard
Principles of database and knowledge-base systems, Vol. I
Principles of database and knowledge-base systems, Vol. I
Processing Implication on Queries
IEEE Transactions on Software Engineering
A theory for rule triggering systems
EDBT '90 Proceedings of the 2nd international conference on extending database technology: Advances in Database Technology
Deriving production rules for constraint maintenance
Proceedings of the sixteenth international conference on Very large databases
Behavior of database production rules: termination, confluence, and observable determinism
SIGMOD '92 Proceedings of the 1992 ACM SIGMOD international conference on Management of data
Understanding the new SQL: a complete guide
Understanding the new SQL: a complete guide
Integrity control in relational database systems: an overview
Data & Knowledge Engineering
Fundamentals of database systems (2nd ed.)
Fundamentals of database systems (2nd ed.)
Automatic generation of production rules for integrity maintenance
ACM Transactions on Database Systems (TODS)
Parallel execution of integrity constraint checks
CIKM '95 Proceedings of the fourth international conference on Information and knowledge management
Modularization techniques for active rules design
ACM Transactions on Database Systems (TODS)
Solving satisfiability and implication problems in database systems
ACM Transactions on Database Systems (TODS)
Deriving optimized integrity monitoring triggers from dynamic integrity constraints
Data & Knowledge Engineering
Advanced database systems
Foundations of aggregation constraints
Theoretical Computer Science
A complete guide to DB2 universal database
A complete guide to DB2 universal database
SQL 3: implementing the SQL foundation standard
SQL 3: implementing the SQL foundation standard
SQL: 1999, formerly known as SQL3
ACM SIGMOD Record
Extending the database relational model to capture more meaning
ACM Transactions on Database Systems (TODS)
SQL standardization: the next steps
ACM SIGMOD Record
SQLJ Part 1: SQL routines using the Java programming language
ACM SIGMOD Record
Informix guide to SQL
A relational model of data for large shared data banks
Communications of the ACM
Implementation of integrity constraints and views by query modification
SIGMOD '75 Proceedings of the 1975 ACM SIGMOD international conference on Management of data
Principles of Database and Knowledge-Base Systems: Volume II: The New Technologies
Principles of Database and Knowledge-Base Systems: Volume II: The New Technologies
Database Systems Concepts
Foundations of Databases: The Logical Level
Foundations of Databases: The Logical Level
Active Rules in Database Systems
Active Rules in Database Systems
Foundations of Semantic Databases
Foundations of Semantic Databases
Active Database Systems: Triggers and Rules for Advanced Database Processing
Active Database Systems: Triggers and Rules for Advanced Database Processing
Transaction Processing: Concepts and Techniques
Transaction Processing: Concepts and Techniques
Fast methods for testing quantified relational calculus assertions
SIGMOD '82 Proceedings of the 1982 ACM SIGMOD international conference on Management of data
Implementing Temporal Integrity Constraints Using an Active DBMS
IEEE Transactions on Knowledge and Data Engineering
IEEE Transactions on Knowledge and Data Engineering
IEEE Transactions on Knowledge and Data Engineering
Trigger Inheritance and Overriding in an Active Object Database System
IEEE Transactions on Knowledge and Data Engineering
A Run-Time Execution Model for Referential Integrity Maintenance
Proceedings of the Eighth International Conference on Data Engineering
A Multi-Set Extended Relational Algebra - A Formal Approach to a Practical Issue
Proceedings of the Tenth International Conference on Data Engineering
Updating Derived Relations: Detecting Irrelevant and Autonomously Computable Updates
VLDB '86 Proceedings of the 12th International Conference on Very Large Data Bases
Practical Applications of Triggers and Constraints: Success and Lingering Issues (10-Year Award)
VLDB '00 Proceedings of the 26th International Conference on Very Large Data Bases
Safe Referential Structures in Relational Databases
VLDB '91 Proceedings of the 17th International Conference on Very Large Data Bases
Integrating Triggers and Declarative Constraints in SQL Database Sytems
VLDB '96 Proceedings of the 22th International Conference on Very Large Data Bases
Typed Sets as a Basis for Object-Oriented Database Schemas
ECOOP '93 Proceedings of the 7th European Conference on Object-Oriented Programming
Achievements of Relational Database Schema Design Theory Revisited
Selected Papers from a Workshop on Semantics in Databases
Notes on Data Base Operating Systems
Operating Systems, An Advanced Course
Integrity Constraints Representation in Object-Oriented Databases
CIKM '92 Selected Papers from the First International Conference on Information and Knowledge Management, Expanding the Definition of Database
Access path support for referential integrity in SQL2
The VLDB Journal — The International Journal on Very Large Data Bases
Theory of Relational Databases
Theory of Relational Databases
Database integrity: fundamentals and current implementations
Database integrity
The semantics of an extended referential integrity for a multilevel secure relational data model
Data & Knowledge Engineering
Testing database transactions with AGENDA
Proceedings of the 27th international conference on Software engineering
Design and implementation of an extended relationship semantics in an ODMG-compliant OODBMS
Journal of Systems and Software
Constraint tuning and management for web applications
ICWE '06 Proceedings of the 6th international conference on Web engineering
SVT: schema validation tool for microsoft SQL-server
VLDB '04 Proceedings of the Thirtieth international conference on Very large data bases - Volume 30
Referential integrity quality metrics
Decision Support Systems
Extending Middleware Protocols for Database Replication with Integrity Support
OTM '08 Proceedings of the OTM 2008 Confederated International Conferences, CoopIS, DOA, GADA, IS, and ODBASE 2008. Part I on On the Move to Meaningful Internet Systems:
DASFAA '09 Proceedings of the 14th International Conference on Database Systems for Advanced Applications
Relational processing of RDF queries: a survey
ACM SIGMOD Record
An efficient features-based processing technique for supergraph queries
Proceedings of the Fourteenth International Database Engineering & Applications Symposium
An experimental evaluation of relational RDF storage and querying techniques
DASFAA'10 Proceedings of the 15th international conference on Database systems for advanced applications
Towards flexible database conversion with automatic restructuring
ICCOMP'10 Proceedings of the 14th WSEAS international conference on Computers: part of the 14th WSEAS CSCC multiconference - Volume I
Efficient and adaptable query workload-aware management for RDF data
WISE'10 Proceedings of the 11th international conference on Web information systems engineering
Preserving semantics when transforming conceptual spatio-temporal schemas
OTM'05 Proceedings of the 2005 OTM Confederated international conference on On the Move to Meaningful Internet Systems
Conceptual schema-centric development: a grand challenge for information systems research
CAiSE'05 Proceedings of the 17th international conference on Advanced Information Systems Engineering
Constraint support in MDA tools: a survey
ECMDA-FA'06 Proceedings of the Second European conference on Model Driven Architecture: foundations and Applications
Semantically correct query answers in the presence of null values
EDBT'06 Proceedings of the 2006 international conference on Current Trends in Database Technology
The view-update problem for indefinite databases
JELIA'12 Proceedings of the 13th European conference on Logics in Artificial Intelligence
Exploiting data dependencies with null values for ontology extraction
ER'12 Proceedings of the 31st international conference on Conceptual Modeling
Guidelines for representing complex cardinality constraints in binary and ternary relationships
Software and Systems Modeling (SoSyM)
Hi-index | 0.00 |
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.