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

Database query method and device and computer readable storage medium

A technology of a query method and a query device, which is applied in the field of database query, can solve problems such as low efficiency of user query data analysis data, and achieve the effect of simplifying the technical process

Pending Publication Date: 2020-06-12
杭州量之智能科技有限公司
View PDF2 Cites 12 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] At present, there is no work at home and abroad to implement a complete set of end-to-end systems. Only the independent work of generating SQL statements from natural language and generating recommended visualization forms based on data tables, the efficiency of users querying and analyzing data is low.

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 query method and device and computer readable storage medium
  • Database query method and device and computer readable storage medium
  • Database query method and device and computer readable storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

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

[0065] like figure 1 As shown, an embodiment of the present invention provides a database query method, which includes the following steps:

[0066] S1. Obtain user input and select a database to be queried.

[0067] The user enters the question to be asked and selects the desired database. In this step, it is necessary to judge whether the input is a normal sentence according to the length of the input sentence and the part of speec...

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 database query method and device and a computer readable storage medium, and the database query method comprises the following steps: S1, obtaining user input and selecting ato-be-queried database; s2, converting user input into SQL statements, and performing database query to obtain a data table; s3, converting the user input and the data table into a visual chart; and S4, displaying the visual chart. According to the database query method and device and the computer readable storage medium, the data query and data analysis efficiency of a user can be improved; whenthe visual form is generated, the use of all data table data is avoided, some sensitive information in the data is prevented from being leaked, and the data security is ensured, so that the data processing speed of the model is increased; and meanwhile, the relation between the modules is enhanced, so that the model can fully understand the input information.

Description

technical field [0001] The present invention relates to the technical field of database query, and in particular, to a database query method, device and computer-readable storage medium. Background technique [0002] Relational databases, as an effective way to store information, are widely used in medical, financial, commercial and other fields, and users obtain this information by using structured query statements. However, although the SQL statement is concise and efficient enough, it still has high learning requirements, and users need to learn it for a long time to master it. Therefore, usually only professional developers have the ability to use SQL to query. At the same time, for the queried data, there is often some connection between the data. If it can be displayed in a visual form, it can help users better analyze the data, and visualization requires sufficient understanding of the data and visualization. The operation has relevant experience, which is also only ...

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/2452G06F16/248G06F16/28G06N3/04G06N3/08
CPCG06F16/24522G06F16/248G06F16/284G06N3/049G06N3/08G06N3/045
Inventor 周慕哲汤斯亮凌立刚
Owner 杭州量之智能科技有限公司
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