Algorithms for Translating View Updates to Database Updates for Views Involving Selections, Projections, and Joins

Summary: Characterizes translations of updates on selection/projection/join views over BCNF bases via five correctness criteria, and supplies templates for insert/delete/replace. Proves uniqueness: no other translations satisfy all five. (summarized by gpt-5-mini on Feb 09 2026)

Paper ID: 729
Venue: PODS
Year: 1985
Pagerank: 0.00012850156
Overall Rank: 979 | 93.29%
DOI: 10.1145/325405.325423

Incoming Non-self Citations Over Time

Authors

1. Arthur M. Keller (Stanford University)

BibTeX Citation

@inproceedings{keller_pods85,
        address = {New York, NY, USA},
        series = {{PODS} '85},
        title = {{Algorithms for Translating View Updates to Database Updates for Views Involving Selections, Projections, and Joins}},
        url = {https://dl.acm.org/doi/10.1145/325405.325423},
        doi = {10.1145/325405.325423},
        booktitle = {Proceedings of the {ACM} {SIGMOD} Symposium on {Principles} of {Database} {Systems}},
        publisher = {Association for Computing Machinery},
        author = {Keller, Arthur M.},
        year = {1985}
}

Incoming Citations (Sorted by Pagerank)

Showing 17 of 17 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
620	On Propagation of Deletions and Annotations Through Views	2002	PODS	0.00015703409
1,672	Language Features for Interoperability of Databases with Schematic Discrepancies	1991	SIGMOD	0.0001004199
1,781	ORCHESTRA: Rapid, Collaborative Sharing of Dynamic Data	2005	CIDR	9.7739542e-05
2,645	Updating Relational Databases through Object-Based Views	1991	SIGMOD	8.303766e-05
2,880	Choosing a View Update Translator by Dialog at View Definition Time	1986	VLDB	8.0033861e-05
3,390	Relational Lenses: A Language for Updatable Views	2006	PODS	7.4518363e-05
3,588	A Database Interface for File Update	1995	SIGMOD	7.281669e-05
3,991	The Complexity of Resilience and Responsibility for Self-Join-Free Conjunctive Queries	2016	VLDB	6.9695922e-05
4,248	Multi-Tuple Deletion Propagation: Approximations and Complexity	2013	VLDB	6.8052749e-05
4,670	New Results for the Complexity of Resilience for Binary Conjunctive Queries with Self-Joins	2020	PODS	6.5734205e-05
4,901	Maximizing Conjunctive Views in Deletion Propagation	2011	PODS	6.4528526e-05
5,263	The Impact of the Constant Complement Approach Towards View Updating	2003	PODS	6.2948019e-05
5,905	A Dichotomy in the Complexity of Deletion Propagation with Functional Dependencies	2012	PODS	6.0461963e-05
6,269	From XML view updates to relational view updates: old solutions to a new problem	2004	VLDB	5.9331005e-05
9,706	Understanding the implications of view update policies	1985	VLDB	5.2351259e-05
11,827	Programmable View Update Strategies on Relations	2020	VLDB	5.093636e-05
12,707	HUX: Handling Updates in XML	2006	VLDB	5.093636e-05

Outgoing Citations (Sorted by Pagerank)

Showing 7 of 7 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
81	Implementation of Integrity Constraints and Views by Query Modification	1975	SIGMOD	0.00036443459
153	Common Expression Analysis in Database Applications	1982	SIGMOD	0.00029032276
162	Inclusion dependencies and their interaction with functional dependencies (Extended abstract)	1982	PODS	0.00027886326
2,704	Data Model Integration Using The Structural Model	1979	SIGMOD	8.2312717e-05
2,880	Choosing a View Update Translator by Dialog at View Definition Time	1986	VLDB	8.0033861e-05
4,769	A Relational Database View Update Translation Mechanism	1984	VLDB	6.5167844e-05
9,707	On Complementary and Independent Mappings on Databases	1984	SIGMOD	5.2351259e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	620	On Propagation of Deletions and Annotations Through Views	2002	PODS
2	11,827	Programmable View Update Strategies on Relations	2020	VLDB
3	5,263	The Impact of the Constant Complement Approach Towards View Updating	2003	PODS
4	6,269	From XML view updates to relational view updates: old solutions to a new problem	2004	VLDB
5	4,769	A Relational Database View Update Translation Mechanism	1984	VLDB
6	7,128	Canonical View Update Support through Boolean Algebras of Components	1984	PODS
7	9,706	Understanding the implications of view update policies	1985	VLDB
8	1,075	Updates Of Relational Views	1983	PODS
9	2,645	Updating Relational Databases through Object-Based Views	1991	SIGMOD
10	2,880	Choosing a View Update Translator by Dialog at View Definition Time	1986	VLDB