WO2022252322A1 - Procédé de synchronisation de base de données de mémoire et de base de données relationnelle d'un système de surveillance de réseau électrique basé sur des étiquettes de caractéristique - Google Patents

Procédé de synchronisation de base de données de mémoire et de base de données relationnelle d'un système de surveillance de réseau électrique basé sur des étiquettes de caractéristique Download PDF

Info

Publication number
WO2022252322A1
WO2022252322A1 PCT/CN2021/103157 CN2021103157W WO2022252322A1 WO 2022252322 A1 WO2022252322 A1 WO 2022252322A1 CN 2021103157 W CN2021103157 W CN 2021103157W WO 2022252322 A1 WO2022252322 A1 WO 2022252322A1
Authority
WO
WIPO (PCT)
Prior art keywords
data
relational database
newly added
database
memory
Prior art date
Application number
PCT/CN2021/103157
Other languages
English (en)
Chinese (zh)
Inventor
梁苑
张勇
赵瑞锋
林敏洪
卢建刚
杨叶昕
刘行健
Original Assignee
广东电网有限责任公司珠海供电局
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by 广东电网有限责任公司珠海供电局 filed Critical 广东电网有限责任公司珠海供电局
Priority to DE112021007528.4T priority Critical patent/DE112021007528T5/de
Publication of WO2022252322A1 publication Critical patent/WO2022252322A1/fr

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00—Administration; Management
    • G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
    • G06Q10/063—Operations research, analysis or management
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
    • G06F16/275—Synchronous replication
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/21—Design, administration or maintenance of databases
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/245—Query processing
    • G06F16/2455—Query execution
    • G06F16/24552—Database cache management
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/28—Databases characterised by their database models, e.g. relational or object models
    • G06F16/284—Relational databases
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
    • G06Q50/06—Energy or water supply

Definitions

  • 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.
  • 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.
  • 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
  • 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.
  • 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 new data into the data cache area of the memory database and marking the new data includes:
  • the added data is detected
  • the newly added data with the mark is written into the cache file of the relational database ,include:
  • writing the newly added data temporarily stored in the cache file into the relational database according to the mark includes:
  • the newly added data temporarily stored in the cache file is written into a corresponding section of the relational database.
  • the relational database is at least one of MySQL, Oracle and DB2.
  • 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 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 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.
  • 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.
  • the signature-based method for synchronizing the memory database and relational database of the power grid monitoring system can be applied to the application environment shown in FIG. 1 .
  • 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 is to write the newly added data with the tag into the cache file of the relational database.
  • the terminal 11 can be, but not limited to, various personal computers, notebook computers, smart phones, tablet computers and portable wearable devices
  • the server 12 can be realized by an independent server or a server cluster composed of multiple servers.
  • 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.
  • 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.
  • 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.
  • marking the newly added data may be an ID for adding data identification, so as to make it unique.
  • the initial new data is marked as "A001”
  • the subsequent new data received can be marked as "B002”
  • Storage sorting can be performed according to tags, making data storage more organized.
  • the memory database can use Redis (Remote Dictionary Server, remote dictionary service), SQLite (a light database), MongoDB (a database based on distributed file storage).
  • Redis Remote Dictionary Server, remote dictionary service
  • SQLite a light database
  • MongoDB a database based on distributed file storage
  • the new data carries identification information
  • 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.
  • 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.
  • 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.
  • 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).
  • 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
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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 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 write the newly added data with the mark into the cache file of the relational database.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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
  • 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.
  • 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.
  • the server 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.
  • 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.
  • 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.
  • 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.
  • the server 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.
  • 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.
  • a device for synchronizing a database relational database in a power grid monitoring system based on a signature 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.
  • 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.
  • 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.
  • 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.
  • the data storage module 63 is also used to delete newly added data in the cache file.
  • 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.
  • 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.
  • FIG. 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.
  • a computer device 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:
  • the memory database is at least one of Redis, SQLite, and MongoDB;
  • the relational database is at least one of MySQL, Oracle and DB2;
  • 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.
  • 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.
  • 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.
  • 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 memory database is at least one of Redis, SQLite, and MongoDB;
  • the relational database is at least one of MySQL, Oracle and DB2;
  • 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.
  • 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.
  • 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.
  • 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.
  • RAM can take many forms, such as Static Random Access Memory (SRAM) or Dynamic Random Access Memory (DRAM).

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Databases & Information Systems (AREA)
  • General Physics & Mathematics (AREA)
  • Physics & Mathematics (AREA)
  • Economics (AREA)
  • Human Resources & Organizations (AREA)
  • Health & Medical Sciences (AREA)
  • General Engineering & Computer Science (AREA)
  • Strategic Management (AREA)
  • Data Mining & Analysis (AREA)
  • General Business, Economics & Management (AREA)
  • Tourism & Hospitality (AREA)
  • Marketing (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Water Supply & Treatment (AREA)
  • Public Health (AREA)
  • General Health & Medical Sciences (AREA)
  • Primary Health Care (AREA)
  • Computing Systems (AREA)
  • Development Economics (AREA)
  • Educational Administration (AREA)
  • Computational Linguistics (AREA)
  • Game Theory and Decision Science (AREA)
  • Operations Research (AREA)
  • Quality & Reliability (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

L'invention concerne un procédé et un appareil destinés à synchroniser une base de données de mémoire et une base de données relationnelle d'un système de surveillance de réseau électrique basé sur des étiquettes de caractéristique, ainsi qu'un dispositif informatique et un support de stockage. Le procédé selon l'invention consiste : à inscrire de nouvelles données dans une zone de cache de données d'une base de données de mémoire et à étiqueter les nouvelles données (21) ; à inscrire les nouvelles données pourvues d'une étiquette dans un fichier de cache d'une base de données relationnelle selon une relation de mappage entre la zone de cache de données et le fichier de cache de la base de données relationnelle (22) ; et à inscrire, selon l'étiquette, les nouvelles données stockées temporairement dans le fichier de cache de la base de données relationnelle (23). Selon ce procédé, les nouvelles données sont étiquetées, et les nouvelles données stockées temporairement dans le fichier de cache sont inscrites dans la base de données relationnelle, de sorte à résoudre le problème selon lequel la base de données de mémoire doit synchroniser les données après un certain temps ; les données de système peuvent être synchronisées rapidement ; et l'efficacité de synchronisation de données entre la base de données de mémoire et la base de données relationnelle du système de surveillance de réseau électrique basé sur des étiquettes de caractéristique est améliorée.
PCT/CN2021/103157 2021-06-03 2021-06-29 Procédé de synchronisation de base de données de mémoire et de base de données relationnelle d'un système de surveillance de réseau électrique basé sur des étiquettes de caractéristique WO2022252322A1 (fr)

Priority Applications (1)

Application Number Priority Date Filing Date Title
DE112021007528.4T DE112021007528T5 (de) 2021-06-03 2021-06-29 Verfahren zur synchronisierung von speicherdatenbank undrelationaler datenbank eines auf merkmalskennzeichnungen basierenden stromnetzüberwachungssystems

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN202110621701.7A CN113360571A (zh) 2021-06-03 2021-06-03 基于特征标记的电网监控系统内存库关系库同步方法
CN202110621701.7 2021-06-03

Publications (1)

Publication Number Publication Date
WO2022252322A1 true WO2022252322A1 (fr) 2022-12-08

Family

ID=77531997

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/CN2021/103157 WO2022252322A1 (fr) 2021-06-03 2021-06-29 Procédé de synchronisation de base de données de mémoire et de base de données relationnelle d'un système de surveillance de réseau électrique basé sur des étiquettes de caractéristique

Country Status (3)

Country Link
CN (1) CN113360571A (fr)
DE (1) DE112021007528T5 (fr)
WO (1) WO2022252322A1 (fr)

Families Citing this family (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN115952204B (zh) * 2023-03-14 2023-05-16 中国西安卫星测控中心 一种缓存式SQLite读取方法

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107291869A (zh) * 2014-04-14 2017-10-24 五八同城信息技术有限公司 一种分布式服务系统数据查询的方法
CN108009282A (zh) * 2017-12-22 2018-05-08 武汉楚鼎信息技术有限公司 一种json数据同步到关系型数据库的方法及系统装置
CN109597568A (zh) * 2018-09-18 2019-04-09 天津字节跳动科技有限公司 一种数据存储方法、装置、终端设备及存储介质
CN111984728A (zh) * 2020-08-14 2020-11-24 北京人大金仓信息技术股份有限公司 异构数据库数据同步方法、装置、介质和电子设备

Family Cites Families (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101876996A (zh) * 2009-12-01 2010-11-03 广州从兴电子开发有限公司 一种内存数据库到文件数据库的数据同步方法及系统
CN110109927A (zh) * 2019-04-25 2019-08-09 上海新炬网络技术有限公司 基于LSM树的Oracle数据库数据处理方法

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107291869A (zh) * 2014-04-14 2017-10-24 五八同城信息技术有限公司 一种分布式服务系统数据查询的方法
CN108009282A (zh) * 2017-12-22 2018-05-08 武汉楚鼎信息技术有限公司 一种json数据同步到关系型数据库的方法及系统装置
CN109597568A (zh) * 2018-09-18 2019-04-09 天津字节跳动科技有限公司 一种数据存储方法、装置、终端设备及存储介质
CN111984728A (zh) * 2020-08-14 2020-11-24 北京人大金仓信息技术股份有限公司 异构数据库数据同步方法、装置、介质和电子设备

Also Published As

Publication number Publication date
DE112021007528T5 (de) 2024-02-15
CN113360571A (zh) 2021-09-07

Similar Documents

Publication Publication Date Title
US11182404B2 (en) Data replication technique in database management system
WO2022126974A1 (fr) Procédé et appareil de synchronisation de données incrémentales par kafka, dispositif et support
WO2019085471A1 (fr) Procédé de synchronisation de bases de données, serveur d'applications, et support de stockage lisible par ordinateur
US10564880B2 (en) Data deduplication method and apparatus
US9697247B2 (en) Tiered data storage architecture
US20200364185A1 (en) Method for data replication in a data analysis system
US10838827B2 (en) System and method for time parameter based database restoration
US11314719B2 (en) Method for implementing change data capture in database management system
CN101184106A (zh) 一种移动数据库的关联事务处理方法
WO2020140622A1 (fr) Système de stockage distribué, dispositif de nœud de stockage, et procédé de suppression de copie de données
US11176110B2 (en) Data updating method and device for a distributed database system
CN103595797B (zh) 一种分布式存储系统中的缓存方法
CN106874281B (zh) 实现数据库读写分离的方法和装置
US9152683B2 (en) Database-transparent near online archiving and retrieval of data
WO2020093501A1 (fr) Procédé de stockage et procédé de suppression de fichiers, serveur et support d'informations
CN102591864B (zh) 比对系统中的数据更新方法及装置
US20200019474A1 (en) Consistency recovery method for seamless database duplication
WO2022095366A1 (fr) Procédé et appareil de lecture de données basés sur redis, dispositif, et support d'enregistrement lisible
US11544229B1 (en) Enhanced tracking of data flows
CN113806301A (zh) 数据同步方法、装置、服务器及存储介质
JP2022543306A (ja) ブロックチェーンデータ処理の方法、装置、機器及び可読記憶媒体
US20170060922A1 (en) Method and device for data search
US10241716B2 (en) Global occupancy aggregator for global garbage collection scheduling
CN104281673A (zh) 一种数据库的缓存构建系统及对应的构建方法
WO2022252322A1 (fr) Procédé de synchronisation de base de données de mémoire et de base de données relationnelle d'un système de surveillance de réseau électrique basé sur des étiquettes de caractéristique

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 21943679

Country of ref document: EP

Kind code of ref document: A1

WWE Wipo information: entry into national phase

Ref document number: 112021007528

Country of ref document: DE