Storage apparatus acquiring static information related to database management system
First Claim
1. A storage apparatus comprising:
- connection means for connecting to a computer in which a database management system operates; and
information acquiring means for acquiring information of data structures including tables, indexes, and logs defined by schema in said database management system, and information of recording positions of data of database in said storage apparatus that are managed by said database management system and grouped under each of said data structures defined by said schema.
1 Assignment
0 Petitions
Accused Products
Abstract
A storage apparatus acquires static constituent information of a database management system (DBMS) through a network by using a DBMS information acquisition/communication program, DBMS information communication portion, and host information setting program, and stores them as DBMS data information in its memory. The physical storage position managing/optimizing execution portion within a control program of the storage apparatus makes data allocation and cache control that consider the characteristics of the data base management system by using DBMS data information, thereby improving the data access performance of the storage apparatus.
-
Citations
22 Claims
-
1. A storage apparatus comprising:
-
connection means for connecting to a computer in which a database management system operates; and
information acquiring means for acquiring information of data structures including tables, indexes, and logs defined by schema in said database management system, and information of recording positions of data of database in said storage apparatus that are managed by said database management system and grouped under each of said data structures defined by said schema. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19)
-
-
20. A method of changing storage positions of data stored within a plurality of physical storage devices by a control unit in a storage apparatus that has connection means for connecting to a computer in which a database management system (DBMS) operates and to administrator'"'"'s terminals, said plurality of physical storage devices for storing data of said DBMS, said control unit for controlling said storage apparatus and a memory useful for said control unit to control, said method comprising the steps of:
-
storing in said memory first information of physical storage positions of said data stored in said plurality of physical storage devices;
acquiring second information about the database processing that said DBMS makes through said connection means, and storing said second information in said memory;
generating a plan for making data relocation between said plurality of physical storage devices in order to improve the performance of access to data in said database processing that said DBMS makes on the basis of said first and second information; and
displaying said relocation plan on the display screens of said administrator'"'"'s terminals through said connection means. - View Dependent Claims (21)
-
-
22. A method of changing storage positions of data stored within a plurality of physical storage devices by a control unit in a storage apparatus that has connection means for connecting to a computer in which a database management system (DBMS) operates and to administrator'"'"'s terminals, said plurality of physical storage devices for storing data of said DBMS, a data cache for said data, said control unit for controlling said storage apparatus and a memory useful for said control unit to control, said method comprising the steps of:
-
storing in said memory first information of physical storage positions of said data stored in said plurality of physical storage devices;
acquiring second information about the database processing that said DBMS makes through said connection means, and storing said second information in said memory;
generating a plan for making data relocation between said plurality of physical storage devices in order to improve the performance of access to data in said database processing that said DBMS makes on the basis of said first and second information; and
displaying said relocation plan on the display screens of said administrator'"'"'s terminals through said connection means.
-
Specification