Relational Foundations For Functorial Data Migration
Abstract
We study the data transformation capabilities associated with schemas that are presented by directed multi-graphs and path equations. Unlike most approaches which treat graph-based schemas as abbreviations for relational schemas, we treat graph-based schemas as categories. A schema $S$ is a finitely-presented category, and the collection of all $S$-instances forms a category, $S$-inst. A functor $F$ between schemas $S$ and $T$, which can be generated from a visual mapping between graphs, induces three adjoint data migration functors, $\Sigma_F:S$-inst$\to T$-inst, $\Pi_F: S$-inst $\to T$-inst, and $\Delta_F:T$-inst $\to S$-inst. We present an algebraic query language FQL based on these functors, prove that FQL is closed under composition, prove that FQL can be implemented with the select-project-product-union relational algebra (SPCU) extended with a key-generation operation, and prove that SPCU can be implemented with FQL.
- Publication:
-
arXiv e-prints
- Pub Date:
- December 2012
- DOI:
- 10.48550/arXiv.1212.5303
- arXiv:
- arXiv:1212.5303
- Bibcode:
- 2012arXiv1212.5303S
- Keywords:
-
- Computer Science - Databases;
- Mathematics - Category Theory;
- Mathematics - Logic;
- 18A40;
- 68P15;
- 03B70;
- H.2;
- H.3.3