Method and device for screening object, electronic device and medium

Abstract

The invention provides a method for screening objects. The method comprises: obtaining a first storage table, wherein the first storage table is used for storing partition information of a plurality of partitions; responding to an obtained screening request, determining whether an unlocked partition exists in the first storage table or not, wherein the screening request comprises at least one screening rule; if the unlocked subarea exists, unlocking the subarea; distributing a partition lock to the screening request, determining a first partition from the unlocked partitions and locking the first partition, and determining at least one second storage table corresponding to the first partition, the second storage table being used for storing object data, the second storage table being usedfor storing the object data, and determining an object satisfying the screening rule based on the object data stored in the at least one second storage table. The invention further provides a device for screening the objects, an electronic device and a computer readable storage medium.

Description

technical field [0001] The present disclosure relates to a method, an apparatus, an electronic device and a medium for screening objects. Background technique [0002] At present, in the process of screening objects in the asset securitization system, traditional databases are used for data storage, and objects are filtered according to different screening conditions. The system program hits the table and row data in the database storage through a database link, and according to the selected part Conditions one by one to determine whether the asset meets the criteria according to the filtering rules. The screening and positioning of objects is completely left to the database program, and the query result set is hit by the SQL statement of the database. [0003] However, in the process of realizing the present invention, the inventor found that in the screening of massive data, the traditional SQL statement cannot achieve fast response and return of the result set, which wil...

AI Technical Summary

Problems solved by technology

[0003] However, in the process of realizing the present invention, the inventor found that in the screening of massive data, the traditional SQL statement cannot achieve fast response and return of the result set, which will seriously slow down the speed of filtering; it cannot be implemented in parallel and must wait Only when a task is filtered can the next task be accessed, otherwise it will lead to serious resource competition within the system

Images