Athanassoulis, M., Kester, M., Maas, L., Stoica, R., Idreos, S., Ailamaki, A. and Callaghan, M. (2016). Designing access methods: the RUM conjecture. In Proceedings of the 19th International Conference on Extending Database Technology (EDBT 2016). DOI 10.5441/002/edbt.2016.42
Key takeaways
Read in full (NOTE-888). The paper names three per-operation overheads of an access method, each a ratio to the base data alone (read, update and space amplification, each minimum 1.0), and conjectures that bounding any two forces a lower bound on the third. Its evidence is three one-line propositions about extreme designs over an integer array (a direct-address array, an append-only log, an unindexed dense array), a placement of known structures on a triangle, and a table of asymptotic I/O costs; nothing is proved, and the formal statement does not say how large the forced bound is, so as worded it is close to empty. The extremes themselves show the overheads are not symmetric: the space-minimal design is also update-minimal, and the read-minimal design keeps updates at 2.0, so the clean conflicts are read against space and update against both. Build cost appears in the table but is outside the triangle, there is no workload weighting, no time or deadline, and no cost of examining an item other than reading it.
Why this is here
QUESTION-114: is sorting a collection amortized search, and does physical database design give the joint cost model the question on amortized retrieval lacks?