Storage system having means for acquiring execution information of database management system

• US 6,928,451 B2
• Filed: 03/07/2002
• Issued: 08/09/2005
• Est. Priority Date: 11/14/2001
• Status: Expired due to Fees

• Current Assignee: Hitachi, Ltd.
• Original Assignee: Hitachi, Ltd.
• Inventors: Mogi, Kazuhiko, Oeda, Takashi, Kitsuregawa, Masaru
• Primary Examiner(s): AMSBURY, WAYNE P
• Application Number:
  US10/093,682
• Publication Number:
  US 20030093647A1
• Time in Patent Office: 1,251 Days
• Field of Search: 707/102, 707/2
• US Class Current: 707/718
• CPC Class Codes: G06F 16/24552 Database cache management
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

A storage system for providing a preferable data access performance by performing controls considering database management system (DBMS) execution information or database process priorities, by acquiring static configurational information of a DBMS by means of a DBMS information acquisition and communication program, a DBMS information communication section, and a host information setting program; acquiring DBMS execution information by means of a query plan acquisition program, the DBMS information communication section, and a process performance management program; acquiring information on priorities of database processes given by the process performance management program; and storing them in disk I/O management information with process priorities, DBMS execution information, and DBMS data information, in which cache control section in a storage system control program controls a data cache by referring to the above information.

Claims

1. A storage system, comprising:

connection means for connecting with a computer in which a plurality of database management systems are operating;

a plurality of storage devices each including a plurality of locations;

information acquisition means for acquiring from said plurality of database management systems through said connection means information on a data structure including a table, an index, and a log defined by a schema in a database management system of said plurality of database management systems, information on recording locations in said storage devices in which database data managed by said database management system is classified according to a data structure defined by said schema, and information on databases managed by said database management system including a query execution plan of a query executed by said database management system;

a cache memory; and

a storage controller for controlling to predict an index access destination in said plurality of locations of said plurality of storage devices to be made based on interpretation of said information acquired by said information acquisition means when interpretable.

2. The system according to claim 1, wherein said information acquisition means acquires said information on the databases managed by said database management system through at least one program other than said database management system.

3. The system according to claim 1, wherein said storage system has one or more physical storage devices for storing data in said plurality of storage devices;

wherein said storage system has physical storage control means for determining an access order of said physical storage devices; and

wherein said physical storage control means uses the information acquired by said information acquisition means for determining the access order for said physical storage devices.

4. The system according to claim 3, further comprising:

cache memory control means for managing said cache memory;

wherein said storage controller comprises access prediction means for predicting an access destination and an access method of an access to be made to said physical storage devices from the information acquired by said information acquisition means.

5. The system according to claim 4, wherein said cache memory control means executes a cache discarded data selection control by using said access prediction means.

6. The system according to claim 4, wherein said cache memory control means executes a data prefetch execution control by using said access prediction means.

7. The system according to claim 6, wherein said information acquired by said information acquisition means includes information on a degree of parallelism used when said database management system accesses said database data belonging to an identical data structure defined by said schema.

8. The system according to claim 6, further comprising database data interpreting means for understanding a content of said database data,

wherein said access prediction means uses said database data interpreting means.

9. The system according to claim 3, wherein said information acquired by said information acquisition means includes process priority information on a priority of a process supplied to a database managed by said database management system or supplied to each process to be executed.

10. The system according to claim 9, wherein said physical storage control means makes a control of executing an access preferentially to data of said database having a higher priority by referring to said process priority information or to said database data used by a process given a higher priority.

11. The system according to claim 9,

wherein said storage controller comprises access prediction means for predicting an access destination and an access method of an access to be made to said physical storage device from said information acquired by said information acquisition means;

and

cache memory control means for executing a data prefetch using said access prediction means and executing a cache memory control considering said process priority information.

12. The system according to claim 11, wherein said cache memory control means executes a prefetch preferentially to data of said database having a higher priority by referring to said process priority information or to said database data used by a process given a higher priority.

13. The system according to claim 11, wherein said cache memory control means makes a control of allocating a higher amount of cache memory to data of said database having a higher priority by referring to said process priority information or to said database data used by a process given a higher priority.

14. The system according to claim 11, further comprising physical storage operating information acquisition means for acquiring operating information of said physical storage devices in said storage system,

wherein said cache control means makes a control using the information acquired by said physical storage operating information acquisition means for executing a data prefetch.

15. A storage system according to claim 1, wherein said storage controller controls to determine whether said access destination is within a data structure of a tree-structured index and controls to predict a sequential access destination based on interpretation of said information acquired by said information acquisition means when said sequential access destination is for a sequential access.

16. A storage system according to claim 15, wherein said controller controls to allocate a data area in said cache memory for said access destination and prefetch data from said plurality of storage devices into said data area based on interpretation of said information acquired by said information acquisition means.

17. A storage system according to claim 1, wherein said controller controls to allocate a data area in said cache memory for said access destination and prefetch data from said plurality of storage devices into said data area based on interpretation of said information acquired by said information acquisition means.

18. A storage system according to claim 1, wherein said controller controls to determine whether an operating ratio of data having a data structure defined by said schema of said information acquired by said acquisition means is equal to or greater than a predetermined threshold value to allocate a data area in said cache memory.