Research MOLAP Databases

alxmrs / xarray-sql

An experiment to query Xarray datasets with SQL

Apache License 2.0

20 stars 2 forks source link

Research MOLAP Databases #47

Open alxmrs opened 2 months ago

alxmrs commented 2 months ago

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 commented 2 months ago

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

alxmrs commented 2 months ago

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

alxmrs commented 2 months ago

Could Zarr become a format for a PG extension?

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

alxmrs commented 2 months ago

How does this solution compare to PostGIS + Citus?

https://github.com/citusdata/citus