CN111984662A - Method and device for updating database in batch - Google Patents
Method and device for updating database in batch Download PDFInfo
- Publication number
- CN111984662A CN111984662A CN202010842356.5A CN202010842356A CN111984662A CN 111984662 A CN111984662 A CN 111984662A CN 202010842356 A CN202010842356 A CN 202010842356A CN 111984662 A CN111984662 A CN 111984662A
- Authority
- CN
- China
- Prior art keywords
- cache information
- database
- updating
- pieces
- same data
- 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 51
- 238000004590 computer program Methods 0.000 claims description 16
- 238000003860 storage Methods 0.000 claims description 9
- 230000003993 interaction Effects 0.000 abstract description 15
- 238000010586 diagram Methods 0.000 description 28
- 230000008569 process Effects 0.000 description 9
- 230000006870 function Effects 0.000 description 4
- 238000010923 batch production Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000013507 mapping Methods 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000000246 remedial effect Effects 0.000 description 1
- 238000012163 sequencing technique Methods 0.000 description 1
- 238000006467 substitution reaction Methods 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/23—Updating
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a method and a device for updating databases in batches, which relate to the technical field of computers, and the method comprises the following steps: acquiring a plurality of pieces of cache information; each piece of cache information comprises an identification serial number; the plurality of pieces of cache information belong to the same data group in the database; determining an updating mode of the cache information according to the identification sequence number; and updating the same data group in the database according to a plurality of pieces of cache information and an updating mode. After the updating mode of the plurality of pieces of cache information to be updated in batch is determined, the method and the device perform information interaction with the database at one time, update the same data group in the database, reduce the interaction times with the database in batch processing, and improve the efficiency of batch processing.
Description
Technical Field
The invention relates to the technical field of computers, in particular to a method and a device for updating databases in batches.
Background
The database updating operation refers to SQL operation for updating database table data, and includes adding, modifying and deleting. Updating the database in batches: it is an operation to submit multiple updated databases at a time to the database, including add processed, modify processed, and delete processed SQL statements. In batch processing, business logic processing is performed on transactions one by one, and the processing of each transaction generally involves one or more update operations on a database, and because many transactions are processed, many interactions with the database exist, and each interaction with the database consumes time, so that batch processing efficiency is low.
Disclosure of Invention
The invention provides a method and a device for updating databases in batches, which can reduce the number of times of interaction with the databases and improve the efficiency of updating the databases in batches.
In a first aspect, an embodiment of the present invention provides a method for updating databases in batches, where the method includes: acquiring a plurality of pieces of cache information; each piece of cache information comprises an identification serial number; the cache information belongs to the same data group in the database; determining the updating mode of the cache information according to the identification sequence number; and updating the same data group in the database according to the plurality of pieces of cache information and the updating mode.
In a second aspect, an embodiment of the present invention further provides an apparatus for updating a database in batch, where the apparatus includes: the acquisition module is used for acquiring a plurality of pieces of cache information; each piece of cache information comprises an identification serial number; the cache information belongs to the same data group in the database; the traversal module is used for determining the updating mode of the cache information according to the identification sequence number; and the updating module is used for updating the same data group in the database according to the plurality of pieces of cache information and the updating mode.
In a third aspect, an embodiment of the present invention further provides a computer device, which includes a memory, a processor, and a computer program stored in the memory and executable on the processor, where the processor implements the method for batch updating a database when executing the computer program.
In a fourth aspect, an embodiment of the present invention further provides a computer-readable storage medium, where a computer program for executing the method for updating a database in batches is stored in the computer-readable storage medium.
The embodiment of the invention has the following beneficial effects: the embodiment of the invention provides a scheme for updating databases in batches, which comprises the steps of firstly obtaining a plurality of pieces of cache information, wherein each piece of cache information comprises an identification serial number; and finally, updating the same data group in the database according to the plurality of cache information and the updating mode. After the updating mode of the plurality of pieces of cache information to be updated in batches is determined, the embodiment of the invention carries out information interaction with the database at one time, updates the same data group in the database, reduces the interaction times with the database in batch processing, and improves the efficiency of batch processing.
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 a method for batch updating a database according to an embodiment of the present invention;
FIG. 2 is a schematic diagram of a conventional batch process flow provided by an embodiment of the present invention;
FIG. 3 is a schematic diagram of a conventional single transaction processing flow according to an embodiment of the present invention;
FIG. 4 is a diagram illustrating database update execution steps provided by an embodiment of the present invention;
FIG. 5 is a schematic flow chart of batch processing according to an embodiment of the present invention;
FIG. 6 is a schematic diagram of a single transaction processing flow according to an embodiment of the present invention;
FIG. 7 is a diagram illustrating steps performed to update a database in batches according to an embodiment of the present invention;
fig. 8 is a schematic diagram illustrating a step of determining an update mode of cache information according to an embodiment of the present invention;
FIG. 9 is a flow chart illustrating a failed transaction process according to an embodiment of the present invention;
FIG. 10 is a block diagram of an apparatus for updating databases in batches according to an embodiment of the present invention;
FIG. 11 is a block diagram of an apparatus for batch updating a database according to an embodiment of the present invention;
fig. 12 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.
Referring to the conventional batch processing flow diagram shown in fig. 2, a transaction set to be processed includes multiple transactions requiring update processing, and in batch processing, business logic processing is performed on the transactions one by one, and processing of each transaction generally involves one or more update operations (insert, update, or delete) on a database, and an update SQL operation on the database may be completed by calling the following method of org. Object insert (String statementName, Object parameter Object); int update (String status name, final Object parameter Object); int delete (String status name, final Object parameter Object). Referring to the schematic flow chart of the conventional single transaction service processing shown in fig. 3, each single transaction txn service processing includes one or more database updating operations, and each database updating operation needs to communicate with and update the database, which is inefficient.
When batch processing is performed, there is no logical dependency between transactions. Therefore, the method can submit the updated SQL (Structured Query Language) of multiple transactions at one time without actually interacting with the database every time of updating, thereby reducing the interaction times with the database and improving the batch processing efficiency.
Based on this, referring to the schematic batch processing flow diagram shown in fig. 5, the method provided in the embodiment of the present invention includes steps of batch update submission and referring to the schematic single transaction service processing flow diagram shown in fig. 6, compared with fig. 2, the method cancels transaction management control and changes the original SQL operation into SQL operation caching operation. The method greatly reduces the interaction with the database by submitting the cache information in batch, thereby greatly improving the efficiency of batch processing.
For the convenience of understanding the embodiment, a detailed description will be given to a method for updating a database in batch according to the embodiment of the present invention.
An embodiment of the present invention provides a method for updating databases in batches, referring to a flowchart of a method for updating databases in batches shown in fig. 1, where the method includes the following steps:
step S102, acquiring a plurality of pieces of cache information.
In an embodiment of the present invention, the cache information includes data for updating the database. Each piece of cache information comprises an identification serial number, and the identification serial number can be used for sequencing the cache information and also can be used for uniquely identifying one piece of cache information. For example, for a certain service, multiple transactions are involved, the data involved in the service belongs to the same data group in the database, and the data involved in each transaction in the service may correspond to a piece of cache information, where the piece of cache information includes data that needs to be updated in the database.
And step S104, determining the updating mode of the cache information according to the identification sequence number.
In the embodiment of the present invention, referring to the step schematic diagram of determining the updating manner of the cache information shown in fig. 8, it may be determined, according to the identification number, what manner each cache information is to be updated in the database, where the updating manner includes adding (alert), deleting (delete), or modifying (update). And after the updating mode of the cache information is determined, submitting the cache information to a module interacting with the database in batches according to the identification serial number.
It should be noted that the submission component in fig. 8 is used for the SQL Map executor to execute SQL update with SQL parameters having target parameters, such as "SQL ID".
It should be noted that, this step needs to determine how the cache information is updated in the database, rather than performing the update, and when this step is performed, no data interaction with the database is performed.
In addition, the method can submit the batch update through an SQL Map executor sqlmapexexer of the ibatis framework. If the number of the cache information pieces is too large, the plurality of pieces of cache information can be submitted in batches according to the identification sequence numbers.
And step S106, updating the same data group in the database according to a plurality of pieces of cache information and an updating mode.
In the embodiment of the invention, after the updating mode is determined, the updating mode is interacted with the database, and each piece of cache information is updated in the database. For example, each transaction involved in a business is updated to complete the batch data update for that business. And updating each service in the database one by one to complete the updating of the whole database.
The embodiment of the invention provides a scheme for updating databases in batches, which comprises the steps of firstly obtaining a plurality of pieces of cache information, wherein each piece of cache information comprises an identification serial number; and finally, updating the same data group in the database according to the plurality of cache information and the updating mode. After the updating mode of the plurality of pieces of cache information to be updated in batches is determined, the embodiment of the invention carries out information interaction with the database at one time, updates the same data group in the database, reduces the interaction times with the database in batch processing, and improves the efficiency of batch processing.
In order to improve the data processing efficiency, before acquiring a plurality of pieces of cache information, the following steps may be further performed:
and generating a plurality of pieces of cache information corresponding to the same data group in the database.
In the embodiment of the present invention, generating multiple pieces of cache information corresponding to the same data group in the database, that is, a process of caching the updated SQL, may be implemented in the following manner:
modifying the original update DAO (Data Access Object) call of the application program into a call for caching the memory; or, the update SQL operation is executed in the modify ORM (Object Relational Mapping) framework as a call for caching to the memory, and the application DAO call writing is unchanged.
In the embodiment of the present invention, the pieces of cache information corresponding to the same data packet in the database may be as follows
The structures shown in table 1:
TABLE 1
The cache is a list, and each element is cache information of one transaction. Each piece of cache information comprises: transaction information txn objects, update SQL information lists. The update SQL information list is the SQL operation information of the transaction needing update operation, and each element of the list comprises an SQL ID and a parameter object for executing the SQL.
Considering that there may be a case of processing failure in batch updating, updating the same data group in the database according to the cache information and the updating manner may be performed according to the following steps:
if the error information is received, determining the identification serial number of the failed transaction according to the error information; grouping the plurality of pieces of cache information according to the identification serial numbers of the failed transactions to obtain grouping results; and updating the same data group in the database according to the identification serial number of the failed transaction and the grouping result.
In the embodiment of the present invention, in the process of performing data interaction with a database, if an error occurs, an error is reported, and an identification number of a failed transaction is determined according to error reporting information, see a schematic diagram of a failed transaction processing flow shown in fig. 9, if between a minimum identification number and a maximum identification number of batch update cache information, the identification number k is a failed transaction, the cache information is grouped, and the cache information from the minimum identification number to the identification number k is a first group, and the cache information from the identification number k +1 to the maximum identification number is a second group, and then the first group and the second group are respectively subjected to batch update processing, where the processing process may refer to the step in fig. 7, and in the diagram, the step of obtaining multiple pieces of cache information may be implemented by setting a batch flag to true through an SQL Map executor.
The cached information with the identification serial number k is processed separately, for example, since the kth transaction cannot update the database normally, information of the failed transaction needs to be recorded. The data can be recorded in a log file or a database table, such as a batch processing failure table. The number of strokes k may be recorded, as well as the transaction information txn. The failure information can be queried and analyzed, and subsequent business remedial measures and the like can be taken.
It should be noted that, when batch update is actually submitted to a Database, referring to the schematic diagram of the batch update Database execution step shown in fig. 7, the step of performing update by interacting with the Database may be implemented by invoking an SQL Map executor in an iBatis framework to execute batch update, and this process may throw exception due to partial SQL execution failure, and JDBC (Java Database Connectivity ) generally throws exception of java.sql.batchupdateexception.
In order to efficiently and accurately process the failed transaction, the identification number of the failed transaction is determined according to the error report information, and the method can be implemented according to the following steps:
recording the number of pieces of cache information of successful transaction; recording the number of the transacted cache information; and if the number of the transacted cache information is larger than that of the successfully transacted cache information, taking the number of the transacted cache information as the identification serial number of the failed transaction.
In an embodiment of the present invention, for example, in an embodiment, the getUpdateCounts () method of java.sql.batchupdateexception returns an int [ ] array representing the number of records updated by each successfully executed SQL, so the length of the array is the number of SQL strips successfully executed, for example, the value is n. Then the transaction records beginning at begin of the cache begin can be traversed, and the SQL number of the transaction is accumulated, and when the accumulated number m > n, the transaction is the record serial number k of the failure of submission.
It should be noted that, in the embodiment of the present invention, the database interaction is based on ibatis framework, and there may be different caching methods or structures and different batch update methods for using other ORM frameworks. But the failure handling mechanism of the batch update is the same.
The embodiment of the invention provides a method and a device for updating databases in batches, which refer to a schematic diagram of database updating execution steps shown in fig. 4, the method firstly updates an SQL cache, and caches SQL operations for updating the databases in a memory; and then, batch updating and submitting, and sending all cached SQL operations to the database for actual updating. The method caches each update SQL, then performs batch update on the database, and when the batch update fails, the database needs to be updated and submitted again in a segmented and batch mode. Because of the batch submission, the interaction with the database is greatly reduced, and the efficiency of batch processing is greatly improved.
The embodiment of the present invention further provides a device for updating a database in batch, as described in the following embodiments. Because the principle of solving the problems of the device is similar to the method for updating the database in batches, the implementation of the device can refer to the implementation of the method for updating the database in batches, and repeated parts are not described in detail. Referring to fig. 10, a block diagram of an apparatus for batch updating a database is shown, the apparatus including:
an obtaining module 71, configured to obtain multiple pieces of cache information; each piece of cache information comprises an identification serial number; the plurality of pieces of cache information belong to the same data group in the database; the traversal module 72 is configured to determine an update mode of the cache information according to the identification sequence number; and the updating module 73 is configured to update the same data group in the database according to the plurality of pieces of cache information and the updating manner.
In one embodiment, referring to the block diagram of the apparatus for batch updating a database shown in fig. 11, the apparatus further includes a database transaction module 74 for: and generating a plurality of pieces of cache information corresponding to the same data group in the database.
In one embodiment, the update module is specifically configured to: if the error information is received, determining the identification serial number of the failed transaction according to the error information; grouping the plurality of pieces of cache information according to the identification serial numbers of the failed transactions to obtain grouping results; and updating the same data group in the database according to the identification serial number of the failed transaction and the grouping result.
In one embodiment, the update module is specifically configured to: recording the number of pieces of cache information of successful transaction; recording the number of the transacted cache information; and if the number of the transacted cache information is larger than that of the successfully transacted cache information, taking the number of the transacted cache information as the identification serial number of the failed transaction.
An 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. 12, the computer device includes a memory 81, a processor 82, and a computer program stored in the memory and executable on the processor, and when the processor executes the computer program, the processor implements any of the steps of the method for batch updating the database.
It can be 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 embodiment, and is not described herein again.
An embodiment of the present invention further provides a computer-readable storage medium, where a computer program for executing any one of the above methods for batch updating a database is stored in the computer-readable storage medium.
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, apparatus (systems), 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. A method for updating a database in a batch, comprising:
acquiring a plurality of pieces of cache information; each piece of cache information comprises an identification serial number; the cache information belongs to the same data group in the database;
determining the updating mode of the cache information according to the identification sequence number;
and updating the same data group in the database according to the plurality of pieces of cache information and the updating mode.
2. The method of claim 1, wherein before obtaining the plurality of cache information, further comprising:
and generating a plurality of pieces of cache information corresponding to the same data group in the database.
3. The method of claim 1, wherein updating the same data packet in the database according to the cache information and the update mode comprises:
if the error information is received, determining the identification serial number of the failed transaction according to the error information;
grouping the plurality of pieces of cache information according to the identification serial numbers of the failed transactions to obtain grouping results;
and updating the same data group in the database according to the identification serial number of the failed transaction and the grouping result.
4. The method of claim 3, wherein determining an identification number of the failed transaction based on the error message comprises:
recording the number of pieces of cache information of successful transaction;
recording the number of the transacted cache information;
and if the number of the transacted cache information is greater than that of the successfully transacted cache information, taking the number of the transacted cache information as the identification serial number of the failed transaction.
5. An apparatus for batch updating a database, comprising:
the acquisition module is used for acquiring a plurality of pieces of cache information; each piece of cache information comprises an identification serial number; the cache information belongs to the same data group in the database;
the traversal module is used for determining the updating mode of the cache information according to the identification sequence number;
and the updating module is used for updating the same data group in the database according to the plurality of pieces of cache information and the updating mode.
6. The apparatus of claim 5, further comprising a database transaction module to:
and generating a plurality of pieces of cache information corresponding to the same data group in the database.
7. The apparatus of claim 5, wherein the update module is specifically configured to:
if the error information is received, determining the identification serial number of the failed transaction according to the error information;
grouping the plurality of pieces of cache information according to the identification serial numbers of the failed transactions to obtain grouping results;
and updating the same data group in the database according to the identification serial number of the failed transaction and the grouping result.
8. The apparatus of claim 7, wherein the update module is specifically configured to:
recording the number of pieces of cache information of successful transaction;
recording the number of the transacted cache information;
and if the number of the transacted cache information is greater than that of the successfully transacted cache information, taking the number of the transacted cache information as the identification serial number of the failed transaction.
9. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the method of any one of claims 1 to 4 when executing the computer program.
10. A computer-readable storage medium, characterized in that the computer-readable storage medium stores a computer program for executing the method of any one of claims 1 to 4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010842356.5A CN111984662B (en) | 2020-08-20 | 2020-08-20 | Method and device for updating databases in batches |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010842356.5A CN111984662B (en) | 2020-08-20 | 2020-08-20 | Method and device for updating databases in batches |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111984662A true CN111984662A (en) | 2020-11-24 |
| CN111984662B CN111984662B (en) | 2024-02-23 |
Family
ID=73443545
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010842356.5A Active CN111984662B (en) | 2020-08-20 | 2020-08-20 | Method and device for updating databases in batches |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111984662B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113139081A (en) * | 2021-04-27 | 2021-07-20 | 中山亿联智能科技有限公司 | Method for reporting and reading user online playing information with high efficiency and low delay |
| CN115048398A (en) * | 2022-06-17 | 2022-09-13 | 中国平安人寿保险股份有限公司 | Data backspacing settlement method and device, electronic equipment and storage medium |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6560700B1 (en) * | 1998-11-17 | 2003-05-06 | Telefonaktiebolaget Lm Ericsson (Publ) | Protocol for synchronizing parallel processors in a mobile communication system |
| CN102222071A (en) * | 2010-04-16 | 2011-10-19 | 华为技术有限公司 | Method, device and system for data synchronous processing |
| CN103577551A (en) * | 2013-10-16 | 2014-02-12 | 青岛海信传媒网络技术有限公司 | Method and device for submitting data to database in batch |
-
2020
- 2020-08-20 CN CN202010842356.5A patent/CN111984662B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6560700B1 (en) * | 1998-11-17 | 2003-05-06 | Telefonaktiebolaget Lm Ericsson (Publ) | Protocol for synchronizing parallel processors in a mobile communication system |
| CN102222071A (en) * | 2010-04-16 | 2011-10-19 | 华为技术有限公司 | Method, device and system for data synchronous processing |
| CN103577551A (en) * | 2013-10-16 | 2014-02-12 | 青岛海信传媒网络技术有限公司 | Method and device for submitting data to database in batch |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113139081A (en) * | 2021-04-27 | 2021-07-20 | 中山亿联智能科技有限公司 | Method for reporting and reading user online playing information with high efficiency and low delay |
| CN113139081B (en) * | 2021-04-27 | 2023-10-27 | 中山亿联智能科技有限公司 | Method for reporting online playing information of reading user with high efficiency and low delay |
| CN115048398A (en) * | 2022-06-17 | 2022-09-13 | 中国平安人寿保险股份有限公司 | Data backspacing settlement method and device, electronic equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111984662B (en) | 2024-02-23 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107391628B (en) | Data synchronization method and device | |
| US20150032695A1 (en) | Client and server integration for replicating data | |
| US11693912B2 (en) | Adapting database queries for data virtualization over combined database stores | |
| CN107301214B (en) | Data migration method and device in HIVE and terminal equipment | |
| CN107665219B (en) | Log management method and device | |
| CN111984662B (en) | Method and device for updating databases in batches | |
| US20200250188A1 (en) | Systems, methods and data structures for efficient indexing and retrieval of temporal data, including temporal data representing a computing infrastructure | |
| CN109714249B (en) | Method and related device for pushing applet messages | |
| CN114564500A (en) | Method and system for implementing structured data storage and query in block chain system | |
| CN116955510B (en) | Space data versioning management method based on data lake | |
| CN111435356B (en) | Data feature extraction method, device, computer equipment and storage medium | |
| CN111459916A (en) | GBASE and ORAC L E database table comparison method and system | |
| CN107273293B (en) | Big data system performance test method and device and electronic equipment | |
| CN111240891A (en) | Data recovery method and device based on data consistency among multiple tables of database | |
| CN116126846A (en) | Data quality detection method, device and medium | |
| CN113835690A (en) | Read-write separation multi-data source component and working method thereof | |
| CN114297311B (en) | Data processing method and distributed processing system | |
| CN111563091B (en) | Method and system for batch updating MongoDB in non-round-trip mode | |
| CN113327167B (en) | Block chain data processing method | |
| CN113934712B (en) | Method, device and equipment for processing field model of industrial quality inspection data | |
| US20220357917A1 (en) | Data sorting method, apparatus and device, storage medium and program product | |
| CN114579604B (en) | Database transaction implementation method and system of application layer | |
| US20240232165A9 (en) | Fine-grained decision on propagation of revalidation | |
| US20050177774A1 (en) | Automated generation of computer-executable compensation procedures for previously executed methods | |
| CN114706854A (en) | Method and device for detecting consistency of heterogeneous data |
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 |