Database management methods and equipment and database management program storage media

• US 7,284,022 B2
• Filed: 04/03/2003
• Issued: 10/16/2007
• Est. Priority Date: 11/12/1999
• Status: Expired due to Fees

• Current Assignee: Hitachi, Ltd.
• Original Assignee: Hitachi, Ltd.
• Inventors: Kawamura, Nobuo
• Primary Examiner(s): Corrielus; Jean M.
• Application Number:
  US10/405,225
• Publication Number:
  US 20050050050A1
• Time in Patent Office: 1,657 Days
• Field of Search: 707/2, 707/3, 707/10, 707/100, 707/205
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2282 Tablespace storage structures; Management thereof
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99952 Coherency, e.g. same view to multiple users
• CPC Class Codes: Y10S 707/99953 Recoverability
• CPC Class Codes: Y10S 707/99956 File allocation

Abstract

Multiple key ranges are correlated with multiple data storage areas provided in memory. In storing data in a database, the data is stored in the data storage area correlated with the key range containing the data. When the addition of a data storage area as mentioned above is needed, a given volume of data is moved from the multiple data storages to the newly added data storage area and the key ranges for the moved data are correlated with the data storage areas.

Claims

1. A method for managing data by a database management apparatus including a computer and at least one storage device having a data storage area, comprising:

providing first information correlating a first bucket and a data storage area,

wherein a number of the first bucket is a number of the data storage area as defined by database definition information;

providing second information correlating a second bucket and one or more data in the data storage area,

wherein a number of the second bucket is a segment number of a segment in the data storage area, said segment storing the one or more data;

managing the data storage area correlated with the first bucket in accordance with the first information;

managing the one or more data of said segment correlated with the second bucket in accordance with the second information; and

managing the first bucket being correlated with the second bucket by a bucket map table.

2. The method of claim 1, wherein the segment number is a number of the one or more data in the data storage area so that a quantity or number of one or more data is equal.

3. The method of claim 1, further comprising:

changing the bucket map table including the second bucket of the second information correlated to the first bucket of the first information;

selecting data corresponding to the first bucket of the changed bucket map table in accordance with the second information;

selecting the data storage area corresponding to the second bucket of the first information from the first information; and

moving the selected data to the selected data storage area.

4. The method of claim 1, further comprising:

in response to a data insertion request, obtaining database definition information;

identifying a data storage area that is available for data insertion in accordance with the obtained database definition information and the first information;

identifying the second bucket from the bucket map table as set forth by the second information, and identifying a segment in the data storage area corresponding to the second bucket; and

inserting data in the segment.

5. The method of claim 1, further comprising:

in response to a data search request, obtaining database definition information;

identifying a data storage area in accordance with the obtained database identifying the second bucket from the bucket map table as set forth by the second information, and identifying a segment in the data storage area corresponding to the second bucket; and

searching for data which matches search conditions in the segment.

6. A computer system, comprising:

a database management system for managing a data;

a first storage having a plurality of data storage areas; and

a second storage having stored therein first information correlating a first bucket and a data storage area,

wherein a number of the first bucket is a number of the data storage area as defined by database definition information and second information correlating a second bucket and one or more data in the data storage area,

wherein a number of the second bucket is a segment number of a segment in the data storage area, said segment storing the one or more data,

wherein said database management system manages the data storage area correlated with the first bucket in accordance with the first information, manages divided data of the one or more data correlated with the second bucket in accordance with the second information, and manages the first bucket being correlated with the second bucket by a bucket map table.

7. The computer system of claim 6, wherein the segment number is a number of the one or more data in the data storage area so that a quantity or number of one or more data is equal.

8. The computer system of claim 6, wherein said database management system changes the bucket map table including the second bucket of the second information correlated to the first bucket of the first information, selects data corresponding to the first bucket of the changed bucket map table in accordance with the second information, selects the data storage area corresponding to the second bucket of the first information from the first information, and moves the selected data to the selected data storage area.

9. The computer system of claim 6, wherein said database management system in response to a data insertion request, obtains database definition information, identifies a data storage area that is available for data insertion in accordance with the obtained database definition information and the first information, identifies the second bucket from the bucket map table as set forth by the second information, and identifying a segment in the data storage area corresponding to the second bucket, and inserts data in the segment.

10. The computer system of claim 6, wherein said database management system in response to a data search request, obtains database definition information, identifies a data storage area in accordance with the obtained database identifying the second bucket from the bucket map table as set forth by the second information, and identifying a segment in the data storage area corresponding to the second bucket, and searches for data which matches search conditions in the segment.