Database writing system and database writing method

Abstract

The invention discloses a database writing system and a database writing method. The system at least comprises a control module, a thread pool, a buffer memory module, a timing scanning module and an asynchronous information processing module. The control module is used for recording writing requests into subtask queues of the tread pool when receiving the writing requests, writing task data into the buffer memory module and transmitting asynchronous requests according to scanning results of the timing scanning module. The thread pool comprises a plurality of subtask queues, and each subtask queue saves a plurality of tasks. The buffer memory module is used for saving the task data. The timing scanning module timely scans the subtask queues in the thread pool to judge whether releasing time comes, judge whether one subtask queue meets the releasing time or not and conduct grouping on data in the subtask queue. The asynchronous information processing module processes the asynchronous requests, receives parameter information of the subtask queues in the releasing process, records the queue tasks and writes corresponding data into a database after monitoring new tasks. By means of the database writing system and database writing method, orderly, efficient and blocking type database writing can be achieved.

Description

technical field [0001] The invention relates to a database writing system and method, in particular to a database writing system and method based on asynchronous fragment cache writing. Background technique [0002] At present, with the development of software technology and the extensive use of database technology, the real-time requirements are getting higher and higher. At this time, high requirements are put forward for the efficiency of the software system in accessing the database. cause a lot of stress. Especially with the development of network technology, in the current WEB2.0 system based on the J2EE (Java 2 Platform, Enterprise Edition) platform, databases are generally required as storage media. When entering, there will often be performance bottlenecks caused by IO, CPU, network, etc. To solve this problem, the traditional optimization schemes either upgrade hardware resources vertically, or expand data servers horizontally. However, with the continuous expans...

AI Technical Summary

Problems solved by technology

[0002] At present, with the development of software technology and the extensive use of database technology, the real-time requirements are getting higher and higher. At this time, high requirements are put forward for the efficiency of the software system in accessing the database. cause a lot of pressure

Especially with the development of network technology, in the current WEB2.0 system based on the J2EE (Java 2 Platform, Enterprise Edition) platform, databases are generally required as storage media. When entering, there will often be performance bottlenecks caused by IO, CPU, network, etc.

In order to solve this problem, traditional optimization schemes either upgrade hardware resources vertically, or expand data servers horizontally. However, with the continuous expansion of the number of users on the WEB platform, the above two optimization schemes will always encounter bottlenecks such as cost and hardware constraints.

[0003] To sum up, it can be seen that there are cost, hardware and other bottleneck constraints in the optimization scheme of database writing technology in the prior art, so it is necessary to propose improved technical means to solve this problem

Images