×

Virtual data maintenance

  • US 8,392,461 B2
  • Filed: 11/19/2007
  • Issued: 03/05/2013
  • Est. Priority Date: 11/19/2007
  • Status: Active Grant
First Claim
Patent Images

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;

    (i) routes a workload to a first database system of the plurality of database systems, based on how the plurality of database systems are tuned for different objectives and particular workloads, as well as the aggregated information compiled by the virtual regulator, for workload management and resource optimization;

    (ii) detects a request to perform a data maintenance task on data stored on the first database system of the plurality of database systems;

    (iii) determines from how the plurality of database systems are tuned for different objectives and particular workloads, as well as the aggregated information compiled by the virtual regulator, that it is undesirable to perform the data maintenance task on the data stored on the first database system, due to limited availability of resources;

    (iv) routes the data maintenance task to a second database system of the plurality of database systems for execution, when it is determined from how the plurality of database systems are tuned for different objectives and particular workloads, as well as the aggregated information compiled by the virtual regulator, that it is undesirable to perform the data maintenance task on the data stored on the first database system due to limited availability of resources, so that the data maintenance task is performed virtually on a replicated copy of the data stored on the second database system; and

    (v) applies results from the data maintenance task performed by the second database system to the first database system, thereby freeing up resources, enhancing parallel processing across the plurality of database systems, and providing cost effective dedication of specific resources for the data maintenance task.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×