SchemaDB: Structures in Relational Datasets
This provides a resource for researchers studying database structures, addressing a gap due to privacy concerns, though it is incremental as it focuses on data collection rather than new methods.
The paper tackles the lack of publicly available relational database schemata by introducing SchemaDB, a dataset of 2,500 standardized schemata from public repositories, enabling structural analysis and downstream research.
In this paper we introduce the SchemaDB data-set; a collection of relational database schemata in both sql and graph formats. Databases are not commonly shared publicly for reasons of privacy and security, so schemata are not available for study. Consequently, an understanding of database structures in the wild is lacking, and most examples found publicly belong to common development frameworks or are derived from textbooks or engine benchmark designs. SchemaDB contains 2,500 samples of relational schemata found in public repositories which we have standardised to MySQL syntax. We provide our gathering and transformation methodology, summary statistics, and structural analysis, and discuss potential downstream research tasks in several domains.