The invention discloses a self-adaptive range query filtering method,
system and device and a storage medium. The method comprises the steps that each key in an input
data set is segmented into a prefix and a suffix, the keys with the same prefix are divided into the same partition, and each partition comprises the number of the prefixes, the number of the suffixes and suffix arrays arranged in an ascending order; a self-adaptive range filter is constructed, in the construction process, coding is carried out with partitions as units, prefixes are inserted into a
cuckoo filter, suffixes are inserted into a bridge structure, suffix arrays are continuously and compactly stored according to the sparse degree, and compression
processing is carried out; according to the query range, the left boundary and the right boundary are segmented into two prefix-suffix pairs, the corresponding partition is rapidly positioned according to the prefix, range query is executed in the
suffix array of the partition, and the suffix meeting the condition is returned. According to the invention, the self-adaptive range query filter based on fingerprints is realized through key segmentation and a specific coding mode, the inclined
workload can be adaptively coped, and the query performance is improved.