Dynamic Adjustment Paradigm based on Genetic Algorithm in Database Index Optimization

Jinsong Wang. 2024. 2024 International Conference on IoT Based Control Networks and Intelligent Systems (ICICNIS).

Read the paper · doi:10.1109/icicnis64247.2024.10823213

What this paper does with SQLancer

NoREC is described in the review of database optimization work: the paper summarises how it constructs a non-optimizing reference engine and detects differences between optimized and non-optimized evaluation, and notes that experiments show it effectively detects optimization errors. That is the whole of the connection -- the paper's own subject is index selection, and no oracle is used, extended or compared against. This paper applies a genetic algorithm to database index selection, adjusting the index set dynamically as the workload changes. Its literature review surveys prior work on database optimization, of which automated testing is one strand. Written by claude-opus-5 from the 3 places 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 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
6	Rigger, Manuel, and Zhendong Su. "Detecting optimization bugs in database engines via non -optimizing reference engine construction." In Proceedings of the 28th ACM Joint Meeting on European Software Engineering Confe...	sqlancer publication · NOREC

Every place it refers to SQLancer (3)

3 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	Rigger and Su [6] designed and optimized NoREC, a non-optimized engine construction method that can be used to detect optimization errors in database engines.	technique definition	II REVIEW OFDATABASE OPTIMIZATION STUDIES page 2
M2	The proposed NoREC constructs a non -optimized engine to evaluate queries and detects the differences between optimized and non optimized engines.	technique definition	II REVIEW OFDATABASE OPTIMIZATION STUDIES page 2
M3	Multiple experiments clearly show that the NoREC model can effectively detect the optimization errors.	technique background	II REVIEW OFDATABASE OPTIMIZATION STUDIES page 2

This page is rendered from _data/papers/paper_doi_10_1109_icicnis64247_2024_10823213.json, extracted from supplied pdf. 7 pages, 24 references parsed.