Article ID | Journal | Published Year | Pages | File Type |
---|---|---|---|---|
379080 | Data & Knowledge Engineering | 2010 | 21 Pages |
Abstract
Traditional workload management methods mainly focus on the current system status while information about the interaction between queued and running transactions is largely ignored. This paper proposes using transaction reordering, a workload management method that considers both the current system status and information about the interaction between queued and running transactions, to improve the transaction throughput in an RDBMS. Our main idea is to reorder the transaction sequence submitted to the RDBMS to minimize resource contention and to maximize resource sharing. The advantages of the transaction reordering method are demonstrated through experiments with three commercial RDBMSs.
Keywords
Related Topics
Physical Sciences and Engineering
Computer Science
Artificial Intelligence
Authors
Gang Luo, Jeffrey F. Naughton, Curt J. Ellmann, Michael W. Watzke,