CN102279855A - Device and method for treating transactions with database - Google Patents

Device and method for treating transactions with database Download PDF

Info

Publication number
CN102279855A
CN102279855A CN201010200913XA CN201010200913A CN102279855A CN 102279855 A CN102279855 A CN 102279855A CN 201010200913X A CN201010200913X A CN 201010200913XA CN 201010200913 A CN201010200913 A CN 201010200913A CN 102279855 A CN102279855 A CN 102279855A
Authority
CN
China
Prior art keywords
transaction
database
asynchronous
synchronized
related 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.)
Pending
Application number
CN201010200913XA
Other languages
Chinese (zh)
Inventor
薛竹飙
顾逶迤
纪晨
谭姝
陈喜圭
金映锡
洪锡璡
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Samsung Electronics China R&D Center
Samsung Electronics Co Ltd
Original Assignee
Samsung Electronics China R&D Center
Samsung Electronics Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Samsung Electronics China R&D Center, Samsung Electronics Co Ltd filed Critical Samsung Electronics China R&D Center
Priority to CN201010200913XA priority Critical patent/CN102279855A/en
Publication of CN102279855A publication Critical patent/CN102279855A/en
Pending legal-status Critical Current

Links

Images

Abstract

The invention provides a device and method for treating transactions with a database. A submitted asynchronous transaction interface which is used for receiving a submitted asynchronous transaction is arranged in the device for treating transactions with a database. The method comprises the following steps of: when an asynchronous transaction is received, extracting relevant data of the asynchronous transaction from the database to a memory for deleting, modifying or/adding, directly determining the finish of transaction processing, and sending a response message to a user; and storing the relevant data of the asynchronous transaction modified, deleted or/and added in the memory in the database of a permanent storage, for example, storing while the database is processing other asynchronous transactions. In the invention, a response can be made to the user without storing the relevant data of the asynchronous transaction which are modified, deleted or/and added in the memory in the database of the permanent storage or performing subsequent processing, so that the database transaction is processed on the basis of reducing response time, and the user experience is improved.

Description

A kind of device and method of database processing affairs
Technical field
The present invention relates to the database technology in computerized information field, particularly a kind of device and method of database processing affairs.
Background technology
Along with the development of computer information technology, database technology has wherein become one of the important component part of advanced infotech and core.
In database technology, affairs need be submitted to database processing.So-called affairs just are meant one group of logical operations unit, make data that affairs relate in database from a kind of state variation to another kind of state.Consistance in order to ensure data in the database, the processing of data should be discrete logical operations unit in groups, when affairs are finished by database processing, data consistency in the database can keep, and when a part of operation failure in the logical operations unit in the database processing business process, then whole affairs should all be considered as mistake, and all logical operations unit all fall back on the initial state of data the database from the later operation of starting point.
Database correctly processing transactions can guarantee the integrality and the consistance of data in the database, before affairs are not finished by database processing, guarantees that the data in the database do not increase, deletion is or/and change.
Lifting an object lesson illustrates.
The tentation data storehouse is bank's application data base, and data are 100 yuans, and affairs are for incorporating in will the account with this 100 yuan depositor's first from bank's application data base among the account to depositor's second.In bank's application data base, depositor's first and depositor's second as storage list, are used to store account information respectively to storage space should be arranged.When bank's application data base during to above-mentioned issued transaction, need respectively the storage list of depositor's first and the storage list of depositor's second to be revised, promptly in the storage list of depositor's first, deduct 100 yuans, in the storage list of depositor's second, increase by 100 yuans, finish processing procedure affairs.Particularly, exactly the storage list of depositor's first in bank's application data base and the storage list of depositor's second are extracted in the internal memory successively, carry out corresponding modification after, store in the database successively again.But, in the processing transactions process, following situation can appear: if deduct 100 yuans in the storage list of depositor's first after, when the storage list of depositor's second is increased the failure of 100 yuans, then need in the storage list of depositor's first, increase by 100 yuans, make the storage list of depositor's first in the database get back to the state before revising,, prevent that data wherein from makeing mistakes to guarantee the consistance and the integrality of data in bank's application data base.
At present, database preestablishes affairs to the processing of affairs as shown in Figure 1, and its concrete steps are:
After step 101, database receive the affairs of submission, the relevant data of affairs in the database are deleted, increased or/and revise according to the affairs that set;
In this step, because database all is provided with on permanent storage, such as hard disk, in the processing transactions process, need from database, extract the affairs related data in internal memory, then the affairs related data in the internal memory is deleted, increased or/and after revising, store into again in the database and forever preserve;
Step 102, judge whether to finish fully the processing of database to affairs, if, process ends then; If not, execution in step 103 then;
Step 103, database carry out rollback operation, abandon all processing to these affairs, get back to the state of beginning processing transactions, guarantee the consistance and the integrality of data in the database.
In addition, in the database processing business process, memory point (save point) can also be set, the affairs related data state of corresponding stored database on the memory point that is provided with.In the processing transactions process, if the issued transaction failure, then database return back on the affairs related data state of memory point correspondence, and does not need to return back to the preceding initial transaction state of issued transaction.If affairs can be divided into several sections processing, just can be divided into several sections database carried out the modification, deletion of affairs related data or/and increase, then a plurality of memory points can be set, when in the issued transaction process, failing, database return back to the affairs related data state of one of them memory point correspondence of setting as required, and does not return back to the data original state before the issued transaction.
But, present this database also exists shortcoming to the method for issued transaction: to the processing of each affairs, all need through submission affairs, internal memory from database extract the affairs related data, internal memory, revise, deletion or/and increase the affairs related data and will revise in the internal memory, deletion or/and the related data that increases store in the database in permanent storage, this process is long, especially under the bigger situation of the data volume of affairs related data.Therefore, after database was finished issued transaction, response user's time also can be long, reduces user's Experience Degree.
Summary of the invention
In view of this, the invention provides a kind of device of database processing affairs, this device can improve user's Experience Degree reducing process database affairs on the basis of response time.
The present invention also provides a kind of method of database processing affairs, and this method can reduce process database affairs on the basis of response time, improves user's Experience Degree.
According to above-mentioned purpose, technical scheme of the present invention is achieved in that
A kind of device of process database affairs comprises: synchronized transaction interface, asynchronous transaction interface, processor, the permanent storage that is provided with database and internal memory, wherein,
The synchronized transaction interface is used to receive synchronized transaction, and the synchronized transaction that receives is offered processor processing;
The asynchronous transaction interface is used to receive asynchronous transaction, and the asynchronous transaction that receives is offered processor processing;
Processor, after being used for receiving synchronized transaction from the synchronized transaction interface, extract the synchronized transaction related data to internal memory from database, the deletion, increase of carrying out the synchronized transaction related data in internal memory are or/and revise, after sending to database storing, send response synchronized transaction message; From the asynchronous transaction interface, receive asynchronous transaction, from database, extract the asynchronous transaction related data, in internal memory, carry out deletion, the increase of asynchronous transaction related data and keep in transmission response asynchronous transaction message or/and revise the back to internal memory;
Be provided with the permanent storage of database, be used to store synchronized transaction and asynchronous transaction related data;
Internal memory is used under the indication of processor synchronized transaction or asynchronous transaction related data being extracted from database, carries out the deletion, increase of synchronized transaction or asynchronous transaction related data or/and revise.
When synchronized transaction or asynchronous transaction processing failure, described processor, also be used for the state of internal memory synchronized transaction or asynchronous transaction related data is carried out rollback, synchronized transaction behind the rollback or asynchronous transaction related data are sent to database storing, send response failure transaction message.
Described processor, also be used to be provided with memory point, when the state of synchronized transaction or asynchronous transaction related data carries out rollback in internal memory, return back to the state of the synchronized transaction of memory point correspondence or asynchronous transaction related data carry out synchronized transaction or asynchronous transaction handle before the state of related data.
Described processor submits to transactional synchronization to submit daily record to database when handling synchronized transaction; Described processor is submitted the asynchronous submission daily record of affairs to database when handling asynchronous transaction; Described processor is submitted the transaction rollback daily record to database after handling the affairs failure procedure.
The asynchronous transaction related data that described processor is also revised, deleted or/and increase in internal memory when database subsequent treatment synchronized transaction process stores in the database in permanent storage.
A kind of method of database processing affairs, this method comprises:
A, receive affairs after, determine whether to be asynchronous transaction, if, execution in step b, if not, execution in step c;
B, from database, extract the asynchronous transaction related data, in internal memory, carry out the deletion, increase of asynchronous transaction related data, send response asynchronous transaction message or/and to revise the back temporary to internal memory;
C, from database, extract the synchronized transaction related data, in internal memory, carry out the deletion, increase of synchronized transaction related data or/and revise to internal memory, send to database storing after, send response synchronized transaction message.
Before sending response asynchronous transaction message or response synchronized transaction message, also comprise:
Determine whether asynchronous transaction or synchronized transaction handle success, if then send; Otherwise, the state of synchronized transaction in the internal memory or asynchronous transaction related data is carried out rollback, synchronized transaction behind the rollback or asynchronous transaction related data are sent to database storing, send response failure transaction message.
Described when the state of synchronized transaction or asynchronous transaction related data carries out rollback in internal memory, return back to the state of the synchronized transaction of memory point correspondence of setting or asynchronous transaction related data carry out synchronized transaction or asynchronous transaction handle before the state of related data.
This method also comprises:
When handling synchronized transaction, submit to transactional synchronization to submit daily record to database; When handling asynchronous transaction, submit the asynchronous submission daily record of affairs to database; After handling the affairs failure procedure, submit the transaction rollback daily record to database.
This method also comprises:
When processor is revised in internal memory, deletion is or/and this asynchronous transaction related data that increases stores in the database in permanent storage, when database subsequent treatment synchronized transaction process, carry out.
From such scheme as can be seen, the present invention is provided with in the device of database processing affairs and submits the asynchronous transaction interface to, be used to receive the asynchronous transaction of being submitted to, after receiving asynchronous transaction, extracting this asynchronous transaction related data from database deletes, revises or/and after increasing to internal memory, confirm that directly issued transaction finishes, and sends response message to the user.Follow-uply again will be in the internal memory revise, deletion or/and this asynchronous transaction related data that increases store in the database of permanent storage, such as storing in the lump when other synchronized transaction processes of database processing.Because the present invention does not need and will revise in the internal memory, delete or/and the database that this asynchronous transaction related data that increases stores in permanent storage just respond the user, and handle again follow-up, thereby process database affairs on the basis of minimizing response time improve user's Experience Degree.
Description of drawings
The database that Fig. 1 provides for prior art is to the processing flow chart of affairs;
Fig. 2 is the structural representation of database processing transaction device provided by the invention;
Fig. 3 is the method flow diagram of database processing affairs provided by the invention;
The response time comparison diagram of the method that adopts method provided by the invention and prior art and provide is provided Fig. 4.
Embodiment
For making purpose of the present invention, technical scheme and advantage clearer, below with reference to the accompanying drawing embodiment that develops simultaneously, the present invention is described in further detail.
The present invention improves user experience in order to reduce the response time of database processing affairs.Two kinds of dissimilar affairs have been proposed: asynchronous transaction and synchronized transaction.Wherein, the processing of synchronized transaction is identical with the process of processing transactions in the prior art, and the processing procedure of asynchronous transaction is: after receiving asynchronous transaction, extracting this asynchronous transaction related data from database deletes, revises or/and after increasing to internal memory, confirm that directly issued transaction finishes, and sends response message to the user.Follow-uply again will be in the internal memory revise, deletion or/and this asynchronous transaction related data that increases store in the database in permanent storage, such as storing in the lump when the database processing synchronized transaction process.Like this, just can reduce the response time of database processing affairs.
Therefore, the present invention is provided with in the device of database processing affairs and submits the asynchronous transaction interface in order to handle asynchronous transaction, is used to receive the asynchronous transaction of being submitted to.
Fig. 2 is the structural representation of database processing transaction device provided by the invention, comprising: synchronized transaction interface, asynchronous transaction interface, processor, the permanent storage that is provided with database and internal memory, wherein,
The synchronized transaction interface is used to receive synchronized transaction, and the synchronized transaction that receives is offered processor processing;
The asynchronous transaction interface is used to receive asynchronous transaction, and the asynchronous transaction that receives is offered processor processing;
Processor, after being used for receiving synchronized transaction from the synchronized transaction interface, extract the synchronized transaction related data to internal memory from database, the deletion, increase of carrying out the synchronized transaction related data in internal memory are or/and revise, after sending to database storing, send response synchronized transaction message; From the asynchronous transaction interface, receive asynchronous transaction, from database, extract the asynchronous transaction related data, in internal memory, carry out deletion, the increase of asynchronous transaction related data and keep in transmission response asynchronous transaction message or/and revise the back to internal memory;
Be provided with the permanent storage of database, be used to store the synchronized transaction data relevant with asynchronous transaction;
Internal memory is used under the indication of processor synchronized transaction or asynchronous transaction related data being extracted from database, carries out the deletion, increase of synchronized transaction or asynchronous transaction related data or/and revise.
In this embodiment, when synchronized transaction or asynchronous transaction processing failure, described processor, also be used for the state of internal memory synchronized transaction or asynchronous transaction related data is carried out rollback, this process of cancellation to the deletion of synchronized transaction or asynchronous transaction related data, increase or/and after revising, synchronized transaction behind the rollback or asynchronous transaction related data are sent to database storing, send response failure transaction message.
In this embodiment, synchronized transaction interface and asynchronous transaction interface can be the hardware interface of database processing transaction device, also can be logic interfacing, can identify synchronized transaction or asynchronous transaction according to sync id or the asynchronous sign that affairs are carried.
Fig. 3 is the method flow diagram of database processing affairs provided by the invention, and synchronized transaction and asynchronous transaction are set, and its concrete steps are:
Step 301, receive affairs after, determine whether to be asynchronous transaction, if, execution in step 302, if not, execution in step 305;
In this step, the sync id or the asynchronous sign of carrying according to affairs determine whether to be synchronized transaction or asynchronous transaction;
Step 302, from database, extract the asynchronous transaction related data, in internal memory, carry out the deletion, increase of asynchronous transaction related data or/and to revise the back temporary to internal memory;
Step 303, determine whether asynchronous transaction handles success, if then execution in step 304; Otherwise then execution in step 308;
Step 304, send response asynchronous transaction message to the user;
Step 305, extract the synchronized transaction related data to internal memory from database, the deletion, increase of carrying out the synchronized transaction related data in internal memory are or/and revise;
Step 306, determine whether synchronized transaction handles success, if then execution in step 307; Otherwise then execution in step 308;
Step 307, at first the asynchronous transaction related data of deleting in the internal memory, increasing or/and revise is sent to database storing after, after again the synchronized transaction related data of deleting in the internal memory, increasing or/and revise being sent to database storing, send response synchronized transaction message to the user;
In this step, at first handle asynchronous transaction related data in the internal memory, and then the synchronized transaction related data in the processing internal memory, that is to say, the asynchronous transaction related data of deleting in internal memory, increasing or/and revise can be at first processed in follow-up synchronized transaction processing procedure, is deposited in the database;
Step 308, the state of synchronized transaction in the internal memory or asynchronous transaction related data is carried out rollback, this process of cancellation to the deletion of synchronized transaction or asynchronous transaction related data, increase or/and after revising, synchronized transaction behind the rollback or asynchronous transaction related data are sent to database storing, send response failure transaction message.
In the method, whole process all is to be undertaken by the processor control of database processing transaction device.
In above-mentioned device or method, processor also is used to be provided with memory point, when the state of synchronized transaction or asynchronous transaction related data carries out rollback in internal memory, return back to the state of the synchronized transaction or the asynchronous transaction related data of memory point correspondence.
In above-mentioned device or method, processor can also submit to transactional synchronization to submit daily record to database when handling synchronized transaction; When handling asynchronous transaction, can also submit the asynchronous submission daily record of affairs to database; After handling the affairs failure procedure, can also submit the transaction rollback daily record to database; So that use when checking affairs related data is consistent in the follow-up data storehouse.
In above-mentioned device or method, when processor is revised in internal memory, deletion or/and this asynchronous transaction related data that increases store in the database in permanent storage, can when database subsequent treatment synchronized transaction process, carry out, being about to this asynchronous transaction related data arranges in the synchronized transaction processing queue, when database storing synchronized transaction related data, at first with after the storage of this asynchronous transaction related data, other synchronized transaction related datas in the storage queue again.
When the user need improve response processing transactions speed, just can adopt asynchronous transaction, processing procedure by asynchronous transaction is finished, owing to saved and in internal memory, to have deleted, revise or/and the asynchronous transaction related data that increases stores the time of database into, so improved the response user velocity.When the user wishes to delete in internal memory, revises or/and when the asynchronous transaction related data that increases stores database into, invoke synchronous issued transaction process again, promptly will in internal memory, delete earlier, revise or/and after the asynchronous transaction related data that increases stores in the database, again other synchronized transaction related datas in the synchronized transaction formation are stored in the database, submit to the transactional synchronization daily record to give database at last.Like this, just can avoid only carrying out single asynchronous transaction process and the consistance of asynchronous transaction related data in database and internal memory that cause, and the shortcoming of memory-limited, remedied the deficiency of only handling the asynchronous transaction process.
The response time comparison diagram of the method that adopts method provided by the invention and prior art and provide is provided Fig. 4, and ordinate is a time shaft, as can be seen, adopts method provided by the invention, and than the method that prior art provides, the response time is many fast.
The above only is preferred embodiment of the present invention, and is in order to restriction the present invention, within the spirit and principles in the present invention not all, any modification of being made, is equal to replacement, improvement etc., all should be included within the scope of protection of the invention.

Claims (10)

1. the device of process database affairs is characterized in that, comprising: synchronized transaction interface, asynchronous transaction interface, processor, the permanent storage that is provided with database and internal memory, wherein,
The synchronized transaction interface is used to receive synchronized transaction, and the synchronized transaction that receives is offered processor processing;
The asynchronous transaction interface is used to receive asynchronous transaction, and the asynchronous transaction that receives is offered processor processing;
Processor, after being used for receiving synchronized transaction from the synchronized transaction interface, extract the synchronized transaction related data to internal memory from database, the deletion, increase of carrying out the synchronized transaction related data in internal memory are or/and revise, after sending to database storing, send response synchronized transaction message; From the asynchronous transaction interface, receive asynchronous transaction, from database, extract the asynchronous transaction related data, in internal memory, carry out deletion, the increase of asynchronous transaction related data and keep in transmission response asynchronous transaction message or/and revise the back to internal memory;
Be provided with the permanent storage of database, be used to store synchronized transaction and asynchronous transaction related data;
Internal memory is used under the indication of processor synchronized transaction or asynchronous transaction related data being extracted from database, carries out the deletion, increase of synchronized transaction or asynchronous transaction related data or/and revise.
2. device as claimed in claim 1, it is characterized in that, when synchronized transaction or asynchronous transaction processing failure, described processor, also be used for the state of internal memory synchronized transaction or asynchronous transaction related data is carried out rollback, synchronized transaction behind the rollback or asynchronous transaction related data are sent to database storing, send response failure transaction message.
3. device as claimed in claim 2, it is characterized in that, described processor, also be used to be provided with memory point, when the state of synchronized transaction or asynchronous transaction related data carries out rollback in internal memory, return back to the state of the synchronized transaction of memory point correspondence or asynchronous transaction related data carry out synchronized transaction or asynchronous transaction handle before the state of related data.
4. device as claimed in claim 2 is characterized in that, described processor submits to transactional synchronization to submit daily record to database when handling synchronized transaction; Described processor is submitted the asynchronous submission daily record of affairs to database when handling asynchronous transaction; Described processor is submitted the transaction rollback daily record to database after handling the affairs failure procedure.
5. as the arbitrary described device of claim 1~4, it is characterized in that the asynchronous transaction related data that described processor is also revised, deleted or/and increase in internal memory stores in the database in permanent storage when database subsequent treatment synchronized transaction process.
6. the method for database processing affairs is characterized in that, this method comprises:
A, receive affairs after, determine whether to be asynchronous transaction, if, execution in step b, if not, execution in step c;
B, from database, extract the asynchronous transaction related data, in internal memory, carry out the deletion, increase of asynchronous transaction related data, send response asynchronous transaction message or/and to revise the back temporary to internal memory;
C, from database, extract the synchronized transaction related data, in internal memory, carry out the deletion, increase of synchronized transaction related data or/and revise to internal memory, send to database storing after, send response synchronized transaction message.
7. method as claimed in claim 6 is characterized in that, before sending response asynchronous transaction message or response synchronized transaction message, also comprises:
Determine whether asynchronous transaction or synchronized transaction handle success, if then send; Otherwise, the state of synchronized transaction in the internal memory or asynchronous transaction related data is carried out rollback, synchronized transaction behind the rollback or asynchronous transaction related data are sent to database storing, send response failure transaction message.
8. method as claimed in claim 7, it is characterized in that, described when the state of synchronized transaction or asynchronous transaction related data carries out rollback in internal memory, return back to the state of the synchronized transaction of memory point correspondence of setting or asynchronous transaction related data carry out synchronized transaction or asynchronous transaction handle before the state of related data.
9. method as claimed in claim 7 is characterized in that, this method also comprises:
When handling synchronized transaction, submit to transactional synchronization to submit daily record to database; When handling asynchronous transaction, submit the asynchronous submission daily record of affairs to database; After handling the affairs failure procedure, submit the transaction rollback daily record to database.
10. as the arbitrary described method of claim 6~9, it is characterized in that this method also comprises:
When processor is revised in internal memory, deletion is or/and this asynchronous transaction related data that increases stores in the database in permanent storage, when database subsequent treatment synchronized transaction process, carry out.
CN201010200913XA 2010-06-10 2010-06-10 Device and method for treating transactions with database Pending CN102279855A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201010200913XA CN102279855A (en) 2010-06-10 2010-06-10 Device and method for treating transactions with database

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201010200913XA CN102279855A (en) 2010-06-10 2010-06-10 Device and method for treating transactions with database

Publications (1)

Publication Number Publication Date
CN102279855A true CN102279855A (en) 2011-12-14

Family

ID=45105309

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201010200913XA Pending CN102279855A (en) 2010-06-10 2010-06-10 Device and method for treating transactions with database

Country Status (1)

Country Link
CN (1) CN102279855A (en)

Cited By (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103019826A (en) * 2012-12-27 2013-04-03 亚信联创科技(中国)有限公司 Method and device for processing events
CN105512244A (en) * 2015-11-30 2016-04-20 北京京东尚科信息技术有限公司 Database transaction processing method and device based on message queue
CN105786877A (en) * 2014-12-23 2016-07-20 中国移动通信集团山东有限公司 Data storage method and system and data inquiry method
CN108279762A (en) * 2018-01-22 2018-07-13 北京计算机技术及应用研究所 Transaction methods based on hardware protection
CN108874587A (en) * 2018-06-06 2018-11-23 亚信科技(中国)有限公司 A kind of the final consistency support method and system of affairs
CN109062931A (en) * 2018-06-12 2018-12-21 阿里巴巴集团控股有限公司 Cache synchronization control method, device, system, server and readable storage medium storing program for executing
CN109657007A (en) * 2018-12-17 2019-04-19 武汉达梦数据库有限公司 Database in phase based on asynchronous submission executes method and apparatus parallel
CN110691123A (en) * 2019-09-23 2020-01-14 四川长虹电器股份有限公司 Method for balancing timeliness and receiving performance of cloud data

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5613060A (en) * 1990-05-16 1997-03-18 International Business Machines Corporation Asynchronous resynchronization of a commit procedure
CN101089857A (en) * 2007-07-24 2007-12-19 中兴通讯股份有限公司 Internal store data base transaction method and system

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5613060A (en) * 1990-05-16 1997-03-18 International Business Machines Corporation Asynchronous resynchronization of a commit procedure
CN101089857A (en) * 2007-07-24 2007-12-19 中兴通讯股份有限公司 Internal store data base transaction method and system

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
C. MOHAN 等: "Transaction management in the R* distributed database management system", 《TRANSACTIONS ON DATABASE SYSTEMS》, vol. 11, no. 4, 31 December 1986 (1986-12-31), pages 378 - 396 *

Cited By (13)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103019826B (en) * 2012-12-27 2016-08-03 亚信科技(中国)有限公司 A kind of method and apparatus of issued transaction
CN103019826A (en) * 2012-12-27 2013-04-03 亚信联创科技(中国)有限公司 Method and device for processing events
CN105786877A (en) * 2014-12-23 2016-07-20 中国移动通信集团山东有限公司 Data storage method and system and data inquiry method
CN105786877B (en) * 2014-12-23 2019-02-26 中国移动通信集团山东有限公司 A kind of date storage method, system and querying method
CN105512244A (en) * 2015-11-30 2016-04-20 北京京东尚科信息技术有限公司 Database transaction processing method and device based on message queue
CN105512244B (en) * 2015-11-30 2019-03-01 北京京东尚科信息技术有限公司 The method and device of db transaction processing is realized based on message queue
CN108279762A (en) * 2018-01-22 2018-07-13 北京计算机技术及应用研究所 Transaction methods based on hardware protection
CN108874587B (en) * 2018-06-06 2022-01-14 亚信科技(中国)有限公司 Method and system for guaranteeing final consistency of affairs
CN108874587A (en) * 2018-06-06 2018-11-23 亚信科技(中国)有限公司 A kind of the final consistency support method and system of affairs
CN109062931A (en) * 2018-06-12 2018-12-21 阿里巴巴集团控股有限公司 Cache synchronization control method, device, system, server and readable storage medium storing program for executing
CN109062931B (en) * 2018-06-12 2021-08-03 创新先进技术有限公司 Cache synchronization control method, device, system, server and readable storage medium
CN109657007A (en) * 2018-12-17 2019-04-19 武汉达梦数据库有限公司 Database in phase based on asynchronous submission executes method and apparatus parallel
CN110691123A (en) * 2019-09-23 2020-01-14 四川长虹电器股份有限公司 Method for balancing timeliness and receiving performance of cloud data

Similar Documents

Publication Publication Date Title
CN102279855A (en) Device and method for treating transactions with database
CN108519862A (en) Storage method, device, system and the storage medium of block catenary system
EP2380090B1 (en) Data integrity in a database environment through background synchronization
CN109919691B (en) Data processing system, method and device
CN110019873B (en) Face data processing method, device and equipment
CN102955792A (en) Method for implementing transaction processing for real-time full-text search engine
US10055445B2 (en) Transaction processing method and apparatus
CN111291023A (en) Data migration method, system, device and medium
WO2019161645A1 (en) Shell-based data table extraction method, terminal, device, and storage medium
CN110443690A (en) A kind of method, apparatus, server and the storage medium of variance data reconciliation
CN108665335A (en) The method for handling the shopping cart data of shopping website
CN110363663A (en) Batch data processing method, device, equipment and storage medium based on block chain
WO2020088072A1 (en) Failover data processing method, apparatus, and system
CN107506200A (en) A kind of screen content switching method, terminal and computer-readable recording medium
US20090320049A1 (en) Third tier transactional commit for asynchronous replication
CN108140043B (en) Read-write protocol for attaching only distributed database
CN109165259B (en) Index table updating method based on network attached storage, processor and storage device
CN107783826A (en) A kind of virtual machine migration method, apparatus and system
CN110619116A (en) Data processing method, device, terminal and storage medium
CN107430596A (en) The externalizing of Input Method Editor performs
CN114022148B (en) Transaction conflict detection method, device, equipment and storage medium based on block chain
CN109901914A (en) Transaction methods, device and equipment
CN105592097A (en) Asynchronous interaction information method based on client
CN104267975B (en) A kind of processing method and device of expanded application data, card
CN107506378A (en) The implementation method and device of database access

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
C12 Rejection of a patent application after its publication
RJ01 Rejection of invention patent application after publication

Application publication date: 20111214