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
Incoming Citations (Sorted by Pagerank)
Showing 7 of 7 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 2,596 | WeTune: Automatic Discovery and Verification of Query Rewrite Rules | 2022 | SIGMOD | 8.4729982e-05 |
| 4,868 | DBPA: A Benchmark for Transactional Database Performance Anomalies | 2023 | SIGMOD | 5.8629636e-05 |
| 5,371 | LearnedSQLGen: Constraint-aware SQL Generation using Reinforcement Learning | 2022 | SIGMOD | 5.5428776e-05 |
| 6,409 | Fine-Grained Lineage for Safer Notebook Interactions | 2021 | VLDB | 5.0756653e-05 |
| 8,345 | SlabCity: Whole-Query Optimization using Program Synthesis | 2023 | VLDB | 4.5426916e-05 |
| 11,508 | DeFiHap: Detecting and Fixing HiveQL Anti-Patterns | 2021 | VLDB | 4.1945683e-05 |
| 11,517 | Interactive Demonstration of SQLCheck | 2021 | VLDB | 4.1945683e-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 |
|---|---|---|---|---|
| 664 | Relational Cloud: A Database-as-a-Service for the Cloud | 2011 | CIDR | 0.00018465843 |
| 1,133 | Unbundling Transaction Services in the Cloud | 2009 | CIDR | 0.00013771132 |
| 1,456 | Rewriting Procedures for Batched Bindings | 2008 | VLDB | 0.00011899772 |
| 2,513 | Leveraging Lock Contention to Improve OLTP Application Performance | 2016 | VLDB | 8.6178149e-05 |
| 2,867 | StatusQuo: Making Familiar Abstractions Perform Using Program Analysis | 2013 | CIDR | 7.9831651e-05 |
| 3,296 | Extracting Equivalent SQL from Imperative Code in Database Applications | 2016 | SIGMOD | 7.2596583e-05 |
| 4,166 | Sloth: Being Lazy is a Virtue (When Issuing Database Queries) | 2014 | SIGMOD | 6.391976e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 5,733 | Explaining Wrong Queries Using Small Examples | 2019 | SIGMOD | 5.3483446e-05 |
| 5,445 | QFix: Diagnosing Errors through Query Histories | 2017 | SIGMOD | 5.5020909e-05 |
| 8,586 | A Demonstration of DLBD: Database Logic Bug Detection System | 2023 | VLDB | 4.4902778e-05 |
| 8,800 | Efficient Black-box Checking of Snapshot Isolation in Databases | 2023 | VLDB | 4.4486165e-05 |
| 7,139 | Automated Validating and Fixing of Text-to-SQL Translation with Execution Consistency | 2025 | SIGMOD | 4.821174e-05 |
| 11,120 | Demonstration of the VeriEQL Equivalence Checker for Complex SQL Queries | 2024 | VLDB | 4.1945683e-05 |
| 10,603 | Detecting Schema-Related Logic Bugs in Relational DBMSs via Equivalent Database Construction | 2025 | VLDB | 4.1945683e-05 |
| 2,891 | APOLLO: Automatic Detection and Diagnosis of Performance Regressions in Database Systems | 2020 | VLDB | 7.954658e-05 |
| 11,508 | DeFiHap: Detecting and Fixing HiveQL Anti-Patterns | 2021 | VLDB | 4.1945683e-05 |
| 11,517 | Interactive Demonstration of SQLCheck | 2021 | VLDB | 4.1945683e-05 |