With the fundamental change of hardware technology, main-memory database systems have emerged as the next generation of DBMS. Thus, new methods to execute transactions in a serial, lock-free mode have been investigated and successfully employed, for instance in H-Store or HyPer. Although these techniques allow for unprecedentedly high throughput for suitable workloads, their throughput quickly diminishes once unsuitable transactions, for instance those crossing partition borders, are encountered. Still, little research concentrates on the overdue re-evaluation of traditional techniques, that do not rely on partitioning.This paper studies strict timestamp ordering (STO), a "good old" technique, in the context of modern main-memory database systems built on commodity hardware with high memory capacities. We show that its traditional main drawback -slowing down reads -has a much lower impact in a main-memory setting than in traditional diskbased DBMS. As a result, STO is a competitive concurrency control method which outperforms the partitioned execution approach, for example in the TPC-C benchmark, as soon as a certain percentage of the workload crosses partition boundaries.
scite is a Brooklyn-based organization that helps researchers better discover and understand research articles through Smart Citations–citations that display the context of the citation and describe whether the article provides supporting or contrasting evidence. scite is used by students and researchers from around the world and is funded in part by the National Science Foundation and the National Institute on Drug Abuse of the National Institutes of Health.