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

A query optimization method and device

A query optimization and query request technology, applied in the field of data query, can solve limited problems and achieve high retrieval efficiency

Active Publication Date: 2019-03-08
NEW FOUNDER HLDG DEV LLC +1
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Although it has certain effects, it only improves query efficiency from one aspect, which is limited after all.

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
  • A query optimization method and device
  • A query optimization method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0050] Such as figure 1 As shown, this embodiment provides a query optimization method, including the following steps:

[0051] S1: Obtain search terms;

[0052] S2: Acquiring the keywords matching the search terms and the priority of the keywords;

[0053] S3: Execute retrieval according to keywords and their priorities;

[0054] S4: Obtain the retrieval time after the retrieval is completed;

[0055] S5: Obtain the retrieval time of the last retrieval using the keyword;

[0056] S6: Judging whether the current retrieval time is longer than the previous retrieval time, if yes, lower the priority of each keyword in the current retrieval; otherwise, increase the priority of each keyword in the current retrieval.

[0057] In the query optimization method provided by this embodiment, after each query, the difference between the current retrieval time and the previous retrieval time using the same set of keywords will be analyzed, and the priority of the keywords participating...

Embodiment 2

[0075] Such as figure 2 As shown, this embodiment provides a query optimization device, including:

[0076] The first obtaining unit U1 is used to obtain search terms;

[0077] The second acquisition unit U2 is used to acquire the keywords matching the search terms and the priority of the keywords;

[0078] A retrieval unit U3, configured to perform retrieval according to keywords and their priorities;

[0079] The third obtaining unit U4 is used to obtain the retrieval time after the retrieval is completed;

[0080] The fourth acquisition unit U5 is used to acquire the retrieval time of the last keyword retrieval;

[0081] The priority adjustment unit U6 is used to judge whether the current retrieval time is longer than the previous retrieval time, and if so, lower the priority of each keyword in the current retrieval; otherwise, increase the priority of each keyword in the current retrieval.

[0082] The query optimization device provided in this embodiment, after each ...

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

A query optimization method and device are provided; the method comprises the following steps: obtaining a retrieval word; obtaining keywords matched with the retrieval word and the priority of the keywords; executing the retrieval step according to the keywords and the priority; obtaining the retrieval time after the retrieval step is finished; obtaining the retrieval time of the previous time using the keywords to retrieve; determining whether the retrieval time is bigger than the previous retrieval time or not, if yes, lowering priority of each keyword of the present retrieval step; otherwise lifting the priority of each keyword of the present retrieval step. After each query, the method and device will analyze the difference between the present and previous retrieval time using the same keyword for retrieval, thus modifying the retrieval keyword priority according to the result. Along with the rising retrieval frequency, the priority of each keyword will become more reasonable, and retrieval efficiency becomes higher and higher.

Description

technical field [0001] The invention relates to the technical field of data query, in particular to a query optimization method and device. Background technique [0002] Resource Description Framework (RDF) is a markup language for users to describe web resources. It is very inclusive. More and more fields such as social networks and knowledge graphs use RDF graph databases. SparQL is a standard query language for RDF graph data, but unlike traditional relational database queries, SparQL queries are more complex. For the same query, query conditions are organized in different order, and retrieval efficiency varies greatly. Therefore, in order to improve retrieval efficiency, optimization processing is required. [0003] Most of the existing SparQL query optimizations improve query efficiency from the aspect of distributed parallel query. Although it has certain effects, it is limited to improve query efficiency only from one aspect. Contents of the invention [0004] Th...

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/2453
CPCG06F16/8365
Inventor 孙伟孟令彬黄树红
Owner NEW FOUNDER HLDG DEV LLC
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