Check patentability & draft patents in minutes with Patsnap Eureka AI!

Data query method and system based on distributed SQL (Structured Query Language)

A data query and distributed technology, applied in the field of data query, can solve problems such as low accuracy and slow data query speed, and achieve the effects of improving effectiveness, saving generation process, and reducing reaction time and delay

Active Publication Date: 2022-07-29
华能信息技术有限公司
View PDF11 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] The invention provides a data query method based on distributed SQL to solve the technical problems of slow data query speed and low accuracy in the prior art

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
  • Data query method and system based on distributed SQL (Structured Query Language)
  • Data query method and system based on distributed SQL (Structured Query Language)

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0038] The technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application. Obviously, the described embodiments are only a part of the embodiments of the present application, but not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by those of ordinary skill in the art without creative efforts shall fall within the protection scope of the present application.

[0039] The present application provides a data query method based on distributed SQL, such as figure 1 As shown, the method is applied to a platform including SQL, and the method includes the following steps:

[0040] Step S101: Receive a data query request, and if the data query request is the first query, determine a corresponding query area according to the type of the data query request;

[0041] Step S102, obtaining a query stateme...

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 discloses a data query method based on a distributed SQL (Structured Query Language), which is applied to a platform comprising the SQL, and comprises the following steps: receiving a data query request, and if the data query request is a first query, determining a corresponding query area according to the type of the data query request; obtaining a query statement based on the data query request, splitting the query statement into a plurality of keywords, and selecting data with the highest association degree with the keywords in the query region as an initial query result; and if the initial query result is not unique, selecting a plurality of keywords from the remaining words, and selecting a final query result from the initial query result based on the keywords. The previous query result is recorded in the historical cache region, and the final query result in the historical cache region is directly called, so that the time is saved. Through a keyword association degree and keyword dual query mechanism, data information query is simple and effective, and query efficiency is improved.

Description

technical field [0001] The present application relates to the technical field of data query, and more particularly, to a method and system for data query based on distributed SQL. Background technique [0002] Structured Query Language (SQL) for short, is a special-purpose programming language, a database query and programming language, used to access data and query, update and manage relational database systems. [0003] Structured query languages ​​are high-level non-procedural programming languages ​​that allow users to work on high-level data structures. It does not require the user to specify the storage method of data, nor does it require the user to know the specific data storage method, so different database systems with completely different underlying structures can use the same structured query language as the interface for data input and management. Structured query language statements can be nested, which makes them extremely flexible and powerful. [0004] In ...

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 Applications(China)
IPC IPC(8): G06F16/242G06F16/2455G06F16/2458G06F16/27G06F16/28
CPCG06F16/2433G06F16/24552G06F16/2471G06F16/27G06F16/284
Inventor 王凯强付丽丽冉宇哲韩杰娇范伟宁杨铭谢佩辉
Owner 华能信息技术有限公司
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

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

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