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

Method and device for generating database query sentences

A query statement and database technology, applied in the computer field, can solve problems such as poor accuracy of query statements, and achieve the effect of improving accuracy

Active Publication Date: 2015-03-25
BEIJING GRIDSUM TECH CO LTD
View PDF4 Cites 10 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The main purpose of the present invention is to provide a method and device for generating database query sentences to solve the problem of poor accuracy when generating database query sentences

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
  • Method and device for generating database query sentences
  • Method and device for generating database query sentences
  • Method and device for generating database query sentences

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0025] It should be noted that, in the case of no conflict, the embodiments in the present application and the features in the embodiments can be combined with each other. The present invention will be described in detail below with reference to the accompanying drawings and examples.

[0026] In order to enable those skilled in the art to better understand the solution of the present application, the technical solution in the embodiment of the application will be clearly and completely described below in conjunction with the accompanying drawings in the embodiment of the application. Obviously, the described embodiment is only It is an embodiment of a part of the application, but not all of the embodiments. Based on the embodiments in this application, all other embodiments obtained by persons of ordinary skill in the art without creative efforts shall fall within the scope of protection of this application.

[0027] It should be noted that the terms "first" and "second" in ...

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 method and a device for generating database query sentences. The method for generating the database query sentences includes acquiring a plurality of preset query objects; acquiring target leaf query objects from a plurality of leaf query objects; determining query columns; adding the query columns and the target leaf query objects into root query objects to obtain target query objects; generating the target database query sentences according to the target query objects. The preset query objects include the root query objects and the leaf query objects. The query columns are used for representing columns corresponding to to-be-queried contents. The method and the device have the advantages that the problem of poor accuracy when database query sentences are generated can be solved by the aid of the method and the device; the query columns and the target leaf query objects are added into the root query objects to obtain the target query objects, the target database query sentences can be generated according to the target query objects, and accordingly an effect of improving the accuracy of the generated database query sentences can be realized.

Description

technical field [0001] The invention relates to the field of computers, in particular to a method and device for generating database query sentences. Background technique [0002] When performing data query on a relational database, it is necessary to use a database query statement, such as a structured query language (Structured Query Language, referred to as SQL), to expand the corresponding data query. At present, there are two main methods of data query using database query statements: one is static query, in which the data related to query conditions is fixed; the other is dynamic query, in which data related to query conditions The relevant data is variable. The static query method can be precompiled and then put into a stored procedure or view. Dynamic query needs to specify different query content according to different user needs. [0003] For dynamic queries, the query content needs to be dynamically constructed before the query is executed. The existing method...

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): G06F17/30
CPCG06F16/2433G06F16/284
Inventor 李亚东
Owner BEIJING GRIDSUM TECH CO LTD
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