xarray-sql icon indicating copy to clipboard operation
xarray-sql copied to clipboard

Published 20 hours ago • verified publisher icon alxmrs

Research MOLAP Databases

Open alxmrs opened this issue 1 year ago • 5 comments

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 avatar Mar 17 '24 10:03 alxmrs

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

alxmrs avatar Mar 17 '24 11:03 alxmrs

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

alxmrs avatar Mar 17 '24 11:03 alxmrs

Could Zarr become a format for a PG extension?

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

alxmrs avatar Mar 18 '24 05:03 alxmrs

How does this solution compare to PostGIS + Citus?

https://github.com/citusdata/citus

alxmrs avatar Mar 18 '24 07:03 alxmrs

e.g. https://earthmover.io/blog/learning-about-icechunk-consistency/

Edit: I called it :) https://github.com/alxmrs/xarray-sql/issues/47#issuecomment-2002408876

alxmrs avatar Sep 27 '25 20:09 alxmrs