The invention discloses an automatic accurate memory expansion and contraction
dynamic management method. The method comprises the following steps: counting
data access records of a single
database table within a preset
time range; integrating data
consanguinity of all
database tables, and simultaneously performing access recording of a current data table and access recording of an upper-
level data table on access data; the access
record is analyzed, an estimated expansion and contraction threshold value and an expansion and contraction threshold value are calculated, and the expansion and contraction threshold value is larger than the estimated expansion and contraction threshold value; when the access
record data reaches the pre-estimated expansion and contraction threshold value, an expansion and contraction value is obtained through calculation; according to the method, the concept of estimating the expansion and contraction threshold value is introduced, memory expansion and contraction operation is carried out in advance, the problem of low response speed is solved, the problem of low cold and hot data judgment precision is solved through integration of the data blood relationship, and by calculating the expansion and contraction value in advance, the access
record data can be quickly and accurately judged. The precision of expansion and contraction prediction is improved, and the problems of frequent and repeated operation and resource waste are solved.