Research MOLAP Databases

[alxmrs]

https://en.wikipedia.org/wiki/Online_analytical_processing?wprov=sfti1#Multidimensional_OLAP_(MOLAP)

https://en.wikipedia.org/wiki/OLAP_cube

It seems like this is probably a wide body of research to learn from that could make this project more effective. Best not fail to learn from mistakes past.

[alxmrs]

Could Xarray and Zarr be used to implement a traditional DB? Like, to store business data and perform OLAP queries?

[alxmrs]

There are a lot of OLAP DBs around! https://en.wikipedia.org/wiki/Comparison_of_OLAP_servers

[alxmrs]

Could Zarr become a format for a PG extension?

https://pigsty.io/blog/pg/pg-eat-db-world/

[alxmrs]

How does this solution compare to PostGIS + Citus?

https://github.com/citusdata/citus