OPTIMIZATION OF MIXED DATABASE WORKLOAD SCHEDULING AND CONCURRENCY CONTROL BY MINING DATA DEPENDENCY RELATIONSHIPS VIA LOCK TRACING

摘要

The present disclosure relates generally to the field of determining data access patterns associated with different workloads. In various examples, determining data access patterns associated with different workloads may be implemented in the form of systems, methods and/or algorithms. The present disclosure also relates generally to the field of scheduling workloads (and/or recommending scheduling for workloads) based upon the determined data access patterns associated with the different workloads. In various examples, scheduling workloads (and/or recommending scheduling for workloads) may be implemented in the form of systems, methods and/or algorithms.

主权项

1. A method for workload scheduling, the method comprising:
obtaining, by a processor, lock trace data associated with a plurality of workloads; replaying, by the processor, the lock trace data associated with the workloads to identify at least one data access conflict between a first one of the workloads and a second one of the workloads; decomposing, by the processor, based at least in part upon the at least one identified data access conflict, at least the first one of workloads into a plurality of shorter duration execution units; and scheduling, by the processor, at least one of the shorter duration execution units at a time window that at least partially overlaps a time window of at least the second one of the workloads.