Run-time access techniques for database images

• US 7,024,420 B2
• Filed: 04/30/2002
• Issued: 04/04/2006
• Est. Priority Date: 04/30/2002
• Status: Active Grant

• Current Assignee: BMC Software Incorporated (KKR & Co., Inc.)
• Original Assignee: BMC Software Incorporated (KKR & Co., Inc.)
• Inventors: Ball, Linda S., Price, Thomas G., Dee, Stanley James, Cunningham, William R.
• Primary Examiner(s): Caffin, Jeffrey
• Assistant Examiner(s): Wu, Yicun
• Application Number:
  US10/135,652
• Publication Number:
  US 20030204510A1
• Time in Patent Office: 1,435 Days
• Field of Search: 707/1, 707/2, 707/3, 707/4, 707/8, 707/9, 707/10, 707/100, 707/101, 707/102, 707/104, 707/201, 707/204, 707/205, 709/201, 709/209
• US Class Current: 1/1
• CPC Class Codes: G06F 16/20 of structured data, e.g. relational data
• CPC Class Codes: G06F 2003/0697 device management, e.g. handlers, drivers, I/O schedulers
• CPC Class Codes: G06F 3/0601 Interfaces specially adapted for storage systems
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

Techniques to provide run-time access to a database image through a target database management system (DBMS) are described. An empty database in the target DBMS (the “target database”) is created having substantially the same schema as the database image. At run-time, queries directed to the target database are intercepted and redirected to the database image. Information returned in response to the redirected query is modified so that internal database identifiers retrieved from the database image are replaced with like database identifiers associated with the target database management system. Thus, run-time access to database image content is provided without the need to load the database image'"'"'s data content into a target database.

Claims

1. A method to provide run-time access to a database image, comprising:

receiving a query directed to a first database;

redirecting the query to a file associated with a database image;

receiving data from the file associated with the database image in response to the query;

generating return data by substituting database identifiers in the received data associated with the database image with database identifiers associated with the first database; and

providing the return data.

2. The method of claim 1, wherein the act of receiving a query comprises receiving a query directed to a specified file associated with the first database.

3. The method of claim 2, wherein the first database and the database image comprise the same type of database.

4. The method of claim 3, wherein the first database and the database image comprise DB2 type databases.

5. The method of claim 4, wherein the act of substituting database identifiers comprises substituting an OBID value associated with the image database with an OBID value associated with the first database.

6. The method of claim 5, wherein the act of substituting database identifiers further comprises substituting a specified value in the returned data for a log file identifier in the data received from the file associated with the database image.

7. The method of claim 3, wherein the first database and the database image are Information Management System (IMS) type databases.

8. The method of claim 7, wherein the act of substituting database identifiers comprises substituting a data set name value associated with the image database with an data set name value associated with the first database.

9. The method of claim 3, wherein the first database is accessible through a first database management system (DBMS) application and the database image was created through a second DBMS application.

10. The method of claim 9, wherein the first and second DBMS applications are different DBMS applications.

11. The method of claim 10, wherein the first and second DBMS applications execute on the same computer system.

12. The method of claim 10, wherein the first and second DBMS applications execute on different computer systems.

13. The method of claim 1, further comprising:

determining the database image schema;

creating the first database based on the database image schema, the first database having substantially the same schema as the database image schema and comprising one or more empty data structures; and

generating a translation scheme for translating file names associated with the database image schema to file names associated with the first database and for further translating database identifiers associated with the database image schema to database identifiers associated with the first database.

14. The method of claim 13, wherein the acts of determining, creating and generating are performed by a single computer executed application.

15. The method of claim 13, wherein the acts of determining, creating and generating are performed by two or more computer executed applications.

16. The method of claim 1, wherein the act of providing comprises returning the return data to a database management system application.

17. A program storage device, readable by a programmable control device, comprising instructions stored on the program storage device for causing the programmable control device to:

receive a query directed to a first database;

redirect the query to a file associated with a database image;

receive data from the file associated with the database image;

generate return data by substituting database identifiers in the received data associated with the database image with database identifiers associated with the first database; and

provide the return data.

18. The program storage device of claim 17 wherein the instructions to receive a query comprise instructions to receive a query directed to a specified file associated with the first database.

19. The program storage device of claim 17, wherein the instructions to query, redirect, receive, generate and provide comprise instructions to access DB2 type databases.

20. The program storage device of claim 19, wherein the instructions to substitute database identifiers comprise instructions to substitute an OBID value associated with the image database with an OBID value associated with the first database.

21. The program storage device of claim 19, wherein the instructions to substitute database identifiers further comprise instructions to substitute a specified value in the returned data for a log file identifier in the data received from the file associated with the database image.

22. The program storage device of claim 17, wherein the instructions to query, redirect, receive, generate and provide comprise instructions to access Information Management System (IMS) type databases.

23. The program storage device of claim 22, wherein the instructions to substitute database identifiers comprise instructions to substitute a data set value associated with the image database with a data set value associated with the first database.

24. The program storage device of claim 17, wherein the instructions to receive a query comprise instructions to receive a query from a first database management system and the instructions to receive data comprise instructions to receive data from a database image whose source database was created in a second database management system.

25. The program storage device of claim 24, wherein the first and second database management systems comprise different database management systems.

26. The program storage device of claim 17, further comprising instructions to:

determine the database image schema;

create the first database based on the database image schema, the first database comprising one or more empty data structures; and

generate a translation scheme for translating file names associated with the database image schema to file names associated with the first database and for further translating database identifiers associated with the database image schema to database identifiers associated with the first database.

27. The program storage device of claim 26, wherein the instructions to determine, create and generate are executed by a single computer executed application.

28. The program storage device of claim 26, wherein the instructions to determine, create and generate are executed by two or more computer executed applications.

29. A computer database system, comprising:

storage system for storing a database image and a first database;

a first database management system operatively coupled to the first database and to the storage system; and

translator means operatively coupled to the storage system and to the first database management system for

redirecting queries from the database management system directed to a specified file associated with the first database to a specified file associated with the database image,

receiving data in response to the redirected query from the specified file associated with the database image, and

substituting database identifiers in the received data associated with the database image with database identifiers associated with the first database.

30. The computer database system of claim 29, wherein the storage system comprise at least one storage device.

31. The computer database system of claim 29, wherein the first database and the database image comprise the same type of database.

32. The computer database system of claim 31, wherein the first database and the database image comprise DB2 type databases.

33. The computer database system of claim 31, wherein the first database and the database image comprise Information Management System (IMS) type databases.

34. The computer database system of claim 29, wherein the translator means executes within the first database management system application.

35. A method to provide run-time access to a database image, comprising:

receiving a query directed to a target DB2 database from a DB2 application;

redirecting the query to a file associated with a DB2 database image;

receiving data from the file associated with the DB2 database image in response to the query;

generating return data by substituting database identifiers in the received data associated with the DB2 database image with database identifiers associated with the target DB2 database; and

providing the return data to the DB2 application.

36. The method of claim 35, wherein the act of receiving a query comprises receiving a query directed to a specified file associated with the target DB2 database.

37. The method of claim 35, wherein the act of substituting database identifiers comprises substituting an identifier value associated with the DB2 database image with an identifier value associated with the target DB2 database, the identifier selected from the group consisting of DBID, OBID and PSID.

38. The method of claim 37, wherein the act of substituting database identifiers further comprises substituting a specified value in the returned data for a log file identifier in the data received from the file associated with the DB2 database image.

39. The method of claim 35, further comprising:

determining the DB2 database image schema;

creating the target DB2 database based on the DB2 database image schema, the target DB2 database having one or more empty data structures and substantially the same schema as the DB2 database image; and

generating a translation scheme for translating file names associated with the target DB2 database schema to file names associated with the DB2 database image and for further translating database identifiers associated with the DB2 database image schema to database identifiers associated with the target DB2 database.