Transaction reordering with application to synchronized scans

Traditional workload management methods mainly focus on the current system status while information about the interaction between queued and running transactions is largely ignored. An exception to this is the transaction reordering method, which reorders the transaction sequence submitted to the RDBMS and improves the transaction throughput by considering both the current system status and information about the interaction between queued and running transactions. The existing transaction reordering method only considers the reordering opportunities provided by analyzing the lock conflict information among multiple transactions. This significantly limits the applicability of the transaction reordering method. In this paper, we extend the existing transaction reordering method into a general transaction reordering framework that can incorporate various factors as the reordering criteria. We show that by analyzing the resource utilization information of transactions, the transaction reo...

• Type: Conference
• Year: 2008
• Where: CIKM
• Authors: Gang Luo, Jeffrey F. Naughton, Curt J. Ellmann, Michael Watzke
• Keywords: CIKM 2008, Information Management, Transaction Reordering Framework, Transaction Reordering Method, Transaction Sequence