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.00025558952
Overall Rank
197 | 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
174 Optimizing Queries across Diverse Data Sources 1997 VLDB 0.00026736308
213 Eager Aggregation and Lazy Aggregation 1995 VLDB 0.00024695393
259 An Overview of Query Optimization in Relational Systems 1998 PODS 0.00022881075
275 Extensible Query Processing in Starburst 1989 SIGMOD 0.000224395
322 Measuring the Complexity of Join Enumeration in Query Optimization 1990 VLDB 0.00021032289
398 On Saying "Enough Already!" in SQL 1997 SIGMOD 0.00019117739
469 Don’t Scrap It, Wrap It! A Wrapper Architecture for Legacy Data Sources 1997 VLDB 0.00017702382
489 Randomized Algorithms For Optimizing Large Join Queries 1990 SIGMOD 0.00017402488
500 The Design of XPRS 1988 VLDB 0.0001724009
691 Query Optimization in the Presence of Foreign Functions 1993 VLDB 0.00014701803
726 Fundamental Techniques for Order Optimization 1996 SIGMOD 0.0001443284
1,265 A Framework for Automating Physical Database Design 1991 VLDB 0.00011257062
1,443 Magic is Relevant 1990 SIGMOD 0.00010618161
1,501 Advanced Query Processing in Object Bases Using Access Support Relations 1990 VLDB 0.00010434058
1,712 Rank-aware Query Optimization 2004 SIGMOD 9.7961248e-05
1,793 System RX: One Part Relational, One Part XML 2005 SIGMOD 9.6149082e-05
1,866 Optimizing Disjunctive Queries with Expensive Predicates 1994 SIGMOD 9.4590899e-05
1,888 WeTune: Automatic Discovery and Verification of Query Rewrite Rules 2022 SIGMOD 9.4148912e-05
2,351 Extending the Search Strategy in a Query Optimizer 1991 VLDB 8.5799847e-05
2,474 AnalyticDB: Real-time OLAP Database System at Alibaba Cloud 2019 VLDB 8.3955114e-05
2,555 A Transformation-Based Approach to Optimizing Loops in Database Programming Languages 1992 SIGMOD 8.2817782e-05
2,565 AQuery: Query Language for Ordered Data, Optimization Techniques, and Experiments 2003 VLDB 8.2689928e-05
2,688 Gral: An Extensible Relational Database System for Geometric Applications 1989 VLDB 8.1151447e-05
3,095 On Parallel Processing of Aggregate and Scalar Functions in Object-Relational DBMS 1998 SIGMOD 7.6369261e-05
3,130 The Starburst Long Field Manager 1989 VLDB 7.6033002e-05
3,135 Evaluating Queries with Generalized Path Expressions 1996 SIGMOD 7.5943566e-05
3,153 Evita Raced: Metacompilation for Declarative Networks 2008 VLDB 7.5712705e-05
3,218 Implementing an Interpreter for Functional Rules in a Query Optimizer 1988 VLDB 7.5096666e-05
3,702 Implementation of Magic-sets in a Relational Database System 1994 SIGMOD 7.0617354e-05
3,725 Bypassing Joins in Disjunctive Queries 1995 VLDB 7.0458585e-05
3,785 Parallelizing Query Optimization 2008 VLDB 7.0012696e-05
4,004 Cracking SQL Barriers: An LLM-based Dialect Translation System 2025 SIGMOD 6.846192e-05
4,197 Rule Languages and Internal Algebras for Rule-Based Optimizers 1996 SIGMOD 6.7307148e-05
4,435 Estimating Compilation Time of a Query Optimizer 2003 SIGMOD 6.5858211e-05
4,528 A Blackboard Architecture for Query Optimization in Object Bases 1993 VLDB 6.5456474e-05
4,746 User-Defined Table Operators: Enhancing Extensibility for ORDBMS 1999 VLDB 6.4264234e-05
4,906 Loading a Cache with Query Results 1999 VLDB 6.34751e-05
5,146 An Incremental Join Attachment for Starburst 1990 VLDB 6.2406639e-05
5,564 Charting the Design Space of Query Execution using VOILA 2021 VLDB 6.0660209e-05
6,154 Parallelizing Extensible Query Optimizers 2009 SIGMOD 5.8543039e-05
6,966 A Signature Access Method for the Starburst Database System 1989 VLDB 5.6166415e-05
7,887 Building Advanced SQL Analytics From Low-Level Plan Operators 2021 SIGMOD 5.4162508e-05
7,941 SlabCity: Whole-Query Optimization using Program Synthesis 2023 VLDB 5.4056478e-05
7,949 Including Bloom Filters in Bottom-up Optimization 2025 SIGMOD 5.4031665e-05
7,983 Excalibur: A Virtual Machine for Adaptive Fine-grained JIT-Compiled Query Execution based on VOILA 2023 VLDB 5.3962907e-05
8,286 User-Optimizer Communication using Abstract Plans in Sybase ASE 2001 VLDB 5.3449621e-05
9,244 DPconv: Super-Polynomially Faster Join Ordering 2024 SIGMOD 5.1864409e-05
10,368 Efficient Enumeration of Recursive Plans in Transformation-based Query Optimizers 2024 VLDB 5.0064651e-05
13,275 TOPAZ: a Cost-Based, Rule-Driven, Multi-Phase Parallelizer 1998 VLDB 4.9605343e-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.0023948467
34 The Design Of Postgres 1986 SIGMOD 0.00049063803
83 Hashing Methods and Relational Algebra Operations 1984 VLDB 0.00035942723
118 The EXODUS Optimizer Generator 1987 SIGMOD 0.00031320165
156 Multiprocessor Hash-Based Join Algorithms 1985 VLDB 0.00028431734
345 R* Optimizer Validation and Performance Evaluation for Distributed Queries 1986 VLDB 0.00020445813
407 Distributed Query Processing In A Relational Data Base System 1978 SIGMOD 0.00019003397
633 A Rule-Based View of Query Optimization 1987 SIGMOD 0.00015365563
1,421 A Data Management Extension Architecture 1987 SIGMOD 0.000107023
2,320 Optimization of Nested Queries in a Distributed Relational Database 1984 VLDB 8.6359247e-05
3,218 Implementing an Interpreter for Functional Rules in a Query Optimizer 1988 VLDB 7.5096666e-05
3,751 Distributing A Database For Parallelism 1983 SIGMOD 7.0332847e-05
4,094 Remotely-Sensed Geophysical Databases: Experience and Implications for Generalized DBMSs 1983 SIGMOD 6.7952395e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 144 Optimization of Nonrecursive Queries 1986 VLDB
2 996 Analyzing Plan Diagrams of Database Query Optimizers 2005 VLDB
3 291 Optimization of Dynamic Query Evaluation Plans 1994 SIGMOD
4 13,377 Investigation of Algebraic Query Optimisation for Database Programming Languages 1994 VLDB
5 691 Query Optimization in the Presence of Foreign Functions 1993 VLDB
6 10,585 Succinct Structure Representations for Efficient Query Optimization 2026 SIGMOD
7 2,521 Optimization of Queries with User-defined Predicates 1996 VLDB
8 7,282 Rule-Based Translation of Relational Queries into Iterative Programs 1986 SIGMOD
9 633 A Rule-Based View of Query Optimization 1987 SIGMOD
10 3,218 Implementing an Interpreter for Functional Rules in a Query Optimizer 1988 VLDB