Method and system of database divisional management for parallel database system

Abstract

A method and a system of database divisional management for use with a parallel database system comprising an FES (front end server), BES's (back end servers), an IOS (I/O server) and disk units. The numbers of processors assigned to the FES, BES's and IOS, the number of disk units, and the number of partitions of the disk units are determined in accordance with the load pattern in question. Illustratively, there may be established a configuration of one FES, four BES's, one IOS and eight disk units. The number of BES's is varied from one to four depending on the fluctuation in load, so that a scalable system configuration is implemented. When the number of BES's is increased or decreased, only the management information thereabout is transferred between nodes and not the data, whereby the desired degree of parallelism is obtained for high-speed query processing.

1 . A database management method comprising the steps of:
 defining a correspondence between a plurality of key ranges and a plurality of data storage areas in a storage device;   storing data in a data storage area which corresponds to a key range containing said data, when storing said data in a database;   dividing said key range containing said data into a plurality of divided key ranges, when it is necessary to divide said key range containing said data; and   defining a correspondence between the divided key ranges and said plurality of data storage areas.   
   
   
       2 . A database management method according to  claim 1 , further comprising the step of:
 defining a correspondence of at least one of said divided key ranges to a data storage area whose correspondence with a key range is not defined.   
   
   
       3 . A database management method according to  claim 2 , further comprising the step of:
 storing the data corresponding to said at least one divided key range to the data storage area whose correspondence with said one divided key range is defined.   
   
   
       4 . A database management method according to  claim 2 , further comprising the step of:
 deleting data corresponding to said divided key range from said data storage area corresponding to the key range necessary to be divided.   
   
   
       5 . A database management method comprising the steps of:
 defining a correspondence between a plurality of key ranges and a plurality of data storage areas in a storage device;   dividing at least one of said plurality of key ranges, when necessary to divide; and   defining a correspondence between the divided key ranges and said plurality of data storage areas.   
   
   
       6 . A database management method according to  claim 5 , further comprising the step of:
 defining a correspondence of at least one of said divided key ranges to a data storage area whose correspondence with a key range is not defined.   
   
   
       7 . A database management method comprising the steps of:
 defining a correspondence between a plurality of key ranges and a plurality of data storage areas in a storage device;   dividing at least one of said plurality of key ranges, when a request is inputted to divide; and   defining a correspondence between the divided key ranges and said plurality of data storage areas.   
   
   
       8 . A database management method according to  claim 7 , further comprising the step of:
 defining a correspondence of at least one of said divided key ranges to a data storage area whose correspondence with a key range is not defined.