Method for constructing query scheme and executing data query and statistics
A query scheme and data query technology, applied in the field of data query, can solve problems such as heavy workload and difficulty
Inactive Publication Date: 2008-08-20
SHENZHEN GRENTECH CO LTD
View PDF0 Cites 28 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0009] The technical problem to be solved by the present invention is to provide a method that does not need to predict the demand for the defects of the prior art, such as the above-mentioned need to predict the demand, the workload is relatively large, the difficulty of modifying or adding functions is relatively large, and the script cannot be used for secondary development. , less development workload, easier to modify, and a data query and statistical method that can use scripts for one-time development
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 moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0058] Such as figure 1 As shown, in an embodiment of the method for constructing a query scheme and using it for data query and statistics in the present invention, before performing data query and statistics, it is necessary to first construct a query scheme based on multiple queries and statistical data, and These query schemes are stored in the system for users to select and call, and the specific steps to construct the query scheme are as follows:
[0059] S101 Select the subject information corresponding to this query plan from the subject information of the system data: In this embodiment, the system includes multiple query plans, and each query plan has different subject information and specific values, and the rest are basically same. The subject information corresponding to the query plan refers to the relevant data fields involved in the plan, that is, the data information for the data query and statistics of the plan. For example, if the subject information corre...
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
Login to View More Abstract
The invention relates to a method for constructing inquiry plan, comprising the following steps of: selecting subject information corresponding to the inquiry plan in the subject information related in a system database for defining data relationship; setting a condition item set as data selection condition; setting a result item set as the selected result data output format; setting a graph table entry and report item as the result data output mode; storing the subject information and each item, so as to finish construction of an inquiry plan. The invention also discloses a method using the inquiry plan for data inquiry and statistic. The construction inquiry plan of the invention and the method for data inquiry and statistic have the advantage of processing secondary development by using script without forecast demand, with little development, workload, which is easy to modify.
Description
technical field [0001] The invention relates to the field of data query, and more specifically, the invention relates to a method for constructing a query scheme and using it for data query. Background technique [0002] It is the basic requirement of the application program to perform data query and statistical analysis on the data stored in the database according to the business needs, and this data query and statistical analysis are changed. This change usually includes query conditions, changes in query results, and report formats. changes etc. [0003] For this kind of change, people usually adopt the real-time development method, that is, when the user has new data query conditions and changes in the query result data items, the user forms a requirement document, which is sent to the software maintenance personnel, and the maintenance personnel will respond to the requirements. Develop and then upgrade the system. The disadvantage of this method is obvious. Whenever ...
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
Login to View More IPC IPC(8): G06F17/30
Inventor 章文理
Owner SHENZHEN GRENTECH CO LTD