Database index search method and apparatus, and user terminal

A database and index technology, applied in the field of database search, can solve problems such as inability to use indexes, and achieve the effect of improving query performance

Inactive Publication Date: 2017-09-15
GUANGDONG YOUMAI INFORMATION COMM TECH
View PDF3 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] In order to overcome the deficiencies of the prior art, one of the purposes of the present invention is to provide a database index lookup method, which can solve the problem that the index cannot be used
[0004] The second object of the present

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
  • Database index search method and apparatus, and user terminal
  • Database index search method and apparatus, and user terminal
  • Database index search method and apparatus, and user terminal

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0048] Such as figure 1 Shown, a kind of database index lookup method, it comprises the following steps:

[0049] Step S1, receiving a query instruction, the query instruction includes a character segment to be searched and a query symbol;

[0050] Step S2, according to the character segment to be searched, match one or more corresponding character segments from the sub-segment data storage table, and obtain one or more primary keys correspondingly according to the character segment;

[0051] Step S3, according to one or more primary keys, match one or more records corresponding to the content of the source field from the source table;

[0052] Step S4, correlating and displaying the corresponding primary key, the matched source field content and the matched character segment.

[0053] Wherein, the fragmented data storage table includes the correspondence between character fragments and primary keys; the source table includes the correspondence between primary keys and sourc...

Embodiment 2

[0060] Such as image 3 As shown, it is a virtual device formed in one-to-one correspondence with the method flow of Embodiment 1, that is, a database index search device is provided, which includes the following modules:

[0061] A receiving module, configured to receive a query instruction, the query instruction includes a character segment to be checked and a query symbol;

[0062] A query module, configured to match one or more corresponding character segments from the sub-segment data storage table according to the character segment to be checked, and obtain one or more primary keys correspondingly according to the character segment;

[0063] A matching module, configured to match one or more records corresponding to the content of the source field from the source table according to one or more of the primary keys;

[0064] The association module is used to correlate and display the corresponding primary key, the matched source field content and the matched character fra...

Embodiment 3

[0067] Such as Figure 4 As shown, in order to implement the method flow of Embodiment 1, a physical device is provided, that is, a user terminal, which includes:

[0068] memory for storing program instructions;

[0069] a processor for executing the program instructions to perform the following steps:

[0070] Receive a query instruction, the query instruction includes a character segment to be checked and a query symbol;

[0071] According to the character segment to be checked, one or more corresponding character segments are matched from the sub-segment data storage table, and one or more primary keys are correspondingly obtained according to the character segment;

[0072] According to the one or more primary keys, matching one or more records corresponding to the content of the source field from the source table;

[0073] Correspondingly display the corresponding primary key, the matched source field content and the matched character fragment.

[0074] Wherein, the ...

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 database index search method and apparatus, and a user terminal. The method comprises the steps of receiving a query instruction, wherein the query instruction comprises to-be-searched character segments and a query character; according to the to-be-searched character segments, performing matching in a data segment storage table to obtain one or more corresponding character segments, and correspondingly obtaining one or more main keys according to the character segments; and according to the one or more main keys, performing matching in a source table to obtain records of one or more corresponding source field contents. According to the method and the apparatus, data needed to be searched for is divided into data segments, then the data segments are associated with the source table, and a back wildcard character mode is adopted during query, so that the problem of full table scanning caused by use of Like query in a front wildcard character mode is solved and the query performance is improved.

Description

technical field [0001] The present invention relates to computer software technology, in particular to database search technology. Background technique [0002] When the database uses LIKE query, especially the SQL database, the leading % wildcard (such as: '%abc') will not be able to use the index, which will cause a full table scan and cause performance problems. Currently, full-text search is used to solve this problem. Full-text search is not only complicated to implement, but also many ORMs used in application development do not support full-text search syntax. Even if they do, it is very troublesome to use. Contents of the invention [0003] In order to overcome the deficiencies of the prior art, one of the objectives of the present invention is to provide a method for searching a database index, which can solve the problem that the index cannot be used. [0004] The second object of the present invention is to provide a database index search device, which can solve...

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
CPCG06F16/2468G06F16/245
Inventor 陈强熊严超
Owner GUANGDONG YOUMAI INFORMATION COMM TECH
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