Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Fuzzy query method and system

A technology of fuzzy query and query times, applied in the computer field, can solve problems such as slow query speed, low efficiency, and inability to use index technology, so as to improve efficiency, reduce time complexity, and increase query speed

Active Publication Date: 2013-04-03
SHENZHEN KINGDEE MIDDLEWARE
View PDF5 Cites 14 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, when using the like statement starting with % in SQL to query the data table according to the query keyword, the aforementioned indexing technology cannot be used, but the entire data table must be traversed
This method of traversing the entire data table is very inefficient, and the query speed is very slow, which cannot meet certain query tasks that require real-time performance.

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 and system
  • Fuzzy query method and system
  • Fuzzy query method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0033] Such as figure 1 Shown, in one embodiment, a kind of fuzzy inquiry method comprises the following steps:

[0034] Step S102, establishing a global index on the database table according to the preset mapping relationship between index values ​​and data items.

[0035] The database is composed of multiple database tables, and multiple data records are stored in the database table, and one data record is one data item. For example, two tables, a user information table and an organizational structure table, are stored in the database. The data stored in the user information table is the relevant information of the user; the data stored in the organizational structure table is the relevant information of each department in the company's composition structure.

[0036] In one embodiment, the database tables with frequent query operations and few add, delete and update operations in the database are determined first, and then keywords are defined for data items in these data...

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 relates to a fuzzy query method, which comprises the following steps of: creating a global indexes for a database table based on the mapping relationship between preset index values and data items; sequencing the global indexes; obtaining query keywords, and finding an index interval matched with a query keyword by interval dichotomy; and obtaining the index values in the index interval, obtaining the data items corresponding to the index values based on the mapping relationship, and returning the data items as query results. With the fuzzy query method and system, the low time complexity advantage of a binary search method can be well utilized, and the higher retrieval speed can be exchanged at the expense of a small amount of space complexity, thus the retrieval efficiency is improved.

Description

【Technical field】 [0001] The invention relates to the field of computer technology, in particular to a fuzzy query method and system. 【Background technique】 [0002] Database is a common data persistence solution in the field of computer technology. In the database business operation of traditional technology, some database tables as information providers have frequent query operations, while operations of adding, updating and deleting occur less frequently. In order to improve query efficiency, database tables are usually indexed. The index reduces the time complexity of the query by appropriately increasing the space complexity, thereby improving query efficiency. [0003] Fuzzy query is a common data query requirement in traditional technologies, usually using the like statement in the database query language SQL. However, when querying a data table using a like statement starting with % in SQL according to a query keyword, the aforementioned indexing technology cannot...

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
IPC IPC(8): G06F17/30
Inventor 陈伟君
Owner SHENZHEN KINGDEE MIDDLEWARE
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com