Patent ID: 7143105

Claim:
A database storing management method comprising the steps of: storing data in a plurality of storage areas under predetermined partition conditions defining separation of the data among the plurality of storage areas, the data being arranged to be separated and stored in the plurality of storage areas in such a manner that newer data are stored in different areas than older data according to said predetermined partition conditions, wherein said predetermined partition conditions include an access frequency of the data defined in accordance with a year in which the data was stored, such that the access frequency determines both a fineness of the stored data and a load for processing the stored data for each of the plurality of storage areas; storing a partition change trigger upon which a relationship between the data and the plurality of storage areas changes, storing a partition change condition with which the relationship changes; monitoring a trigger state of said partition change trigger; detecting an occurrence of the partition change trigger; executing a change of data stored in each of the plurality of storage areas based on said partition change condition when said partition change trigger is detected, wherein said step of executing said change of data includes the steps of: obtaining a correspondence of partition conditions to the plurality of storage areas after said relationship change with reference to said partition change condition; comparing said correspondence with a current correspondence of partition conditions to the storage areas so as to obtain a migration destination of the data stored in each of the plurality of storage areas; classifying partitions defined by said partition conditions into a first partition classification of partitions to be unchanged, a second partition classification of partitions to be deleted after said relationship change, a third partition classification of partitions to be migrated to a different storage area, and a fourth partition classification of partitions to be added after said relationship change; deleting data of said second partition classification from each data storage area corresponding thereto; migrating data of said third partition classification from a migration source data storage area to a migration destination data storage area corresponding to said second partition classification; and changing the partition change condition, wherein said step of migrating data includes the step of: simultaneously executing a plurality of migrations of data, when a plurality of data migrations are required, for any migration source data storage areas or any migration destination data storage areas that do not overlap with each other.