Single repository manifestation of a multi-repository system

• US 8,392,439 B2
• Filed: 05/31/2011
• Issued: 03/05/2013
• Est. Priority Date: 11/05/2003
• Status: Active Grant

• Current Assignee: Hewlett Packard Enterprise Development LP (Hewlett-Packard Enterprise Company)
• Original Assignee: Hewlett-Packard Development Company, L.P. (HP Inc.)
• Inventors: Bodamer, Roger, Dahbour, Ziyad Mohammad, Templeton, Bruce Alec, Butterfield, Richard Ira
• Primary Examiner(s): Ortiz Ditren, Belix M
• Application Number:
  US13/149,295
• Publication Number:
  US 20110231398A1
• Time in Patent Office: 644 Days
• Field of Search: 707/758, 707/736, 707/695
• US Class Current: 707/758
• CPC Class Codes: G06F 16/217 Database tuning G06F16/2282 takes precedence; database performance monitoring G06F11/3409

Abstract

Techniques are provided for manifesting a multiple repository system as a single repository to an application that is designed to use a single repository. According to one aspect, a particular container, which is used by the application to store data, is identified. One or more additional containers are created in one or more different repositories. Each of the additional containers is formatted to store the data that the application stores in the particular container. A construct is created. The construct is associated with the particular container'"'"'s identifier. The construct causes information from the particular container and each of the additional containers to be combined to answer database commands that reference the particular container'"'"'s identifier. As a result, data stored in a single repository can be distributed among multiple repositories, and the unmodified application can continue to access that data as though the data was stored in the single repository.

Claims

1. A computer-implemented method for use with an application designed to interact with a single database of a single database system comprising:

converting the single database system into a multi-database system that is manifested to said application as the single database system, comprising;

selecting a first table within the single database, the first table having information items stored therein and having a particular identifier by which the application is to identify the first table;

creating a second table in a different database provided for the multi-database system; and

removing at least a portion of the information items from the first table and storing the removed information items in the second table; and

in response to a database command from the application, retrieving the information items stored in the second table and returning the retrieved information items to the application.

2. The computer-implemented method of claim 1 further including, creating a construct that has the same particular identifier as the first table such that the database command from the application is directed toward the construct instead of the first table.

3. The computer-implemented method of claim 2 further including, in response to execution of a statement contained in the construct, combining information items from the first table and the second table and returning the combined items to the application.

4. The computer-implemented method of claim 2 including removing all of the information items from the first table and storing the removed information items in the second table, and in response to accessing the construct instead of the first table, pointing to the information items stored in the second table.

5. The computer-implemented method of claim 4 further including finding executable statements in the single database that refer to said first table by said particular identifier and modifying the executable statements to refer to the second table.

6. The computer-implemented method of claim 5 further including creating an identifier for said second table that is different from said particular identifier, and wherein modifying the executable statements includes referring to said second table by said identifier for said second table.

7. The computer-implemented method of claim 2 further including identifying the first table by a new identifier to distinguish the first table from said construct.

8. An article comprising a non-transitory computer-readable storage medium to store instructions that when executed by at least one processor cause said at least one processor to:

convert a single database system into a multi-database system that is manifested to an application as the single database system, where the converting comprises;

selecting a first table within the single database of the single database system, the first table to store information items therein and to have a particular identifier by which the application is to identify the first table;

creating a second table in a different database to be included in the multi-database system; and

removing at least a portion of the information items stored in the first table and storing the removed information items in the second table; and

in response to a database command from the application, retrieve the information items stored in the second table and return the retrieved information items to the application.

9. The article of claim 8, the storage medium to store instructions that when executed by said at least one processor cause said at least one processor to create a construct that has the same particular identifier as the first table such that the database command from the application is directed toward the construct instead of the first table.

10. The article of claim 9, the storage medium to store instructions that when executed by said at least one processor cause said at least one processor to, in response to execution of a statement contained in the construct, combine information items from the first table and the second table and return the combined items to the application.

11. The article of claim 9, the storage medium to store instructions that when executed by said at least one processor cause said at least one processor to remove all of the information items from the first table and store all of the removed information items in the second table, and in response to accessing the construct instead of the first table, point to the information items stored in the second table.

12. The article of claim 11, the storage medium to store instructions that when executed by said at least one processor cause said at least one processor to find executable statements in the single database that refer to said first table by said particular identifier and modify the executable statements to refer to the second table.

13. The article of claim 12, the storage medium to store instructions that when executed by said at least one processor cause said at least one processor to create an identifier for said second table that is different from said particular identifier, and modify the executable statements to refer to said second table by said identifier for said second table.

14. The article of claim 9, the storage medium to store instructions that when executed by said at least one processor cause said at least one processor to identify the first table by a new identifier to distinguish the first table from said construct.

15. A multi-database system manifested as a single database system to an application designed to interact with a single database system comprising:

a first table stored in a first database, the first table to store information items therein and to have a particular identifier by which the application is to identify the first table;

a second table stored in a second database other than the first database; and

at least one processor to store instructions that when executed cause the at least one processor to remove at least a portion of the information items stored in the first table and store the removed information items in the second table, and, in response to a database command from the application, to retrieve the information items stored in the second table and return the retrieved information items to the application.

16. The multi-database system of claim 15 wherein the at least one processor is to store instructions that when executed cause the at least one processor to, create a construct that has the same particular identifier as the first table such that the database command from the application is directed toward the construct instead of the first table.

17. The multi-database system of claim 16 wherein the at least one processor is to store instructions that when executed cause the at least one processor to, in response to execution of a statement contained in the construct, combine information items from the first table and the second table and return the combined items to the application.

18. The multi-database system of claim 16 wherein the at least one processor is to store instructions that when executed cause the at least one processor to remove all of the information items from the first table and store all of the removed information items in the second table, and, in response to a pointer in the construct, retrieve the information items stored in the second table.

19. The multi-database system of claim 15 wherein the first database and the second database are both logically and physically separated.