A method and device for fast data query
A data and fast technology, applied in the field of data query, can solve problems such as inability to meet data processing, affect system performance, increase system overhead, etc., and achieve the effect of reducing the number of data traversals, reducing query time, and improving speed
Active Publication Date: 2022-04-22
SUZHOU METABRAIN INTELLIGENT TECH CO LTD
View PDF0 Cites 0 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
But this is not enough to handle all data
For example, if the data does not have a Key, all fields must be compared. If you need to find some of the data in the form of full field comparison during data query, traversing all the data one by one will increase the system overhead and time-consuming
Another example is that one of the fields in a piece of data is a special character "*" or a null character, etc. When comparing such data, it needs to be treated specially, which will seriously affect the performance of the system
Method used
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0039] While the invention may be embodied in various forms, some exemplary and non-limiting embodiments are shown in the drawings and will be described below, it should be understood that the disclosure is to be considered as an example of the invention and not It is intended that the invention be limited to the specific embodiments described.
[0040] figure 1 A schematic block diagram of an embodiment of the method for fast data query according to the present invention is shown. In the embodiment shown in the figure, the method at least includes the following steps:
[0041] S1: The query data and the data in the data set to be matched are respectively templated and abstracted according to the character type;
[0042] S2: Calculate key values for each templated abstract result;
[0043] S3: Extract all data with the same key value as the key value of the query data from the data set to be matched to form a secondary matching data set;
[0044] S4: Traverse the seconda...
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More PUM
Login to View More Abstract
The present invention relates to a method and device for fast data query, wherein the method includes the following steps: template-based abstraction is performed on query data and data in a data set to be matched according to character types; key values are respectively calculated for each template-based abstraction result ; Extract all data with the same key value as the key value of the query data from the data set to be matched to form a secondary matching data set; traverse the secondary matching data set according to the query business of the query data to find data that meets the query conditions. By using the method of the invention, fast data search can be performed for different types of data sets to be matched, corresponding data can be accurately matched, search time is reduced, and search efficiency is correspondingly improved.
Description
technical field [0001] The invention relates to the technical field of data query. The present invention further relates to a method and device for fast data query. Background technique [0002] Now, with the increase of system resource data and the amount of data, the execution time for data query will become longer and longer, and the pressure of data query will also increase accordingly. At present, most systems will search according to the Key corresponding to a piece of data when processing queries. But this is not enough to handle all data. For example, if the data does not have a key, all fields must be compared. If you need to find some of the data in the form of full field comparison during data query, traversing all the data one by one will increase the system overhead and time-consuming. Another example is that one of the fields in a piece of data is a special character "*" or a null character, etc. When comparing such data, it needs to be treated specially, wh...
Claims
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More Application Information
Patent Timeline
Login to View More Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/2453
CPCG06F16/2453
Inventor 岳耀强
Owner SUZHOU METABRAIN INTELLIGENT TECH CO LTD