Automatic and dynamic provisioning of databases

Abstract

Approaches described herein may be used for provisioning of databases that requires a bulk transfer of data within a distributed computing environment, such as a grid. The approaches do not require the manual intervention of a DBA to, for example, transfer a tablespace between the file systems of operating systems. Instead, the tablespaces may be provisioned automatically and dynamically by a grid computing system whenever it determines the need to dynamically provision a database. In addition, as copies of tablespaces are provisioned, synchronization mechanisms can also be automatically provisioned to keep the tablespaces and their copies in sync.

Description

RELATED APPLICATIONS[0001]This application claims priority to U.S. Provisional Application No. 60 / 495,368, entitled Computer Resource Provisioning, filed by Debashish Chatterjee, et al. on Aug. 14, 2003, the contents of which are incorporated herein by reference; this application claims priority to U.S. Provisional Application No. 60 / 500,050, entitled Automatic And Dynamic Provisioning Of Databases, filed by Benny Souder, et al. on Sep. 3, 2003, the contents of which are incorporated herein by reference; this application claims priority to U.S. Provisional Application 60 / 500,096, entitled Service Based Workload Management and Measurement in a Distributed System, filed by Carol Colrain, et al. on Sep. 3, 2003, the contents of which are incorporated herein by reference.[0002]The following applications are related to the current application:[0003]U.S. Provisional Application No. 60 / 410,883, entitled Oracle Streams, filed by Alan Downing, et al. on Sep. 13, 2002, the contents of which a...

AI Technical Summary

Benefits of technology

This solution allows for efficient, automated allocation and synchronization of database resources, enhancing the ability of grid computing systems to dynamically meet varying workload demands without manual intervention, thereby optimizing resource utilization and reducing costs.

Problems solved by technology

As a result, there is a lot of resource capacity that is left unutilized.

Unfortunately, techniques for bulk transfer of data that are used for database provisioning entail manual intervention and therefore cannot be used to effectively provision data automatically and dynamically as is required for grid computing.

Because Grid computing requires that data provisioning be performed automatically and dynamically, database provisioning that requires the bulk transfer of data is not amenable for Grid computing.

Images