This post dives into how different OLAP systems handle real-time updates, including approaches like Copy-on-Write, Merge-on-Read, and delete bitmap based designs.
We also discuss some of the tradeoffs between update performance, query latency, and storage complexity in analytical databases.
Happy to answer questions or discuss the design.