Teradata Us, Inc.

Scott E Gnau

Douglas Paul Brown

John Mark Morris

William P Ward

A query is executed on a multi-database system. The multi-database system includes a first system database and a second system database. The query is partially executed on a first system database by generating a spool. It is determined that it is more efficient to store the spool on the second system database than to store the spool on the first system database, and in response the spool is stored on the second system database. The query execution is continued by accessing the spool on the second system database, completing execution of the query to produce a result, and storing the result.

Spool management and checkpointing in a multi-database system

A virtual regulator monitors and manages a plurality of database systems in a domain. Each of the database systems is tuned for a particular type of workload, and the virtual regulator or multiple virtual regulators running in parallel routes a set of one or more queries to a particular database system within the domain based on a cost function for each database system.

Dynamic query and step routing between systems tuned for different objectives

A system and method for managing a domain comprised of a plurality of database systems, wherein each of the database systems performs database queries to retrieve data stored by the database systems. There are one or more virtual regulators for managing the domain and one or more closed-loop system management (CLSM) regulators for managing each of the database systems in the domain. Both the virtual regulators and CLSM regulators perform parallel virtual optimization of the database queries performed by the database systems.

Growing community of inventors

Escondido, CA, United States of America

Scott E Gnau