Optimal Computation of Total Projections with Unions of Simple Chase Join Expressions

Summary: Generalizes extension joins to chase join expressions to compute total projections of the representative instance under functional dependencies. Demonstrates that unions of simple chase join expressions suffice under an independent scheme, with a simple algorithm to minimize join count. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 2243
Venue: SIGMOD
Year: 1984
Pagerank: 5.1716335e-05
Overall Rank: 6,168 | 57.10%
DOI: -

Incoming Non-self Citations Over Time

Authors

1. Edward P. F. Chan

Incoming Citations (Sorted by Pagerank)

Showing 5 of 5 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
2,318	Efficient Query Answering in the Representative Instance Approach	1985	PODS	9.0400919e-05
7,979	Independence-reducible Database Schemes	1988	PODS	4.613363e-05
8,403	On Designing Database Schemes Bounded or Constant-time-maintainable with respect to Functional Dependencies	1987	PODS	4.5234988e-05
12,926	Efficient Updates to Independent Schemes in the Weak Instance Model	1990	SIGMOD	4.1945683e-05
12,975	A New Basis for the Weak Instance Model	1987	PODS	4.1945683e-05

Outgoing Citations (Sorted by Pagerank)

Showing 13 of 13 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
38	Testing Implications Of Data Dependencies	1979	SIGMOD	0.00075110004
58	Efficient Optimization of a Class of Relational Expressions	1978	SIGMOD	0.00064826446
135	Can We Use The Universal Instance Assumption Without Using Nulls?	1981	SIGMOD	0.00042421957
458	Independent Database Schemas (Extended Abstract)	1982	PODS	0.00022657396
920	The U. R. Strikes Back	1982	PODS	0.00015338004
1,224	A Generalized Access Path Model And Its Application To A Relational Data Base System	1976	SIGMOD	0.00013194206
1,937	Windows On The World	1983	SIGMOD	0.00010029315
2,918	Notions of Dependency Satisfaction	1982	PODS	7.9051531e-05
3,380	Independent and Separable Database Schemes	1983	PODS	7.1606467e-05
3,461	Specifying Connections for a Universal Relation Scheme Database	1982	SIGMOD	7.0711544e-05
6,686	An Algorithm For Servicing Multi-Relational Queries	1977	SIGMOD	4.9624102e-05
9,012	Querying Weak Instances	1984	PODS	4.4096041e-05
9,013	The Revenge Of The Jd	1983	PODS	4.4096041e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
3,559	Incomplete Information and Dependencies in Relational Databases	1983	SIGMOD	6.9759696e-05
2,401	Physical Data Independence, Constraints, and Optimization with Universal Plans	1999	VLDB	8.8954126e-05
3,496	Dependency Satisfaction in Databases with Incomplete Information	1984	VLDB	7.0397186e-05
135	Can We Use The Universal Instance Assumption Without Using Nulls?	1981	SIGMOD	0.00042421957
7,509	Optimizing the Chase: Scalable Data Integration under Constraints	2014	VLDB	4.7180617e-05
7,976	On the Optimality of Strategies for Multiple Joins	1990	PODS	4.613363e-05
7,984	The Equivalence of Solving Queries and Producing Tree Projections (Extended Abstract)	1986	PODS	4.613363e-05
2,727	Semantic Query Optimization in the Presence of Types	2010	PODS	8.2216778e-05
1,196	On Computing Restricted Projections of Representative Instances	1985	PODS	0.00013403617
2,318	Efficient Query Answering in the Representative Instance Approach	1985	PODS	9.0400919e-05