Schema-Driven Exceptional Query Generation for Soccer Analytics using Relational and Graph Databases

This thesis explores interesting fact analysis and how it could be implemented through automatically generating and executing exceptional queries using relational and graph databases. A schema-driven framework loading soccer data on a weekly basis was introduced using the Statsbomb open-source dataset. This framework automatically generates thousands of queries, executes them efficiently, and retrieves relevant facts for any entity of interest. A key contribution of this thesis was the development of a fully automatic approach for generating exceptional queries which are based solely on the underlying database schema. To go along with the full-season analysis of the data, the inclusion of rolling-window analyses to derive facts from only specific portions of a season was another contribution made in this thesis. The evaluation of this pipeline was performed using one relational database and two graph databases, comparing both the efficiency and maintenance overhead of these different databases.

Name thesis:degree_name

Master of Computer Science (M.C.S.)

Level thesis:degree_level

Master's

Discipline thesis:degree_discipline

FLAG

Grantor dc:publisher

Carleton University

Year dc:date.issued

2026

Author dc:creator

• Kuehni, Kyle Conner

Statement dc:rights

• Copyright © 2026 the author(s). Theses may be used for non-commercial research, educational, or related academic purposes only. Such uses include personal study, distribution to students, research and scholarship. Theses may only be shared by linking to the Carleton University Institutional Repository and no part may be copied without proper attribution to the author; no part may be used for commercial purposes directly or indirectly via a for-profit platform; no adaptation or derivative works are permitted without consent from the copyright owner.

Language dc:language.iso

en

DOI

10.22215/etd/2026-16937

OAI identifier oai:identifier

oai:carleton.scholaris.ca:20.500.14718/45094