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: 730
Venue: PODS
Year: 1985
Pagerank: 0.00018370973
Overall Rank: 671 | 95.34%
DOI: -

Incoming Non-self Citations Over Time

Authors

1. Arthur M. Keller

Incoming Citations (Sorted by Pagerank)

Showing 17 of 17 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
655	On Propagation of Deletions and Annotations Through Views	2002	PODS	0.00018608845
1,332	Language Features for Interoperability of Databases with Schematic Discrepancies	1991	SIGMOD	0.00012531626
1,767	ORCHESTRA: Rapid, Collaborative Sharing of Dynamic Data	2005	CIDR	0.00010623574
2,389	Choosing a View Update Translator by Dialog at View Definition Time	1986	VLDB	8.9124635e-05
2,469	Updating Relational Databases through Object-Based Views	1991	SIGMOD	8.7346857e-05
2,593	A Database Interface for File Update	1995	SIGMOD	8.4746844e-05
2,857	A Dichotomy in the Complexity of Deletion Propagation with Functional Dependencies	2012	PODS	8.0037703e-05
3,356	Relational Lenses: A Language for Updatable Views	2006	PODS	7.18009e-05
4,260	Multi-Tuple Deletion Propagation: Approximations and Complexity	2013	VLDB	6.3124474e-05
4,336	The Impact of the Constant Complement Approach Towards View Updating	2003	PODS	6.279016e-05
4,361	The Complexity of Resilience and Responsibility for Self-Join-Free Conjunctive Queries	2016	VLDB	6.2559141e-05
4,937	New Results for the Complexity of Resilience for Binary Conjunctive Queries with Self-Joins	2020	PODS	5.8187108e-05
4,971	Maximizing Conjunctive Views in Deletion Propagation	2011	PODS	5.7938195e-05
6,211	From XML view updates to relational view updates: old solutions to a new problem	2004	VLDB	5.1555735e-05
9,570	Understanding the implications of view update policies	1985	VLDB	4.3254416e-05
11,632	Programmable View Update Strategies on Relations	2020	VLDB	4.1945683e-05
12,514	HUX: Handling Updates in XML	2006	VLDB	4.1945683e-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
69	Implementation of Integrity Constraints and Views by Query Modification	1975	SIGMOD	0.00060379399
88	Common Expression Analysis in Database Applications	1982	SIGMOD	0.00052316625
104	Inclusion dependencies and their interaction with functional dependencies (Extended abstract)	1982	PODS	0.00048766186
1,519	Data Model Integration Using The Structural Model	1979	SIGMOD	0.00011553956
2,389	Choosing a View Update Translator by Dialog at View Definition Time	1986	VLDB	8.9124635e-05
3,889	A Relational Database View Update Translation Mechanism	1984	VLDB	6.6611592e-05
9,571	On Complementary and Independent Mappings on Databases	1984	SIGMOD	4.3254416e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
655	On Propagation of Deletions and Annotations Through Views	2002	PODS	0.00018608845
11,632	Programmable View Update Strategies on Relations	2020	VLDB	4.1945683e-05
4,336	The Impact of the Constant Complement Approach Towards View Updating	2003	PODS	6.279016e-05
6,211	From XML view updates to relational view updates: old solutions to a new problem	2004	VLDB	5.1555735e-05
3,889	A Relational Database View Update Translation Mechanism	1984	VLDB	6.6611592e-05
6,766	Canonical View Update Support through Boolean Algebras of Components	1984	PODS	4.9324705e-05
9,570	Understanding the implications of view update policies	1985	VLDB	4.3254416e-05
895	Updates Of Relational Views	1983	PODS	0.00015534879
2,469	Updating Relational Databases through Object-Based Views	1991	SIGMOD	8.7346857e-05
2,389	Choosing a View Update Translator by Dialog at View Definition Time	1986	VLDB	8.9124635e-05