View Matching for Outer-Join Views

Summary: First view-matching algorithm for materialized SPOJG views, extending beyond SPJG to arbitrary mixtures of inner and outer joins. Uses an SPOJ normal form rather than bottom-up syntax, while supporting SQL bags and exploiting nullability, uniqueness, and foreign keys. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID: 9516
Venue: VLDB
Year: 2005
Pagerank: 5.9398047e-05
Overall Rank: 6,256 | 57.08%
DOI: -

Incoming Non-self Citations Over Time

Authors

1. Per-Åke Larson (Microsoft)
2. Jingren Zhou (Microsoft)

BibTeX Citation

@article{larson_vldb05,
        title = {{View Matching for Outer-Join Views}},
        author = {Larson, Per-Åke and Zhou, Jingren},
        journal = {PVLDB},
        series = {{VLDB} '05},
        pages = {445},
        year = {2005}
}

Incoming Citations (Sorted by Pagerank)

Showing 2 of 2 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
3,556	Static Analysis and Optimization of Semantic Web Queries	2012	PODS	7.3113256e-05
5,411	Efficient outer join data skew handling in parallel DBMS	2009	VLDB	6.2273741e-05

Outgoing Citations (Sorted by Pagerank)

Showing 12 of 12 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
166	Query Transformation for PSJ-queries	1987	VLDB	0.00027676268
206	Eager Aggregation and Lazy Aggregation	1995	VLDB	0.00025092273
539	Computing Queries from Derived Relations	1985	VLDB	0.00016872223
554	Answering Queries with Aggregation Using Views	1996	VLDB	0.00016580778
559	Optimizing Queries Using Materialized Views: A Practical, Scalable Solution	2001	SIGMOD	0.00016528822
643	Materialized Views In Oracle	1998	VLDB	0.00015372449
913	A Scalable Algorithm for Answering Queries Using Views	2000	VLDB	0.00013253821
1,034	Answering Complex SQL Queries Using Automatic Summary Tables	2000	SIGMOD	0.00012516197
1,176	Outerjoins as Disjunctions	1994	SIGMOD	0.00011809075
3,263	Hypergraph based reorderings of outer join queries with complex predicates	1995	SIGMOD	7.584572e-05
3,625	Canonical Abstraction for Outerjoin Optimization	2004	SIGMOD	7.2458252e-05
7,272	SQL Query Optimization: Reordering for a General Class of Queries	1996	SIGMOD	5.6594801e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	4,155	On the Content of Materialized Aggregate Views	2000	PODS
2	9,403	Materializing Views with Minimal Size To Answer Queries	2003	PODS
3	736	Materialized View Maintenance and Integrity Constraint Checking: Trading Space for Time	1996	SIGMOD
4	929	Materialized View Selection and Maintenance Using Multi-Query Optimization	2001	SIGMOD
5	1,787	Adapting Materialized Views after Redefinitions	1995	SIGMOD
6	979	Algorithms for Translating View Updates to Database Updates for Views Involving Selections, Projections, and Joins	1985	PODS
7	225	Complexity of Answering Queries Using Materialized Views	1998	PODS
8	1,176	Outerjoins as Disjunctions	1994	SIGMOD
9	554	Answering Queries with Aggregation Using Views	1996	VLDB
10	1,887	Extending the Algebraic Framework of Query Processing to Handle Outerjoins	1984	VLDB