Page based data query method and system thereof

A data query and page technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve the problems of increased development workload and difficulty, complex query conditions, difficult maintenance, etc., and achieve flexible query content , Guarantee usability, and avoid input error problems

Inactive Publication Date: 2010-07-07
CHINA UNIONPAY
View PDF3 Cites 15 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This method can implement complex query conditions, but it is actually based on the intermediate variable settings in the background
This processing method increases the workload and difficulty of development, and the logic is complex and not easy to maintain

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
  • Page based data query method and system thereof
  • Page based data query method and system thereof
  • Page based data query method and system thereof

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0023] figure 1 A schematic flow chart showing the configurable-based optimization query method of the present invention. refer to figure 1 , the optimization query method includes:

[0024] Step 100, authority authentication;

[0025] Step 102, call the storage condition set module and the public query module of authority query, which are mainly used to merge the query result set, user information and organization information into a private storage list, and use the drop-down list to call. For example, click Personal Query, select the name of the user-defined query condition set in the drop-down list box, call its corresponding object list and load it into the configuration condition module, on the other hand, the user can also delete it through the selected query condition set name operate;

[0026] Step 104, loading query condition sets or adding query conditions to form new query condition sets;

[0027] Step 106, configure the query condition, wherein the configurati...

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 page based data query method. The method comprises the following steps: calling saving condition set module of a permission querying part and a public querying part; loading querying conditions; configuring the loaded querying conditions; and verifying and saving the querying conditions. The invention also discloses a data querying system, which at least comprises a calling unit, a loading unit, a configuring unit, a verifying unit and a saving unit, wherein the calling unit is used for calling the saving condition set module of the permission querying part and the public querying part; the loading unit is used for loading the querying conditions; the configuring unit is used for configuring the loaded querying conditions; the verifying unit is used for verifying the querying conditions; and the saving unit is used for saving the querying result set. Compared with the prior querying mode, the page based data querying method and the system thereof not only ensures that the querying range is not restricted, and the content of searched words and sentences are more flexible, but also has reusability which ensures the operation efficiency to be obviously improved.

Description

technical field [0001] The present invention relates to data query and the application of SQL (Structured Query Language: Structured Query Language), in particular to a page-based optimized query method and system. Background technique [0002] The page-based query method has been widely used in various information management systems. For the general query method, it is usually used to select the corresponding logical conditions according to the page fields and combine them into SQL statements to perform query operations on database tables. The query logic is relatively simple, and complex logical business operations cannot be performed. In the traditional information management system, all kinds of information are integrated based on its own business characteristics, and the page query in the general sense is simply matched with the page conditions by selecting fields and operating conditions, and the system returns the result set according to the query conditions. However...

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 CHINA UNIONPAY
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap