Query method and query system based on general query language

A general query and query method technology, applied in special data processing applications, instruments, electrical digital data processing, etc., can solve problems such as limitations of optimization effects

Pending Publication Date: 2020-11-27
HANGZHOU SHUYUN INFORMATION TECH CO LTD
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Existing big data query engines each have their own implementation methods for data query performance optimization, and each has its own focus. A

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
  • Query method and query system based on general query language
  • Query method and query system based on general query language

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0027] The present invention will be further described in detail below in conjunction with the accompanying drawings and specific embodiments.

[0028] A query method based on a general query language, comprising the following steps:

[0029] S1. Analyze the structured query, convert the query content into a relational algebra expression, and obtain the query characteristics of the relational algebra expression by analyzing the relational algebra expression;

[0030] S2. Match the characteristics of the query engine with the query characteristics of the obtained relational algebra expression, calculate the cost required by each query engine to satisfy the query characteristics, and select the query engine with the smallest cost;

[0031] S3. After selecting the query engine, optimize the relational algebra expressions by using the query optimization rules bound to the query engine, and at the same time, perform query optimization for the query features that differ between 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 provides a query method and a query system based on a general query language, and belongs to the technical field of query engines. The method comprises: converting query content into a relational algebra expression, and obtaining query features of the relational algebra expression by analyzing the relational algebra expression; matching the query engine features with the query features, calculating the cost required by each query engine for meeting the query features, and selecting the query engine with the minimum cost; performing query optimization on the relational algebraic expression by using a query optimization rule bound with a query engine, and performing related query feature rewriting at the same time; calling a specific query engine adaptation service for the rewritten query features, converting the query features into a query language of a target engine, and submitting the target query language to the query engine for query to obtain a query result; and writing the query result into an external storage module, notifying a user that the query is finished, and acquiring the query result by the user through access connection.

Description

technical field [0001] The invention belongs to the technical field of query engines, and in particular relates to a query method and a query system based on a general query language. Background technique [0002] With the rapid development of big data technology, traditional data query methods can no longer meet the requirements for data query performance under massive data. As a result, various data query engines based on big data architectures have emerged, such as ElasticSearch, HIVE, and NoSQL. [0003] This type of professional big data query engine plays a very important role in solving the performance of big data query, and solves the problem of big data query performance to a certain extent. However, different query engines focus on different problems to be solved, so in different scenarios, different query engines have different advantages. Existing big data query engines each have their own implementation methods for data query performance optimization, and each...

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): G06F16/242G06F16/2453
CPCG06F16/2433G06F16/2453
Inventor 郭祖凯秦建伟
Owner HANGZHOU SHUYUN INFORMATION TECH CO LTD
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