Using target database system statistics in emulation

• US 9,244,793 B1
• Filed: 11/04/2008
• Issued: 01/26/2016
• Est. Priority Date: 11/04/2008
• Status: Active Grant

• Current Assignee: Teradata US, Inc. (Teradata Corporation)
• Original Assignee: Teradata US, Inc. (Teradata Corporation)
• Inventors: Brown, Douglas P., Shelton, Jeffrey S
• Primary Examiner(s): Chad, Aniss
• Application Number:
  US12/264,671
• Time in Patent Office: 2,639 Days
• Field of Search: 703/23, 703/22, 707999002-999003, 715/700
• US Class Current: 1/1
• CPC Class Codes: G06F 11/261 by simulating additional hardware, e.g. fault simulation
• CPC Class Codes: G06F 30/33 Design verification, e.g. functional simulation or model checking

Abstract

A method, system, and computer program are disclosed. Statistics are read from a data dictionary on a target system. The statistics include statistics for a table in a database in the target system. The statistics are exported to a test system separate from the target system. A command is received to use the statistics in emulation. In response the statistics are copied to a cache in the test system and the target system is emulated on the test system using the statistics in the test system'"'"'s cache.

Claims

1. A method comprising:

reading statistics from a data dictionary on a target system, the statistics including statistics for a table in a database in the target system;

exporting the statistics to a test system separate from the target system;

storing the exported statistics in a query capture database in the test system;

receiving a command to use the stored statistics in emulation, the command specifying one of a plurality of possible levels of emulation for which emulation includes copying the stored statistics from the query capture database to a cache in the test system and, in response;

copying the stored statistics from the query capture database to a cache in the test system; and

emulating the target system on the test system using the statistics in the test system'"'"'s cache.

2. The method of claim 1 wherein:

the cache in the test system is segmented into a plurality of segments, each of the segments corresponding to a respective level of emulation;

copying the statistics to a cache in the test system comprises copying the statistics to a segment in the cache in the test system corresponding to the level of emulation; and

emulating the target system on the test system using the statistics in the test system'"'"'s cache comprises emulating the target system on the test system using the statistics in the segment in the cache corresponding to the level of emulation.

3. The method of claim 2 wherein:

receiving a command to use the stored statistics comprises receiving the command from a first user;

copying the statistics to the segment in the cache in the test system corresponding to the level of emulation comprises copying a private version of the statistics to the segment in the cache in the test system corresponding to the level of emulation, the private version of the statistics being accessible only by the first user and not by any other user; and

emulating the target system on the test system comprises using the private version of the statistics in the segment in the cache corresponding to the level of emulation.

4. The method of claim 3 wherein emulating the target system on the test system using the private version of the statistics in the segment in the cache corresponding to the level of emulation comprises:

optimizing the processing of a first request submitted by the first user using the private version of the statistics; and

optimizing the processing of a second request submitted by a second user using statistics other than the private version of the statistics.

5. The method of claim 1 where receiving a command to use the stored statistics in emulation comprises:

receiving a command in which the specified level of emulation is selected from a group of levels of emulation consisting of system level, interface processor level, session level, and request level.

6. The method of claim 1 wherein:

receiving a command to use the stored statistics in emulation comprises receiving a command specifying the database and the table;

copying the statistics to a cache in the test system comprises copying the statistics for the table to the cache; and

emulating the target system on the test system using the statistics in the test system'"'"'s cache comprises emulating the target system on the test system using the statistics for the table in the cache.

7. The method of claim 1 wherein:

receiving a command to use the stored statistics in emulation comprises receiving a command from a user specifying the database, the table, and a level of emulation;

copying the statistics to a cache in the test system comprises copying the statistics for the table to a segment in the cache corresponding to the level of emulation; and

emulating the target system on the test system using the statistics in the test system'"'"'s cache comprises emulating the target system on the test system using the statistics for the table in the segment in the cache corresponding to the level of emulation.

8. A database system comprising:

one or more nodes;

a plurality of CPUs, each of the one or more nodes providing access to one or more CPUs;

a plurality of virtual processes, each of the one or more CPUs providing access to one or more virtual processes;

each virtual process configured to manage data, including rows from a set of database table rows, stored in one of a plurality of data-storage facilities;

a process configured to emulate a target system on a test system by;

reading statistics from a data dictionary on a target system, the statistics including statistics for a table in a database in the target system;

exporting the statistics to a test system separate from the target system;

storing the exported statistics in a query capture database in the test system;

receiving a command to use the stored statistics in emulation, the command specifying one of a plurality of possible levels of emulation for which emulation includes copying the stored statistics from the query capture database to a cache in the test system and, in response;

copying the stored statistics from the query capture database to a cache in the test system; and

emulating the target system on the test system using the statistics in the test system'"'"'s cache.

9. The database system of claim 8 wherein:

the cache in the test system is segmented into a plurality of segments, each of the segments corresponding to a respective level of emulation;

copying the statistics to a cache in the test system comprises copying the statistics to a segment in the cache in the test system corresponding to the level of emulation; and

emulating the target system on the test system using the statistics in the test system'"'"'s cache comprises emulating the target system on the test system using the statistics in the segment in the cache corresponding to the level of emulation.

10. The database system of claim 9 wherein:

receiving a command to use the stored statistics in emulation comprises receiving the command from a first user;

copying the statistics to the segment in the cache in the test system corresponding to the level of emulation comprises copying a private version of the statistics to the segment in the cache in the test system corresponding to the level of emulation, the private version of the statistics being accessible only by the first user and not by any other user; and

emulating the target system on the test system comprises using the private version of the statistics in the segment in the cache corresponding to the level of emulation.

11. The database system of claim 10 wherein emulating the target system on the test system using the private version of the statistics in the segment in the cache corresponding to the level of emulation comprises:

optimizing the processing of a first request submitted by the first user using the private version of the statistics; and

optimizing the processing of a second request submitted by a second user using statistics other than the private version of the statistics.

12. The database system of claim 8 where receiving a command to use the stored statistics in emulation comprises:

receiving a command in which the specified level of emulation is selected from a group of levels of emulation consisting of system level, interface processor level, session level, and request level.

13. The database system of claim 8 wherein:

receiving a command to use the stored statistics comprises receiving a command specifying the database and the table;

copying the statistics to a cache in the test system comprises copying the statistics for the table to the cache; and

emulating the target system on the test system using the statistics in the test system'"'"'s cache comprises emulating the target system on the test system using the statistics for the table in the cache.

14. The database system of claim 8 wherein:

receiving a command to use the stored statistics comprises receiving a command from a user specifying the database, the table, and a level of emulation;

copying the statistics to a cache in the test system comprises copying the statistics for the table to a segment in the cache corresponding to the level of emulation; and

emulating the target system on the test system using the statistics in the test system'"'"'s cache comprises emulating the target system on the test system using the statistics for the table in the segment in the cache corresponding to the level of emulation.

15. A non-transitory computer-readable storage medium, including instructions that cause a computer to:

read statistics from a data dictionary on a target system, the statistics including statistics for a table in a database in the target system;

export the statistics to a test system separate from the target system;

store the exported statistics in a query capture database in the test system;

receive a command to use the stored statistics in emulation, the command specifying one of a plurality of possible levels of emulation for which emulation includes copying the stored statistics from the query capture database to a cache in the test system and, in response;

copy the stored statistics from the query capture database to a cache in the test system; and

emulate the target system on the test system using the statistics in the test system'"'"'s cache.

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

the cache in the test system is segmented into a plurality of segments, each of the segments corresponding to a respective level of emulation;

when copying the statistics to a cache in the test system the computer copies the statistics to a segment in the cache in the test system corresponding to the level of emulation; and

when emulating the target system on the test system using the statistics in the test system'"'"'s cache the computer emulates the target system on the test system using the statistics in the segment in the cache corresponding to the level of emulation.

17. The non-transitory computer-readable storage medium of claim 16 whereas:

when receiving a command to use the stored statistics in emulation the computer receives the command from a first user;

when copying the statistics to the segment in the cache in the test system corresponding to the level of emulation the computer copies a private version of the statistics to the segment in the cache in the test system corresponding to the level of emulation, the private version of the statistics being accessible only by the first user and not by any other user; and

when emulating the target system on the test system using the private version of the statistics in the segment in the cache corresponding to the level of emulation.

18. The non-transitory computer-readable storage medium of claim 17 wherein when emulating the target system on the test system using the private version of the statistics in the segment in the cache corresponding to the level of emulation the computer:

optimizes the processing of a first request submitted by the first user using the private version of the statistics; and

optimizes the processing of a second request submitted by a second user using statistics other than the private version of the statistics.

19. The non-transitory computer-readable storage medium of claim 15 wherein when receiving a command to use the stored statistics in emulation the computer:

receives a command in which the specified level of emulation is selected from a group of levels of emulation consisting of system level, interface processor level, session level, and request level.

20. The non-transitory computer-readable storage medium of claim 15 wherein when:

receiving a command to use the stored statistics the computer receives a command specifying the database and the table;

copying the statistics to a cache in the test system the computer copies the statistics for the table to the cache; and

emulating the target system on the test system using the statistics in the test system'"'"'s cache the computer emulates the target system on the test system using the statistics for the table in the cache.

21. The non-transitory computer-readable storage medium of claim 15 wherein when:

receiving a command to use the stored statistics the computer receives a command from a user specifying the database, the table, and a level of emulation;

copying the statistics to a cache in the test system the computer copies the statistics for the table to a segment in the cache corresponding to the level of emulation; and

emulating the target system on the test system using the statistics in the test system'"'"'s cache the computer emulates the target system on the test system using the statistics for the table in the segment in the cache corresponding to the level of emulation.