CN110413679B - Database information processing method, device, equipment and readable storage medium - Google Patents

Abstract

The invention relates to the field of financial science and technology, and discloses a database information processing method, which comprises the following steps: when an information query instruction of a user side is received, judging whether a first information set corresponding to the information query instruction exists in a cached current information set or not; if a first information set corresponding to the information query instruction exists in the current information set, judging whether a degradation record corresponding to a preset identifier of the first information set exists in a degradation table; and if the degradation record exists in the degradation table, acquiring a second information set corresponding to the preset identification from a database, and sending the second information set to the user side. The invention also discloses a database information processing device, equipment and a readable storage medium. The invention effectively reduces the dependence on the cache through the downgrade table, and does not influence the maintenance transaction and the information access transaction under the condition that the cache system has a fault.

Description

Database information processing method, device, equipment and readable storage medium

technical field

The invention relates to the technical field of financial technology (Fintech), in particular to a database information processing method, device, equipment and readable storage medium in the financial industry.

Background technique

With the development of computer technology, more and more technologies (such as distributed, blockchain, artificial intelligence, etc.) are applied in the financial field. The traditional financial industry is gradually transforming into financial technology (Fintech). Technology applied to the financial industry. In the financial industry, the commonly used information sets of bank accounts are usually stored in the database. Since the query of the database is usually slow, the frequently used information sets will be loaded in the cache, so that users can quickly query the required information sets .

In the existing technology, when the user does not find the corresponding information set in the query cache, it will continue to query the slower database. In order to ensure that the information set in the cache is not old and outdated information, when the information changes , to delete the information set in the cache, so that users can downgrade to the database with slower queries to obtain the latest information set; when the asynchronous thread loads the latest information set to the cache, the cache operation synchronization lock is required to update the information Sets are loaded into the cache; in the information maintenance process, the operation of clearing the cache is performed through a synchronization lock, so that the latest information set can be loaded into the cache. However, in order to ensure that the information set in the cache is up-to-date, the information maintenance process and the asynchronous thread loading process need to be synchronized, which has a great impact on the throughput of information maintenance. When a failure occurs, it causes the query to fail.

Contents of the invention

The main purpose of the present invention is to propose a database information processing method, device, equipment and readable storage medium, aiming at solving the problem of relying too much on the cache when the user queries the database information set in the prior art. When the cache fails, it is easy to cause the query to fail.

In order to achieve the above object, the present invention provides a database information processing method, the database information processing method includes the following steps:

When receiving an information query instruction from the client, judging whether there is a first information set corresponding to the information query instruction in the cached current information set;

If there is a first information set corresponding to the information query instruction in the current information set, then judging whether there is a downgrade record corresponding to the preset identifier of the first information set in the downgrade table;

If the downgrade record exists in the downgrade table, a second information set corresponding to the preset identifier is obtained from a database, and the second information set is sent to the user terminal.

Optionally, after the step of judging whether there is a degraded record corresponding to the first information set in the degraded table, the database information processing method includes:

If the downgrade record does not exist in the downgrade table, then acquire the current information set in the cache;

Sending a third information set in the current information set corresponding to the information query instruction to the client.

Optionally, after the step of judging whether there is a first information set corresponding to the information query instruction in the current cached information set, the database information processing method includes:

If the current information set does not have the first information set corresponding to the information query instruction, then obtain the fourth information set corresponding to the information query instruction from the database, and send the fourth information set to the client.

Optionally, before the step of judging whether there is a first information set corresponding to the information query instruction in the cached current information set when receiving the information query instruction from the client, the database information processing method further includes:

Obtaining a real-time information set of the database, wherein the real-time information set is a data set updated in real time in the database;

judging whether the real-time information set has changed;

If yes, register a downgrade record in the downgrade table based on the real-time information set.

Optionally, the step of judging whether a change occurs in the real-time information set includes:

Judging whether there is an information identifier in the real-time information set;

If so, determine that the real-time information set has changed;

If not, it is determined that the real-time information set has not changed.

Optionally, the degraded record includes an information index item, and the step of registering the degraded record in the degraded table based on the real-time information set includes:

Acquiring the corresponding preset identifier based on the information identifier;

A downgrade record corresponding to the preset identifier is generated and stored in the downgrade table, so that the downgrade record is registered in the downgrade table.

Optionally, after the step of obtaining the second information set corresponding to the degraded record in the database, the database information processing method includes:

loading the second set of information into the current set of information to replace the first set of information;

After the loading of the second information set is completed, the downgrade record is deleted in the downgrade table.

In addition, in order to achieve the above object, the present invention also provides a database information processing device, the database information processing device includes:

The first judging module is configured to judge whether there is a first information set corresponding to the information query instruction in the cached current information set when receiving an information query instruction from the client;

The second judging module is configured to judge whether there is a downgrade record corresponding to the preset identifier of the first information set in the downgrade table if the first information set corresponding to the information query instruction exists in the current information set;

A processing module, configured to acquire a second information set corresponding to the preset identifier from a database if the downgrade record exists in the downgrade table, and send the second information set to the client.

Optionally, after the second judging module executes the step of judging whether there is a degraded record corresponding to the first information set in the degraded table, the database information processing device includes a first executing module, configured to:

If the downgrade record does not exist in the downgrade table, then acquire the current information set in the cache;

Sending a third information set in the current information set corresponding to the information query instruction to the client.

Optionally, after the first judging module executes the step of judging whether there is a first information set corresponding to the information query instruction in the current cached information set; the database information processing device includes a second execution module, using At:

If the current information set does not have the first information set corresponding to the information query instruction, then obtain the fourth information set corresponding to the information query instruction from the database, and send the fourth information set to the client.

Optionally, before executing the first query module, the database information processing device further includes a registration module, configured to:

Obtaining a real-time information set of the database, wherein the real-time information set is a data set updated in real time in the database;

judging whether the real-time information set has changed;

If yes, register a downgrade record in the downgrade table based on the real-time information set.

Optionally, after the processing module executes the step of acquiring the second information set corresponding to the preset identifier in the database, the database information processing device further includes a loading module, configured to:

loading the second set of information into the current set of information to replace the first set of information;

After the loading of the second information set is completed, the downgrade record is deleted in the downgrade table.

In addition, in order to achieve the above object, the present invention also provides a database information processing device, which includes: a memory, a processor, and a database information processing system stored in the memory and operable on the processor. A program, when the database information processing program is executed by the processor, implements the steps of the database information processing method described above.

In addition, in order to achieve the above object, the present invention also provides a readable storage medium, on which a database information processing program is stored, and when the database information processing program is executed by a processor, the above-mentioned database information The steps of the processing method.

In the database information processing method proposed by the present invention, a downgrade table is introduced at the database side. When an information query instruction is received, the current information set in the cache is first queried. If there is a corresponding first information set in the cache, and the downgrade table If there is a degraded record in the cache, it means that the current information set in the cache is old and outdated information and should not be used, otherwise it will cause data consistency problems; at this time, it is necessary to obtain the second information set from the database, that is, to obtain the latest information set to ensure that the user end obtains the latest information set. The invention effectively reduces the dependence on the high-speed cache through the downgrade table, and does not affect the maintenance transaction or the information access transaction in the case of a failure of the high-speed cache system.

Description of drawings

Fig. 1 is a schematic diagram of the device structure of the hardware operating environment involved in the solution of the embodiment of the present invention;

Fig. 2 is a schematic flow chart of the first embodiment of the database information processing method of the present invention;

FIG. 3 is a schematic flowchart of a second embodiment of the database information processing method of the present invention;

FIG. 4 is a schematic flowchart of a third embodiment of the database information processing method of the present invention.

The realization of the purpose of the present invention, functional characteristics and advantages will be further described in conjunction with the embodiments and with reference to the accompanying drawings.

Detailed ways

It should be understood that the specific embodiments described here are only used to explain the present invention, not to limit the present invention.

As shown in FIG. 1 , FIG. 1 is a schematic diagram of the equipment structure of the hardware operating environment involved in the solution of the embodiment of the present invention.

The database information processing device in this embodiment of the present invention may be a PC or a server device.

As shown in FIG. 1 , the database information processing device may include: a processor 1001 , such as a CPU, a network interface 1004 , a user interface 1003 , a memory 1005 , and a communication bus 1002 . Wherein, the communication bus 1002 is used to realize connection and communication between these components. The user interface 1003 may include a display screen (Display), an input unit such as a keyboard (Keyboard), and the optional user interface 1003 may also include a standard wired interface and a wireless interface. Optionally, the network interface 1004 may include a standard wired interface and a wireless interface (such as a WI-FI interface). The memory 1005 can be a high-speed RAM memory, or a stable memory (non-volatile memory), such as a disk memory. Optionally, the memory 1005 may also be a storage device independent of the aforementioned processor 1001 .

Those skilled in the art can understand that the device structure shown in FIG. 1 does not constitute a limitation to the device, and may include more or less components than shown in the figure, or combine some components, or arrange different components.

As shown in FIG. 1 , the memory 1005 as a computer-readable storage medium may include an operating system, a network communication module, a user interface module, and a database information processing program.

In the device shown in Figure 1, the network interface 1004 is mainly used to connect to the background server and perform data communication with the background server; the user interface 1003 is mainly used to connect to the client and perform data communication with the client; and the processor 1001 can be used for Call the database information processing program stored in the memory 1005, and execute the operations in the various embodiments of the database information processing method described below.

Based on the above hardware structure, an embodiment of the database information processing method of the present invention is proposed.

Referring to FIG. 2, FIG. 2 is a schematic flowchart of the first embodiment of the database information processing method of the present invention, the method includes:

Step S10, when receiving an information query instruction from the client, judging whether there is a first information set corresponding to the information query instruction in the cached current information set;

In this embodiment, the commonly used information sets of bank accounts are usually stored in the database. Since there are many information sets frequently accessed by users in the database, in order to facilitate users to quickly query the required information sets, the frequently accessed information sets are usually stored in the database. Information sets are loaded in the cache for easy retrieval by the user.

When receiving an information query instruction from the client, it starts to query the cache to check whether there is a first information set corresponding to the information query instruction in the current information set in the cache.

The information query instruction may include information ID, information content, storage location, etc., and the cached current information may cache information sets frequently used by users.

There are many frequently used information sets stored in the cache, so that the user can call them in time. When receiving the information query instruction from the user, the current information set in the cache is obtained, and the first information set corresponding to the information query instruction is compared with the first information set corresponding to the information query instruction. The current information set in the cache is compared, and if the first information set exists in the current information set, it is determined that the first information set exists in the cache.

In order to judge whether the information set in the cache is the latest information set, a subsequent judgment is required to prevent the current information set in the cache from being used because it is old and outdated.

Step S20, if the first information set corresponding to the information query instruction exists in the current information set, then judge whether there is a downgrade record corresponding to the preset identifier of the first information set in the downgrade table;

In this step, when it is considered that the first information set exists in the cache, in order to determine whether the current information set in the cache is the latest information set, it is necessary to query the degradation table.

The downgrading table in this case, downgrading means that if the obtained information set is judged to be outdated and unusable if it is not obtained from the cache, it will drop to a slower database to perform information query. The degrading table in this case is relatively A data table with a lower query speed due to the cache and a higher query speed than the database can be composed of one column or several columns. At the same time, it is also a table with a small amount of data. According to a certain time frequency , load the latest information set from the database into the cache according to the information set identifier in the downgrade table, and delete the downgrade record, so that the size of the downgrade table is kept at a small level.

Due to the lightweight storage method of the downgrade table, the changed information set in the database can be simply recorded. After the information corresponding to the downgrade record in the downgrade table is loaded into the cache, the downgrade record can be deleted, making the volume of the downgrade table Maintained at a small level, the query speed is fast.

Use the downgrade table to store the relevant information of the latest information set. When there is a downgrade record corresponding to the preset identifier in the downgrade table, it means that the current information set in the cache has changed, and it is old and outdated information, which needs to be obtained from the database. Only the latest information can avoid data consistency problems.

When it is determined that there is a degraded record corresponding to the preset identifier of the first information set in the degraded table, it means that the current information set in the cache has been changed and is old and outdated information. At this time, the current information set in the cache needs to be renew.

When it is determined that there is no degraded record corresponding to the preset identifier of the first information set in the degraded table, it means that the current information set in the cache has not changed. At this time, the current information in the cache is consistent with the latest information set in the database , then the information set can be called directly to execute the corresponding logical operation.

Step S30, if the downgrade record exists in the downgrade table, obtain a second information set corresponding to the preset identifier from a database, and send the second information set to the client.

In this step, it is judged whether there is a degraded record corresponding to the first information set in the degraded table, and when it is determined that there is a degraded record corresponding to the preset identifier of the first information set in the degraded table, it means that the current information set in the cache has been changed , is old and outdated information, that is, the latest information in the database is obviously inconsistent with the current information set in the cache. Since the latest information in the database is in the information maintenance phase, the information has changed and has been registered in the downgrade table. Therefore, The downgrade record can be found in the downgrade table.

By sequentially querying the cache, the downgrade table, and even the database, the information set queried by the client is guaranteed to be up-to-date; and, due to the addition of the downgrade table, the dependency of the cache is effectively reduced.

In the database information processing method proposed by the present invention, a downgrade table is introduced at the database side. When an information query instruction is received, the current information set in the cache is first queried. If there is a corresponding first information set in the cache, and the downgrade table If there is a degraded record in the cache, it means that the current information set in the cache is old and outdated information and should not be used, otherwise it will cause data consistency problems; at this time, it is necessary to obtain the second information set from the database, that is, to obtain the latest information set to ensure that the user end obtains the latest information set. The invention effectively reduces the dependence on the high-speed cache through the downgrade table, and does not affect the maintenance transaction or the information access transaction in the case of a failure of the high-speed cache system.

Further, after step S20, the database information processing method includes:

Step S21, if the degraded record does not exist in the degraded table, obtain the current information set in the cache;

Step S22, sending a third information set in the current information set corresponding to the information query instruction to the client.

In this embodiment, when it is determined that there is no degraded record corresponding to the first information set in the degraded table, it means that the current information set in the cache has not changed. At this time, the current information in the cache and the latest information in the database The sets are consistent, and the third information set corresponding to the information query instruction in the current information set is sent to the client, so that the client can directly call the information set and execute the corresponding logical operation.

Through the cooperation of the downgrade table and the cache, the data in the cache and the database are guaranteed to be consistent, thereby effectively ensuring that the information set queried by the user is the latest information set.

Further, after step S10, the database information processing method includes:

Step S11, if the current information set does not have the first information set corresponding to the information query instruction, then obtain the fourth information set corresponding to the information query instruction from the database, and store the fourth information The set is sent to the client.

In this embodiment, if the first information set corresponding to the information query instruction does not exist in the current information set, it means that the first information set does not exist in the cache, and it can be determined that the first information set has never had a user The used information set belongs to low-frequency information, so at this time, it is only necessary to directly downgrade to the database to search, that is, to find the fourth information set corresponding to the information query command in the database, and send the fourth information set to the client for convenience. The user end executes the corresponding logical operation.

For low-frequency information, there is no need to use a cache or a downgrade table, and it is only stored in the database, effectively reducing the pressure on the cache.

Further, based on the first embodiment of the present invention, a second implementation example of the database information processing method is proposed, please refer to FIG. 3 , before step S10, the database information processing method further includes:

Step S101, acquiring a real-time information set of the database, wherein the real-time information set is a data set updated in real time in the database;

Step S102, judging whether the real-time information set has changed;

Step S103, if yes, register a downgrade record in the downgrade table based on the real-time information set.

In this embodiment, in the information maintenance phase, the real-time information set of the database is obtained; it is judged whether the real-time information set has changed; if so, a downgrade record is registered in the downgrade table based on the real-time information set.

Judging whether the real-time information set has changed is specifically: judging whether there is an information identifier in the real-time information set; if so, determining that the real-time information set has changed.

The real-time information set is a data set that is updated in real time in the database. During information maintenance, the information set can be changed by adding, deleting, and modifying the information set. If the real-time information set of the database changes, it will be registered in the downgrade table. The existence of a record in the downgrade table indicates that the cache information set corresponding to the information identifier is outdated, and the information user needs to downgrade to a slower relational database to obtain the latest information; the downgrade record also drives the asynchronous processing thread to load and update the old and outdated Cache information.

Further, step S102 may include:

Judging whether there is an information identifier in the real-time information set;

If so, determine that the real-time information set has changed;

If not, it is determined that the real-time information set has not changed.

In this embodiment, the basis for judging whether the real-time information set changes is whether there is an information identifier. When adding, deleting, or modifying the information set, section-oriented programming (AOP) will be performed to form an information identifier. The logo allows the business to register in the downgrade record without awareness. There is no need to perform synchronization locks during maintenance, and it is not necessary to delete the corresponding cache for the target information set for maintenance. When maintenance fails, it is responsible for restoring the cache. These relatively cumbersome operations.

Further, step S103 may include:

Acquiring the corresponding preset identifier based on the information identifier;

A downgrade record corresponding to the preset identifier is generated and stored in the downgrade table, so that the downgrade record is registered in the downgrade table.

In this embodiment, the real-time information set in the database can also include information ID and information content, etc., and can also include information identification when the information changes. The information ID is used as a search keyword, and the information ID corresponds to the information content. The information ID corresponds to a piece of information content; the information ID corresponds to an information ID and a piece of information content; the downgrade record set in the downgrade table includes multiple downgrade records, which are listed in a table, and the downgrade record only records a certain information ID, and the information ID corresponds to Simple information such as the index item of the index item, the time of modification, and the storage location information, such as the default identifier of the first information ID is 1, and the preset identifier of the second information ID is 2, which are modified at a certain point in time.

The degraded table is a table with a simple structure. According to the composition of the unique identifier of the information set, there may be only one column or several columns. It is simple and easy to implement.

Further, based on the first embodiment of the present invention, a third implementation example of the database information processing method is proposed, please refer to FIG. 4 , after step S30, the database information processing method includes:

Step S40, loading the second information set into the current information set to replace the first information set;

Step S50, after the second information set is loaded, delete the downgrade record in the downgrade table.

In this embodiment, in the asynchronous processing thread, the second information set is loaded into the current information set to replace the first information set, and the second information set cache is deleted after loading/updating. The degraded record identified by the information, when it is detected that there is no degraded record identified by the information set, the information obtained from the cache can be guaranteed to be up-to-date.

The degraded record also drives the asynchronous processing thread to load and update the old and outdated cache information, and loads the latest information set from the database to the cache according to the information set identifier in the degraded table according to a certain time frequency and deletes the degraded record, thus making the degraded table The volume is kept at a small level.

The invention also provides a database information processing device. The database information processing device of the present invention includes:

The first judging module is configured to judge whether there is a first information set corresponding to the information query instruction in the cached current information set when receiving an information query instruction from the client;

The second judging module is configured to judge whether there is a downgrade record corresponding to the preset identifier of the first information set in the downgrade table if the first information set corresponding to the information query instruction exists in the current information set;

A processing module, configured to obtain a second information set corresponding to the preset identifier from a database if the downgrade record exists in the downgrade table, and send the second information set to the client.

Further, after the second judging module executes the step of judging whether there is a degraded record corresponding to the first information set in the degraded table, the database information processing device includes a first executing module, configured to:

If the downgrade record does not exist in the downgrade table, then acquire the current information set in the cache;

Sending a third information set in the current information set corresponding to the information query instruction to the client.

Further, after the first judging module executes the step of judging whether there is a first information set corresponding to the information query instruction in the current cached information set; the database information processing device includes a second execution module for :

If the current information set does not have the first information set corresponding to the information query instruction, then obtain the fourth information set corresponding to the information query instruction from the database, and send the fourth information set to the client.

Further, before executing the first query module, the database information processing device also includes a registration module for:

Obtaining a real-time information set of the database, wherein the real-time information set is a data set updated in real time in the database;

judging whether the real-time information set has changed;

If yes, register a downgrade record in the downgrade table based on the real-time information set.

Further, the registration module is also used for:

Judging whether there is an information identifier in the real-time information set;

If so, it is determined that the real-time information set has changed

If not, it is determined that the real-time information set has not changed.

Further, the degraded record includes information index items, and the registration module is also used for:

Acquiring the corresponding preset identifier based on the information identifier;

A downgrade record corresponding to the preset identifier is generated and stored in the downgrade table, so that the downgrade record is registered in the downgrade table.

Further, after the processing module executes the step of acquiring the second information set corresponding to the preset identifier in the database, the database information processing device further includes a loading module, configured to:

loading the second set of information into the current set of information to replace the first set of information;

After the loading of the second information set is completed, the downgrade record is deleted in the downgrade table.

The present invention also provides a computer-readable storage medium.

The computer-readable storage medium of the present invention stores a database information processing program, and when the database information processing program is executed by a processor, the steps of the above-mentioned database information processing method are realized.

For the method implemented when the database information processing program running on the processor is executed, reference may be made to various embodiments of the database information processing method of the present invention, which will not be repeated here.

It should be noted that, as used herein, the term "comprises", "comprises" or any other variation thereof is intended to cover a non-exclusive inclusion such that a process, method, article or system comprising a set of elements includes not only those elements, It also includes other elements not expressly listed, or elements inherent in the process, method, article, or system. Without further limitations, an element defined by the phrase "comprising a..." does not preclude the presence of additional identical elements in the process, method, article or system comprising that element.

The serial numbers of the above embodiments of the present invention are for description only, and do not represent the advantages and disadvantages of the embodiments.

Through the description of the above embodiments, those skilled in the art can clearly understand that the methods of the above embodiments can be implemented by means of software plus a necessary general-purpose hardware platform, and of course also by hardware, but in many cases the former is better implementation. Based on this understanding, the technical solution of the present invention can be embodied in the form of a software product in essence or in other words, the part that contributes to the prior art, and the computer software product is stored in a readable storage medium (such as ROM) as described above /RAM, magnetic disk, optical disk), including several instructions to make a database information processing device (which can be a mobile phone, computer, server, air conditioner, or network equipment, etc.) execute the methods described in various embodiments of the present invention.

The above are only preferred embodiments of the present invention, and are not intended to limit the patent scope of the present invention. Any equivalent structure or equivalent process conversion made by using the description of the present invention and the contents of the accompanying drawings, or directly or indirectly used in other related technical fields , are all included in the scope of patent protection of the present invention in the same way.

Claims (12)

1. A database information processing method, characterized in that, said database information processing method comprises the steps: When receiving an information query instruction from the client, judging whether there is a first information set corresponding to the information query instruction in the cached current information set; If there is a first information set corresponding to the information query instruction in the current information set, then judging whether there is a downgrade record corresponding to the preset identifier of the first information set in the downgrade table; If the downgrade record exists in the downgrade table, obtain a second information set corresponding to the preset identifier from a database, and send the second information set to the client; Wherein, after the step of obtaining the second information set corresponding to the preset identifier in the database, the database information processing method further includes: loading the second set of information into the current set of information to replace the first set of information; After the loading of the second information set is completed, the downgrade record is deleted in the downgrade table. 2. The database information processing method according to claim 1, wherein after the step of judging whether there is a degraded record corresponding to the preset identifier of the first information set in the degraded table, the database information processing Methods include: If the downgrade record does not exist in the downgrade table, then acquire the current information set in the cache; Sending a third information set in the current information set corresponding to the information query instruction to the client. 3. The database information processing method according to claim 1, wherein after the step of determining whether the current information set of the cache has a first information set corresponding to the information query instruction, the database information processing Methods include: If the current information set does not have the first information set corresponding to the information query instruction, then obtain the fourth information set corresponding to the information query instruction from the database, and send the fourth information set to the client. 4. The database information processing method according to claim 1, characterized in that, when receiving an information query instruction from the client, it is judged whether there is a first information corresponding to the information query instruction in the current information set of the cache Before the set step, the database information processing method also includes: Obtaining a real-time information set of the database, wherein the real-time information set is a data set updated in real time in the database; judging whether the real-time information set has changed; If yes, register a downgrade record in the downgrade table based on the real-time information set. 5. The database information processing method according to claim 4, wherein the step of judging whether a change occurs in the real-time information set comprises: Judging whether there is an information identifier in the real-time information set; If so, determine that the real-time information set has changed; If not, it is determined that the real-time information set has not changed. 6. The database information processing method according to claim 5, wherein the step of registering a degraded record in the degraded table comprises: Acquiring the corresponding preset identifier based on the information identifier; A downgrade record corresponding to the preset identifier is generated and stored in the downgrade table, so that the downgrade record is registered in the downgrade table. 7. A database information processing device, characterized in that the database information processing device comprises: The first judging module is configured to judge whether there is a first information set corresponding to the information query instruction in the cached current information set when receiving an information query instruction from the client; The second judging module is configured to judge whether there is a downgrade record corresponding to the preset identifier of the first information set in the downgrade table if the first information set corresponding to the information query instruction exists in the current information set; A processing module, configured to obtain a second information set corresponding to the preset identifier from a database if the downgrade record exists in the downgrade table, and send the second information set to the client; The database information processing device also includes a loading module for: loading the second set of information into the current set of information to replace the first set of information; After the loading of the second information set is completed, the downgrade record is deleted in the downgrade table. 8. The database information processing device according to claim 7, wherein after the second judging module executes the step of judging whether there is a degraded record corresponding to the first information set in the degraded table, the database information The processing device includes a first execution module for: If the downgrade record does not exist in the downgrade table, then acquire the current information set in the cache; Sending a third information set in the current information set corresponding to the information query instruction to the client. 9. The database information processing device according to claim 7, wherein, in the first judging module, it is judged whether the current information set in the judging cache has a first information set corresponding to the information query instruction. After the step; the database information processing device includes a second execution module for: If the current information set does not have the first information set corresponding to the information query instruction, then obtain the fourth information set corresponding to the information query instruction from the database, and send the fourth information set to the client. 10. The database information processing device according to claim 7, characterized in that, before executing the first query module, the database information processing device further comprises a registration module for: Obtaining a real-time information set of the database, wherein the real-time information set is a data set updated in real time in the database; judging whether the real-time information set has changed; If yes, register a downgrade record in the downgrade table based on the real-time information set. 11. A database information processing device, characterized in that the database information processing device comprises: a memory, a processor, and a database information processing program stored on the memory and operable on the processor, the database When the information processing program is executed by the processor, the steps of the database information processing method according to any one of claims 1 to 6 are realized. 12. A readable storage medium, characterized in that, a database information processing program is stored on the readable storage medium, and when the database information processing program is executed by a processor, it realizes the process described in any one of claims 1 to 6. Steps of the database information processing method described above.

Images