Database reading method and device and computer readable storage medium

Abstract

The invention relates to the technical field of cloud storage and discloses a database reading method. The method comprises the following steps: loading database reading optimization logic into a client program by using a packaged dynamic shared library so file, obtaining a query command of the client program, when a data reading interface provided by the dynamic shared library so file requests toexecute a query command, executing the query command; judging whether the query command needs to be subjected to the optimization logic or not; when the query command does not need to be subjected tologic optimization, enabling the packaged dynamic shared library so file to search a database when the query command does not need optimal logic. A client program adopts a local data buffer optimization strategy through a data reading interface provided by calling the so file and then executes the process of optimal logic of data query operation of the database and then returns a query result. The invention further provides a database reading device and a computer readable storage medium. According to the invention, efficient reading of the database is realized.

Description

technical field [0001] The present invention relates to the technical field of cloud storage, in particular to a database reading method, device and computer-readable storage medium based on dynamic execution files. Background technique [0002] With the rapid development of information technology and the rapid increase of data volume, the reading and writing speed of the database is often difficult to meet the needs of actual products when storing massive data, especially in the financial industry, which requires high data real-time and accuracy. In this scenario, there is a stronger demand for optimizing the read and write speed of the database. In this case, database access and read and write speeds need to be optimized at every stage of the client and server connection. [0003] Commonly used database read performance optimization methods mainly include hardware expansion, sub-database and sub-table, data archiving, reducing remote deployment / cross-room access, etc. Am...

AI Technical Summary

Problems solved by technology

[0004] The above-mentioned optimization methods all require a lot of changes in the data structure and hardware changes. During the actual execution process, it is easy to cause data loss, data table damage, newly entered data errors, temporary service interruption and other abnormal situations, resulting in huge economic and reputation losses.

In addition, hardware upgrades and network cabling updates will also increase costs.

Images