Extending a Relational Database with Deferred Referential Integrity Checking and Intelligent Joins

Summary: Extends relational DBMS with Deferred Referential Integrity Checking (RIC) and Intelligent Join (IJ) to aid interactive use by non-expert users. RIC statically validates constraints (uniqueness, non-null keys, inclusion dependencies); IJ lets users fetch only target data, no explicit joins. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 2493
Venue: SIGMOD
Year: 1989
Pagerank: 5.093636e-05
Overall Rank: 13,138 | 9.87%
DOI: 10.1145/67544.66935

Incoming Non-self Citations Over Time

No non-self incoming citations found for this paper in this database.

Authors

1. Stephanie Cammarata (RAND Corporation)
2. Prasadram Ramachandra (RAND Corporation)
3. Darrell Shane (RAND Corporation)

BibTeX Citation

@inproceedings{cammarata_sigmod89,
        title = {{Extending a Relational Database with Deferred Referential Integrity Checking and Intelligent Joins}},
        author = {Cammarata, Stephanie and Ramachandra, Prasadram and Shane, Darrell},
        series = {{SIGMOD} '89},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/67544.66935},
        url = {https://dl.acm.org/doi/10.1145/67544.66935},
        year = {1989}
}

Incoming Citations (Sorted by Pagerank)

Showing 0 of 0 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank

Outgoing Citations (Sorted by Pagerank)

Showing 5 of 5 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
34	The Design Of Postgres	1986	SIGMOD	0.00049302774
1,356	Metadata Management for Large Statistical Databases	1982	VLDB	0.00011050127
3,887	Enforcing Inclusion Dependencies and Referential Integrity	1988	VLDB	7.0455552e-05
4,818	Semantic Integrity Dependencies and Delayed Integrity Checking	1982	VLDB	6.494062e-05
8,300	Dynamic Derivation of Personalized Views	1988	VLDB	5.4574671e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	742	Independent Database Schemas (Extended Abstract)	1982	PODS
2	4,094	Formal Limits on the Automatic Generation and Maintenance of Integrity Constraints	1987	PODS
3	2,591	Knowledge-based Integrity Constraint Validation	1986	VLDB
4	3,901	A System for Semantic Query Optimization	1987	SIGMOD
5	3,222	Comprehensive Approach to the Design of Relational Database Schemes	1984	VLDB
6	81	Implementation of Integrity Constraints and Views by Query Modification	1975	SIGMOD
7	9,247	The Role of Integrity Constraints in Database Interoperation	1996	VLDB
8	181	On Extending the Functions of a Relational Database System	1982	SIGMOD
9	6,346	Referential Integrity Revisited: An Object-Oriented Perspective	1990	VLDB
10	7,741	Safe Referential Integrity Structures in Relational Databases	1991	VLDB