Virtual regulator for a database system
View Patent ↗A virtual regulator implemented to provide closed-loop system management (CLSM) functionality to a database system and without a need to substantially adapt a given CLSM technology to account for specific nuances and requirements of an operating system. For example, the regulator may be implemented with either or both of process model operating systems and thread model operating systems. Common examples of these include UNIX, LINUX, MP-RAS, MS WINDOWS or WINDOWS NT.
1. A method for managing a database system with a regulator component, the database system being operable within an operating system for executing one or more queries, the operating system being selected from multiple types of operating systems, and the method comprising:
receiving a query of the database system;
being responsive to a protocol configured to:
classify the query to execute in accordance with a set of rules associated with a workload definition that defines one or more execution release rules for releasing the query before or after the release of one or more other queries of the database system; and
selectively releasing the query, in accordance with the classifying of the query, for execution under control of a priority scheduler facility, where the priority scheduler facility is unique to the operating system within which the database system operates and where the regulator component is operable across the multiple types of operating system; and
applying a mask to the priority scheduler facility for isolating functions associated with the regulator component that are dependent on the operating system of the priority scheduler facility to allow communication between the regulator component and the priority scheduler facility; and
wherein the mask allows the regulator component to monitor the activity of the priority scheduler facility and translates commands provided by the regulator component to the priority scheduler facility into a form functionally operable with the priority scheduler facility and each unique priority scheduler facility requires a specific mask.
2. A non-transitory computer readable storage medium storing at least computer-executable instruction for managing workloads using a regulator across a range of database system that are operable within a range of operating systems, the operating systems each being selected from multiple types of operating systems, wherein the computer-executable instructions when executed by a computing system:
receiving a query of the range of database system; and
being responsive to a protocol configured to:
classify the query to execute in accordance with a set of rules associated with a workload definition that defines one or more execution release rules for releasing the query before or after the release of one or more other queries of the database system; and
selectively releasing the query for execution under control of a priority scheduler facility in accordance with the classifying of the query, where the priority scheduler facility is unique to one of the operating systems, and where the regulator is operable across the multiple types of operating systems; and
apply a mask to the priority scheduler facility for isolating functions associated with the regulator that are dependent on the operating system of the priority scheduler facility to allow communication between the regulator and the priority scheduler facility; and
wherein the mask allows the regulator component to monitor the activity of the priority scheduler facility and translates commands provided by the regulator component to the priority scheduler facility into a form functionally operable with the priority scheduler facility and each unique priority scheduler facility requires a specific mask.
3. The non-transitory computer readable storage medium of claim 2 , wherein Parallel Database Extensions are used to insulate the regulator from operating systems.
4. The non-transitory computer readable storage medium of claim 2 , wherein the operating system is a process model operating system.
5. The non-transitory computer readable storage medium of claim 2 , wherein the operating system is a thread model operating system.
6. An apparatus that includes one or more physical processors configured to manage a database system with a regulator component, the database system being operable within an operating system for executing one or more queries, wherein the one or more processors are further configured to:
receive a query of the database system;
being responsive to a protocol configured to:
classify the query to execute in accordance with a set of rules associated with a workload definition that defines one or more execution release rules for releasing the query before or after the release of one or more other queries of the database system; and
selectively release the query, in accordance with the classifying of the query, for execution under control of a priority scheduler facility, where the priority scheduler facility is unique to the operating system within which the database system operates, and
where the regulator component is operable across the multiple types of operating system; and
apply a mask to the priority scheduler facility for isolating functions associated with the regulator component that are dependent on the operating system of the priority scheduler facility to allow communication between the regulator component and the priority scheduler facility; and
wherein the mask allows the regulator component to monitor the activity of the priority scheduler facility and translates commands provided by the regulator component to the priority scheduler facility into a form functionally operable with the priority scheduler facility and each unique priority scheduler facility requires a specific mask.