keiko kamijo
I work as a software engineer, mainly on test automation, CI/CD tooling, and authorization systems for production services.
Session
This talk explores the inner workings of an RDBMS through KeiPyDB, a custom RDBMS I implemented in Python.We will follow the processing flow of a SELECT statement step by step, covering lexical analysis, parsing, abstract syntax tree construction, query planning, and execution, using code examples and debugger output.
The talk also covers the storage layer. By inspecting actual data files with a hex viewer, we will observe how pages and records are stored on disk, and how INSERT and DELETE operations modify them.
The goal of this session is to provide a clear, concrete understanding of the main components that make up an RDBMS. It is intended for attendees who are familiar with SQL but have not yet examined how a database processes queries internally.