4 ms·
Is a "write if not exists" atomic operation enouhg as a concurrency primitive for database locks?
by afiori 3y ago
Is a "write if not exists" atomic operation enouhg as a concurrency primitive for database locks?
- justincormack 3y agoYes, its not necessarily the most efficient mechanism (could be a lot of retries) but its sufficient. See the Delta Lake paper for example [0] [0] https://people.eecs.berkeley.edu/~matei/papers/2020/vldb_delta_lake.pdf https://people.eecs.berkeley.edu/~matei/papers/2020/vldb_del...
- yencabulator 3y agoWhen talking about analytical databases for "big data", yeah. They generally just want a "atomically replace the list of Parquet files that make up this table", with one writer succeeding at a time. That would not be a great base to build a transactional database on.