Nov 24, 2019 | Case Studies, Technical Papers
Abstract Using a simplified financial reporting example, we examine how traditional data warehouses are put together. We then propose an improved method for creating data warehouses: using the categorical query language CQL. Finally we demonstrate how CQL enables the...
Nov 24, 2019 | Case Studies, Technical Papers
Abstract We consider the issue of multiple overlapping data models in the context of modern power grids. We present a methodology for specifying, managing and reasoning within multiple models of distributed energy resources (DERs, e.g., microgrids and generators)...
Sep 11, 2019 | Case Studies, Technical Papers
Abstract In this paper we consider how to integrate a simple and developer-friendly data model such as the property graph with more complex and less user-friendly data models such as relational database tables. We observe that algebraic data types are a common...
Jun 15, 2019 | Case Studies, Technical Papers
Abstract CQL is an open-source query and data integration scripting language that can be applied to common challenges in the field of computational science. It can preserve structure as it moves data from one database to another, and thus allows users who share their...
Jun 17, 2017 | Case Studies, Technical Papers
Abstract We approach the integration of manufacturing service capability databases using a different set of tools, specifically category theory (CT) and FQL, a functorial query language based on categorical mathematics. This work demonstrates the potential utility of...