[xquery-talk] [show xqt] A modern data warehouse, open source, written in JSONiq

[William Candillon]

https://github.com/28msec/cellstore

Written in 15k of lines JSONiq code (and 20k for the test suite), the
CellStore is an implementation of a modern data warehousing paradigm
designed by Ghislain Fourny (http://arxiv.org/pdf/1410.0600.pdf).

Cell stores are an extremely efficient solution to perform analytical
tasks on top of XML and JSON data lakes. Too often we see XML users
trying to fit their data back into traditional OLAP solutions and it
always breaks our hearts. We wanted to build OLAP commodities that
directly work on top of data lakes. And the CellStore is what we came
up with.

The relational world has SQL for queries and OLAP for analytics. We
have JSONiq/XQuery for queries and the CellStore for analytics.

The cell store model defines the notion of cell as an atom of data. A
cell contains a value and a set of dimensional coordinates that are
string-value pairs. Cells can be stored on any type of physical
storage. Whereas traditional analytical processing tools can only
support hundreds of fixed dimensions and thus need to ETL the data to
analyze, cell stores support an unbounded number of dimensions. There
is no need for fixed hypercubes to be designed up front. Hypercubes
are not the schema. Hypercubes are the queries.

We're focused on financial use cases at the moment but the technology
can be used for any vertical.

Kind regards,

William