Merge-on-Read

A write strategy in transactional table formats where updates and deletes are written to separate log files (delete files). During read execution, the engine merges the base files with the logs.

Part of the Data & AI Terms glossary.