DBScholar

Back to papers

Query Transformation for PSJ-queries

Summary: Query transformation for PSJ-queries: decide if a query can be computed from derived relations when both query and sources are PSJ-expressions. Contributions: PSJ-theory, reduced attribute mappings to prune search space, prototype PSJ-based transformation. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
hf18ee4bf48b97a6d
Venue
VLDB
Year
1987
Pagerank
0.00027190577
Overall Rank
167 | 98.88%
DOI
-

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{yang_vldb87,
        title = {{Query Transformation for PSJ-queries}},
        author = {Yang, H.Z. and Larson, P.-A.},
        journal = {PVLDB},
        series = {{VLDB} '87},
        pages = {245},
        year = {1987}
}

Incoming Citations (Sorted by Pagerank)

Showing 29 of 29 citing papers.

Rank Citing Paper Year Venue Pagerank
72 Answering Queries Using Views (Extended Abstract) 1995 PODS 0.0003753293
117 Querying Heterogeneous Information Sources Using Source Descriptions 1996 VLDB 0.00031616101
129 Efficient and Extensible Algorithms for Multi Query Optimization 2000 SIGMOD 0.00030395767
202 Aggregate-Query Processing in Data Warehousing Environments 1995 VLDB 0.0002523837
238 Complexity of Answering Queries Using Materialized Views 1998 PODS 0.00023580688
272 An Overview of Query Optimization in Relational Systems 1998 PODS 0.0002251422
301 Answering Queries Using Templates With Binding Patterns (Extended Abstract) 1995 PODS 0.00021673683
410 Semantic Data Caching and Replacement 1996 VLDB 0.00018796567
532 Answering Recursive Queries Using Views 1997 PODS 0.00016821057
553 Optimizing Queries Using Materialized Views: A Practical, Scalable Solution 2001 SIGMOD 0.00016518678
567 Answering Queries with Aggregation Using Views 1996 VLDB 0.00016264813
577 The GMAP: A Versatile Tool for Physical Data Independence 1994 VLDB 0.00016111779
824 Data Integration: The Teenage Years 2006 VLDB 0.00013641217
880 Rewriting Aggregate Queries Using Views 1999 PODS 0.00013274554
936 A Scalable Algorithm for Answering Queries Using Views 2000 VLDB 0.00012983552
1,052 Answering Queries Using Limited External Query Processors 1996 PODS 0.00012269616
1,549 Data Warehouse Configuration 1997 VLDB 0.00010287654
1,822 Adapting Materialized Views after Redefinitions 1995 SIGMOD 9.5620235e-05
2,046 Views and Queries: Determinacy and Rewriting 2005 PODS 9.1331561e-05
2,128 Query Rewriting for Semistructured Data 1999 SIGMOD 8.9984814e-05
2,192 Data Integration: After the Teenage Years 2017 PODS 8.8826744e-05
2,229 Physical Data Independence, Constraints, and Optimization with Universal Plans 1999 VLDB 8.7991965e-05
2,574 Rewriting Queries Using Views in Description Logics 1997 PODS 8.2749164e-05
3,097 Query Containment for Data Integration Systems 2000 PODS 7.649698e-05
3,438 Expiring Data in a Warehouse 1998 VLDB 7.2961679e-05
4,497 A Chase Too Far? 2000 SIGMOD 6.5739818e-05
6,385 View Matching for Outer-Join Views 2005 VLDB 5.8039464e-05
7,269 Query Evaluation using Overlapping Views: Completeness and Efficiency 2006 SIGMOD 5.5673576e-05
8,055 On Views and XML 1999 PODS 5.3978399e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 4 of 4 cited papers.

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

Rank Cited Paper Year Venue Pagerank
155 Common Expression Analysis in Database Applications 1982 SIGMOD 0.0002851688
551 Computing Queries from Derived Relations 1985 VLDB 0.000165456
592 Global Query Optimization 1986 SIGMOD 0.00015835128
1,393 Updating Derived Relations: Detecting Irrelevant and Autonomously Computable Updates 1986 VLDB 0.00010801562
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 724 A Performance Analysis of View Materialization Strategies 1987 SIGMOD
2 553 Optimizing Queries Using Materialized Views: A Practical, Scalable Solution 2001 SIGMOD
3 6,394 From XML view updates to relational view updates: old solutions to a new problem 2004 VLDB
4 8,478 The Equivalence of Solving Queries and Producing Tree Projections (Extended Abstract) 1986 PODS
5 7,264 Rule-Based Translation of Relational Queries into Iterative Programs 1986 SIGMOD
6 631 A Rule-Based View of Query Optimization 1987 SIGMOD
7 1,936 Extending the Algebraic Framework of Query Processing to Handle Outerjoins 1984 VLDB
8 2,144 The Tree Property Is Fundamental For Query Processing (Extended Abstract) 1982 PODS
9 1,393 Updating Derived Relations: Detecting Irrelevant and Autonomously Computable Updates 1986 VLDB
10 551 Computing Queries from Derived Relations 1985 VLDB