Automatic and dynamic provisioning of databases

• US 8,161,085 B2
• Filed: 10/14/2010
• Issued: 04/17/2012
• Est. Priority Date: 08/14/2003
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Souder, Benny, Stamos, James, Wong, Lik, Ciminski, John, Lakshminath, Anand, Downing, Alan
• Primary Examiner(s): Fleurantin, Jean B
• Application Number:
  US12/904,345
• Publication Number:
  US 20110029585A1
• Time in Patent Office: 551 Days
• Field of Search: 707600 -831, 711/161, 711/162
• US Class Current: 707/825
• CPC Class Codes: G06F 16/2386 Bulk updating operations data conversion details G06F16/258

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.

Claims

1. A method for a particular database server to provide copies of files, the method comprising the steps of:

on a particular computing element, said particular database server running under control of a particular operating system that manages resources of said particular computing element, wherein said particular database server comprises database server code separate from said particular operating system;

said particular database server receiving a request to create a copy of a first file stored in a first file system of a first operating system;

said particular database server causing the creation of said copy in a second file system of a second operating system, wherein causing the creation of said copy in a second file system of a second operating system is performed pursuant execution of one or more routines of said database server code; and

wherein said copy is a different file than said first file.

2. The method of claim 1,

wherein the particular database server causing the creation of said copy includes causing the transmission of the copy of said first file between said particular database server and a second database server;

and

wherein the steps further include storing said copy in said second file system.

3. The method of claim 2, wherein:

said first file system is local relative to said particular database server and remote relative to said second database server, wherein said particular operating system is said first operating system;

said second file system is local relative to said second database server and remote relative to said particular database server; and

wherein the step of storing is performed by said second database server.

4. The method of claim 2, wherein the step of causing the transmission includes causing the transmission of the copy as a binary file via a messaging system that propagates messages between said particular database server and said second database server.

5. The method of claim 2, wherein:

said first file system is local relative to said second database server and remote relative to said particular database server;

said second file system is local relative to said particular database server and remote relative to said second database server, wherein said particular operating system is said second operating system; and

wherein the step of storing is performed by said particular database server.

6. The method of claim 1, wherein said first file system is local relative to said particular database server and said second file system is local relative to said second database server, wherein said particular operating system is said first operating system.

7. The method of claim 1, wherein receiving a request includes the invocation of a routine that passes as a parameter a value identifying the file.

8. The method of claim 1, wherein:

receiving a request includes receiving a command through an interface;

said particular database server executes commands received through said interface that conform to a database language; and

said command identifies the file.

9. A computer-readable non-transitory storage medium storing one or more instructions for a database server to provide copies of files, which instructions, when executed, cause one or more processors to perform:

on a particular computing element, a particular database server running under control of a particular operating system that manages resources of said particular computing element, wherein said particular database server comprises database server code separate from said particular operating system;

said particular database server receiving a request to create a copy of a first file stored in a first file system of a first operating system;

said particular database server causing the creation of said copy in a second file system of a second operating system, wherein causing the creation of said copy in a second file system of a second operating system is performed pursuant execution of one or more routines of said database server code; and

wherein said copy is a different file than said first file.

10. The computer-readable non-transitory storage medium of claim 9,

wherein the particular database server causing the creation of said copy includes causing the transmission of the copy of said first file between said particular database server and a second database server;

and

wherein the steps further include storing said copy in said second file system.

11. The computer-readable non-transitory storage medium of claim 10, wherein:

said first file system is local relative to said particular database server and remote relative to said second database server, wherein said particular operating system is said first operating system;

said second file system is local relative to said second database server and remote relative to said particular database server; and

wherein the step of storing is performed by said second database server.

12. The computer-readable non-transitory storage medium of claim 10, wherein the step of causing the transmission includes causing the transmission of the copy as a binary file via a messaging system that propagates messages between said first database server and said second database server.

13. The computer-readable non-transitory storage medium of claim 9, wherein:

said first file system is local relative to said second database server and remote relative to said particular database server;

said second file system is local relative to said particular database server and remote relative to said second database server, wherein said particular operating system is said second operating system; and

wherein the step of storing is performed by said particular database server.

14. The computer-readable non-transitory storage medium of claim 9, wherein said first file system is local relative to said particular database server and said second file system is local relative to said second database server, wherein said particular operating system is said first operating system.

15. The computer-readable non-transitory storage medium of claim 9, wherein receiving a request includes the invocation of a routine that passes as a parameter a value identifying the file.

16. The computer-readable non-transitory storage medium of claim 9, wherein:

receiving a request includes receiving a command through an interface;

said database server executes commands received through said interface that conform to a database language; and

said command identifies the file.