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,893 | WeTune: Automatic Discovery and Verification of Query Rewrite Rules | 2022 | SIGMOD | 9.4126198e-05 |
| 4,482 | LearnedSQLGen: Constraint-aware SQL Generation using Reinforcement Learning | 2022 | SIGMOD | 6.5802486e-05 |
| 5,077 | DBPA: A Benchmark for Transactional Database Performance Anomalies | 2023 | SIGMOD | 6.2858696e-05 |
| 6,190 | Fine-Grained Lineage for Safer Notebook Interactions | 2021 | VLDB | 5.8565828e-05 |
| 7,931 | SlabCity: Whole-Query Optimization using Program Synthesis | 2023 | VLDB | 5.4238328e-05 |
| 10,436 | Dialect-Agnostic SQL Parsing via LLM-Based Segmentation | 2026 | SIGMOD | 4.9793485e-05 |
| 12,010 | DeFiHap: Detecting and Fixing HiveQL Anti-Patterns | 2021 | VLDB | 4.9793485e-05 |
| 12,018 | Interactive Demonstration of SQLCheck | 2021 | VLDB | 4.9793485e-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.00015255418 |
| 993 | Unbundling Transaction Services in the Cloud | 2009 | CIDR | 0.0001263917 |
| 1,274 | Rewriting Procedures for Batched Bindings | 2008 | VLDB | 0.00011247334 |
| 2,180 | Leveraging Lock Contention to Improve OLTP Application Performance | 2016 | VLDB | 8.9119622e-05 |
| 2,979 | StatusQuo: Making Familiar Abstractions Perform Using Program Analysis | 2013 | CIDR | 7.789233e-05 |
| 2,993 | Extracting Equivalent SQL from Imperative Code in Database Applications | 2016 | SIGMOD | 7.7721951e-05 |
| 3,923 | Sloth: Being Lazy is a Virtue (When Issuing Database Queries) | 2014 | SIGMOD | 6.9224617e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 4,827 | QFix: Diagnosing Errors through Query Histories | 2017 | SIGMOD |
| 2 | 8,615 | A Demonstration of DLBD: Database Logic Bug Detection System | 2023 | VLDB |
| 3 | 8,878 | Efficient Black-box Checking of Snapshot Isolation in Databases | 2023 | VLDB |
| 4 | 10,893 | Developing and Benchmarking Verification Algorithms to Improve Text-to-SQL Generation | 2026 | VLDB |
| 5 | 5,544 | Automated Validating and Fixing of Text-to-SQL Translation with Execution Consistency | 2025 | SIGMOD |
| 6 | 11,644 | Demonstration of the VeriEQL Equivalence Checker for Complex SQL Queries | 2024 | VLDB |
| 7 | 9,403 | Detecting Schema-Related Logic Bugs in Relational DBMSs via Equivalent Database Construction | 2025 | VLDB |
| 8 | 1,832 | APOLLO: Automatic Detection and Diagnosis of Performance Regressions in Database Systems | 2020 | VLDB |
| 9 | 12,010 | DeFiHap: Detecting and Fixing HiveQL Anti-Patterns | 2021 | VLDB |
| 10 | 12,018 | Interactive Demonstration of SQLCheck | 2021 | VLDB |