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

Method and device for processing query statements

A technology of query statement and processing process, applied in the field of database query, can solve problems such as complex processing process, difficult maintenance, difficult change, etc., to achieve the effect of improving system operation efficiency, improving research and development efficiency, and lowering technical threshold

Inactive Publication Date: 2015-06-17
AEROSPACE INFORMATION
View PDF4 Cites 9 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] 2) The processing process is complicated and inconvenient to maintain
Because of this, these processes are not easy to maintain, nor easy to change to deal with future changes

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 processing query statements
  • Method and device for processing query statements
  • Method and device for processing query statements

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0050] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0051] The problem to be solved by the invention is how to provide a data query solution that is convenient for development and efficient in operation for a large-scale software management system. To solve this problem, we mainly need to solve the following problems: provide parameterization schemes for query statements, schemes for dynamically adding query conditions, schemes for paging queries, and schemes for sorting and grouping. At the same time, the focu...

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 device for processing query statements. The method for processing the query statements comprises six continuous processing procedures of query condition dynamic addition, query parameter switch, query statement analysis, a paging query function, a sorting function and a grouping function, a user can choose which procedure to use and which procedure not to use freely through configuring a usage scheme in use of the processing procedures, but an established sequence must be followed; after the usage scheme is determined, when the user submits the query statements and a parameter set, the method for processing the query statements can perform the processing procedures of each query statement according to the usage scheme; when all the processing procedures of the query statement are finished, new query statements and a new parameter set are generated, and the new query statements and the new parameter set are submitted to a query module to execute query.

Description

technical field [0001] The invention relates to the field of database query, in particular to a method and device for processing query sentences. Background technique [0002] At present, various large-scale web (network) systems and large-scale information management systems on the market generally have large-scale database query requirements. In the past, database queries were usually hard-coded in each functional module. However, with the development of software technology, more and more software systems are trying to adopt platform development in order to reduce the overall R&D cost and R&D cycle. Under such an overall background, various general query schemes were born. An important technical issue that can hardly be bypassed in all general query schemes is a series of processing procedures for query statements, such as dynamically adding query conditions to original query statements, performing parameter processing, paging, sorting, grouping, etc. . [0003] Under s...

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
Inventor 范钢宋颖
Owner AEROSPACE INFORMATION
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