Database Anomaly はいかに気づかれていないのか
From the beginning, it was recognized that relaxing correctness could lead to better performance. Weaker isolation levels, notably read-committed, offer over 3x higher throughput than 2PL. Why users accept it is a mystery. Perhaps the anomalous behavior it allows does not happen often, or no one notices the errors, or databases have so many mistakes for other reasons that this source of mistakes can be ignored.
Research Opportunity
Can my application run correctly with weaker isolation?
What can go wrong?
How can I identify the errors in my database?
Keynote of SIGMOD'25
Philip A. Bernstein. 2025. Fifty Years of Transaction Processing Research. In Companion of the 2025 International Conference on Management of Data (SIGMOD/PODS '25). Association for Computing Machinery, New York, NY, USA, 1–2. https://doi.org/10.1145/3722212.3727992