With some of the recent work done with ClickHouse this has been an area I've had to learn about and, tbh, wish I had found this earlier.
Our CTO started using Morton curves for interesting purposes several months ago with initially piqued my interest and started me down the path.
https://reversedns.space/ (a map of the Internet) - Morton curve is used as a visualization tool;
https://adsb.exposed/ (a visualizer of air traffic) - Morton curve is used as a database index;
Our most recent release post dove into the usage of Hilbert curves in context of maintaining spatial locality for weather measurements
https://clickhouse.com/blog/clickhouse-release-24-06#hilbert...
Quite an interesting area of study and optimisation!
With some of the recent work done with ClickHouse this has been an area I've had to learn about and, tbh, wish I had found this earlier.
Our CTO started using Morton curves for interesting purposes several months ago with initially piqued my interest and started me down the path.
https://reversedns.space/ (a map of the Internet) - Morton curve is used as a visualization tool;
https://adsb.exposed/ (a visualizer of air traffic) - Morton curve is used as a database index;
Our most recent release post dove into the usage of Hilbert curves in context of maintaining spatial locality for weather measurements
https://clickhouse.com/blog/clickhouse-release-24-06#hilbert...
Quite an interesting area of study and optimisation!