DATABASE SYSTEM AND DATABASE MANAGEMENT METHOD

摘要

The method includes (A) acquiring storage location information that can identify a volume that stores data and access type information, (B) acquiring volume management information that can identify the storage unit that stores the volume, (C) identifying the volume of data to be accessed, identifying the storage unit storing the volume, and identifying the storage method of the storage unit, (D) identifying the type of access to the data to be accessed, (E) determining whether the data needs to be moved to another storage unit of a different storage method based on the storage method and the type of access, and (F) giving an indication of moving the data if it is determined that the data needs to be moved in (E).

主权项

1. A database management method for a database system comprising:
a storage apparatus including a plurality of types of storage units that use different storage methods for storing data; a computer configured to manage a database by storing data to be managed with the database in storage areas of the storage units of the storage apparatus; and a control server coupled to the storage apparatus and the computer, wherein a storage device of the control server has stored therein storage method information that identifies the storage method of the storage units of the storage apparatus, the method comprising: (A) acquiring, from the computer, volume identifying information capable of identifying a volume that stores database data to be accessed during processing for a query request to the database, and access type information that is capable of identifying a type of access to the data; (B) acquiring, from the storage apparatus, volume management information that is capable of identifying the storage unit that stores the volume; (C) identifying the volume of the data that is to be accessed during processing for the query request based on the volume identifying information, identifying the storage unit that stores the identified volume based on the volume management information, and identifying the storage method of the storage unit based on the storage method information; (D) identifying the type of access to the data that is to be accessed during processing for the query request, based on the access type information; (E) determining whether the data needs to be moved to another storage unit of a different storage method, based on the storage method identified in (C) and the type of access identified in (D); and (F) giving an indication of moving the data to another storage unit of a different storage method if it is determined in (E) that the data needs to be moved to another storage unit of a different storage method.