strategy

Copy on Write

prioritizes faster reads by doing the work upfront (copying).

• Immutable
  • Immutable Commit Tree in Git
  • MVCC in pg, oracle, snowflake

Merge on Read

prioritizes faster writes by delaying the work (merging) until reading.

• append-only
  • The event sourcing on Data Lake Table Format
  • Log as Data