Algebraic Databases

Fuente: arXiv
Saved in:
Bibliographic Details
Main Authors: Schultz, Patrick, Spivak, David I., Vasilakopoulou, Christina, Wisnesky, Ryan
Format: Preprint
Published: 2016
Subjects:
Online Access:
Tags: Add Tag
No Tags, Be the first to tag this record!
_version_ 1866912191199838208
author Schultz, Patrick
Spivak, David I.
Vasilakopoulou, Christina
Wisnesky, Ryan
author_facet Schultz, Patrick
Spivak, David I.
Vasilakopoulou, Christina
Wisnesky, Ryan
contents Databases have been studied category-theoretically for decades. The database schema -- whose purpose is to arrange high-level conceptual entities -- is generally modeled as a category or sketch. The data itself, often called an instance, is generally modeled as a set-valued functor, assigning to each conceptual entity a set of examples. While mathematically elegant, these categorical models have typically struggled with representing concrete data such as integers or strings. In the present work, we propose an extension of the set-valued functor model, making use of multisorted algebraic theories (a.k.a. Lawvere theories) to incorporate concrete data in a principled way. This also allows constraints and queries to make use of operations on data, such as multiplication or comparison of numbers, helping to bridge the gap between traditional databases and programming languages. We also show how all of the components of our model -- including schemas, instances, change-of-schema functors, and queries - fit into a single double categorical structure called a proarrow equipment (a.k.a. framed bicategory).
format Preprint
id arxiv_https___arxiv_org_abs_1602_03501
institution arXiv
publishDate 2016
record_format arxiv
spellingShingle Algebraic Databases
Schultz, Patrick
Spivak, David I.
Vasilakopoulou, Christina
Wisnesky, Ryan
Category Theory
Databases
18C10, 18D05, 68P15
Databases have been studied category-theoretically for decades. The database schema -- whose purpose is to arrange high-level conceptual entities -- is generally modeled as a category or sketch. The data itself, often called an instance, is generally modeled as a set-valued functor, assigning to each conceptual entity a set of examples. While mathematically elegant, these categorical models have typically struggled with representing concrete data such as integers or strings. In the present work, we propose an extension of the set-valued functor model, making use of multisorted algebraic theories (a.k.a. Lawvere theories) to incorporate concrete data in a principled way. This also allows constraints and queries to make use of operations on data, such as multiplication or comparison of numbers, helping to bridge the gap between traditional databases and programming languages. We also show how all of the components of our model -- including schemas, instances, change-of-schema functors, and queries - fit into a single double categorical structure called a proarrow equipment (a.k.a. framed bicategory).
title Algebraic Databases
topic Category Theory
Databases
18C10, 18D05, 68P15
url https://arxiv.org/abs/1602.03501