Patent ID: 6578039
Filing Date: 2003-06-10
Classification: G06F,Y10S

Abstract:
A method for managing a database storage area and multiple segments, comprising:providing a database comprising m data storage areas, where m represents a non-zero integer; identifying at least one data in the database as a partitioning key; using the partitioning key to partition the database into n buckets, where n represents a non-zero integer and n&gE;m; providing a bucket map table correlating the n buckets and the m data storage areas and correlating the n buckets and the multiple segments; storing data in the multiple segments in accordance with the bucket map table; providing an additional data storage area; selecting buckets from each of the m data storage areas; moving the buckets selected from each of the m data storage areas to the additional data storage area on a segment-by-segment basis in accordance with the bucket map table; updating information in the bucket map table concerning the correlation between the buckets and the additional data storage area and the correlation between the buckets and the segments, wherein each of the data storage areas comprises an equal number of buckets; in response to a data insertion request, obtaining database definition information, the database definition information including database partition information and partitioning key information; using the bucket map table to identify a data storage area that is available for data insertion; identifying a segment that is allocated for a bucket map table entry; identifying a free page in the allocated segment; and inserting data in the free page.