Method and system for storing data into a database

• US 20060212495A1
• Filed: 02/06/2006
• Published: 09/21/2006
• Est. Priority Date: 03/18/2005
• Status: Abandoned Application

• Current Assignee: Hitachi, Ltd.
• Original Assignee: Hitachi, Ltd.
• Inventors: Hara, Norihiro, Tokunaga, Mikihiko
• Application Number:
  US11/347,266
• Publication Number:
  US 20060212495A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2282 Tablespace storage structures; Management thereof

Abstract

An information processing apparatus divides a database table into separate tables according to a table division condition, correlates the separate tables to areas as logical storage devices, correlates the areas to storage devices, detects a predetermined area whose use amount is equal to or exceeds a predetermined value, assures an empty storage device having an empty capacity, and adds the empty storage device to a storage device correlated to the predetermined area.

Claims

1. A storing-into-database method for storing a database table into a storage device as a physical storage medium, the method executed by an information processing apparatus comprising the steps of:

dividing the database table into separate tables according to a table division condition, correlating the separate tables with areas as logical storage devices, and correlating the areas with the storage devices;

detecting a predetermined area whose use amount is equal to or exceeds a predetermined value;

assuring an empty storage device having an empty capacity; and

adding the empty storage device to the storage device correlated to the predetermined area.

2. The method as claimed in claim 1, wherein an area type of at least one of a data area, an index area and an object area is assigned to the area and according to the area type, the area is correlated to the storage device.

3. The method as claimed in claim 1, wherein the step of detecting that the use amount of the area is equal to or exceeds the predetermined value is executed during data write.

4. The method as claimed in claim 2, wherein the step of detecting that the use amount of the area is equal to or exceeds the predetermined value is executed during data write.

5. The method as claimed in claim 1, wherein operation is modified for the empty storage device and another storage correlated to the predetermined area.

6. The method as claimed in claim 2, wherein operation is modified for the empty storage device and another storage correlated to the predetermined area.

7. The method as claimed in claim 3, wherein operation is modified for the empty storage device and another storage correlated to the predetermined area.

8. The method as claimed in claim 4, wherein operation is modified for the empty storage device and another storage correlated to the predetermined area.

9. A storing-into-database method for storing a database table into a storage device as a physical storage medium, the method executed by an information processing apparatus comprising the steps of:

dividing the database table into separate tables according to a table division condition, correlating the separate tables with areas as logical storage devices, and correlating the areas with the storage devices;

detecting a first area whose use amount is equal to or exceeds a predetermined value;

assuring an empty storage device having an empty capacity;

modifying the table division condition concerning the first area division table and a division table of a second area in the area; and

adding the empty storage device to the storage device correlated to the second area.

10. The method as claimed in claim 9, wherein a area type of at least one of a data area, an index area and an object area is assigned to the area and according tot the area type, the area is correlated to the storage device.

11. The method as claimed in claim 9, wherein the step of detecting that the use amount of the area is equal to or exceeds the predetermined value is executed during data write.

12. The method as claimed in claim 10, wherein the step of detecting that the use amount of the area is equal to or exceeds the predetermined value is executed during data write.

13. The method as claimed in claim 9, wherein operation is modified for the empty storage device and another storage device correlated to the first area.

14. The method as claimed in claim 10, wherein operation is modified for the empty storage device and another storage device correlated to the first area.

15. The method as claimed in claim 11, wherein operation is modified for the empty storage device and another storage device correlated to the first area.

16. The method as claimed in claim 12, wherein operation is modified for the empty storage device and another storage device correlated to the first area.

17. A database storing system comprising an information processing apparatus for storing a database table into a storage device as a physical storage medium, wherein:

the information processing apparatus divides the database table into separate tables according to a table division condition, correlates the separate tables with areas as logical storage areas, and correlates the areas with the storage areas, and

the information processing apparatus includes;

an area monitoring unit for detecting a predetermined area whose use amount is equal to or exceeds a predetermined value;

a processing request execution unit for assuring an empty storage device having an empty capacity; and

an area allocation unit for adding the empty storage device to the storage device correlated to the predetermined area.

18. A database storing system comprising an information processing apparatus for storing a database table into a storage device as a physical storage medium, wherein:

the information processing apparatus divides the database table into separate tables according to a table division condition, correlates the separate tables with areas as logical storage areas, and correlates the areas with the storage devices, and the information processing apparatus includes;

an area monitoring unit for detecting a first area whose use amount of the area is equal to or exceeds a predetermined value;

a processing request execution unit for assuring an empty storage device having an empty capacity;

a table division definition modification unit for modifying the table division condition concerning the division table of first area and a division table of a second area in the area; and

an area allocation unit for adding the empty storage device to the storage device correlated to the second area.