Optimizing Database System Performance: Design and Query Optimization Strategies
Read the paper · doi:10.53799/zb6b1375
What this paper does with SQLancer
How it was classified
uses infrastructure — no
SQLancer is cited as related work; no reuse of its code, generator or workload is described.
extends technique — no
No SQLancer technique is extended; the citation is background.
compares with — no
No empirical comparison against SQLancer or one of its oracles is reported.
describes as state of the art — no
The text does not describe SQLancer as the state of the art.
SQLancer publications it cites (1)
Bibliography entries that resolved to a SQLancer publication, or to a paper by one of the project's authors. A sentence citing one of these numbers is a reference to SQLancer even when it never writes the name.
| # | Entry | Matched as |
|---|---|---|
| 13 | J. Ba and M. Rigger, “CERT: Finding performance issues in database systems th rough the lens of cardinality estimation,” in Proc. ACM SIGMOD Int. Conf. Manage. Data, 2023, pp. 1600 –1612, doi: 10.1145/3597503.3639076. | sqlancer publication · CERT |
Every place it refers to SQLancer (4)
4 sentences, each stored verbatim from the extracted text with where it was found and how. “Citation marker” means the sentence names no tool at all and was reached through a reference number that resolved to a SQLancer publication.
| Id | Sentence | Found by | Where |
|---|---|---|---|
| M1 | Recent studies have further shown that additional dependency information and cardinality -estimation quality can significantly affect query plan efficiency and execution behavior [10], [13]. |
citation marker |
page 1 |
| M2 | Existing studies tend to focus either on general normalization strategies [6-12] or on optimizer behavior and cost estimation [10], [13], leaving a gap in understanding how alternative r elational design choices influence practical DBMS performance under a shared workload. |
citation marker |
page 2 |
| M3 | Ba and Rigger furt her confirmed that cardinality -estimation errors remain a meaningful source of DBMS performance issues across mature database systems [13]. |
citation marker |
page 2 |
| M4 | Research Gap Prior studies have established that relational schema design influences query performa nce [7 -12] and that optimizer effectiveness depends on access paths, cardinality estimation, AJSE Volume 25, Issue 1, Page 19 - 30 Page 20 and structural dependencies [1 -5], [10], [13]. |
citation marker |
page 2 |