Data access method for all-memory database

Abstract

A data access method of whole memory database, belongs to a data access method. In the method, a whole memory database information is arranged firstly, and is initialized then, a corresponding operation of database is carried out according to a upper application professional operation at last,and a corresponding operated result is returned towards the upper application. The invention is especially suitable for a system in which the requirement for the data access effect is high and the lifecycle of database is in a certain range, accordingly the operated speed of system is improved, and the operated ability of system is enlarged, the cost of syatem and the maintenance of system are reduced.

Description

technical field [0001] The invention belongs to a data access method, in particular to a data access method of a full memory database. Background technique [0002] In the database system, the I / O speed of the disk is still the key to limit the processing speed of the system. [0003] In ordinary databases, disk I / O operations are unavoidable. Only when the data accessed by applications concentrates on certain records within a period of time, ordinary databases can use the cache mechanism of the database itself to improve part of the performance of the system. [0004] The existing in-memory database improves the processing speed of the system through memory access, but due to the volatile nature of the memory, when the application program exits, the data in the memory cannot be saved, so it still needs to be backed up synchronously with the disk. [0005] In addition, in ordinary databases and in-memory databases, the function of automatically cleaning historical data cann...

AI Technical Summary

Problems solved by technology

[0004] The existing in-memory database improves the processing speed of the system through memory access, but due to the volatile nature of the memory, when the application exits, the data in the memory cannot be saved, so it still needs to be backed up synchronously with the disk

[0005] In addition, in ordinary databases and in-memory databases, the function of automatically cleaning historical data cannot be realized. Historical data can only be deleted by calling the delete operation of the database, or the old historical records can be overwritten by using table space recycling.

In this way, with the growth of time, more and more historical data, and the increase in the amount of data, has a great impact on the performance of the database, resulting in a further decline in the performance of the database

Images