A Fix for the Fixation on Fixpoints
Summary: Derives iterative CTE variants from SQL:1999 WITH RECURSIVE's loop-based operational semantics, avoiding fixpoint semantics and monotonicity constraints. Variants let CTEs retain/forget past iterations or store keyed iteration state, enabling imperative-style iterative SQL with better readability and performance. (summarized by gpt-5-mini on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Denis Hirn (University of Tübingen)
- 2. Torsten Grust (University of Tübingen)
BibTeX Citation
@inproceedings{hirn_cidr23,
address = {Amsterdam, Netherlands},
series = {{CIDR} '23},
title = {{A Fix for the Fixation on Fixpoints}},
booktitle = {Proceedings of the {Conference} on {Innovative} {Data} {Systems} {Research}},
author = {Hirn, Denis and Grust, Torsten},
year = {2023}
}Incoming Citations (Sorted by Pagerank)
Showing 6 of 6 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 8,356 | Optimizing Nested Recursive Queries | 2024 | SIGMOD | 5.3481891e-05 |
| 9,979 | Trampoline-Style Queries for SQL | 2025 | CIDR | 5.1013913e-05 |
| 10,001 | Democratize MATCH_RECOGNIZE ! | 2025 | VLDB | 5.0979044e-05 |
| 10,147 | How DuckDB is USING KEY to Unlock Recursive Query Performance | 2025 | SIGMOD | 5.0715586e-05 |
| 10,962 | GraphAlg Playground: An Online Platform for Learning and Experimenting with the GraphAlg Language | 2026 | VLDB | 4.9793485e-05 |
| 11,033 | An Extended Tutorial and Vocabulary for Relational Language Design in an Era of AI-Assisted Query Generation | 2026 | VLDB | 4.9793485e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 5 of 5 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 67 | An Amateur's Introduction to Recursive Query Processing Strategies | 1986 | SIGMOD | 0.00038009523 |
| 2,705 | Compiling PL/SQL Away | 2020 | CIDR | 8.1111408e-05 |
| 2,938 | RaSQL: Greater Power and Performance for Big Data Analytics with Recursive-aggregate-SQL on Spark | 2019 | SIGMOD | 7.8355984e-05 |
| 3,194 | One WITH RECURSIVE is Worth Many GOTOs | 2021 | SIGMOD | 7.5498012e-05 |
| 6,400 | Functional-Style SQL UDFs With a Capital 'F' | 2020 | SIGMOD | 5.7981078e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 8,042 | Adaptive Optimizations of Recursive Queries in Teradata | 2012 | SIGMOD |
| 2 | 132 | Optimization of Nested SQL Queries Revisited | 1987 | SIGMOD |
| 3 | 9,347 | Optimizing Recursive Queries in SQL | 2005 | SIGMOD |
| 4 | 9,979 | Trampoline-Style Queries for SQL | 2025 | CIDR |
| 5 | 4,061 | Aggify: Lifting the Curse of Cursor Loops using Custom Aggregates | 2020 | SIGMOD |
| 6 | 7,261 | Rule-Based Translation of Relational Queries into Iterative Programs | 1986 | SIGMOD |
| 7 | 3,046 | Tractable Query Languages for Complex Object Databases | 1991 | PODS |
| 8 | 6,088 | Iterative Query Processing based on Unified Optimization Techniques | 2019 | SIGMOD |
| 9 | 2,114 | Reusing Invariants: A New Strategy for Correlated Queries | 1998 | SIGMOD |
| 10 | 3,194 | One WITH RECURSIVE is Worth Many GOTOs | 2021 | SIGMOD |