A method and system for transferring data between processes

Abstract

The invention relates to an inter-progress data transfer method and system. The method comprises the steps of S1, establishing a database table, inserting a null control record and a full control record in the database table, and conducting locking respectively; S2, judging the state of a data record quantity before inserting and processing a data record; S3, when the data record quantity reaches a lower limit, pausing a consumer progress, and executing the step S4; when the data record quantity reaches an upper limit, pausing a producer progress, and executing the step S5; when the data record quantity is between the lower limit and the upper limit, inserting the producer progress, and processing the consumer progress; S4, making the producer progress unlock a lock on the null control record to inform the consumer progress, and executing the step S2; S5, making the consumer progress unlock a lock on the full control record to inform the producer progress, and executing the step S2. According to the inter-progress data transfer method and system, the purpose is achieved that CPU resources are saved, and the transfer speed is increased.

Description

Technical field [0001] The invention belongs to the field of data processing, and in particular relates to a method and system for transferring data between processes. Background technique [0002] The existing methods of using database tables to achieve data transfer between processes use the producer process to insert data records into the database table, and the consumer process periodically scans the database table, analyzes the read data records one by one, and then reads the data from the database table after the analysis is successful. Deleted. When there is no data record in the database table, the consumer process uses the following two methods for processing: [0003] The first method is: the consumer process continuously scans the database table repeatedly. Once the producer process successfully inserts data records into the database table without data records, the consumer process can immediately find out, and start to read the data records, perform analysis, etc., but...

AI Technical Summary

Problems solved by technology

This method can effectively solve the problems of high CPU usage and consumer process idling in method 1, but once the producer process inserts a data record into a database table without data records, the consumer process needs to wait after the waiting time is over. The inserted data records can only be found and read, resulting in poor sensitivity of the consumer process to the data records in the database table

[0005] Similarly, when the records in the database table are full, the existing method of using the database table to transfer data between processes also has the problems of high CPU usage, idle process of the producer, and poor sensitivity of the producer to the data records in the database table.

Images