CN112905691A - Information synchronization method and device - Google Patents
Information synchronization method and device Download PDFInfo
- Publication number
- CN112905691A CN112905691A CN201911133469.1A CN201911133469A CN112905691A CN 112905691 A CN112905691 A CN 112905691A CN 201911133469 A CN201911133469 A CN 201911133469A CN 112905691 A CN112905691 A CN 112905691A
- Authority
- CN
- China
- Prior art keywords
- information
- database
- difference function
- function data
- synchronization
- Prior art date
- Legal status (The legal status 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 status listed.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 48
- 230000006870 function Effects 0.000 claims description 91
- 238000012545 processing Methods 0.000 claims description 16
- 238000004590 computer program Methods 0.000 claims description 13
- 238000012795 verification Methods 0.000 claims description 12
- 230000001360 synchronised effect Effects 0.000 abstract description 17
- 239000000047 product Substances 0.000 description 21
- 238000010586 diagram Methods 0.000 description 20
- 238000013461 design Methods 0.000 description 4
- 238000004519 manufacturing process Methods 0.000 description 4
- 230000008569 process Effects 0.000 description 4
- 238000011161 development Methods 0.000 description 3
- 230000004048 modification Effects 0.000 description 3
- 238000012986 modification Methods 0.000 description 3
- 238000010200 validation analysis Methods 0.000 description 3
- 238000005516 engineering process Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000000903 blocking effect Effects 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 238000012544 monitoring process Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000009467 reduction Effects 0.000 description 1
- 230000008521 reorganization Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 239000013589 supplement Substances 0.000 description 1
- 230000001502 supplementing effect Effects 0.000 description 1
Images
Classifications
-
- 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
-
- 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/23—Updating
- G06F16/2308—Concurrency control
- G06F16/2336—Pessimistic concurrency control approaches, e.g. locking or multiple versions without time stamps
- G06F16/2343—Locking methods, e.g. distributed locking or locking implementation details
-
- 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/23—Updating
- G06F16/2365—Ensuring data consistency and integrity
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computing Systems (AREA)
- Computer Security & Cryptography (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides an information synchronization method and a device, wherein the method comprises the following steps: acquiring first information and second information according to preset time; the first information is generated according to the second information; the first information is stored in a first database; the second information is stored in a second database; comparing the first information with the second information to obtain difference function data; the first information includes difference function data and the second information does not include difference function data; the difference function data is synchronized to the second database. The method and the device can automatically compare the related information in different databases to realize the automatic synchronization of the difference function data from the first database to the second database, relieve the complexity and the error susceptibility of manual operation and improve the efficiency and the accuracy of data synchronization.
Description
Technical Field
The present invention relates to the field of communications technologies, and in particular, to an information synchronization method and apparatus.
Background
A DBA (Database Administrator) system, which is responsible for overall management and control of a Database system, and the specific responsibilities include: determining the data content and structure stored in the database; determining a storage structure and an access strategy of the database; defining security requirements and integrity constraints for the data; monitoring the use and operation of the database; improvement and reorganization of databases. The DBA system may be used to manage and control multiple databases. According to business requirements, sometimes data in a database needs to be synchronized, and because the structures of tables stored in the database are numerous, synchronization operations among databases performed manually face higher complexity and higher error susceptibility.
Disclosure of Invention
The invention provides an information synchronization method and device, which can automatically compare and synchronize information among databases and relieve the complexity and the error easiness of manual operation.
In a first aspect, an embodiment of the present invention provides an information synchronization method, where the method includes: acquiring first information and second information according to preset time; the first information is generated according to the second information; the first information is stored in a first database; the second information is stored in a second database; comparing the first information with the second information to obtain difference function data; the difference function data is included in the first information and the difference function data is not included in the second information; synchronizing the difference function data to the second database.
In a second aspect, an embodiment of the present invention further provides an information synchronization apparatus, where the apparatus includes: the acquisition module is used for acquiring the first information and the second information according to preset time; the first information is generated according to the second information; the first information is stored in a first database; the second information is stored in a second database; the comparison module is used for comparing the first information with the second information to obtain difference function data; the difference function data is included in the first information and the difference function data is not included in the second information; a synchronization module for synchronizing the difference function data to the second database.
In a third aspect, an embodiment of the present invention further provides a computer device, including a memory and a processor, where the memory stores a computer program operable on the processor, and the processor implements the information synchronization method when executing the computer program.
In a fourth aspect, the present invention further provides a computer-readable medium having a non-volatile program code executable by a processor, where the program code causes the processor to execute the above information synchronization method.
The embodiment of the invention has the following beneficial effects: the embodiment of the invention provides an information synchronization scheme, which is characterized in that first information in a first database and second information in a second database are obtained according to preset time, the first information is generated according to the second information, then the first information is compared with the second information, content which is included in the first information but not included in the second information is used as difference function data, and finally the difference function data are synchronized to the second database so as to enrich information in the second database. The embodiment of the invention can automatically compare the related information in different databases to realize the automatic synchronization of the difference function data from the first database to the second database, thereby relieving the complexity and the error of manual operation and improving the efficiency and the accuracy of data synchronization.
Additional features and advantages of the invention will be set forth in the description which follows, and in part will be obvious from the description, or may be learned by practice of the invention. The objectives and other advantages of the invention will be realized and attained by the structure particularly pointed out in the written description and claims hereof as well as the appended drawings.
In order to make the aforementioned and other objects, features and advantages of the present invention comprehensible, preferred embodiments accompanied with figures are described in detail below.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and other drawings can be obtained by those skilled in the art without creative efforts.
Fig. 1 is a flowchart of an information synchronization method according to an embodiment of the present invention;
fig. 2 is a schematic diagram illustrating an implementation of an information synchronization method according to an embodiment of the present invention;
fig. 3 is a block diagram of an information synchronization apparatus according to an embodiment of the present invention;
FIG. 4 is a block diagram of another information synchronization apparatus according to an embodiment of the present invention;
fig. 5 is a block diagram of a computer device according to an embodiment of the present invention.
Detailed Description
To make the objects, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions of the present invention will be clearly and completely described below with reference to the accompanying drawings, and it is apparent that the described embodiments are some, but not all embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
At present, with the increase of the number of users and the increase of personalized function requirements of the users, different structures and data can be obtained for data stored in a database for realizing a certain function after modification or supplement, and common functions may exist in the same industry or different industries, so that different project functions can be obtained according to the same product function, and the project functions are obtained by supplementing, deleting or modifying on the basis of the product functions so as to meet various personalized requirements of the users. If the related data of the developed product functions can be reused, the design and development time of new functions can be greatly saved, and the production efficiency is improved.
Based on this, the information synchronization method and apparatus provided in the embodiments of the present invention can improve the reusability of the product function database structure, save design and development time, improve production efficiency, and can also solve the problem of synchronization between a distributed product and a multi-item database.
For the convenience of understanding the embodiment, a detailed description will be given to an information synchronization method disclosed in the embodiment of the present invention.
An embodiment of the present invention provides an information synchronization method, referring to a flow chart of the information synchronization method shown in fig. 1, the method includes the following steps:
and step S102, acquiring the first information and the second information according to preset time.
In an embodiment of the invention, the first information is stored in a first database; the second information is stored in a second database. The second information can be processed by one or more of deleting, adding and modifying to generate a plurality of kinds of first information, and each kind of first information can be stored in different first databases. The second information of different kinds may be stored in different second databases. According to scanning at a preset time, a first database, first information in the first database and second information in a corresponding second database can be obtained.
It should be noted that, in order to implement a certain service function, the second information may be a general version, that is, the second database may open access rights to multiple users, and the first information is a customized version generated based on the second information, and may open access rights of the first database only to specified users.
It should be further noted that the second information may include a table structure, a field included in the table structure, data included in the field, and other information, and one or more service functions may be implemented through a combination of the table structure, the field, the data, and other information. For example, the first information is generated according to the second information, if the second information includes table 1, where table 1 includes field a, field b, and field c, and field a includes functional data d, functional data e, and functional data f, the first information obtained by field addition and functional data reduction may include table 1, where table 1 includes field a, field b, field c, and field d, and field a includes functional data d and functional data e; the other type of first information obtained through the modification of the functional data may include table 1, where table 1 includes field a, field b, and field c, and field a includes functional data d, functional data e, and functional data h. The second information can be processed according to actual requirements to obtain different first information.
In addition, for multiple types of first information corresponding to the same second information, the multiple types of first information may be stored in a distributed manner, and different times may be set to scan different types of first information.
And step S104, comparing the first information with the second information to obtain difference function data.
In the embodiment of the present invention, the functional data is a part of the first information or the second information, and the functional data may be one or a combination of any several of a table structure, a field, or data. By contrast, if the first information includes some function data and the second information does not include the function data, the function data may be used as difference function data.
It should be noted that comparing includes comparing the table structure with the data. For example, the data comparison may be performed by comparing the first information with the second information, where the second information includes table 1, table 1 includes field a, field b, and field c, field a includes function data d, function data e, and function data f, the first information includes table 1, table 1 includes field a, field b, field c, and field d, and field a includes function data d and function data e, and the obtained difference function data is: a field d. However, the functional data f is not present in the first information because it is present in the second information, and cannot be regarded as difference functional data.
And step S106, synchronizing the difference function data to a second database.
In the embodiment of the present invention, if there is a difference after comparison, the difference is automatically synchronized. Synchronization includes synchronizing the table structure and data of the database into the database. And copying and sending the difference function data to a second database, and establishing a table in the second database to realize the synchronization of the table structure when the table structure included in the difference function data is synchronously operated. The second database may be tabulated using SQL (Structured Query Language).
It should be noted that, in the embodiment of the present invention, for a plurality of pieces of first information corresponding to the same second information, parallel comparison may be performed to improve comparison efficiency, but synchronization needs to be performed one by one to ensure accuracy of a synchronization result.
In addition, after the data in the first database is synchronized to the second database, the user can conveniently access the second database to obtain the synchronized information, and after multiple times of synchronization, the second database comprises multiple kinds of first information in different first databases, so that the user can combine and use the multiple kinds of first information in the second database, further realize the multiplexing of the data, and save the design and development time.
The embodiment of the invention provides an information synchronization scheme, which is characterized in that first information in a first database and second information in a second database are obtained according to preset time, the first information is generated according to the second information, then the first information is compared with the second information, content which is included in the first information but not included in the second information is used as difference function data, and finally the difference function data are synchronized to the second database so as to enrich information in the second database. The embodiment of the invention can automatically compare the related information in different databases to realize the automatic synchronization of the difference function data from the first database to the second database, thereby relieving the complexity and the error of manual operation and improving the efficiency and the accuracy of data synchronization.
In order to improve the data processing efficiency of the comparison operation, before the first information and the second information are compared to obtain the difference function data, the following steps may be further performed:
the first information and the second information are loaded to a Remote Dictionary service (Redis) database.
In the embodiment of the invention, the first information and the second information to be compared are loaded into the Redis database, so that data comparison is carried out in the Redis database, and the pressure of a DB (database) database of the DBA system is reduced.
In order to further improve the accuracy of data synchronization, after the first information and the second information are compared to obtain difference function data, the following operations may be further performed:
locking the first information; judging whether the second information is locked; and if not, locking the second information.
In the embodiment of the invention, the first information is locked, so that the loading authority of the first information can be managed. After a certain execution engine acquires a certain first message, the first message is locked, and then the next execution engine can not acquire the first message any more. Similarly, details regarding the content of locking the second information are not repeated.
It should be noted that a lock is a mutually exclusive mechanism, and implements forced control over resources in a multi-thread environment to help implement concurrent control. And locking operation, so that a plurality of threads cannot be executed simultaneously, and when a certain thread is in a running state, other threads are in ready or blocking states.
In addition, in the embodiment of the present invention, if the second information is in an unlocked state, the second information is locked. If the second information is in the operation of synchronizing with other first information, it is indicated that the second information is in the locked state, and the second information needs to be locked after the second information is unlocked (i.e. synchronization of other first information and the second information is completed).
After the synchronization of the first information and the second information is completed, in order to facilitate the synchronization operation of other first information and second information, the method may further perform the following steps:
carrying out unlocking processing on the first information; and unlocking the second information.
In the embodiment of the invention, after the table structure and the data synchronization in the second database are completed, explanation processing operation is started. The unlocking processing can remove the loading authority limit of the first information and the second information, facilitate other processing of the first information, facilitate loading of the second information by other first information, and synchronize with the second information.
Considering that the first information and the second information are loaded into the Redis database for processing, the related information of the processing result is still stored in the Redis database, and in order to facilitate the user to obtain the difference function data, the synchronizing of the difference function data to the second database can be performed according to the following steps:
the difference function data is synchronized from the Redis database to the second database.
In the embodiment of the invention, the difference function data is copied and sent to the second database, and if a table structure exists in the difference function data, a table needs to be built in the second database, so that the synchronized information in the second database can realize the function which can be realized by the information in the first database.
In order to improve the correctness of the synchronized information, after the difference function data is synchronized to the second database, the following steps can be further executed:
comparing the first database with a second database after synchronizing the difference function database to obtain a verification result; the verification result is used for verifying the correctness of database synchronization.
In the embodiment of the present invention, the second database after synchronizing the difference function database should include all information in the first data, so as to implement all functions that can be implemented by the first information in the first database, and if it is found, according to the verification result obtained after the comparison, that the second database after synchronizing the difference function database does not include all information in the first data, it is not possible to implement all functions that can be implemented by the first information in the first database, and it is proved that data synchronization has a problem and needs to be paid attention.
In order to improve the efficiency of data processing in each step, before comparing the first information with the second information and obtaining the difference function data, the following steps may be further performed:
generating a plurality of micro services; the plurality of microservices includes at least: one or more of distributed timing microservice, contrast service microservice, plan synchronization microservice and verification microservice; registering various micro services through a registration center; and executing the information synchronization method according to the registered multiple microservices.
In the embodiment of the present invention, the micro service is a small service composed of a single Application, and has its own process and lightweight processing, and the service is deployed in a fully automatic manner according to a business function design, and communicates with other services using an HTTP API (Application Programming Interface). Meanwhile, the service uses a minimum scale centralized management (such as Docker) technology, the service can use different programming languages and databases, and the like. The microservices may be deployed on different servers or on different containers of the same server.
The micro-services are registered in the registration center, information such as addresses of the services can be obtained, and the registered micro-services can be mutually called.
Different kinds of micro-services can achieve different functions, for example, the distributed timing micro-service can be used for acquiring first information in a first database and second information in a second database according to preset time; the contrast service microservice can be used for contrasting the first information and the second information to obtain difference function data; the plan synchronization microservice may be used to synchronize the differential function data to a second database; the validation microservice may be used to compare the first database with a second database after synchronizing the difference function database to obtain a validation result.
Referring to the schematic diagram of the information synchronization method shown in fig. 2, the method will be described with reference to a specific embodiment.
(1) Distributed timing, contrast service, plan synchronization, verification and other micro services register services through the registration center and call each other.
(2) And scanning information such as a certain item table, a field and data in the DB management database at regular time, loading the information into the memory database Redis and locking the item.
(3) And checking whether the product corresponding to the item is locked or not, if not, immediately locking the product, and if so, waiting for the product to be unlocked.
(4) After the product is unlocked, information such as tables, fields and data of the items is compared with information related to the product, and redundant tables, fields and data in the items are merged into the information related to the product which is added to Redis.
(5) And after the plan synchronization micro-service receives the merging completion notification, the micro-service synchronizes relevant information to the product management database.
(6) After the table, the field and the data are synchronized into the database, the micro service executes to generate SQL and synchronizes to the product database.
(7) The validation microservice checks the database synchronization correctness by comparing the product database to the project database.
The embodiment of the invention provides an information synchronization method and device, the method can regularly scan information such as various project tables and fields, service data and the like in first information through micro-service and compare the information with tables and fields and the like in second information, and the information is regularly synchronized to a product database according to redundant project tables, fields, data and the like after comparison. The specified product library is not deleted, but only newly added. The method can be used for solving the problem of automatic comparison and synchronization in the management of multiple projects (customized versions for a certain user based on the universal versions) of the same product (universal version), the project functions are synchronized to the product functions by combing version information, the existing functions in the project are not required to be re-developed by workers, the data of the existing project functions can be obtained from the second database where the product function data are located, and the production efficiency is improved; the problems that the table structures of multiple items of the same product are various and complex, the complexity of manual comparison and the error are easy to achieve, the items are automatically synchronized to the product and are synchronized to other items can be solved, and the efficiency and the accuracy of data synchronization are improved.
An embodiment of the present invention further provides an information synchronization apparatus, referring to a structural block diagram of the information synchronization apparatus shown in fig. 3, where the apparatus includes:
an obtaining module 71, configured to obtain the first information and the second information according to a preset time; the first information is generated according to the second information; the first information is stored in a first database; the second information is stored in a second database; a comparison module 72, configured to compare the first information with the second information to obtain difference function data; the first information includes difference function data and the second information does not include difference function data; a synchronization module 73 for synchronizing the difference function data to the second database.
In one embodiment, referring to another block diagram of the information synchronization apparatus shown in fig. 4, the apparatus includes: the device also includes: and a loading module 74, configured to load the first information and the second information into a Redis database.
In one embodiment, referring to another block diagram of the information synchronization apparatus shown in fig. 4, the apparatus includes: the device also includes: a locking module 75, configured to perform locking processing on the first information; judging whether the second information is locked; and if not, locking the second information.
In one embodiment, referring to another block diagram of the information synchronization apparatus shown in fig. 4, the apparatus includes: the device also includes: an unlocking module 76 for: carrying out unlocking processing on the first information; and unlocking the second information.
In one embodiment, the synchronization module is further configured to: the difference function data is synchronized from the Redis database to the second database.
In one embodiment, referring to another block diagram of the information synchronization apparatus shown in fig. 4, the apparatus includes: the device also includes: a verification module 77 for: comparing the first database with a second database after synchronizing the difference function database to obtain a verification result; the verification result is used for verifying the correctness of database synchronization.
In one embodiment, referring to another block diagram of the information synchronization apparatus shown in fig. 4, the apparatus includes: the device also includes: a microservice module 78 for: generating a plurality of micro services; the plurality of microservices includes at least: one or more of distributed timing microservice, contrast service microservice, plan synchronization microservice and verification microservice; registering various micro services through a registration center; and executing the information synchronization method according to the registered multiple microservices.
The embodiment of the present invention further provides a computer device, referring to the schematic block diagram of the structure of the computer device shown in fig. 5, the computer device includes a memory 81 and a processor 82, the memory stores a computer program that can be executed on the processor, and the processor implements the steps of any one of the methods when executing the computer program.
It is clearly understood by those skilled in the art that, for convenience and brevity of description, the specific working process of the computer device described above may refer to the corresponding process in the foregoing method embodiments, and no further description is provided herein
Embodiments of the present invention also provide a computer readable medium having non-volatile program code executable by a processor, the program code causing the processor to perform any of the steps of the above-described method.
As will be appreciated by one skilled in the art, embodiments of the present invention may be provided as a method, system, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present invention is described with reference to flowchart illustrations and/or block diagrams of methods and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
Finally, it should be noted that: the above-mentioned embodiments are only specific embodiments of the present invention, which are used for illustrating the technical solutions of the present invention and not for limiting the same, and the protection scope of the present invention is not limited thereto, although the present invention is described in detail with reference to the foregoing embodiments, those skilled in the art should understand that: any person skilled in the art can modify or easily conceive the technical solutions described in the foregoing embodiments or equivalent substitutes for some technical features within the technical scope of the present disclosure; such modifications, changes or substitutions do not depart from the spirit and scope of the embodiments of the present invention, and they should be construed as being included therein. Therefore, the protection scope of the present invention shall be subject to the protection scope of the claims.
Claims (10)
1. An information synchronization method, comprising:
acquiring first information and second information according to preset time; the first information is generated according to the second information; the first information is stored in a first database; the second information is stored in a second database;
comparing the first information with the second information to obtain difference function data; the difference function data is included in the first information and the difference function data is not included in the second information;
synchronizing the difference function data to the second database.
2. The information synchronization method according to claim 1, wherein before comparing the first information with the second information to obtain difference function data, the method further comprises:
and loading the first information and the second information to a Redis database.
3. The information synchronization method according to claim 2, wherein after comparing the first information with the second information to obtain difference function data, the method further comprises:
locking the first information;
judging whether the second information is locked or not;
and if not, locking the second information.
4. The information synchronization method of claim 3, wherein after synchronizing the difference function data to the second database, further comprising:
carrying out unlocking processing on the first information;
and unlocking the second information.
5. The information synchronization method of claim 2, wherein synchronizing the difference function data to the second database comprises:
synchronizing the difference function data from the Redis database to the second database.
6. The information synchronization method according to any one of claims 1 to 5, wherein after synchronizing the difference function data to the second database, further comprising:
comparing the first database with a second database after synchronizing the difference function database to obtain a verification result; and the verification result is used for verifying the correctness of database synchronization.
7. The information synchronization method according to claim 6, wherein before comparing the first information with the second information to obtain difference function data, the method further comprises:
generating a plurality of micro services; the plurality of microservices includes at least: one or more of distributed timing microservice, contrast service microservice, plan synchronization microservice and verification microservice;
registering the multiple micro services through a registration center;
and executing the information synchronization method according to the registered multiple micro services.
8. An information synchronization apparatus, comprising:
the acquisition module is used for acquiring the first information and the second information according to preset time; the first information is generated according to the second information; the first information is stored in a first database; the second information is stored in a second database;
the comparison module is used for comparing the first information with the second information to obtain difference function data; the difference function data is included in the first information and the difference function data is not included in the second information;
a synchronization module for synchronizing the difference function data to the second database.
9. A computer device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the steps of the method of any one of claims 1 to 7 when executing the computer program.
10. A computer-readable medium having non-volatile program code executable by a processor, the program code causing the processor to perform the method of any of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911133469.1A CN112905691B (en) | 2019-11-19 | 2019-11-19 | Information synchronization method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911133469.1A CN112905691B (en) | 2019-11-19 | 2019-11-19 | Information synchronization method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112905691A true CN112905691A (en) | 2021-06-04 |
| CN112905691B CN112905691B (en) | 2024-05-14 |
Family
ID=76103421
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911133469.1A Active CN112905691B (en) | 2019-11-19 | 2019-11-19 | Information synchronization method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112905691B (en) |
Citations (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20090307277A1 (en) * | 2008-06-04 | 2009-12-10 | Microsoft Corporation | Generation of database deltas and restoration |
| JP2011221594A (en) * | 2010-04-05 | 2011-11-04 | Yahoo Japan Corp | System and method for multiplexing database |
| CN102867066A (en) * | 2012-09-28 | 2013-01-09 | 用友软件股份有限公司 | Data summarization device and data summarization method |
| CN103914307A (en) * | 2014-04-22 | 2014-07-09 | 浪潮电子信息产业股份有限公司 | Interactive-interface fast implementation method based on reusable library |
| CN104809202A (en) * | 2015-04-24 | 2015-07-29 | 联动优势科技有限公司 | Database synchronization method and device |
| US20150242478A1 (en) * | 2014-02-21 | 2015-08-27 | Solidfire, Inc. | Data syncing in a distributed system |
| WO2016045285A1 (en) * | 2014-09-25 | 2016-03-31 | 中兴通讯股份有限公司 | Data synchronization method, device, and system for database |
| CN107423303A (en) * | 2016-05-24 | 2017-12-01 | 北京京东尚科信息技术有限公司 | The method and system of data syn-chronization |
| CN107688618A (en) * | 2017-08-08 | 2018-02-13 | 平安科技（深圳）有限公司 | Data comparison method, apparatus, computer equipment and storage medium |
| CN109408528A (en) * | 2018-10-25 | 2019-03-01 | 北京信安世纪科技股份有限公司 | A kind of database script generation method, device, computing device and storage medium |
| CN109634670A (en) * | 2018-11-20 | 2019-04-16 | 深圳市优博讯科技股份有限公司 | A kind of PDA quickly configuration method and device based on USB OTG |
| CN109800272A (en) * | 2019-02-25 | 2019-05-24 | 广州虎牙信息科技有限公司 | Data cached synchronous method, server, application system and storage device |
| CN109885581A (en) * | 2019-03-14 | 2019-06-14 | 苏州达家迎信息技术有限公司 | Synchronous method, device, equipment and the storage medium of database |
| CN110209735A (en) * | 2019-05-05 | 2019-09-06 | 深圳市腾讯计算机系统有限公司 | Database backup method, calculates equipment and storage medium at DB Backup device |
-
2019
- 2019-11-19 CN CN201911133469.1A patent/CN112905691B/en active Active
Patent Citations (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20090307277A1 (en) * | 2008-06-04 | 2009-12-10 | Microsoft Corporation | Generation of database deltas and restoration |
| JP2011221594A (en) * | 2010-04-05 | 2011-11-04 | Yahoo Japan Corp | System and method for multiplexing database |
| CN102867066A (en) * | 2012-09-28 | 2013-01-09 | 用友软件股份有限公司 | Data summarization device and data summarization method |
| US20150242478A1 (en) * | 2014-02-21 | 2015-08-27 | Solidfire, Inc. | Data syncing in a distributed system |
| CN103914307A (en) * | 2014-04-22 | 2014-07-09 | 浪潮电子信息产业股份有限公司 | Interactive-interface fast implementation method based on reusable library |
| WO2016045285A1 (en) * | 2014-09-25 | 2016-03-31 | 中兴通讯股份有限公司 | Data synchronization method, device, and system for database |
| CN104809202A (en) * | 2015-04-24 | 2015-07-29 | 联动优势科技有限公司 | Database synchronization method and device |
| CN107423303A (en) * | 2016-05-24 | 2017-12-01 | 北京京东尚科信息技术有限公司 | The method and system of data syn-chronization |
| CN107688618A (en) * | 2017-08-08 | 2018-02-13 | 平安科技（深圳）有限公司 | Data comparison method, apparatus, computer equipment and storage medium |
| CN109408528A (en) * | 2018-10-25 | 2019-03-01 | 北京信安世纪科技股份有限公司 | A kind of database script generation method, device, computing device and storage medium |
| CN109634670A (en) * | 2018-11-20 | 2019-04-16 | 深圳市优博讯科技股份有限公司 | A kind of PDA quickly configuration method and device based on USB OTG |
| CN109800272A (en) * | 2019-02-25 | 2019-05-24 | 广州虎牙信息科技有限公司 | Data cached synchronous method, server, application system and storage device |
| CN109885581A (en) * | 2019-03-14 | 2019-06-14 | 苏州达家迎信息技术有限公司 | Synchronous method, device, equipment and the storage medium of database |
| CN110209735A (en) * | 2019-05-05 | 2019-09-06 | 深圳市腾讯计算机系统有限公司 | Database backup method, calculates equipment and storage medium at DB Backup device |
Non-Patent Citations (1)
| Title |
|---|
| 黄新 等: "基于Delphi开发的应用系统数据通用迁移", 电脑与电信, no. 08, 10 August 2016 (2016-08-10), pages 61 - 63 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112905691B (en) | 2024-05-14 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Nathan et al. | Blockchain meets database: Design and implementation of a blockchain relational database | |
| US20140006459A1 (en) | Rule-based automated test data generation | |
| US11698915B1 (en) | Cloud platform based architecture for continuous deployment and execution of modular data pipelines | |
| US8589346B2 (en) | Techniques for combining statement level, procedural, and row level replication | |
| CA2648210C (en) | System and method for automating etl applications | |
| US8689179B2 (en) | Transportable refactoring object | |
| JP7438603B2 (en) | Transaction processing methods, apparatus, computer devices and computer programs | |
| EP4029191B1 (en) | Supporting blockchain collections in a database | |
| US11573974B2 (en) | System and method for automatic correction/rejection in an analysis applications environment | |
| US20210191845A1 (en) | Unit testing of components of dataflow graphs | |
| CN112930528A (en) | Upgrading a database from a first version to a second version | |
| US11762654B2 (en) | Processing framework for in-system programming in a containerized environment | |
| US9395979B1 (en) | Pre-emptive development conflict resolution | |
| CN109408591B (en) | Decision-making distributed database system supporting SQL (structured query language) driven AI (Artificial Intelligence) and feature engineering | |
| US20230098963A1 (en) | Object processing method and apparatus, computer device, and storage medium | |
| CN113792026B (en) | Method and device for deploying database script and computer-readable storage medium | |
| CN112015463B (en) | Configuration version management device and working method thereof | |
| CN111444199A (en) | Data processing method and device, storage medium and processor | |
| US20110023010A1 (en) | Reserved component container-based software development method and apparatus | |
| CN112905691A (en) | Information synchronization method and device | |
| US20230179541A1 (en) | Configuration management of cloud resources for multiple providers and frameworks | |
| CN115080663A (en) | Distributed database synchronization method, system, device and medium | |
| CN111367892A (en) | Data migration method and device | |
| US20230306126A1 (en) | Limiting cloud permissions in deployment pipelines | |
| CN115879098B (en) | Android application installation optimization method based on atomic transaction operation |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |