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

Data query method and device, computer equipment, storage medium and program product

A computer program and data query technology, applied in the computer field, can solve the problem of error-prone SQL statements, and achieve the effect of reducing the error rate and improving the writing speed.

Pending Publication Date: 2022-04-15
浙江太美医疗科技股份有限公司
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0010] In view of this, the implementation mode of this specification is dedicated to providing a data query method, device, computer equipment, storage medium and computer program products to solve the technical problems that are prone to errors when writing SQL statements in the traditional technology

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 device, computer equipment, storage medium and program product
  • Data query method and device, computer equipment, storage medium and program product
  • Data query method and device, computer equipment, storage medium and program product

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0026] The technical solutions in the embodiments of this specification will be clearly and completely described below in conjunction with the accompanying drawings in the embodiments of this specification. Obviously, the described embodiments are only part of the implementations of this specification, not all of them. Based on the implementations in this specification, all other implementations obtained by persons of ordinary skill in the art without creative efforts fall within the protection scope of this specification.

[0027] see figure 1 , the embodiments of this specification provide a data query system, and the data query method provided in this specification is applied to the data query system. The data query system may include a hardware environment formed by a terminal 110 and a server 120 . The terminal 110 communicates with the server 120 through the network. Terminal 110 provides an editing page for command generation text; wherein, the editing page has an inp...

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 embodiment of the invention provides a data query method and device, computer equipment, a storage medium and a computer program product. The method comprises the following steps: receiving an instruction generation text which cannot be directly executed by a database engine and is used for describing a query task, converting text data which cannot be executed by a computer in the instruction generation text into keywords which can be executed by the computer, and further generating a query instruction; the query task is executed by executing the query instruction, so that the execution result of the query task is obtained, it is avoided that database tables and fields in a database are directly adopted to compile SQL statements, the compiling speed of the SQL statements is increased, and the error rate is reduced.

Description

technical field [0001] The embodiments of this specification relate to the field of computer technology, and specifically relate to a data query method, device, computer equipment, storage medium, and computer program product. Background technique [0002] When querying corresponding data from a relational database, first, programmers can write SQL statements based on the fields in the database to build a data view, and then perform filtering, aggregation, and higher-dimensional analysis and display based on the data view. [0003] In traditional technology, in order to ensure global uniqueness, the fields and data tables in the relational database will use complex expressions. For example, the data table can use D2AD7F823B2E14ECAD3; the data table includes several fields, and the fields can use F2AD7F823B2E15ECAD3, B2E18E9563B2E14E3N80. In order to obtain the data corresponding to the fields F2AD7F823B2E15ECAD3 and B2E18E9563B2E14E3N80 from the data table D2AD7F823B2E14ECAD...

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/2455G06F16/28G06F3/0481G06F3/0484
CPCG06F16/2433G06F16/2455G06F16/284G06F3/0481G06F3/0484
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