Patent ID: 8392461
Filing Date: 2013-03-05
Classification: G06F

Abstract:
1. A computer-implemented apparatus for performing data maintenance tasks in a data warehouse system, comprising: (a) a domain comprised of a plurality of database systems that are tuned for different objectives and particular workloads, wherein each of the plurality of database systems includes a closed-loop system management (CLSM) regulator, performed by a processor, for monitoring and managing its database system and for controlling resources within its database system, such that each CLSM regulator aggregates information related to its database system as well as that of its children CLSM regulators, and reports the aggregated information to its parent CLSM regulator; and (b) a virtual regulator, performed by a processor and comprising a CLSM regulator at a highest level of the domain, that communicates with the CLSM regulators that manage the plurality of database systems, for monitoring and managing the domain and for controlling resources within the domain across the plurality of database systems, such that the virtual regulator compiles the aggregated information reported by the CLSM regulators in order to apply rules that adjust operational characteristics of the plurality of database systems and that adjust resources allocated to workloads performed by the plurality of database systems, in order to make sure that service level goals (SLGs) for the workloads are met; (c) wherein the virtual regulator automatically: