Every dispatch filed under “Databases” · 7 entries.
A detailed breakdown of Apache Doris, the MPP real-time data warehouse that speaks the MySQL protocol, covering its storage engine, meta service,...
A deep dive into the R-tree, the data-driven spatial index built on bounding rectangles, and how it powers range and nearest-neighbor queries....
Tessellation for spatial indexing divides space into non-overlapping shapes for efficient data management. The Uber H3 grid system uses hexagonal cells, offering...
Grid systems in spatial indexing, including Geohash and Google S2, encode geographic locations for efficient spatial data management. Geohash uses a Z-order...
Spatial indexes optimize multi-dimensional data querying using space-filling curves like Z-order and Hilbert curves. Z-order curves employ a recursive Z pattern, and...
How B-trees and B+ trees organize data on disk for fast lookups, starting from disk structure and why databases lean on them...
Modeling and querying graph data in PostgreSQL when a dedicated graph database would be overkill, starting from graph fundamentals.