On The Reasonable Effectiveness of Relational Diagrams: Explaining Relational Query Patterns and the Pattern Expressiveness of Relational Languages
Summary: Semantic notion of relational query patterns via structure-preserving mappings; yields a pattern-expressiveness hierarchy. Relational Diagrams provide a complete, sound diagrammatic representation for safe relational calculus, capturing unions of non-disjunctive query patterns; user studies show faster, more accurate recognition than SQL. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Wolfgang Gatterbauer (Northeastern University)
- 2. Cody Dunne (Northeastern University)
BibTeX Citation
@inproceedings{gatterbauer_sigmod24,
title = {{On The Reasonable Effectiveness of Relational Diagrams: Explaining Relational Query Patterns and the Pattern Expressiveness of Relational Languages}},
author = {Gatterbauer, Wolfgang and Dunne, Cody},
series = {{SIGMOD} '24},
booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
publisher = {Association for Computing Machinery},
doi = {10.1145/3639316},
url = {https://dl.acm.org/doi/10.1145/3639316},
year = {2024}
}Incoming Citations (Sorted by Pagerank)
Showing 6 of 6 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 9,371 | Exploring Exploratory Querying | 2025 | VLDB | 5.1843659e-05 |
| 10,366 | Database Research needs an Abstract Relational Query Language | 2026 | CIDR | 4.9769913e-05 |
| 10,622 | A Principled Solution to the Disjunction Problem of Diagrammatic Query Representations | 2026 | SIGMOD | 4.9769913e-05 |
| 11,042 | An Extended Tutorial and Vocabulary for Relational Language Design in an Era of AI-Assisted Query Generation | 2026 | VLDB | 4.9769913e-05 |
| 11,217 | LICS: Towards Theory-Informed Effective Visual Abstraction of Property Graph Schemas | 2025 | SIGMOD | 4.9769913e-05 |
| 13,641 | PatternVis: A Tool for Relational Pattern Visualization | 2025 | SIGMOD | - |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 8 of 8 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,680 | Axiomatic Foundations and Algorithms for Deciding Semantic Equivalences of SQL Queries | 2018 | VLDB | 9.9000396e-05 |
| 4,048 | Expressive Query Construction through Direct Manipulation of Nested Relational Results | 2016 | SIGMOD | 6.8293035e-05 |
| 4,063 | The Complexity of Resilience and Responsibility for Self-Join-Free Conjunctive Queries | 2016 | VLDB | 6.8215087e-05 |
| 4,328 | Playful Query Specification with DataPlay | 2012 | VLDB | 6.6582731e-05 |
| 4,619 | QueryVis: Logic-based Diagrams help Users Understand Complicated SQL Queries Faster | 2020 | SIGMOD | 6.4965731e-05 |
| 5,510 | Troubles with Nulls, Views from the Users | 2022 | VLDB | 6.0980926e-05 |
| 8,346 | Databases will Visualize Queries too | 2011 | VLDB | 5.3488022e-05 |
| 11,787 | A Tutorial on Visual Representations of Relational Queries | 2023 | VLDB | 4.9769913e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 4,358 | Toward Logical Data Independence: A Relational Query Language without Relations | 1982 | SIGMOD |
| 2 | 13,153 | String Operations in Query Languages | 2001 | PODS |
| 3 | 8,840 | Graph Data Models, Query Languages and Programming Paradigms | 2018 | VLDB |
| 4 | 4,619 | QueryVis: Logic-based Diagrams help Users Understand Complicated SQL Queries Faster | 2020 | SIGMOD |
| 5 | 11,042 | An Extended Tutorial and Vocabulary for Relational Language Design in an Era of AI-Assisted Query Generation | 2026 | VLDB |
| 6 | 10,366 | Database Research needs an Abstract Relational Query Language | 2026 | CIDR |
| 7 | 9,069 | Understanding Queries by Conditional Instances | 2022 | SIGMOD |
| 8 | 8,076 | On the Expressiveness of Languages for Querying Property Graphs in Relational Databases | 2026 | PODS |
| 9 | 13,641 | PatternVis: A Tool for Relational Pattern Visualization | 2025 | SIGMOD |
| 10 | 11,787 | A Tutorial on Visual Representations of Relational Queries | 2023 | VLDB |