Method, system, device and storage medium for database read-write asynchronous access
A database, asynchronous technology, applied in the field of data processing, can solve problems affecting application service performance and availability, restricting system real-time processing performance, blocking, etc., to reduce read and write operations, increase data volume, and balance CPU and network read and write effect of operation
Active Publication Date: 2020-06-23
CTRIP TRAVEL NETWORK TECH SHANGHAI0
View PDF6 Cites 0 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
The pressure on the application will also increase, and the frequent read and write access to the database seriously affects the service performance and availability of the application
For some systems that require high real-time response to access the database, due to the need to support large-scale concurrent access and be able to respond efficiently, in the database access component, the client's request for data cannot block the service
Database access restricts the real-time processing performance of the system
Method used
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0048] Example embodiments will now be described more fully with reference to the accompanying drawings. Example embodiments may, however, be embodied in many forms and should not be construed as limited to the embodiments set forth herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the concept of the example embodiments to those skilled in the art. The same reference numerals denote the same or similar structures in the drawings, and thus their repeated descriptions will be omitted.
[0049] figure 1 It is a flowchart of the method for database read and write asynchronous access of the present invention. Such as figure 1 As shown, the embodiment of the present invention provides a method for database read and write asynchronous access, comprising the following steps:
[0050] S101. Cache the request data in the request queue first;
[0051] S102. The main thread takes out data from the request queue...
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More PUM
Login to View More Abstract
The invention provides a method, a system and equipment for asynchronous reading and writing accessing of a database and a storage medium. The method comprises the following steps of firstly, cachingrequest data into a request queue; enabling a main thread to read data from the request queue, and distribute to a working thread according to a data routing method; enabling the working thread to obtain request data from a self request queue; judging whether the request queue contains data or not; when the request queue contains data, grouping the request data; judging whether a grouping data mapping set contains retention data or not; when the grouping data mapping set contains retention data, judging whether the grouping data mapping set contains data or not; when the grouping data mappingset contains data, sequentially processing the grouping data in the grouping data mapping set, and correspondingly reading and writing the database; judging whether the reading and writing operation is normal or not; when the reading and writing operation is normal, putting the result produced by a request into a response queue. The method has the advantage that by controlling different states ofasynchronous reading and writing accessing threads of the database and gathering the data, the reading and writing threads can fully utilize the limited system resources to complete more reading and writing requests as much as possible.
Description
technical field [0001] The invention relates to the field of data processing, in particular to a method, a system, a device and a storage medium for asynchronous access of database reading and writing. Background technique [0002] With more and more Internet applications, the business volume has doubled. Then there will be a geometric increase in the amount of data. The pressure on the application will also increase, and the frequent read and write access to the database seriously affects the service performance and availability of the application. For some systems that require high real-time response to access the database, due to the need to support large-scale concurrent access and be able to respond efficiently, in the database access component, the client's request for data cannot block the service. Database access restricts the real-time processing performance of the system. It is necessary to asynchronously and batch process the read and write access to the databa...
Claims
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More Application Information
Patent Timeline
Login to View More Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/2455G06F16/27G06F9/54
CPCG06F9/546G06F9/547G06F16/24552G06F16/27G06F2209/548G06F2209/549
Inventor 周宜兵郑佰云邢钦华
Owner CTRIP TRAVEL NETWORK TECH SHANGHAI0