CN111984662B - Method and device for updating databases in batches - Google Patents
Method and device for updating databases in batches Download PDFInfo
- Publication number
- CN111984662B CN111984662B CN202010842356.5A CN202010842356A CN111984662B CN 111984662 B CN111984662 B CN 111984662B CN 202010842356 A CN202010842356 A CN 202010842356A CN 111984662 B CN111984662 B CN 111984662B
- Authority
- CN
- China
- Prior art keywords
- cache information
- updating
- database
- 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.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 52
- 238000004590 computer program Methods 0.000 claims description 16
- 238000012545 processing Methods 0.000 abstract description 43
- 230000003993 interaction Effects 0.000 abstract description 15
- 238000010586 diagram Methods 0.000 description 28
- 230000008569 process Effects 0.000 description 7
- 230000006870 function Effects 0.000 description 4
- 238000013507 mapping Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 238000006467 substitution reaction Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000007246 mechanism 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
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: obtaining a plurality of pieces of cache information; each piece of cache information comprises an identification sequence number; the plurality of pieces of cache information belong to the same data packet in the database; determining the updating mode of the cache information according to the identification sequence number; and updating the same data packet in the database according to the plurality of pieces of cache information and the updating mode. After the updating mode of a plurality of pieces of cache information to be batched for updating 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 present invention relates to the field of computer technologies, and in particular, to a method and an apparatus for batch updating a database.
Background
Database update operations refer to SQL operations that update database table data, including add processing, modify processing, and delete processing. And updating the database in batches: the method is an operation of submitting a plurality of updated databases to the database at a time, and comprises SQL sentences of adding processing, modifying processing and deleting processing. In batch processing, business logic processing is performed on transactions each time, and processing of each transaction generally involves one or more updating operations on a database, and because of many processed transactions, interaction with the database is more, each interaction with the database consumes time, so that the efficiency of batch processing is low.
Disclosure of Invention
The invention provides a method and a device for updating databases in batches, which can reduce the interaction times 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 batch updating a database, where the method includes: obtaining a plurality of pieces of cache information; each piece of cache information comprises an identification sequence number; the plurality of pieces of cache information belong to the same data packet in the database; determining the updating mode of the cache information according to the identification sequence number; and updating the same data packet 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 batches, 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 sequence number; the plurality of pieces of cache information belong to the same data packet in the database; the traversing 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 packet 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, including a memory, a processor, and a computer program stored in the memory and capable of running on the processor, where the processor implements the method for batch updating the database when executing the computer program.
In a fourth aspect, embodiments of the present invention also provide a computer-readable storage medium storing a computer program for executing the above method of batch updating a database.
The embodiment of the invention has the following beneficial effects: the embodiment of the invention provides a scheme for updating a database in batches, which comprises the steps of firstly, acquiring a plurality of pieces of cache information, wherein each piece of cache information comprises an identification serial number; and determining the updating mode of the cache information according to the identification sequence number, and finally updating the same data packet in the database according to the plurality of cache information and the updating mode. After the update mode of a plurality of pieces of cache information to be updated in batch is determined, the embodiment of the invention performs information interaction with the database once, updates the same data packet 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 above objects, features and advantages of the present invention more 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 that are needed in the description of the embodiments or the prior art will be briefly described, and it is obvious that the drawings in the description below are some embodiments of the present invention, and other drawings can be obtained according to the drawings without inventive effort for a person skilled in the art.
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 processing flow provided by an embodiment of the present invention;
FIG. 3 is a schematic diagram of a conventional single transaction service processing flow provided in an embodiment of the present invention;
FIG. 4 is a schematic diagram of a database update execution step according to an embodiment of the present invention;
FIG. 5 is a schematic diagram of a batch processing flow provided in an embodiment of the present invention;
FIG. 6 is a schematic diagram of a single transaction service processing flow provided in an embodiment of the present invention;
FIG. 7 is a schematic diagram of a batch update database execution step according to an embodiment of the present invention;
FIG. 8 is a schematic diagram of steps for determining an update mode of cache information according to an embodiment of the present invention;
FIG. 9 is a schematic diagram of a failed transaction processing flow provided by an embodiment of the present invention;
FIG. 10 is a block diagram of a device for batch updating of databases according to an embodiment of the present invention;
FIG. 11 is a block diagram of another 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
For the purpose of making the objects, technical solutions and advantages of the embodiments of the present invention more apparent, 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 embodiments of the present invention, but not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
Referring to the schematic batch processing flow shown in fig. 2, the transaction set to be processed includes a plurality of transactions requiring update processing, in batch processing, business logic processing is performed on transactions, and each transaction generally involves one or more update operations (insert, update or delete) on a database, and the update SQL operation on the database may be completed by calling the following methods of org. Object insert (String statementName, object parameterObject); int update (String statementName, final Object parameterObject); int delete (String statementName, final Object parameterObject). Referring to the schematic diagram of the existing single transaction service processing flow shown in fig. 3, each single transaction txn service processing includes one or more database updating operations, and each database updating operation needs to be performed with the database and the database updating operation, which is low in efficiency.
There is no logical dependency between transactions when bulk processing is performed. Therefore, the update SQL (Structured Query Language ) of a plurality of transactions can be submitted at one time without actually interacting with the database every update, so that the interaction times with the database are reduced, and the batch processing efficiency is improved.
Based on this, referring to the batch processing flow diagram shown in fig. 5, compared with fig. 2, the method includes a step of batch update submission, referring to the single transaction service processing flow diagram shown in fig. 6, compared with fig. 3, the method cancels transaction management control and changes the original SQL operation into the SQL operation cache operation. According to the method, the cache information is submitted in batches, so that interaction with a database is greatly reduced, and the efficiency of batch processing is greatly improved.
For the sake of understanding the present embodiment, a method for batch updating a database disclosed in the present embodiment will be described in detail.
The embodiment of the invention provides a method for updating a database in batches, which is shown in a flow chart of the method for updating the database in batches in FIG. 1, and comprises the following steps:
step S102, a plurality of pieces of cache information are acquired.
In an embodiment of the present invention, the cache information includes data for updating the database. Each piece of cache information comprises an identification sequence number, and the identification sequence number can be used for sequencing the cache information and can also be used for uniquely identifying one piece of cache information. The plurality of pieces of cache information belong to the same data packet in the database, for example, for a certain service, a plurality of transactions are related, the data related to the service belongs to the same data packet in the database, and the data related to each transaction in the service can correspond to one piece of cache information, wherein the piece of cache information comprises the data which needs to be updated in the database.
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 update mode of the cache information shown in fig. 8, each piece of cache information may be traversed according to the identification sequence number, and it may be determined what mode is to be used for updating each piece of cache information in the database, where the update mode includes addition (insert), deletion (delete) or modification (update). After the updating mode of the cache information is determined, the cache information is submitted to a module which interacts with the database in batches according to the identification sequence number.
It should be noted that, the submit component in fig. 8 is used for the SQL Map executor to execute the update of the SQL with the ID as the target parameter, such as "sqld" by using the SQL parameter.
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 the step is performed without data interaction with the database.
In addition, the method can submit batch updates through an SQL Map executor SqlMapExeccor of an ibatis framework. If the number of the cache information pieces is too large, the cache information pieces can be submitted in batches according to the identification sequence numbers.
And step S106, updating the same data packet in the database according to the plurality of pieces of cache information and the updating mode.
In the embodiment of the invention, after the updating mode is determined, the method interacts with the database, and updates each piece of cache information in the database. For example, each transaction involved in a business is updated to complete a batch data update for the business. And updating each service in the database one by one to finish updating the whole database.
The embodiment of the invention provides a scheme for updating a database in batches, which comprises the steps of firstly, acquiring a plurality of pieces of cache information, wherein each piece of cache information comprises an identification serial number; and determining the updating mode of the cache information according to the identification sequence number, and finally updating the same data packet in the database according to the plurality of cache information and the updating mode. After the update mode of a plurality of pieces of cache information to be updated in batch is determined, the embodiment of the invention performs information interaction with the database once, updates the same data packet 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 the pieces of cache information, the following steps may be further executed:
and generating a plurality of pieces of cache information corresponding to the same data packet in the database.
In the embodiment of the invention, the generation of a plurality of pieces of cache information corresponding to the same data packet in the database, namely the process of caching the update SQL, can be realized in the following way:
the method comprises the steps that an original update DAO (Data Access Object, database access object) call in an application program is modified into a call for caching a memory; or, the update SQL operation is executed in the ORM (Object Relational Mapping, object relation mapping) framework to make a cached call to the memory, and the application DAO call writing method 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 structure shown in Table 1:
TABLE 1
Wherein the cache is a list, and each element caches information for a transaction. Each piece of cache information comprises: transaction information txn object, update SQL information list. The update SQL information list is the SQL operation information of the transaction needing to be updated, and each element of the list comprises an SQL ID and a parameter object for executing the SQL.
Considering that there may be a processing failure in batch update, updating the same data packet in the database according to the cache information and the update manner may be performed as follows:
if the error reporting information is received, determining the identification serial number of the failed transaction according to the error reporting information; grouping the plurality of pieces of cache information according to the identification serial numbers of the failed transactions to obtain a grouping result; and updating the same data packet in the database according to the identification sequence number and the packet result of the failed transaction.
In the embodiment of the present invention, during the process of performing data interaction with the database, if an error occurs, an error reporting is performed, and an identification number of a failed transaction is determined according to the error reporting information, referring to 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 cache information is grouped, and the cache information from the minimum identification number to the identification number k is obtained as a first group, and the cache information from the identification number k+1 to the maximum identification number is obtained as a second group, and then batch update processing is performed on the first group and the second group, where the processing procedure can refer to steps in fig. 7, and in the diagram, the step of obtaining a plurality of cache information can be implemented by setting a batch flag as true through the SQL Map executor.
The buffer information with the identification number k is separately processed, for example, since the kth transaction cannot normally update the database, the information of the failed transaction needs to be recorded. May be recorded in a log file or in a database table, such as a batch processing failure table. The number of digits k may be recorded, as well as transaction information txn. The failure information can be queried and analyzed, and subsequent business remedial measures, etc.
It should be noted that, when the batch update is actually submitted to the database, referring to the schematic diagram of the batch update database execution step shown in fig. 7, the step of interacting with the database to update may call the SQL Map executor in the iBatis framework to execute batch update implementation, and this process may throw an exception due to a failure of executing part of the SQL, and JDBC (Java Database Connectivity, java database connection) generally throws a Java.
In order to efficiently and accurately process the failed transaction, determining the identification sequence number of the failed transaction according to the error reporting information may be performed according to the following steps:
recording the number of cache information of successful transaction; recording the number of the cache information which is transacted; if the number of the transacted cache information is larger than the number of the cache information of successful transaction, the number of the transacted cache information is used as the identification serial number of the failed transaction.
In an embodiment of the present invention, for example, in one embodiment, the java. SQL. BattupdateException getUpdateCounts () method returns an int [ ] array that indicates the number of records updated for each successfully executed SQL, so the length of the array is the number of SQL entries that were successfully executed, e.g., the value is n. The transaction record from the buffered begin may be traversed, the SQL number of transactions accumulated, and when the accumulated number m > n, the transaction is the record sequence number k of the commit failure.
It should be noted that, in the embodiment of the present invention, the database interaction is based on the ibatis framework, and different caching methods or structures and different batch updating methods may exist for using other ORM frameworks. But the failure handling mechanism for batch updates is the same.
The embodiment of the invention provides a method and a device for updating databases in batches, and referring to a database updating execution step schematic diagram shown in fig. 4, the method firstly updates SQL cache, and caches SQL operation for updating the databases in a memory; and then, batch updating and submitting, and sending all the cached SQL operations to the database for actual updating. According to the method, each update SQL is cached, then the database is updated in batches, and when the batch update fails, the batch update submission is required to be segmented again. Because batch submission is performed, interaction with the database is greatly reduced, and thus, the efficiency of batch processing is greatly improved.
The embodiment of the invention also provides a device for updating the database in batches, which is described in the following embodiment. Because the principle of the device for solving the problem is similar to that of 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 the repeated parts are not repeated. Referring to fig. 10, there is shown a block diagram of an apparatus for batch updating a database, the apparatus comprising:
an acquisition module 71, configured to acquire a plurality of pieces of cache information; each piece of cache information comprises an identification sequence number; the plurality of pieces of cache information belong to the same data packet in the database; a traversing module 72, configured to determine an update manner of the cache information according to the identification sequence number; an updating module 73, configured to update the same data packet 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 packet in the database.
In one embodiment, the updating module is specifically configured to: if the error reporting information is received, determining the identification serial number of the failed transaction according to the error reporting information; grouping the plurality of pieces of cache information according to the identification serial numbers of the failed transactions to obtain a grouping result; and updating the same data packet in the database according to the identification sequence number and the packet result of the failed transaction.
In one embodiment, the updating module is specifically configured to: recording the number of cache information of successful transaction; recording the number of the cache information which is transacted; if the number of the transacted cache information is larger than the number of the cache information of successful transaction, the number of the transacted cache information is used as the identification serial number of the failed transaction.
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. 12, where the computer device includes a memory 81, a processor 82, and a computer program stored on the memory and capable of running on the processor, and when the processor executes the computer program, the processor implements the steps of any of the methods for updating databases in batches.
It will 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, which is not repeated herein.
The embodiment of the invention also provides a computer readable storage medium, and the computer readable storage medium stores a computer program for executing any one of the batch database updating methods.
It will be appreciated by those skilled in the art that 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 flowchart illustrations and/or block diagrams, and combinations of flows and/or blocks in the flowchart illustrations 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 examples are only specific embodiments of the present invention, and are not intended to limit the scope of the present invention, but it should be understood by those skilled in the art that the present invention is not limited thereto, and that the present invention is described in detail with reference to the foregoing examples: any person skilled in the art may modify or easily conceive of the technical solution described in the foregoing embodiments, or perform equivalent substitution of some of the technical features, while remaining within the technical scope of the present disclosure; such modifications, changes or substitutions do not depart from the spirit and scope of the technical solutions of the embodiments of the present invention, and are intended to be included in the scope of the present invention. Therefore, the protection scope of the present invention shall be subject to the protection scope of the claims.
Claims (8)
1. A method for batch updating a database, comprising:
setting batch marks as true through an SQL Map executor, and acquiring a plurality of pieces of cache information; each piece of cache information comprises an identification sequence number; the plurality of pieces of cache information belong to the same data packet in the database;
determining the updating mode of the cache information according to the identification sequence number;
updating the same data packet in the database according to the plurality of pieces of cache information and the updating mode;
updating the same data packet in the database according to the cache information and the updating mode, wherein the updating comprises the following steps:
if the error reporting information is received, determining the identification serial number of the failed transaction according to the error reporting information, and marking the identification serial number as K;
the method comprises the steps of dividing the cache information from the minimum identification serial number to K in the plurality of pieces of cache information into a first group, and dividing the cache information from the identification serial number k+1 to the maximum identification serial number into a second group;
and updating the same data packet in the database according to the first group, the K-th failed transaction and the second group respectively.
2. The method of claim 1, further comprising, prior to obtaining the plurality of pieces of cache information:
and generating a plurality of pieces of cache information corresponding to the same data packet in the database.
3. The method of claim 1, wherein determining the identification number of the failed transaction based on the error message comprises:
recording the number of cache information of successful transaction;
recording the number of the cache information which is transacted;
and if the number of the transacted cache information is larger than the number of the cache information of successful transaction, taking the number of the transacted cache information as the identification serial number of the failed transaction.
4. An apparatus for batch updating a database, comprising:
the acquisition module is used for setting batch marks as true through the SQL Map executor and acquiring a plurality of pieces of cache information; each piece of cache information comprises an identification sequence number; the plurality of pieces of cache information belong to the same data packet in the database;
the traversing module is used for determining the updating mode of the cache information according to the identification sequence number;
the updating module is used for updating the same data packet in the database according to the plurality of pieces of cache information and the updating mode;
the updating module is specifically configured to:
if the error reporting information is received, determining the identification serial number of the failed transaction according to the error reporting information, and marking the identification serial number as K;
the method comprises the steps of dividing the cache information from the minimum identification serial number to K in the plurality of pieces of cache information into a first group, and dividing the cache information from the identification serial number k+1 to the maximum identification serial number into a second group;
and updating the same data packet in the database according to the first group, the K-th failed transaction and the second group respectively.
5. The apparatus of claim 4, further comprising a database transaction module for:
and generating a plurality of pieces of cache information corresponding to the same data packet in the database.
6. The apparatus of claim 4, wherein the updating module is specifically configured to:
recording the number of cache information of successful transaction;
recording the number of the cache information which is transacted;
and if the number of the transacted cache information is larger than the number of the cache information of successful transaction, taking the number of the transacted cache information as the identification serial number of the failed transaction.
7. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor implements the method of any of claims 1 to 3 when executing the computer program.
8. 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 3.
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 CN111984662A (en) | 2020-11-24 |
| CN111984662B true 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) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
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 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111984662A (en) | 2020-11-24 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11126620B2 (en) | Automatic verification and triage of query results | |
| US8332433B2 (en) | Database synchronization and validation | |
| US20180067962A1 (en) | Consistent execution of partial queries in hybrid dbms | |
| US9589041B2 (en) | Client and server integration for replicating data | |
| US20170220617A1 (en) | Scalable conflict detection in transaction management | |
| US7996413B2 (en) | Data modernization system for legacy software | |
| US8560500B2 (en) | Method and system for removing rows from directory tables | |
| CN108647357B (en) | Data query method and device | |
| CN111984621B (en) | Heterogeneous database migration method and device and storage medium | |
| US20140372374A1 (en) | Difference determination in a database environment | |
| US20080249988A1 (en) | Computer programming method and system for performing a reversal of selected structured query language operations within a database transaction | |
| CN111984662B (en) | Method and device for updating databases in batches | |
| CN107665219B (en) | Log management method and device | |
| US10642792B2 (en) | Distributed transaction conflict resolution | |
| CN110716936B (en) | Database optimistic lock implementation method and system based on SpringBoot + JPA | |
| CN110555770B (en) | Block chain world state checking and recovering method based on incremental hash | |
| Kvet et al. | Complex time management in databases | |
| CN115543402B (en) | Software knowledge graph increment updating method based on code submission | |
| EP2797001B1 (en) | System and method for creating variants in a test database during various test stages | |
| US7752399B2 (en) | Exclusion control method and information processing apparatus | |
| CN114564500A (en) | Method and system for implementing structured data storage and query in block chain system | |
| CN111240891A (en) | Data recovery method and device based on data consistency among multiple tables of database | |
| US11372838B2 (en) | Parallel processing of changes in a distributed system | |
| CN113835690A (en) | Read-write separation multi-data source component and working method thereof | |
| CN114579604B (en) | Database transaction implementation method and system of application layer |
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 |