DBScholar

Back to papers

Implementation of Integrity Constraints and Views by Query Modification

Summary: Proposes query-level modification to guarantee integrity constraints during updates, decoupling UI from storage. Extends the same modification approach to support views, enabling virtual relations to be maintained without extra storage. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
h0289ed7f853c30f1
Venue
SIGMOD
Year
1975
Pagerank
0.00035703156
Overall Rank
87 | 99.42%
DOI
10.1145/500080.500091

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{stonebraker_sigmod75,
        title = {{Implementation of Integrity Constraints and Views by Query Modification}},
        author = {Stonebraker, Michael},
        series = {{SIGMOD} '75},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/500080.500091},
        url = {https://dl.acm.org/doi/10.1145/500080.500091},
        year = {1975}
}

Incoming Citations (Sorted by Pagerank)

Showing 50 of 58 citing papers.

Rank Citing Paper Year Venue Pagerank
34 The Design Of Postgres 1986 SIGMOD 0.00049129967
147 On Rules, Procedures, Caching And Views In Data Base Systems 1990 SIGMOD 0.00029006574
246 Deriving Production Rules for Incremental View Maintenance 1991 VLDB 0.00023204593
388 Incremental Maintenance of Views with Duplicates 1995 SIGMOD 0.00019342096
405 Distributed Query Processing In A Relational Data Base System 1978 SIGMOD 0.00019057201
590 Lineage Tracing for General Data Warehouse Transformations 2001 VLDB 0.00015884721
724 A Performance Analysis of View Materialization Strategies 1987 SIGMOD 0.00014480522
774 Data Abstraction, Views And Updates In Rigel 1979 SIGMOD 0.00014079981
996 Algorithms for Translating View Updates to Database Updates for Views Involving Selections, Projections, and Joins 1985 PODS 0.00012629814
1,089 Incremental Maintenance of Externally Materialized Views 1996 VLDB 0.0001208456
1,372 Deriving Production Rules for Constraint Maintenance 1990 VLDB 0.00010893304
1,657 Fast Methods For Testing Quantified Relational Calculus Assertions 1982 SIGMOD 9.9642922e-05
1,712 Hypothetical Data Bases As Views 1981 SIGMOD 9.813296e-05
1,754 On-Line Warehouse View Maintenance 1997 SIGMOD 9.7204307e-05
1,844 A Performance Study of Query Optimization Algorithms on a Database System Supporting Procedures 1988 VLDB 9.5195972e-05
1,900 Tioga: Providing Data Management Support for Scientific Visualization Applications 1993 VLDB 9.4026255e-05
1,936 Extending the Algebraic Framework of Query Processing to Handle Outerjoins 1984 VLDB 9.334734e-05
2,005 Data Constructors: On the Integration of Rules and Relations 1985 VLDB 9.2054351e-05
2,059 Rule Condition Testing and Action Execution in Ariel 1992 SIGMOD 9.1060398e-05
2,335 Compiling complex database transition triggers 1989 SIGMOD 8.6214724e-05
2,410 Implementing Mapping Composition 2006 VLDB 8.5106165e-05
2,536 Database Portals: A New Application Program Interface 1984 VLDB 8.3294304e-05
2,640 Knowledge-based Integrity Constraint Validation 1986 VLDB 8.1766826e-05
2,752 An Implementation of Hypothetical Relations 1983 VLDB 8.0520473e-05
2,906 Choosing a View Update Translator by Dialog at View Definition Time 1986 VLDB 7.8740247e-05
3,038 Monitoring Database Objects 1989 VLDB 7.7276794e-05
3,197 "Fill-in-the-Form" Programming 1985 VLDB 7.5432017e-05
3,600 Practical Applications of Triggers and Constraints: Successes and Lingering Issues 2000 VLDB 7.1731072e-05
3,832 Cost and Performance Analysis of Semantic Integrity Validation Methods 1979 SIGMOD 6.9931089e-05
3,957 Enforcing Inclusion Dependencies and Referential Integrity 1988 VLDB 6.8971225e-05
4,019 Preliminary Design of ADMS+: A Workstation-Mainframe Integrated Architecture for Database Management Systems 1986 VLDB 6.8487335e-05
4,221 Efficiently Supporting Procedures In Relational Database Systems 1987 SIGMOD 6.7207714e-05
4,324 Embedding Expert Knowledge and Hypothetical Data Bases into a Data Base System 1980 SIGMOD 6.6628184e-05
4,335 Specification, Semantics, and Enforcement of Dynamic Database Constraints 1984 VLDB 6.6530386e-05
4,728 User-Defined Table Operators: Enhancing Extensibility for ORDBMS 1999 VLDB 6.4446427e-05
4,856 Design and Implementation of an Extendible Integrity Subsystem 1984 SIGMOD 6.3774007e-05
4,864 A Relational Database View Update Translation Mechanism 1984 VLDB 6.3752808e-05
4,931 Semantic Integrity Dependencies and Delayed Integrity Checking 1982 VLDB 6.3462643e-05
5,458 Language Support for Office Modelling 1984 VLDB 6.1213264e-05
5,814 AIM - An Integrity Monitor for the Database System INGRES 1983 VLDB 5.9836584e-05
6,271 Integrity Constraint Reformulation for Efficient Validation 1987 VLDB 5.8270347e-05
6,332 On Verification Of Database Temporal Constraints 1985 SIGMOD 5.8103591e-05
6,375 Integrity Constraints Checking In Deductive Databases 1991 VLDB 5.8064898e-05
6,527 Analytical Modeling of Materialized View Maintenance 1988 PODS 5.7541144e-05
6,713 Application of Novel Technologies to the Management of a Very Large Data Base 1983 VLDB 5.6995771e-05
6,915 An Approach For Building Secure Database Federations 1994 VLDB 5.6456106e-05
7,268 Canonical View Update Support through Boolean Algebras of Components 1984 PODS 5.5674125e-05
7,678 Isolation Support for Service-based Applications: A Position Paper 2007 CIDR 5.4746904e-05
7,865 Semantic Integrity Constraints: Declarative Guardrails for AI-Augmented Data Processing Systems 2025 VLDB 5.4361737e-05
8,611 Integrity Maintenance in an Object-Oriented Database 1992 VLDB 5.3022604e-05
Previous Page 1 / 2 Next

Outgoing Citations (Sorted by Pagerank)

Showing 0 of 0 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank Cited Paper Year Venue Pagerank
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 3,288 Comprehensive Approach to the Design of Relational Database Schemes 1984 VLDB
2 1,521 Constraint Checking with Partial Information 1994 PODS
3 2,700 Updating Relational Databases through Object-Based Views 1991 SIGMOD
4 7,899 Safe Referential Integrity Structures in Relational Databases 1991 VLDB
5 8,611 Integrity Maintenance in an Object-Oriented Database 1992 VLDB
6 9,609 Using Integrity Constraints to Provide Intensional Answers to Relational Queries 1989 VLDB
7 4,179 Formal Limits on the Automatic Generation and Maintenance of Integrity Constraints 1987 PODS
8 13,369 Combining Theory and Practice in Integrity Control: A Declarative Approach to the Specification of a Transaction Modification Subsystem 1993 VLDB
9 2,640 Knowledge-based Integrity Constraint Validation 1986 VLDB
10 9,429 The Role of Integrity Constraints in Database Interoperation 1996 VLDB