Method for storing and inquiring range data

Abstract

The invention discloses a method for storing and inquiring range data, which comprises the following steps of: 1, data storage: storing a plurality of data into a data table built in a storage device, storing the range data in a single-field storage manner, and correspondingly building a bound range data identification library, an error range data identification library and a region range data identification library; and 2, data inquiry comprising the following procedures of: inputting an inquiring keyword, analyzing and judging the inquiring keyword and inquiring the range data. The invention has the advantages of reasonable design, convenience for data storage and inquiry, and small data processing workload; meanwhile, the method for storing and inquiring the range data accords with the ordinary data storage and inquiry habit of people, visually embodies the link among the data, and can effectively solve the defects that the traditional method for storing and inquiring the range data does not accord with the daily data storage habit of people, is large in data processing workload, difficult to change, inconvenient for inquiry and the like.

Description

technical field [0001] The invention belongs to the technical field of data storage and query, and in particular relates to a method for storing and querying range-type data. Background technique [0002] There are a lot of range-type data in daily work, production and study, and the above-mentioned range-type data also play a vital role. Compared with numerical data, the workload of storage and query of range-type data is very large . Here are a few examples to illustrate: [0003] Example 1: In the current population census, it is necessary to effectively store the valid ID number of the population (that is, the ID card number). This storage is usually stored according to the sub-region of the range data. For example, it is stored by province first, and the identity of Shaanxi Province The ID card number of Henan Province is between 610XXXXXXX-619XXXXXXX, and the provincial ID card number of Henan Province is between 620XXXXXXXX-629XXXXXXXXXX; after that, it is stored ac...

AI Technical Summary

Problems solved by technology

This existing storage method stores data by expanding the space of the table structure, but this storage method has the following practical problems: First, the storage method does not match people's usual habits of storing data, the connection between data is not close and the data The type expression is not intuitive. In actual storage, a continuous data needs to be stored in two fields at 40°C-80°C respectively; secondly, for some data, if you know in advance which type of data it is, which fields should be used for this type of data For the division of processing, it is easy to divide the relevant divisions if the relevant divisions are already clear; but for some unknown data, that is, the data type is not known in advance, if range-type data appears after a large amount of data has been stored, the data structure must be changed, involving a large amount of data Migration and other storage problems,

Images