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, the workload is very heavy and errors are prone to occur; moreover, the above-mentioned existing data storage methods are time-consuming in data query, because the values ​​​​of the two fields need to be compared, and the query results Set storage is not very convenient

At the same time, when the above method stores data, each operation must first split the data (that is, first split the upper and lower limits of the data) before storing the data

Therefore, this existing data storage method is not in line with people's usual habit of storing data, and it is not easy to show the internal relationship between data intuitively. Using multiple fields to store at the same time will cost a lot of storage space.

In addition, the above-mentioned existing storage methods have a general disadvantage: if the data type is not known in advance, it is very troublesome to modify the data structure of the table in the future

Images