Hitachi, Ltd.

Tomoto Shimizu

Yoshito Kamegi

Masato Asami

Youichi Yamamoto

Nobuo Beniyama

Tomoyuki Kaji

Provided are a relocation system and a relocation method capable of relocating a virtual volume that is formed based on thin provisioning while ensuring security against exhaustion of pools. A database stores attribute information for pools and virtual volumes for thin provisioning that exist in a storage device as well as parameters for predicting time period till exhaustion of the pools. When a virtual volume is to be relocated between a plurality of pools, a relocation control section predicts time periods till exhaustion of the pools before and after relocation based on information in the database and determines the relocation is possible or not based on the result of prediction or determines an appropriate relocation plan. This enables control of relocation of virtual volumes.

Relocation system and a relocation method

A newly defined data type is added to a database management system. Information about a query component assisting in querying data belonging to the newly defined data type is registered along with data type information in a query component information. If the data type being queried is the newly added data type, the query component information is searched to find a query component for assisting queries to data belonging to the particular data type. The matching query component is activated and a screen is displayed to input information needed to the query data belonging to the data type. The information is input and a query statement is generated using the inputted information. The generated query statement is issued to the database management system and query results are obtained.

Method for querying a database in which a query statement is issued to a database management system for which data types can be defined

A newly defined data type is added to a database management system. Information about a query component assisting in querying data belonging to the newly defined data type is registered along with data type information in a query component information. If the data type being queried is the newly added data type, the query component information is searched to find a query component for assisting queries to data belonging to the particular data type. The matching query component is activated and a screen is displayed to input information needed to query data belonging to the data type. The information is input and a query statement is generated using the inputted information. The generated query statement is issued to the database management system and query results are obtained.

Growing community of inventors

Yokohama, Japan

Tomoto Shimizu