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)

Paper ID: h965c7f59408a3fed
Venue: SIGMOD
Year: 2020
Pagerank: 6.7549236e-05
Overall Rank: 4,166 | 72.08%
DOI: 10.1145/3318464.3389754

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,888	WeTune: Automatic Discovery and Verification of Query Rewrite Rules	2022	SIGMOD	9.4148912e-05
4,508	LearnedSQLGen: Constraint-aware SQL Generation using Reinforcement Learning	2022	SIGMOD	6.5553854e-05
5,098	DBPA: A Benchmark for Transactional Database Performance Anomalies	2023	SIGMOD	6.2631174e-05
6,203	Fine-Grained Lineage for Safer Notebook Interactions	2021	VLDB	5.8344547e-05
7,941	SlabCity: Whole-Query Optimization using Program Synthesis	2023	VLDB	5.4056478e-05
10,514	Dialect-Agnostic SQL Parsing via LLM-Based Segmentation	2026	SIGMOD	4.9605343e-05
12,060	DeFiHap: Detecting and Fixing HiveQL Anti-Patterns	2021	VLDB	4.9605343e-05
12,068	Interactive Demonstration of SQLCheck	2021	VLDB	4.9605343e-05

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
644	Relational Cloud: A Database-as-a-Service for the Cloud	2011	CIDR	0.00015201984
995	Unbundling Transaction Services in the Cloud	2009	CIDR	0.00012602141
1,276	Rewriting Procedures for Batched Bindings	2008	VLDB	0.00011210489
2,189	Leveraging Lock Contention to Improve OLTP Application Performance	2016	VLDB	8.8866479e-05
2,992	StatusQuo: Making Familiar Abstractions Perform Using Program Analysis	2013	CIDR	7.7605188e-05
3,002	Extracting Equivalent SQL from Imperative Code in Database Applications	2016	SIGMOD	7.7473824e-05
3,938	Sloth: Being Lazy is a Virtue (When Issuing Database Queries)	2014	SIGMOD	6.8968843e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	8,640	A Demonstration of DLBD: Database Logic Bug Detection System	2023	VLDB
2	8,895	Efficient Black-box Checking of Snapshot Isolation in Databases	2023	VLDB
3	4,917	Automated Validating and Fixing of Text-to-SQL Translation with Execution Consistency	2025	SIGMOD
4	10,963	Developing and Benchmarking Verification Algorithms to Improve Text-to-SQL Generation	2026	VLDB
5	11,697	Demonstration of the VeriEQL Equivalence Checker for Complex SQL Queries	2024	VLDB
6	10,382	Automated Database Testing via LLM-Synthesized SQL Features	2027	SIGMOD
7	8,426	Detecting Schema-Related Logic Bugs in Relational DBMSs via Equivalent Database Construction	2025	VLDB
8	1,765	APOLLO: Automatic Detection and Diagnosis of Performance Regressions in Database Systems	2020	VLDB
9	12,060	DeFiHap: Detecting and Fixing HiveQL Anti-Patterns	2021	VLDB
10	12,068	Interactive Demonstration of SQLCheck	2021	VLDB