Adapting Performance Analytic Techniques in a Real-World Database-Centric System: An Industrial Experience Report

Lizhi Liao, Heng Li, Weiyi Shang, Catalin Sporea, Andrei Toma, S. Sajedi. 2023. ESEC/SIGSOFT FSE.

Read the paper · doi:10.1145/3611643.3613893

What this paper does with SQLancer

A single citation naming SQLancer's three oracles -- query partitioning, pivoted query synthesis and non-optimizing reference engine construction -- as analysis techniques Rigger and Su apply to databases. An industrial experience report on adapting performance analysis to a large-scale database-centric system. The authors argue that in such systems most business logic and calculation live in the database rather than the application, and that because those calculations are written in SQL, both the performance issues and their diagnosis differ from systems dominated by conventional programming languages. Written by claude-opus-5 from the 1 place this paper refers to SQLancer. The quotations below are the paper's own words, stored verbatim when the text was extracted.

How it was classified

uses infrastructure — no

SQLancer is cited, not used; nothing in the mentions describes reusing its code.

extends technique — no

No technique is extended; the citation is background.

compares with — no

No empirical comparison against SQLancer is reported in the mentions.

describes as state of the art — no

The citation does not characterise SQLancer as the state of the art.

SQLancer publications it cites (3)

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
42	Manuel Rigger and Zhendong Su. 2020. Detecting optimization bugs in database engines via non-optimizing reference engine construction. In ESEC/FSE ’20: 28th 1865 ESEC/FSE ’23, December 3–9, 2023, San Francisco, CA, US...	sqlancer publication · NOREC
43	Manuel Rigger and Zhendong Su. 2020. Finding bugs in database systems via query partitioning. Proc. ACM Program. Lang. 4, OOPSLA (2020), 211:1–211:30.	sqlancer publication · TLP
44	Manuel Rigger and Zhendong Su. 2020. Testing Database Engines via Pivoted Query Synthesis. In 14th USENIX Symposium on Operating Systems Design and Implementation, OSDI 2020, Virtual Event, November 4-6, 2020. USENIX ...	sqlancer publication · PQS

Every place it refers to SQLancer (1)

1 sentence, 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	Rigger and Su utilize multiple analysis techniques, such as query partitioning [ 43], pivoted query synthesis [ 44], or non-optimizing reference engine construction [ 42] to detect database logic bugs that are critical in databasecentric system quality but often go unnoticed by developers.	technique background	4.2 P erformance r egression a nalysis between page 10

This page is rendered from _data/papers/paper_doi_10_1145_3611643_3613893.json, extracted from supplied pdf. 12 pages, 58 references parsed.