A database cache control method and system

Abstract

The invention relates to a database cache control method and a database cache control system. The method comprises the following steps: S0, establishing a first mapping table, a second mapping table and a third mapping table in cache; S1, executing S2 for data of every time and executing S3 for data update of every time; S2, inquiring the first mapping table, if the first mapping table has no inquiring result, inquiring the database and updating the first mapping table based on the database inquiring result and inquiring the table names involved to update the second mapping table and the third mapping table; and S3, after updating the database, updating the first mapping table, the second mapping table and the third mapping table based on the table names involved in update. The method provided by the invention can more precisely judge the relationship between an inquiring sentence and an updating sentence. Local cache which is truly associated is only emptied after executing the updating operation every time and cache which is not associated is reserved instead of emptying the cache in a large scale, so that the cache hit ratio can be increased, the access average speed can be raised, the development efficiency can be improved, the error rate of software can be reduced, and the software equality can be enhanced.

Description

technical field [0001] The invention relates to the field of computers, in particular to a database cache control method and system. Background technique [0002] Most of the current web pages are generated using dynamic data and static styles, and dynamic data is often stored in relational databases, such as Oracle, Mysql, Sqlserver and so on. In order to improve the speed of webpage generation, database caching technology is often used, that is, the data queried from the database is not destroyed immediately after the webpage is generated this time, but there is a place that can be read quickly (such as memory), and the next time you wait for this When the webpage is requested again, the data can be quickly retrieved from the cache without querying the database again, thereby increasing the speed of webpage generation, increasing the throughput of the website, reducing user waiting time, and improving user experience. [0003] To query data from the database, query statem...

AI Technical Summary

Problems solved by technology

[0006] However, in relational database queries, query statements usually need to span multiple tables. In such a complex situation, it is difficult to classify these query statements according to namespaces. In the end, most query statements will be classified into the same namespace. Then, as long as one of the update statements is executed, all the caches will be cleared, resulting in a very low cache hit rate, and the cache technology has no obvious effect

In addition, under the existing technology, developers use namespaces to declare the relationship between query statements and update statements, which invisibly increases the difficulty of work and increases the risk of errors

Images