Database queries and constraints via lifting problems

Abstract

Previous work has demonstrated that categories are useful and expressive models for databases. In the present paper we build on that model, showing that certain queries and constraints correspond to lifting problems, as found in modern approaches to algebraic topology. In our formulation, each so-called SPARQL graph pattern query corresponds to a category-theoretic lifting problem, whereby the set of solutions to the query is precisely the set of lifts. We interpret constraints within the same formalism and then investigate some basic properties of queries and constraints. In particular, to any database $\pi$ we can associate a certain derived database $\Qry(π)$ of queries on $\pi$. As an application, we explain how giving users access to certain parts of $\Qry(π)$, rather than direct access to $\pi$, improves ones ability to manage the impact of schema evolution.

References in corpus (4)

• Ologs: a categorical framework for knowledge representation
• Polynomial functors and polynomial monads
• Understanding the small object argument
• Homotopy theoretic models of identity types

Cited by in corpus (6)

• Algebraic Model Management: A Survey
• A diagrammatic view of differential equations in physics
• A Formal Category Theoretical Framework for Multi-model Data Transformations
• Learning Functors using Gradient Descent
• Compositional Separation of Control Flow and Data Flow
• A category-theoretic approach to modeling John Cage's Silent piece