Tagged: Databases

Projects

• Query Optimisation of Semantically Equivalent Queries in SQLite3 — This work focuses on SQLite's query optimiser by executing three pairs of semantically equivalent queries across progressively larger instances of the Mondial database. We examine subquery flattening and co-routine usage, the performance impact of DISTINCT versus self-JOIN with GROUP BY, and index utilisation for filtered selections. Hypotheses are stated before experimentation, with query execution plans and timing measurements used to assess each pair.