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,595 | WeTune: Automatic Discovery and Verification of Query Rewrite Rules | 2022 | SIGMOD | 8.4725961e-05 |
| 4,870 | DBPA: A Benchmark for Transactional Database Performance Anomalies | 2023 | SIGMOD | 5.8583776e-05 |
| 5,289 | LearnedSQLGen: Constraint-aware SQL Generation using Reinforcement Learning | 2022 | SIGMOD | 5.5790771e-05 |
| 6,405 | Fine-Grained Lineage for Safer Notebook Interactions | 2021 | VLDB | 5.0707934e-05 |
| 8,339 | SlabCity: Whole-Query Optimization using Program Synthesis | 2023 | VLDB | 4.5383933e-05 |
| 11,512 | DeFiHap: Detecting and Fixing HiveQL Anti-Patterns | 2021 | VLDB | 4.1905499e-05 |
| 11,521 | Interactive Demonstration of SQLCheck | 2021 | VLDB | 4.1905499e-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.0001846313 |
| 1,130 | Unbundling Transaction Services in the Cloud | 2009 | CIDR | 0.00013767385 |
| 1,457 | Rewriting Procedures for Batched Bindings | 2008 | VLDB | 0.00011891025 |
| 2,498 | Leveraging Lock Contention to Improve OLTP Application Performance | 2016 | VLDB | 8.6408169e-05 |
| 2,874 | StatusQuo: Making Familiar Abstractions Perform Using Program Analysis | 2013 | CIDR | 7.9762275e-05 |
| 3,298 | Extracting Equivalent SQL from Imperative Code in Database Applications | 2016 | SIGMOD | 7.2527707e-05 |
| 4,164 | Sloth: Being Lazy is a Virtue (When Issuing Database Queries) | 2014 | SIGMOD | 6.3859482e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 5,743 | Explaining Wrong Queries Using Small Examples | 2019 | SIGMOD | 5.3432106e-05 |
| 5,454 | QFix: Diagnosing Errors through Query Histories | 2017 | SIGMOD | 5.4967096e-05 |
| 8,582 | A Demonstration of DLBD: Database Logic Bug Detection System | 2023 | VLDB | 4.4868313e-05 |
| 8,798 | Efficient Black-box Checking of Snapshot Isolation in Databases | 2023 | VLDB | 4.4443524e-05 |
| 7,137 | Automated Validating and Fixing of Text-to-SQL Translation with Execution Consistency | 2025 | SIGMOD | 4.8165495e-05 |
| 11,123 | Demonstration of the VeriEQL Equivalence Checker for Complex SQL Queries | 2024 | VLDB | 4.1905499e-05 |
| 10,611 | Detecting Schema-Related Logic Bugs in Relational DBMSs via Equivalent Database Construction | 2025 | VLDB | 4.1905499e-05 |
| 2,899 | APOLLO: Automatic Detection and Diagnosis of Performance Regressions in Database Systems | 2020 | VLDB | 7.9478977e-05 |
| 11,512 | DeFiHap: Detecting and Fixing HiveQL Anti-Patterns | 2021 | VLDB | 4.1905499e-05 |
| 11,521 | Interactive Demonstration of SQLCheck | 2021 | VLDB | 4.1905499e-05 |