Fuzzy query method, device and system based on large amount of data

A technology of fuzzy query and large amount of data, which is applied in text database query, special data processing application, unstructured text data retrieval, etc., and can solve problems such as time-consuming, failure to meet user’s usability requirements, and low efficiency of data query, etc. problem, to achieve the effect of improving efficiency

Active Publication Date: 2021-10-26
INDUSTRIAL AND COMMERCIAL BANK OF CHINA
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The traditional fuzzy query method (that is, direct query in oracle through the front and back %, like statement), when the amount of data reaches about 300,000, the query time basically takes 400 milliseconds, and when the amount of data reaches 10 million, it takes longer
[0004] For the traditional fuzzy query method, when the amount of data rises to millions or even tens of millions, directly querying through the database will lead to low data query efficiency, which does not meet the user's usability requirements

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 more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Fuzzy query method, device and system based on large amount of data
  • Fuzzy query method, device and system based on large amount of data
  • Fuzzy query method, device and system based on large amount of data

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0041] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0042] Those skilled in the art know that the embodiments of the present invention can be implemented as a system, device, method or computer program product. Therefore, the disclosure of the present invention can be embodied in the form of complete hardware, complete software (including firmware, resident software, microcode, etc.), or a combination of hardware and software.

[0043] The principle and spirit of the present invention will be explained in detai...

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

No PUM Login to view more

Abstract

The invention provides a fuzzy query method, device and system based on a large amount of data, and relates to the field of computer application. The method includes that the nighttime preprocessing device manages reverse index data and refreshes cached data; the daytime data query device receives a fuzzy query request entered by a user, and carries out a data fuzzy query in combination with the nighttime preprocessing device according to the fuzzy query request. , returning the query result to the user; the daytime data management device caches the query result obtained by the daytime query device, and manages the query result. Through the reverse index preprocessing and query result cache management mode, the present invention avoids full table scan when the amount of data is large, improves the efficiency of data fuzzy query, and solves the problem of fuzzy query directly through the database in the scenario of high concurrency and big data. efficiency issues.

Description

technical field [0001] The present invention relates to the computer application field, and specifically relates to a fuzzy query method based on a large amount of data, a fuzzy query system based on a large amount of data, computer equipment, and a computer-readable storage medium. Background technique [0002] This section is intended to provide a background or context for implementations of the invention that are recited in the claims. The descriptions herein are not admitted to be prior art by inclusion in this section. [0003] In the field of computer software, providing fuzzy query function on input items is a way to improve the usability of the system. Usually, data fuzzy query with small amount of data can be realized directly through the database. A disadvantage of this approach is that it cannot avoid full table scans. Taking oracle as an example, it is generally implemented through a method like ‘%keyword%’. The traditional fuzzy query method (that is, direct...

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
no application Login to view more
Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/33
CPCG06F16/3344
Inventor 邢韬邵一飞李祥曹江波
Owner INDUSTRIAL AND COMMERCIAL BANK OF CHINA
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap