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

Dynamic query sentence processing method and device

A query statement and processing method technology, applied in the field of database query, can solve problems such as heavy workload and affect program running efficiency, and achieve the effect of easy-to-use function support and flexible function support

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

AI Technical Summary

Problems solved by technology

This method has a large workload and affects the efficiency of program operation.

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
  • Dynamic query sentence processing method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

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

[0036] The focus of the invention is to provide developers with a convenient, fast and flexible data query solution. Usually, there is a need for large-scale database query in various large-scale web systems and large-scale information management systems, and the function of user input filter conditions is provided for various report queries. In these query reports, the system may provide users with many filter conditions, but users may only use one or several...

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 dynamic query sentence processing method and device. The method includes the steps that a configuration file is set, wherein the configuration file is used for defining mark key words needed for query sentences and should comprise at least one configuration item, and each configuration item comprises a mark key word name and an expression of the mark key word name; after receiving the query sentences and query parameter sets transmitted by clients, the mark key words are searched for according to marks in the query sentences, and the corresponding mark key word names and the query expressions of the mark key word names are found from the configuration file; if the marks corresponding to the mark key words exist in the query parameter sets, the original query sentences are replaced according to the determined mark key word names and the query expressions of the mark key word names, the matched marks in the original query sentences are converted into query expressions, and if the marks corresponding to the mark key words do not exist in the query parameter sets, the marks in the original query sentences are removed; through the mode, new query sentences are obtained.

Description

technical field [0001] The invention relates to the field of database query, in particular to a dynamic query sentence processing method and device thereof. 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 to dynamically add filter conditions to query statements. [0003] Usually, in this type of system, the function of inputting filtering conditions for users is provided for all kinds of report queries. ...

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): 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