SQLCheck: Automated Detection and Diagnosis of SQL Anti-Patterns
Summary: SQLCheck automates detection and diagnosis of SQL anti-patterns by combining query analysis with data analysis for high precision. It ranks anti-patterns by impact on performance, maintainability, and accuracy, and suggests rule-based fixes, validated on large open-source query corpora. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Prashanth Dintyala (Georgia Institute of Technology)
- 2. Arpit Narechania (Georgia Institute of Technology)
- 3. Joy Arulraj (Georgia Institute of Technology)
BibTeX Citation
@inproceedings{dintyala_sigmod20,
title = {{SQLCheck: Automated Detection and Diagnosis of SQL Anti-Patterns}},
author = {Dintyala, Prashanth and Narechania, Arpit and Arulraj, Joy},
series = {{SIGMOD} '20},
booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
publisher = {Association for Computing Machinery},
doi = {10.1145/3318464.3389754},
url = {https://dl.acm.org/doi/10.1145/3318464.3389754},
year = {2020}
}Incoming Citations (Sorted by Pagerank)
Showing 8 of 8 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 1,982 | WeTune: Automatic Discovery and Verification of Query Rewrite Rules | 2022 | SIGMOD | 9.3573897e-05 |
| 5,023 | DBPA: A Benchmark for Transactional Database Performance Anomalies | 2023 | SIGMOD | 6.3979497e-05 |
| 5,169 | LearnedSQLGen: Constraint-aware SQL Generation using Reinforcement Learning | 2022 | SIGMOD | 6.3349035e-05 |
| 6,071 | Fine-Grained Lineage for Safer Notebook Interactions | 2021 | VLDB | 5.9873765e-05 |
| 8,164 | SlabCity: Whole-Query Optimization using Program Synthesis | 2023 | VLDB | 5.4750309e-05 |
| 10,220 | Dialect-Agnostic SQL Parsing via LLM-Based Segmentation | 2026 | SIGMOD | 5.093636e-05 |
| 11,706 | DeFiHap: Detecting and Fixing HiveQL Anti-Patterns | 2021 | VLDB | 5.093636e-05 |
| 11,715 | Interactive Demonstration of SQLCheck | 2021 | VLDB | 5.093636e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 7 of 7 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 641 | Relational Cloud: A Database-as-a-Service for the Cloud | 2011 | CIDR | 0.00015400863 |
| 1,000 | Unbundling Transaction Services in the Cloud | 2009 | CIDR | 0.000127281 |
| 1,261 | Rewriting Procedures for Batched Bindings | 2008 | VLDB | 0.0001143305 |
| 2,154 | Leveraging Lock Contention to Improve OLTP Application Performance | 2016 | VLDB | 9.0745745e-05 |
| 2,930 | StatusQuo: Making Familiar Abstractions Perform Using Program Analysis | 2013 | CIDR | 7.9494635e-05 |
| 2,939 | Extracting Equivalent SQL from Imperative Code in Database Applications | 2016 | SIGMOD | 7.9395908e-05 |
| 3,900 | Sloth: Being Lazy is a Virtue (When Issuing Database Queries) | 2014 | SIGMOD | 7.0361352e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 4,759 | Explaining Wrong Queries Using Small Examples | 2019 | SIGMOD |
| 2 | 4,959 | QFix: Diagnosing Errors through Query Histories | 2017 | SIGMOD |
| 3 | 8,482 | A Demonstration of DLBD: Database Logic Bug Detection System | 2023 | VLDB |
| 4 | 8,715 | Efficient Black-box Checking of Snapshot Isolation in Databases | 2023 | VLDB |
| 5 | 6,267 | Automated Validating and Fixing of Text-to-SQL Translation with Execution Consistency | 2025 | SIGMOD |
| 6 | 11,326 | Demonstration of the VeriEQL Equivalence Checker for Complex SQL Queries | 2024 | VLDB |
| 7 | 9,227 | Detecting Schema-Related Logic Bugs in Relational DBMSs via Equivalent Database Construction | 2025 | VLDB |
| 8 | 2,030 | APOLLO: Automatic Detection and Diagnosis of Performance Regressions in Database Systems | 2020 | VLDB |
| 9 | 11,706 | DeFiHap: Detecting and Fixing HiveQL Anti-Patterns | 2021 | VLDB |
| 10 | 11,715 | Interactive Demonstration of SQLCheck | 2021 | VLDB |