WO2022252322A1

WO2022252322A1 - Method for synchronizing memory database and relational database of feature tag-based power grid monitoring system

Info

Publication number: WO2022252322A1
Application number: PCT/CN2021/103157
Authority: WO
Inventors: 梁苑; 张勇; 赵瑞锋; 林敏洪; 卢建刚; 杨叶昕; 刘行健
Original assignee: 广东电网有限责任公司珠海供电局
Priority date: 2021-06-03
Filing date: 2021-06-29
Publication date: 2022-12-08
Also published as: DE112021007528T5; CN113360571A; CN113360571B

Abstract

A method and apparatus for synchronizing a memory database and a relational database of a feature tag-based power grid monitoring system, a computer device, and a storage medium. The method comprises: writing new data into a data cache area of a memory database and tagging the new data (21); writing the new data having a tag into a cache file of a relational database according to a mapping relationship between the data cache area and the cache file of the relational database (22); and writing, according to the tag, the new data temporarily stored in the cache file into the relational database (23). According to the method, the new data is tagged, and the new data temporarily stored in the cache file is written into the relational database, such that the problem that the memory database needs to synchronize the data after a period of time is solved; the system data can be synchronized quickly; and the efficiency of data synchronization between the memory database and the relational database of the feature tag-based power grid monitoring system is improved.

Description

Synchronization method of memory database and relational database in power grid monitoring system based on feature mark

technical field

The present application relates to the technical field of power grid monitoring, and in particular to a method, device, computer equipment and storage medium for synchronizing memory databases and relational databases of a power grid monitoring system based on signatures.

Background technique

In-memory databases and relational databases generally exist in power grid monitoring systems; in-memory databases are databases that store data in memory and operate directly. Features, save data in memory; relational database refers to a database that organizes, stores and manages data according to a certain data structure and model, and a database built using a relational model is called a relational database.

In a system, the in-memory database and the relational database generally coexist at the same time, and the new data is generally stored in the in-memory database first, and after a preset time, the new data will be transferred from the in-memory database to the relational database However, if the new data stored in the memory database is lost due to system power failure before the preset time, this will affect the transfer synchronization of the new data, resulting in the existing new data transfer efficiency Still lower.

Contents of the invention

Based on this, it is necessary to provide a method, device, computer equipment, and storage medium for synchronizing a power grid monitoring system's memory library and relational library based on signatures in order to address the above technical problems.

A method for synchronizing a relational library in a memory library of a power grid monitoring system based on a feature mark, comprising:

Writing the newly added data into the data cache area of the memory database and marking the newly added data;

writing the newly added data with the tag into the cache file of the relational database according to the mapping relationship between the data cache area and the cache file of the relational database;

Writing the newly added data temporarily stored in the cache file into the relational database according to the mark.

In one of the embodiments, writing the new data into the data cache area of the memory database and marking the new data includes:

The added data is detected;

writing the newly added data into the data cache area of the memory database;

Marking the newly added data stored in the data cache area.

In one of the embodiments, according to the mapping relationship between the data cache area and the cache file of the relational database, the newly added data with the mark is written into the cache file of the relational database ,include:

Establishing a mapping relationship between the data cache area and the cache file of the relational database according to memory mapping technology;

Writing the newly added data with the tag into the cache file of the relational database according to the mapping relationship.

In one of the embodiments, writing the newly added data temporarily stored in the cache file into the relational database according to the mark includes:

comparing and matching the tags of the newly added data with the stored tags in the relational database to obtain a tag comparison and matching result;

According to the tag comparison and matching result, the newly added data temporarily stored in the cache file is written into a corresponding section of the relational database.

In one of the embodiments, after writing the newly added data temporarily stored in the cache file into the relational database according to the mark, it includes:

Deleting the newly added data in the cache file.

In one of the embodiments, the relational database is at least one of MySQL, Oracle and DB2.

In one of the embodiments, the in-memory database is at least one of Redis, SQLite, and MongoDB.

A feature tag-based synchronization device for a power grid monitoring system memory library relationship library, the device includes:

A data marking module, configured to write new data into the data cache area of the memory database and mark the new data;

A data writing module, configured to write the newly added data with the tag into the cache file of the relational database according to the mapping relationship between the data cache area and the cache file of the relational database;

A data storage module, configured to write the newly added data temporarily stored in the cache file into the relational database according to the mark.

A computer device, comprising a memory and a processor, the memory stores a computer program, and the processor implements the following steps when executing the computer program:

A computer-readable storage medium, on which a computer program is stored, and when the computer program is executed by a processor, the following steps are implemented:

The method, device, computer equipment, and storage medium for synchronizing the memory library relational library of the power grid monitoring system based on the feature mark, the method includes: writing the newly added data into the data cache area of the memory database and marking the newly added data; according to the data cache area According to the mapping relationship with the cache file of the relational database, the newly added data with the mark is written into the cache file of the relational database; according to the mark, the newly added data temporarily stored in the cache file is written into the relational database. This application marks the new data and writes the new data temporarily stored in the cache file into the relational database, which solves the problem that the memory database needs a period of time to synchronize the data, so that the system data can be quickly synchronized , which improves the efficiency of data synchronization between memory and relational databases in the power grid monitoring system based on feature marks.

Description of drawings

Fig. 1 is the application environment diagram of the method for synchronizing the relational database in the power grid monitoring system based on the signature in one embodiment;

Fig. 2 is a schematic flow diagram of a method for synchronizing a relational library in a power grid monitoring system based on a signature in an embodiment;

Fig. 3 is a schematic flow chart of the steps of writing new data into the data cache area of the memory database and marking the new data in one embodiment;

Fig. 4 is a schematic flow chart of the steps of writing new data with a mark into a cache file of a relational database in one embodiment;

FIG. 5 is a schematic flow diagram of a method for synchronizing a relational library in a power grid monitoring system based on a signature in another embodiment;

Fig. 6 is a structural block diagram of a power grid monitoring system memory library relational library synchronization device based on a feature mark in an embodiment;

Figure 7 is an internal block diagram of a computer device in one embodiment.

Detailed ways

In order to make the purpose, technical solution and advantages of the present application clearer, the present application will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the present application, and are not intended to limit the present application.

The signature-based method for synchronizing the memory database and relational database of the power grid monitoring system provided by the present application can be applied to the application environment shown in FIG. 1 . Wherein, the terminal 11 communicates with the server 12 through the network. The server 12 receives the data sent by the terminal 11 as new data, and the server 12 writes the new data into the data cache area of the memory database and marks the new data; The mapping relationship is to write the newly added data with the tag into the cache file of the relational database; the server 12 writes the newly added data temporarily stored in the cache file into the relational database according to the tag; the server 12 returns the new data to the terminal 11. The result of adding data processing.

Wherein, the terminal 11 can be, but not limited to, various personal computers, notebook computers, smart phones, tablet computers and portable wearable devices, and the server 12 can be realized by an independent server or a server cluster composed of multiple servers.

In one embodiment, as shown in FIG. 2 , a method for synchronizing a relational library in a power grid monitoring system memory library based on a signature is provided. The application of the method to the server 12 in FIG. 1 is used as an example for illustration, including the following steps:

Step 21, write the newly added data into the data cache area of the memory database and mark the newly added data.

Among them, the memory database refers to the database that puts the data in the memory and directly operates it. It uses the characteristics of the read and write speed of the memory faster than the disk, and the random access of the memory while the sequential access of the disk, and stores the data in the memory. The table structure and index structure are imitated in memory and optimized for memory characteristics. Compared with accessing from disk, memory database access is faster. The data processed by the memory database is usually "short-lived", that is, it has a certain effective time.

Wherein, the newly added data may be data received by the server and transmitted from an external device, and the data may be expressed as text information, image information or notification information, which is not limited here. The external device may be a router, a switch, a server, a cloud platform or other data transmission communication devices. The added data may be generated by human operations or sensors, for example, data generated by operating instructions input by a user or trigger signals generated by sensors due to changes in the external environment.

Wherein, marking the newly added data may be an ID for adding data identification, so as to make it unique. For example, the initial new data is marked as "A001", and the subsequent new data received can be marked as "B002", and so on, and when the new data is stored in the subsequent relational database, Storage sorting can be performed according to tags, making data storage more organized.

Among them, the memory database can use Redis (Remote Dictionary Server, remote dictionary service), SQLite (a light database), MongoDB (a database based on distributed file storage).

Specifically, the new data carries identification information, and the identification information can be the data type of the new data, or the tag information of the data when the data is generated; the server can determine the memory database corresponding to the new data according to the identification information And the specific data cache area within the memory database that can be used for storage; after that, the server will mark the new data, and the marking action can be performed at the same time as the storage, or before or after the storage.

Step 22, according to the mapping relationship between the data cache area and the cache file of the relational database, write the newly added data with the mark into the cache file of the relational database.

Among them, a relational database refers to a database that organizes, stores and manages data according to a certain data structure and model. A database built using a relational model is called a relational database. Relational databases are built on the basis of set algebra and apply mathematical methods to process data in the database. Relational databases deal with permanent, stable data.

Wherein, the mapping relationship between the data cache area and the cache file of the relational database can be established according to the mapping function; using the mapping relationship, the new data stored in the memory database can be quickly transferred to the cache file of the relational database.

Among them, the relational database can use MySQL (a relational database management system), Oracle (also known as Oracle RDBMS, a relational database management system with a distributed database as the core), DB2 (a relational database management system mainly used in large-scale application systems) database management system).

Specifically, the server obtains a preset mapping relationship, and identifies, according to the identifier of the data cache area, the cache file matching the identifier as the cache file of the relational database for writing the newly added data.

Step 23, write the newly added data temporarily stored in the cache file into the relational database according to the mark.

Specifically, the server transfers the newly added data from the cache file of the relational database to the relational database, so that the newly added data is stored in the relational database from the memory database. The centralized control of new data can be realized through the relational database, and the data can be independent of the application program, which provides convenience for the use, adjustment, optimization and further expansion of the data. Relational databases are structured according to a certain structure. The newly added data are related to each other within the record and between record types. Data can be accessed through different paths, and the speed of data acquisition and processing is relatively fast.

Further, in the method for synchronizing the memory database relational database of the power grid monitoring system based on the feature mark in the embodiment of the present invention, the newly added data is first written into the data cache area of the memory database, and the newly added data is marked; then according to the memory database According to the mapping relationship between the data cache area and the cache file of the relational database, the newly marked new data is first written into the cache file of the relational database; then according to the mark, the newly added data temporarily stored in the cache file is written to Into the relational database, there is no need to temporarily store the data in the memory database as before, and it will be transferred and synchronized to the relational database after a period of time. The data can be quickly synchronized, which improves the efficiency of data synchronization between the memory database and the relational database of the power grid monitoring system based on the feature mark.

In the method for synchronizing the relational database in the memory database of the power grid monitoring system based on the feature mark, by writing the newly added data into the data cache area of the memory database and marking the newly added data; According to the mapping relationship, the newly added data with the mark is written into the cache file of the relational database; according to the mark, the newly added data temporarily stored in the cache file is written into the relational database. This application marks the newly added data and writes the newly added data temporarily stored in the cache file into the relational database, which solves the problem that the memory database needs a period of time to synchronize the data, so that the system data can be quickly synchronized, improving the Efficiency of data synchronization between relational databases in power grid monitoring system based on feature marks.

In one embodiment, as shown in FIG. 3, the above step 21, writing the newly added data into the data cache area of the memory database and marking the newly added data includes:

Step 31, detecting new data;

Step 32, write the newly added data into the data cache area of the memory database;

Step 33, mark the newly added data stored in the data cache area.

Specifically, the server detects the newly added data; if the newly added data is detected, the newly added data is written into the preset data cache area in the memory database; the server performs the new data stored in the data cache area mark.

Specifically, the server regularly checks the incoming of newly added data; the newly added data also includes new files obtained after the original file has been modified, and the server can judge whether the original file has passed the Modified update.

It should be noted that the detection of newly added data can be set as a regular detection method, and the set detection time interval can be 0.5 ms or 1 ms, which can be set by the user according to needs.

In this embodiment, the server can store the newly added data into the data cache area as soon as possible according to the input characteristics of the newly added data and mark them by timing or real-time detection of the newly added data, so as to improve the memory of the power grid monitoring system based on feature marks. The effect of data synchronization efficiency between library relational libraries.

In one embodiment, as shown in FIG. 4, the above step 22, according to the mapping relationship between the data cache area and the cache file of the relational database, writes the newly added data with the mark into the cache file of the relational database, include:

Step 41, establish a mapping relationship between the data cache area and the cache file of the relational database according to the memory mapping technology;

Step 42, according to the mapping relationship, write the newly added data with the mark into the cache file of the relational database.

Wherein, the memory mapping technology may be in the form of a mapping function, using the mapping function to establish a one-to-one mapping relationship between the data cache area and the cache file.

Specifically, the server uses memory mapping technology to establish a mapping relationship between the data cache area and the cache file of the relational database, and can use a mapping function to establish a one-to-one mapping relationship between the data cache area and the cache file; The mapping relationship writes the newly added data with tags into the cache file of the relational database.

The server of this embodiment uses the memory mapping technology to establish a connection between the cache file of the relational database and the data cache area, so as to transfer the newly added data in a targeted manner and store it in the cache file of the target, which improves the power grid based on the feature mark. Monitor the efficiency of data synchronization between system memory database relational databases.

In one embodiment, the above step 23, according to the tag, writes the newly added data temporarily stored in the cache file into the relational database, including: comparing and matching the tag of the newly added data with the tag already stored in the relational database , to obtain the tag comparison and matching result; according to the tag comparison and matching result, write the newly added data temporarily stored in the cache file to the corresponding interval of the relational database.

Among them, the data already stored in the relational database is also tagged, and the tags in the newly added data are compared and matched with the tags already stored in the relational database to obtain the tag comparison and matching result; then according to the tag comparison and matching result, the The newly added data temporarily stored in the cache file is written into the corresponding interval of the relational database. For example, if the new data is marked as "003", when it is compared and matched with the mark of the stored data in the relational database, the data marked as "002" will be searched, and then the newly added data will be stored in the data marked as " 002" data storage interval, making data storage more organized.

In this embodiment, the server obtains the tag comparison and matching result by comparing and matching the tag of the newly added data with the tag stored in the relational database; according to the tag comparison and matching result, the newly added data temporarily stored in the cache file is written to In the corresponding section of the relational database, new data can be stored in the relational database in the order of marking, so that the new data is displayed in the relational database in the order of input, which improves the ease of use and extraction of subsequent data.

In one embodiment, the above step 23, after writing the newly added data temporarily stored in the cache file into the relational database according to the mark, includes: deleting the newly added data in the cache file.

Specifically, after the server writes the new data into the relational database, it can delete the new data in the cache file, so that the cache file can be fully utilized, and the new data is only temporarily stored each time as the previous data stored in the relational database. transition. At the same time, cache files can maintain a high memory capacity after each deletion, and subsequent new data can be directly transferred in, which improves the turnover efficiency of new data.

In this embodiment, the server deletes the newly added data in the cache file after writing the newly added data temporarily stored in the cache file into the relational database, so that the cache file can maintain a larger available memory for subsequent storage of newly added data. .

In one embodiment, as shown in FIG. 5 , there is provided another method for synchronizing a relational database in a power grid monitoring system memory database based on a signature, and the method is applied to the server 12 in FIG. 1 as an example for illustration, including the following steps:

Step 51, writing the newly added data into the data cache area of the memory database and marking the newly added data;

Step 52, according to the mapping relationship between the data cache area and the cache file of the relational database, write the newly added data with the mark into the cache file of the relational database;

Step 53, write the newly added data temporarily stored in the cache file into the relational database according to the mark;

Step 54, delete the newly added data in the cache file.

Specifically, after the server writes the new data into the relational database, it also deletes the new data stored in the cache file of the relational database, so that the storage space can be well cleaned up, so that the storage space does not appear unnecessary. Wasteful, does not increase the storage overhead of a relational database.

In this embodiment, the server writes the newly added data into the data cache area of the memory database and marks the newly added data; according to the mapping relationship between the data cache area and the cache file of the relational database, writes the newly added data with the mark into the cache file of the relational database; according to the mark, write the new data temporarily stored in the cache file into the relational database; delete the new data in the cache file, so that the data can be saved from the cache file after being stored in the relational database It improves the overall operating efficiency of data synchronization between memory databases and relational databases in the power grid monitoring system based on feature marks.

It should be understood that although the various steps in the flow charts of FIGS. 2-5 are shown sequentially as indicated by the arrows, these steps are not necessarily executed sequentially in the order indicated by the arrows. Unless otherwise specified herein, there is no strict order restriction on the execution of these steps, and these steps can be executed in other orders. Moreover, at least some of the steps in Figures 2-5 may include multiple steps or stages, these steps or stages are not necessarily executed at the same moment, but may be executed at different moments, the execution of these steps or stages The sequence is not necessarily performed sequentially, but may be performed alternately or alternately with other steps or at least a part of steps or stages in other steps.

In one embodiment, as shown in FIG. 6 , a device for synchronizing a database relational database in a power grid monitoring system based on a signature is provided, including: a data marking module 61, a data writing module 62 and a data storage module 63, wherein:

Data marking module 61, for writing new data into the data cache area of the memory database and marking the new data;

The data writing module 62 is used for writing the newly added data with the mark into the cache file of the relational database according to the mapping relationship between the data cache area and the cache file of the relational database;

The data storage module 63 is configured to write the newly added data temporarily stored in the cache file into the relational database according to the mark.

In one embodiment, the data marking module 61 is further configured to detect new data; write the new data into the data cache area of the memory database; and mark the new data stored in the data cache area.

In one embodiment, the data writing module 62 is also used to establish a mapping relationship between the data cache area and the cache file of the relational database according to the memory mapping technology; according to the mapping relationship, write the newly added data with the mark into In the cache file of the relational database.

In one embodiment, the data storage module 63 is also used to compare and match the tags of the newly added data with the stored tags in the relational database to obtain a tag comparison and matching result; The newly added data in the file is written to the corresponding section of the relational database.

In one embodiment, the data storage module 63 is also used to delete newly added data in the cache file.

For the specific limitations of the device for synchronizing the relational library in the memory database of the power grid monitoring system based on signatures, please refer to the above-mentioned definition of the method for synchronizing the relational databases in the memory database of the power grid monitoring system based on signatures, and details will not be repeated here. All or part of the various modules in the above-mentioned signature-based power grid monitoring system memory library relation library synchronization device can be realized by software, hardware and combinations thereof. The above-mentioned modules can be embedded in or independent of the processor in the computer device in the form of hardware, and can also be stored in the memory of the computer device in the form of software, so that the processor can invoke and execute the corresponding operations of the above-mentioned modules.

In one embodiment, a computer device is provided. The computer device may be a server, and its internal structure may be as shown in FIG. 7 . The computer device includes a processor, memory and a network interface connected by a system bus. Wherein, the processor of the computer device is used to provide calculation and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, computer programs and databases. The internal memory provides an environment for the operation of the operating system and computer programs in the non-volatile storage medium. The computer device's database is used to store synchronization data. The network interface of the computer device is used to communicate with an external terminal via a network connection. When the computer program is executed by a processor, a method for synchronizing a power grid monitoring system's internal memory library and relational library is realized.

Those skilled in the art can understand that the structure shown in Figure 7 is only a block diagram of a part of the structure related to the solution of this application, and does not constitute a limitation to the computer equipment on which the solution of this application is applied. The specific computer equipment can be More or fewer components than shown in the figures may be included, or some components may be combined, or have a different arrangement of components.

In one embodiment, a computer device is provided, including a memory and a processor, a computer program is stored in the memory, and the processor implements the following steps when executing the computer program:

Write the new data into the data cache area of the memory database and mark the new data; the memory database is at least one of Redis, SQLite, and MongoDB;

According to the mapping relationship between the data cache area and the cache file of the relational database, the newly added data with the mark is written into the cache file of the relational database; the relational database is at least one of MySQL, Oracle and DB2;

Write the newly added data temporarily stored in the cache file into the relational database according to the mark.

In one embodiment, the following steps are also implemented when the processor executes the computer program: detecting newly added data; writing the newly added data into the data cache area of the memory database; mark.

In one embodiment, when the processor executes the computer program, the following steps are also implemented: according to the memory mapping technology, a mapping relationship is established between the data cache area and the cache file of the relational database; into the cache file of the relational database.

In one embodiment, when the processor executes the computer program, the following steps are also implemented: comparing and matching the tags of the newly added data with the tags already stored in the relational database to obtain the tag comparison and matching result; according to the tag comparison and matching result, the temporarily The newly added data stored in the cache file is written into the corresponding section of the relational database.

In one embodiment, a computer-readable storage medium is provided, on which a computer program is stored, and when the computer program is executed by a processor, the following steps are implemented:

In one embodiment, when the computer program is executed by the processor, the following steps are also implemented: detecting newly added data; writing the newly added data into the data cache area of the memory database; to mark.

In one embodiment, when the computer program is executed by the processor, the following steps are also implemented: according to the memory mapping technology, a mapping relationship is established between the data cache area and the cache file of the relational database; Write to the cache file of the relational database.

In one embodiment, when the computer program is executed by the processor, the following steps are also implemented: comparing and matching the tags of the newly added data with the tags already stored in the relational database to obtain a tag comparison and matching result; according to the tag comparison and matching result, the The newly added data temporarily stored in the cache file is written to the corresponding section of the relational database.

Those of ordinary skill in the art can understand that all or part of the processes in the methods of the above embodiments can be implemented through computer programs to instruct related hardware, and the above computer programs can be stored in a non-volatile computer-readable storage medium In this case, when the computer program is executed, it may include the processes of the embodiments of the above-mentioned methods. Wherein, any references to memory, storage, database or other media used in the various embodiments provided in the present application may include at least one of non-volatile memory and volatile memory. Non-volatile memory may include read-only memory (Read-Only Memory, ROM), magnetic tape, floppy disk, flash memory or optical memory, etc. Volatile memory can include Random Access Memory (RAM) or external cache memory. By way of illustration and not limitation, RAM can take many forms, such as Static Random Access Memory (SRAM) or Dynamic Random Access Memory (DRAM).

The technical features of the above embodiments can be combined arbitrarily. To make the description concise, all possible combinations of the technical features in the above embodiments are not described. However, as long as there is no contradiction in the combination of these technical features, they should be It is considered to be within the range described in this specification.

The above embodiments only express several implementation modes of the present application, and the description thereof is relatively specific and detailed, but it should not be construed as limiting the scope of the patent for the invention. It should be noted that those skilled in the art can make several modifications and improvements without departing from the concept of the present application, and these all belong to the protection scope of the present application. Therefore, the scope of protection of the patent application should be based on the appended claims.

Claims

A method for synchronizing a relational library in a power grid monitoring system memory library based on a feature mark, characterized in that it includes:

Writing the newly added data into the data cache area of the memory database and marking the newly added data;

writing the newly added data with the tag into the cache file of the relational database according to the mapping relationship between the data cache area and the cache file of the relational database;

Writing the newly added data temporarily stored in the cache file into the relational database according to the mark.
The method for synchronizing a relational database in a power grid monitoring system based on a feature mark according to claim 1, wherein the writing of newly added data into the data cache area of the memory database and marking the newly added data includes :

The added data is detected;

writing the newly added data into the data cache area of the memory database;

Marking the newly added data stored in the data cache area.
The method for synchronizing a relational database in a power grid monitoring system based on a feature mark according to claim 1, wherein, according to the mapping relationship between the cache file of the data cache area and the relational database, there will be a The newly added data marked is written into the cache file of the relational database, including:

Establishing a mapping relationship between the data cache area and the cache file of the relational database according to memory mapping technology;

Writing the newly added data with the tag into the cache file of the relational database according to the mapping relationship.
The method for synchronizing a relational library in a power grid monitoring system based on a feature tag according to claim 1, wherein, according to the tag, the newly added data temporarily stored in the cache file is written into the Among the relational databases mentioned above, including:

comparing and matching the tags of the newly added data with the stored tags in the relational database to obtain a tag comparison and matching result;

According to the tag comparison and matching result, the newly added data temporarily stored in the cache file is written to the corresponding section of the relational database.
According to claim 4, the method for synchronizing the relational library of the power grid monitoring system memory library based on the feature mark is characterized in that, according to the mark, the described new data temporarily stored in the cache file is written into the After the relational database, including:

Deleting the newly added data in the cache file.
The method for synchronizing a relational database in a power grid monitoring system based on a signature according to any one of claims 1 to 5, wherein the relational database is at least one of MySQL, Oracle and DB2.
According to any one of claims 1 to 5, the signature-based method for synchronizing the memory database relational database of the power grid monitoring system, wherein the memory database is at least one of Redis, SQLite, and MongoDB.
A power grid monitoring system memory library relational library synchronization device based on feature marks, characterized in that the device includes:

A data marking module, configured to write new data into the data cache area of the memory database and mark the new data;

A data writing module, configured to write the newly added data with the tag into the cache file of the relational database according to the mapping relationship between the data cache area and the cache file of the relational database;

A data storage module, configured to write the newly added data temporarily stored in the cache file into the relational database according to the mark.
A computer device, comprising a memory and a processor, the memory stores a computer program, wherein the processor implements the steps of the method according to any one of claims 1 to 7 when executing the computer program.
A computer-readable storage medium, on which a computer program is stored, wherein, when the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 7 are realized.