Database transaction processing method and device based on sub-libraries and sub-tables

Abstract

The invention discloses a database transaction processing method and device based on sub-libraries and sub-tables. The method comprises the steps of obtaining sub-libraries and sub-table fields of aninitial sub-process of a service according to a pre-constructed mapping table; allocating sub-libraries to the current sub-process according to the sub-library and sub-table fields of the initial sub-process and the number of the sub-libraries, wherein the current sub-process is any sub-process of the service except the initial sub-process; selecting sub-tables from the sub-libraries for the current sub-process according to the sub-library sub-table fields of the initial sub-process and the number of the sub-tables; and updating the data of the current sub-process to the allocated sub-tables,and updating related data in the sub-tables corresponding to other sub-processes of the service. According to the method and the system, the data of all the sub-processes of the service operated eachtime falls into the same database, so that the realization of distributed transactions is avoided, the development cost and the system risk caused by the distributed transactions are reduced, Meanwhile, the characteristics of the database can be utilized to ensure that the operated service data is successful or failed at the same time.

Description

technical field [0001] The invention relates to the technical field of database transaction processing, in particular to a database transaction processing method and device based on sub-database and sub-table. Background technique [0002] With the development of mobile technology, the Internet has penetrated into all aspects of people's lives, and the share of online economic activities continues to grow. The access of a large number of users and services will inevitably lead to excessive pressure on the system and reduce the response speed of the system, thereby affecting user experience. However, the competition among major e-commerce companies is fierce. If the website response is not timely, or the application has obvious delays, it will lead to poor user experience and even lead to problems such as loss of users. [0003] In some current application systems, because the database is a single database, database performance has become a bottleneck for system performance ...

AI Technical Summary

Problems solved by technology

At present, the above-mentioned situation is generally improved by means of horizontal expansion of the database, but the horizontal expansion of the database will bring difficulties in the implementation of cross-database transactions

This is because, in a single-database environment, multiple rows of data can be operated at one time, and the characteristics of the database (that is, the atomicity of the database) can ensure that the operation succeeds or fails at the same time, but in a multi-database environment, multiple rows of data in one operation may Distributed in different database instances, it is impossible to guarantee the success or failure of operations at the same time through the characteristics of the database. Distributed transactions must be introduced to ensure that a batch of data in the operation succeeds or fails at the same time

However, whether it is introducing middleware or self-developing distributed transactions, the cost is very high

Images