DBScholar

Back to papers

Grammar-like Functional Rules for Representing Query Optimization Alternatives

Summary: Grammar-like functional rules represent query-optimization alternatives as data, with parameterized productions and conditions. Terminals are runtime primitives; non-terminals form plans with cost vectors and a glue to satisfy input properties. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
h8513870b505a7626
Venue
SIGMOD
Year
1988
Pagerank
0.00025616489
Overall Rank
196 | 98.69%
DOI
10.1145/50202.50204

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{lohman_sigmod88,
        title = {{Grammar-like Functional Rules for Representing Query Optimization Alternatives}},
        author = {Lohman, Guy M.},
        series = {{SIGMOD} '88},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/50202.50204},
        url = {https://dl.acm.org/doi/10.1145/50202.50204},
        year = {1988}
}

Incoming Citations (Sorted by Pagerank)

Showing 49 of 49 citing papers.

Rank Citing Paper Year Venue Pagerank
173 Optimizing Queries across Diverse Data Sources 1997 VLDB 0.00026814969
213 Eager Aggregation and Lazy Aggregation 1995 VLDB 0.00024753576
272 An Overview of Query Optimization in Relational Systems 1998 PODS 0.0002251422
273 Extensible Query Processing in Starburst 1989 SIGMOD 0.00022498382
321 Measuring the Complexity of Join Enumeration in Query Optimization 1990 VLDB 0.00021082176
396 On Saying "Enough Already!" in SQL 1997 SIGMOD 0.00019153354
468 Don’t Scrap It, Wrap It! A Wrapper Architecture for Legacy Data Sources 1997 VLDB 0.00017752831
487 Randomized Algorithms For Optimizing Large Join Queries 1990 SIGMOD 0.00017455404
499 The Design of XPRS 1988 VLDB 0.00017291748
689 Query Optimization in the Presence of Foreign Functions 1993 VLDB 0.00014746059
725 Fundamental Techniques for Order Optimization 1996 SIGMOD 0.00014471289
1,263 A Framework for Automating Physical Database Design 1991 VLDB 0.00011283218
1,439 Magic is Relevant 1990 SIGMOD 0.000106437
1,498 Advanced Query Processing in Object Bases Using Access Support Relations 1990 VLDB 0.00010467803
1,773 Rank-aware Query Optimization 2004 SIGMOD 9.6683429e-05
1,784 System RX: One Part Relational, One Part XML 2005 SIGMOD 9.6466168e-05
1,860 Optimizing Disjunctive Queries with Expensive Predicates 1994 SIGMOD 9.4862912e-05
1,890 WeTune: Automatic Discovery and Verification of Query Rewrite Rules 2022 SIGMOD 9.4234723e-05
2,341 Extending the Search Strategy in a Query Optimizer 1991 VLDB 8.6079269e-05
2,483 AnalyticDB: Real-time OLAP Database System at Alibaba Cloud 2019 VLDB 8.3973995e-05
2,550 A Transformation-Based Approach to Optimizing Loops in Database Programming Languages 1992 SIGMOD 8.3085137e-05
2,559 AQuery: Query Language for Ordered Data, Optimization Techniques, and Experiments 2003 VLDB 8.2963498e-05
2,678 Gral: An Extensible Relational Database System for Geometric Applications 1989 VLDB 8.141803e-05
3,088 On Parallel Processing of Aggregate and Scalar Functions in Object-Relational DBMS 1998 SIGMOD 7.6593918e-05
3,120 The Starburst Long Field Manager 1989 VLDB 7.6284878e-05
3,126 Evaluating Queries with Generalized Path Expressions 1996 SIGMOD 7.6190081e-05
3,142 Evita Raced: Metacompilation for Declarative Networks 2008 VLDB 7.595954e-05
3,211 Implementing an Interpreter for Functional Rules in a Query Optimizer 1988 VLDB 7.5331392e-05
3,707 Implementation of Magic-sets in a Relational Database System 1994 SIGMOD 7.0789307e-05
3,722 Bypassing Joins in Disjunctive Queries 1995 VLDB 7.0684532e-05
3,777 Parallelizing Query Optimization 2008 VLDB 7.0240115e-05
4,180 Rule Languages and Internal Algebras for Rule-Based Optimizers 1996 SIGMOD 6.7524714e-05
4,229 Cracking SQL Barriers: An LLM-based Dialect Translation System 2025 SIGMOD 6.7133739e-05
4,417 Estimating Compilation Time of a Query Optimizer 2003 SIGMOD 6.6064397e-05
4,511 A Blackboard Architecture for Query Optimization in Object Bases 1993 VLDB 6.5666591e-05
4,728 User-Defined Table Operators: Enhancing Extensibility for ORDBMS 1999 VLDB 6.4446427e-05
4,883 Loading a Cache with Query Results 1999 VLDB 6.3684401e-05
5,125 An Incremental Join Attachment for Starburst 1990 VLDB 6.2613541e-05
5,545 Charting the Design Space of Query Execution using VOILA 2021 VLDB 6.0860849e-05
6,138 Parallelizing Extensible Query Optimizers 2009 SIGMOD 5.8732713e-05
6,947 A Signature Access Method for the Starburst Database System 1989 VLDB 5.6352648e-05
7,871 Building Advanced SQL Analytics From Low-Level Plan Operators 2021 SIGMOD 5.434014e-05
7,929 SlabCity: Whole-Query Optimization using Program Synthesis 2023 VLDB 5.4231855e-05
7,936 Including Bloom Filters in Bottom-up Optimization 2025 SIGMOD 5.4210921e-05
7,966 Excalibur: A Virtual Machine for Adaptive Fine-grained JIT-Compiled Query Execution based on VOILA 2023 VLDB 5.4141361e-05
8,296 User-Optimizer Communication using Abstract Plans in Sybase ASE 2001 VLDB 5.3589207e-05
9,221 DPconv: Super-Polynomially Faster Join Ordering 2024 SIGMOD 5.2036474e-05
10,341 Efficient Enumeration of Recursive Plans in Transformation-based Query Optimizers 2024 VLDB 5.0230745e-05
13,234 TOPAZ: a Cost-Based, Rule-Driven, Multi-Phase Parallelizer 1998 VLDB 4.9769913e-05
Previous Page 1 / 1 Next

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
1 Access Path Selection in a Relational Database Management System 1979 SIGMOD 0.0023943337
34 The Design Of Postgres 1986 SIGMOD 0.00049129967
82 Hashing Methods and Relational Algebra Operations 1984 VLDB 0.00036042975
118 The EXODUS Optimizer Generator 1987 SIGMOD 0.00031381726
156 Multiprocessor Hash-Based Join Algorithms 1985 VLDB 0.00028509887
345 R* Optimizer Validation and Performance Evaluation for Distributed Queries 1986 VLDB 0.0002045459
405 Distributed Query Processing In A Relational Data Base System 1978 SIGMOD 0.00019057201
631 A Rule-Based View of Query Optimization 1987 SIGMOD 0.00015411265
1,411 A Data Management Extension Architecture 1987 SIGMOD 0.00010736094
2,311 Optimization of Nested Queries in a Distributed Relational Database 1984 VLDB 8.6623569e-05
3,211 Implementing an Interpreter for Functional Rules in a Query Optimizer 1988 VLDB 7.5331392e-05
3,744 Distributing A Database For Parallelism 1983 SIGMOD 7.0553676e-05
4,073 Remotely-Sensed Geophysical Databases: Experience and Implications for Generalized DBMSs 1983 SIGMOD 6.8175763e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 143 Optimization of Nonrecursive Queries 1986 VLDB
2 995 Analyzing Plan Diagrams of Database Query Optimizers 2005 VLDB
3 288 Optimization of Dynamic Query Evaluation Plans 1994 SIGMOD
4 13,336 Investigation of Algebraic Query Optimisation for Database Programming Languages 1994 VLDB
5 689 Query Optimization in the Presence of Foreign Functions 1993 VLDB
6 10,519 Succinct Structure Representations for Efficient Query Optimization 2026 SIGMOD
7 2,516 Optimization of Queries with User-defined Predicates 1996 VLDB
8 7,264 Rule-Based Translation of Relational Queries into Iterative Programs 1986 SIGMOD
9 631 A Rule-Based View of Query Optimization 1987 SIGMOD
10 3,211 Implementing an Interpreter for Functional Rules in a Query Optimizer 1988 VLDB