Data writing method and device and data reading method and device

Abstract

Embodiments of the invention provide a data writing method and device and a data reading method and device. The data writing method comprises the following steps of: when an application process in a target server is started or restarted, obtaining main key configuration information from a database, wherein the main key configuration information at least comprises corresponding relationship among data table identifiers of one or more data tables in the database and / or a target server identifier and real-time main key information; storing the main key configuration information in the target server; obtaining business data to be written into a target data table; determining target main key information corresponding to the business data from the main key configuration information, wherein thetarget main key information at least comprises a target data table identifier and / or the target server business and a business data sequence of the business data; and writing the business data into the target data table by adoption of the target main key information, so as to distinguish the main key information, optimize a composition structure of the main key information, enhancing the timeliness of obtaining the main key information and enhancing the persistent business data writing performance.

Description

technical field [0001] The present invention relates to the communication field, in particular to a data writing method, a data writing device, a data reading method, and a data reading device. Background technique [0002] With the development of science and technology, computer systems are becoming more and more complex, and the business pressure that needs to be loaded is increasing. The real-time requirements for computer systems to process business data are also increasing. [0003] At present, computer systems are usually deployed with a multi-application server-single database server architecture. A single database server is naturally under great pressure, especially when business pressure suddenly increases and application servers have high concurrency, which seriously affects the computer system. performance. [0004] The traditional database primary key management is a part of the database management system. Due to the performance of the computer system, especiall...

AI Technical Summary

Problems solved by technology

[0003] At present, computer systems are usually deployed with a multi-application server-single database server architecture. A single database server is naturally under great pressure, especially when business pressure suddenly increases and application servers have high concurrency, which seriously affects the computer system. performance

[0004] The traditional database primary key management is a part of the database management system. Due to the performance of the computer system, especially in the high concurrency scenario of a huge distributed system, the primary key generation and management strategies aggravate the problem of data persistence, resulting in data persistence. The transformation is getting slower and slower, and the business data cannot obtain the primary key in a timely manner, resulting in slower real-time response of the database

Images