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: h68231711296841dc
Venue: SIGMOD
Year: 1989
Pagerank: 4.9793485e-05
Overall Rank: 13,428 | 9.72%
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.00049142315
1,390	Metadata Management for Large Statistical Databases	1982	VLDB	0.00010816545
3,956	Enforcing Inclusion Dependencies and Referential Integrity	1988	VLDB	6.9003868e-05
4,930	Semantic Integrity Dependencies and Delayed Integrity Checking	1982	VLDB	6.3492697e-05
8,468	Dynamic Derivation of Personalized Views	1988	VLDB	5.3350162e-05

Semantically Similar Papers

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