System and method for processing a prioritizing protocol
View Patent ↗A system for processing a prioritizing protocol for a database, the system including an interface for nominating a first prioritizing protocol that maps a plurality of user accounts to one or more performance groups and to one or more periods; a processor that is responsive to the interface for defining a second prioritizing protocol; and an output in communication with the processor for exporting the second prioritizing protocol. The processor defines the second prioritizing protocol by defining a plurality of workload classes; associating each user account to a particular workload class; and mapping each workload class to a workload weight. The system provides a mechanism for DBMS administrators to migrate their systems from user-centric management to workload-centric management, wherein many DBMS components require updating, replacement or modification.
1. A system for processing a prioritizing protocol for a database, the system including:
an interface for nominating a first prioritizing protocol that maps a plurality of user accounts to one or more performance groups and to one or more periods;
a processor that is responsive to the interface for defining a second prioritizing protocol by:
defining a plurality of workload classes;
associating each user account to a particular workload class; and
mapping each workload class to a workload weight; and
an output in communication with the processor for exporting the second prioritizing protocol.
2. A system according to claim 1 wherein the first protocol:
maps a group weight to a performance group to which user accounts are assignable such that each user account has an associated group weight; and
prioritizes a request from a user account in response to the associated group weight of that user account.
3. A system according to claim 2 wherein the second protocol:
maps a workload weight to a performance group to which requests are attributable such that each request has an attributed workload weight; and
prioritizes a request from a user account in response to the attributed workload weight of that request.
4. A system according to claim 3 wherein a request from a user account has a associate group weight and an equal attributed workload weight.
5. A system according to claim 4 wherein a group weight belongs to one of a plurality of existing resource partitions, and the equal workload weight belongs to the same existing resource partition.
6. A system according to claim 4 wherein a wherein a group weight belongs to one of a plurality of existing resource partitions, and the equal workload weight is mapped to one of a plurality of simplified resource partitions defined by the processor.
7. A system according to claim 6 wherein an enforcement priority corresponding to a simplified resource partition is allocated to each workload class, and the processor maps the workload weight for the allocated workload class to the corresponding simplified resource partition.
8. A system according to claim 7 wherein the enforcement priorities denote workload classes as being of a particular character.
9. A system according to claim 8 wherein workload classes of a single genre of character are mapped to a reselected simplified resource partition.
10. A system according to claim 9 wherein, wherein each existing resource partition has a standard weight and each simplified resource partition has a simplified weight.
11. A system according to claim 1 wherein the output allows a user to selectively set service level goals for each workload class.
12. A system according to claim 1 wherein the first prioritizing protocol and second prioritizing protocol are each used by a priority scheduling application.
13. A system according to claim 1 wherein the interface conforms the nominated prioritizing protocol for compliance with predetermined standards.
14. A system according to claim 13 wherein conforming the first protocol includes either or both of identifying and defining period rules for the protocol.
15. A system according to claim 14 wherein the interface is responsive to the period rules for determining workload periods.
16. A system according to claim 1 wherein confirming the nominated protocol includes determining whether one or more performance groups referenced by the protocol are active or inactive.
17. A system according to claim 16 wherein the determination is performed on the basis of either or both of an input from a user and an examination of a request log of the database.
18. A system according to claim 1 wherein the first protocol references a plurality of user accounts and a plurality of performance groups and the processor selectively either:
defines a workload class for each referenced user account and associates each user account to the workload class defined for that user account; or
defines a workload class for each referenced performance group and associates each user account in a performance group to the workload class defined for that performance group.
19. A system according to claim 18 wherein the processor is selective in response to the number of referenced user accounts and the number of referenced performance groups.
20. A system according to claim 1 wherein the output allows for selective determination of service level goals for one or more workload classes.
21. A method for processing a prioritizing protocol for a database, the method including the steps of:
nominating a first prioritizing protocol that maps a plurality of user accounts to one or more performance groups and to one or more periods;
defining a second prioritizing protocol by:
defining a plurality of workload classes;
associating each user account to a particular workload class; and
mapping each workload class to a workload weight; and
exporting the second prioritizing protocol.