Applying Read-Only Optimization in Commit Processing of Pure Main Memory Database Systems

This paper applies the traditional read-only optimization in the one and two phase protocols of commit processing in the context of pure main memory database systems. Thereby there is no need for logging log records to backup node in read-only transactions. Through this optimization, the response time will be decreased in these transactions. Furthermore, the message complexity will be decreased which leads to the decrease of communicative traffic overhead during commit processing in distributed systems. This decrease in multi-level distributed transactions which are the most common types of transactions is more observable. Also, a new read-only optimization is proposed about two phase protocols that remove both the commit processing phases for read-only transactions and also removes all the logging activities to backup node for partially read-only transactions. As a result, response times, the message and log complexity, and transactions concurrency level in comparison to traditional read-only optimization will be improved more.