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

Query statement generation method and device, computer equipment and storage medium

A query statement generation and query statement technology, applied in the computer field, can solve problems such as increasing user learning costs, and achieve the effect of reducing learning costs

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

[0004] In view of this, the implementation mode of this specification is dedicated to providing a query statement generation method, device, computer equipment, storage medium and computer program products to solve the technical problem of increasing user learning costs for cross-database queries in traditional technologies

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 statement generation method and device, computer equipment and storage medium
  • Query statement generation method and device, computer equipment and storage medium
  • Query statement generation method and device, computer equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0017] 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.

[0018] see figure 1 , the embodiment of this specification provides a data query system, and the query statement generation 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. The server 120 obtains the initial query statement; parses the initial query statement ...

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 query statement generation method and device, computer equipment, a storage medium and a computer program product. The method comprises the following steps: acquiring an initial query statement, calling a query statement analysis service to analyze the initial query statement, and determining a target keyword which is not matched with a target database engine based on an analysis result; further, obtaining a target expression adapted to the target database engine; and replacing the target keyword in the initial query statement with the target expression to obtain a target query statement adaptive to the target database engine, and calling a query statement analysis service to analyze the initial query statement no matter which database engine the initial query statement is adaptive to. Therefore, the same initial query statement can be used for querying in different databases, a developer does not need to learn the compiling language of the target database, and the learning cost of the developer is reduced.

Description

technical field [0001] The embodiments of this specification relate to the field of computer technology, and specifically relate to a query statement generation method, device, computer equipment, storage medium, and computer program product. Background technique [0002] In software engineering, databases are often used to store, read and write large amounts of data efficiently and quickly. The database engine is the core service used to store, process and protect data. Using the database engine can control access rights and quickly process transactions to meet the requirements of most applications that need to process large amounts of data in the enterprise, including creating tables for storing data and database objects for viewing, managing and protecting data security ( such as indexes, views, and stored procedures). [0003] In different relational database management systems (such as Oracle, MySQL), each relational database management system has different database e...

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/2452G06F16/242
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