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.00018353514
Overall Rank: 672 | 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.00018593536
1,336	Language Features for Interoperability of Databases with Schematic Discrepancies	1991	SIGMOD	0.00012521979
1,765	ORCHESTRA: Rapid, Collaborative Sharing of Dynamic Data	2005	CIDR	0.00010614654
2,389	Choosing a View Update Translator by Dialog at View Definition Time	1986	VLDB	8.9038897e-05
2,468	Updating Relational Databases through Object-Based Views	1991	SIGMOD	8.7262344e-05
2,597	A Database Interface for File Update	1995	SIGMOD	8.4665851e-05
2,864	A Dichotomy in the Complexity of Deletion Propagation with Functional Dependencies	2012	PODS	7.9964194e-05
3,357	Relational Lenses: A Language for Updatable Views	2006	PODS	7.1738547e-05
4,256	Multi-Tuple Deletion Propagation: Approximations and Complexity	2013	VLDB	6.3063725e-05
4,334	The Impact of the Constant Complement Approach Towards View Updating	2003	PODS	6.2730913e-05
4,358	The Complexity of Resilience and Responsibility for Self-Join-Free Conjunctive Queries	2016	VLDB	6.2499e-05
4,940	New Results for the Complexity of Resilience for Binary Conjunctive Queries with Self-Joins	2020	PODS	5.8131196e-05
4,973	Maximizing Conjunctive Views in Deletion Propagation	2011	PODS	5.7882537e-05
6,210	From XML view updates to relational view updates: old solutions to a new problem	2004	VLDB	5.1506157e-05
9,569	Understanding the implications of view update policies	1985	VLDB	4.3212967e-05
11,636	Programmable View Update Strategies on Relations	2020	VLDB	4.1905499e-05
12,523	HUX: Handling Updates in XML	2006	VLDB	4.1905499e-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.00060388875
89	Common Expression Analysis in Database Applications	1982	SIGMOD	0.00052299473
105	Inclusion dependencies and their interaction with functional dependencies (Extended abstract)	1982	PODS	0.00049082041
1,518	Data Model Integration Using The Structural Model	1979	SIGMOD	0.000115422
2,389	Choosing a View Update Translator by Dialog at View Definition Time	1986	VLDB	8.9038897e-05
3,891	A Relational Database View Update Translation Mechanism	1984	VLDB	6.6544495e-05
9,570	On Complementary and Independent Mappings on Databases	1984	SIGMOD	4.3212967e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
655	On Propagation of Deletions and Annotations Through Views	2002	PODS	0.00018593536
11,636	Programmable View Update Strategies on Relations	2020	VLDB	4.1905499e-05
4,334	The Impact of the Constant Complement Approach Towards View Updating	2003	PODS	6.2730913e-05
6,210	From XML view updates to relational view updates: old solutions to a new problem	2004	VLDB	5.1506157e-05
3,891	A Relational Database View Update Translation Mechanism	1984	VLDB	6.6544495e-05
6,768	Canonical View Update Support through Boolean Algebras of Components	1984	PODS	4.9276482e-05
9,569	Understanding the implications of view update policies	1985	VLDB	4.3212967e-05
893	Updates Of Relational Views	1983	PODS	0.00015519479
2,468	Updating Relational Databases through Object-Based Views	1991	SIGMOD	8.7262344e-05
2,389	Choosing a View Update Translator by Dialog at View Definition Time	1986	VLDB	8.9038897e-05