CN102436503A - Data condition filtering and screening method and screener - Google Patents

Data condition filtering and screening method and screener Download PDF

Info

Publication number
CN102436503A
CN102436503A CN2011104363602A CN201110436360A CN102436503A CN 102436503 A CN102436503 A CN 102436503A CN 2011104363602 A CN2011104363602 A CN 2011104363602A CN 201110436360 A CN201110436360 A CN 201110436360A CN 102436503 A CN102436503 A CN 102436503A
Authority
CN
China
Prior art keywords
parameter
data
condition
filtering screening
filtering
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN2011104363602A
Other languages
Chinese (zh)
Inventor
贾晓霞
傅永财
李淑惠
郑扬飞
吕建波
金辉
郭红钰
李兰辉
郭彦义
胡春波
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
CETC 15 Research Institute
Original Assignee
CETC 15 Research Institute
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by CETC 15 Research Institute filed Critical CETC 15 Research Institute
Priority to CN2011104363602A priority Critical patent/CN102436503A/en
Publication of CN102436503A publication Critical patent/CN102436503A/en
Pending legal-status Critical Current

Links

Images

Abstract

The invention discloses a data condition filtering and screening method and a screener. The method comprises the following steps of: receiving the data to be searched from the data table selected by user; aiming at each data required to filter and screen in the data to be searched, receiving the filtering and screening condition arranged for the data to be searched by user and forming the sub-condition of filtering and screening; receiving the logic operation symbol between every sub-condition of filtering and screening input by user, generating the self-defined filtering and screening condition; performing the data search according to the self-defined filtering and screening condition, obtaining the searching result. For the invention can provide the data in the data table for user, and user sets the filtering and screening condition, the data search is performed according to the self-defined filtering and screening condition; thus when user changes the searching request, user can automatically define the new filtering and screening condition; the software re-design and development are not in need, thereby greatly saving the labor and material and avoiding the frequently work of updating software.

Description

Data qualification filtering screening method and screening washer
Technical field
The present invention relates to computer technology, relate in particular in the data processing condition filter method for screening and device data.
Background technology
The core of infotech is the processing to data, and screening is a common demand of data processing to the condition filter of data.In information industry, all there is the business demand of carrying out the condition filter screening to data in a lot of infosystems, and the condition filter screening of various ways also is one of function of these VS .NET Prerequisites.
Existing condition filter screening washer mostly is the fixedly screening washer of on the basis of understanding customer demand, being made by the software developer, can only screen according to the fixing filtercondition of prior establishment.For example, certain software provides in initial version the function of certain information according to the time period screening, the demand of in software development, just only screening according to the time so, design and relevant logical code; Usually way will produce one according to the beginning and ending time, and the function to certain information is inquired about calls this function on the interface; And input parameter; This function sends querying command to database or other data sources, and the result that will return is committed to the interface, by interface display.
But, after online implementing operation a period of time,, need on the basis of original function, when utilizing temporal filtering, also to increase function according to the title screening if the client proposes.This just need begin from analyzing customer demand, and software is upgraded.Detailed process comprises: in the software query interface, increase input frame, in software, increase the function call to the title screening, pass through through test, submit the software of redaction to, carry out activities such as software upgrading.From the investigation customer demand, to renewal, the issue of software, process is complicated, and complex steps takies a large amount of manpower and materials.When the software demand side often changed the demand of renewal to multiple user's diversified demand or user, this way will be brought more serious consumption.
This way must be by software developer's updating maintenance filtering screening function when the changeable customer demand of dealing with complicated, and this mainly relies on Communication with Customer and frequent software upgrading; Process is more loaded down with trivial details; The duplication of labour is many, and the construction cycle is long, and has increased the weight of the risk and the burden of software development.
Summary of the invention
The embodiment of the invention provides a kind of data qualification filtering screening method and screening washer, in order to data qualification filtering screening demand complicated and changeable, avoids the work of frequent updating software.
A kind of data qualification filtering screening method comprises:
Be used for receiving the data to be checked of the tables of data that the user selects;
To each need carry out the data of filtering screening in the said data to be checked, receiving the user is the set filtering screening conditions of these data, forms sub-filtering screening condition;
Logical operator between each sub-filtering screening condition of reception user input generates self-defined formula filtering screening condition;
With need in Query Result, carrying out data presented as first parameter in the said data to be checked, the table name of said tables of data is as second parameter, and said self-defined formula filtering screening condition is as the 3rd parameter;
First, second and third parameter is imported in the querying command of database, and called this querying command, obtain Query Result.
Said querying command is specially:
Select parameter A from B parameter where parameters C; Wherein,
First parameter is imported parameter A into, and second parameter is imported B parameter into, and the 3rd parameter is imported parameters C into.
Said user is the set filtering screening conditions of these data to be checked, specifically comprises: data operation symbol and constrained parameters.
Said obtain Query Result after, also comprise:
First parameter, second parameter, the 3rd parameter are preserved as the modular filter screening conditions; And,
In the time need obtaining the Query Result under these modular filter screening conditions next time, behind the constrained parameters of reception user input, in order to replace the constrained parameters in the 3rd parameter; And with first and second parameter, and the 3rd parameter of having replaced constrained parameters imports in the said querying command, calls this querying command, obtains Query Result.
Before the self-defined formula filtering screening of said generation condition, also comprise:
Receive the bracket that the user imports between sub-filtering screening condition; And,
Also, generate said self-defined formula filtering screening condition according to the bracket between the sub-filtering screening condition.A kind of data qualification filtering screening device comprises:
Custom condition filtering screening module is used for receiving the data to be checked of the tables of data that the user selects; To each need carry out the data of filtering screening in the said data to be checked, receiving the user is the set filtering screening conditions of these data, forms sub-filtering screening condition; Logical operator between each sub-filtering screening condition of reception user input generates self-defined formula filtering screening condition;
Pacing items filtering screening module is used to receive first parameter, second parameter, the 3rd parameter that said custom condition filtering screening module is imported into; And first, second and third parameter imported in the querying command of database, call this querying command, obtain Query Result; Wherein, first parameter is need in Query Result, carry out data presented in the said data to be checked, and second parameter is the table name of said tables of data, and the 3rd parameter is said self-defined formula filtering screening condition.
Said user is the set filtering screening conditions of these data to be checked, specifically comprises: data operation symbol and constrained parameters.
Said screening washer also comprises: combined type condition filtering screening module; And,
Said custom condition filtering screening module also is used for first parameter, second parameter, the 3rd parameter are saved in said combined type condition filtering screening module as the modular filter screening conditions;
After said combined type condition filtering screening module is used to receive the constrained parameters of user's input, in order to replace the constrained parameters in the 3rd parameter; And with first and second parameter, and the 3rd parameter of having replaced constrained parameters imports in the said querying command, calls this querying command, obtains Query Result.
Said pacing items filtering screening module also is used for the data that provide said tables of data can supply the user to select to said custom condition filtering screening module.
The embodiment of the invention is receiving the filtering screening condition that the user sets up on their own to each data to be checked owing to can select data to be checked voluntarily by the user for the user provides the data in the tables of data; After forming the filtering screening condition of final self-defined formula, carry out data query according to the filtering screening condition of this self-defined formula, thereby; When the user changes query demand; The user can define new filtering screening condition voluntarily, needn't design again, develop software, and has practiced thrift manpower and materials greatly; Avoid the work of frequent updating software, significantly reduced software development cost.
Further; Also user-defined filtering screening condition is preserved in the embodiment of the invention; When next user need carry out data query under this self-defining filtering screening condition, the user only need access this self-defining filtering screening condition, and the constrained parameters in the condition once are set; Can realize inquiry, further facilitate the user.
Description of drawings
Fig. 1 is the synoptic diagram of the tables of data table1 of the embodiment of the invention;
Fig. 2 is the structural representation of the data qualification filtering screening device of the embodiment of the invention;
Fig. 3 generates the method flow diagram of self-defined filtering screening condition for the custom condition filtering screening module of the embodiment of the invention.
Embodiment
The basic ideas customized justice of a kind of user that the embodiment of the invention provides, knockdown data filter triage techniques scheme are: the interface that defines the filtering screening condition voluntarily is provided for the user; Carry out the tables of data of data query to needs, can guide and receive the filtering screening condition of definition voluntarily of user's input.This interface provides the data in the tables of data for the user, and the user can therefrom select data to be checked; This interface can also be directed against each user-selected data to be checked, and receiving the user is the set filtering screening conditions of these data to be checked, forms sub-filtering screening condition; This interface can also receive the logical operator between each sub-filtering screening condition of user input, generates self-defined formula filtering screening condition.Above-mentioned sub-filtering screening condition specifically comprises: data operation symbol and constrained parameters.
After obtaining self-defined formula filtering screening condition; Need in Query Result, carry out data presented in the data to be checked that the user is selected as first parameter; As second parameter, self-defined formula filtering screening condition is as the 3rd parameter by the table name of data query table; First, second and third parameter is imported in the querying command that database supports, and called this querying command, thereby obtain Query Result.In the scheme of the embodiment of the invention, supported the function of User Defined filtering screening condition, needn't, each filtering screening condition develop software again when changing to some extent, practiced thrift manpower and materials greatly, avoided the work of frequent updating software.
Further, after generating self-defined formula filtering screening condition, can also the first above-mentioned parameter, second parameter, the 3rd parameter be preserved as the modular filter screening conditions.In the time need obtaining the Query Result under these modular filter screening conditions next time, do not need the user to repeat to select data to be checked, and the filtering screening condition of each data to be checked, only need to receive the constrained parameters that the user imports.Behind the constrained parameters that received user's input, in order to replace the constrained parameters in the 3rd parameter; And with first and second parameter, and the 3rd parameter of having replaced constrained parameters imports in the querying command that database supports, calls this querying command, obtains Query Result.Like this, can convenience further be provided for the user: for user's filtering screening condition of self-defined mistake once, the user can re-define, and only needs an input constraint parameter to get final product.
Introduce the concrete scheme of the embodiment of the invention in detail below in conjunction with accompanying drawing.Suppose; To tables of data table1 as shown in Figure 1; The data qualification filtering screening device (as shown in Figure 2) that adopts the embodiment of the invention to provide realizes that the user defines the filtering screening condition voluntarily, inquires about in tables of data table1 according to this filtering screening condition, obtains Query Result.
The data filter screening washer 200 that the embodiment of the invention provides comprises: pacing items filtering screening module 201, custom condition filtering screening module 202.
Custom condition filtering screening module 202 is used for receiving the data to be checked of the tables of data that the user selects; Need carry out the data of filtering screening in the said data to be checked each, receiving the user is the selected filtering screening conditions of these data, forms sub-filtering screening condition; Logical operator between each sub-filtering screening condition of reception user input generates self-defined formula filtering screening condition.Custom condition filtering screening module 202 is with need in Query Result, carrying out data presented as first parameter in the said data to be checked; The table name of tables of data is as second parameter, and self-defined formula filtering screening condition the 3rd parameter is imported in the pacing items filtering screening module 201 as the 3rd parameter.
Concrete, custom condition filtering screening module 202 realizes the step of above-mentioned functions, process flow diagram is as shown in Figure 3, comprises the steps.
In step S301, the data to be checked in the tables of data that custom condition filtering screening module 202 reception users select.User or software maintenance personnel are according to query demand; Selection needs the data of inquiry; Like " table1. time ", " table1. title ", " table1. content ", " table1. quantity ", " table1. remarks ", " table2. another name " etc.; Wherein, " table2. another name " is used for joining the table inquiry with " table1. title ".
In step S302; Each need carry out the data of filtering screening in the data to be checked that custom condition filtering screening module 202 is selected to user among the step S301; Receiving the user is the set filtering screening conditions of these data, forms sub-filtering screening condition.User or software maintenance personnel are to the data of selecting among the step S301 to be checked, and the filtering screening condition of selection specifically comprises: data operation symbol and constrained parameters.User or software maintenance personnel are to each data to be checked of selecting among the step S301; Select the data operation symbol earlier; Comprise: arithmetic operator and data operation function; As being directed against " table1. time " selection ">=", being directed against " table1. time " selection "<=", to " table1. title " selection "=".And then; User or software maintenance personnel are to each data to be checked of selecting among the step S301; Input constraint parameter again: as constrained parameters 1 being set to " table1. time " ">="; To " table1. time " "<=" constrained parameters 2 are set, are set to constrained parameters 3 " table2. another name " to " table1. title " "=".Like this, be provided with data operation symbol and constrained parameters to each data to be checked after, be these data to be checked and be provided with a filtering screening condition, form a sub-filtering screening condition.
In step S303, the logical operator between each sub-filtering screening condition of custom condition filtering screening module 202 reception user inputs generates self-defined formula filtering screening condition.Each sub-filtering screening condition that will be generated by logical operator conspires to create a comprehensive filtering screening condition, thereby forms final self-defined formula filtering screening condition.Logical operator between each sub-filtering screening condition can comprise: with (and) or (or), XOR (nor) etc.The user can input arithmetic logic between sub-filtering screening condition outside the symbol, can also import bracket, in order to the priority ranking of partitioned operation, thereby generates self-defined formula filtering screening condition.For example; Suppose to be set to " and " according to the relation between this a little filtering screening condition of query demand, the final self-defined formula filtering screening condition that then forms is: (table1. time>=constrained parameters 1and table1. time<=constrained parameters 2) and table1. title=table2. another name.
In step S304, first parameter that custom condition filtering screening module 202 will generate, second parameter, the 3rd parameter are imported in the pacing items filtering screening module.Concrete; Custom condition filtering screening module 202 is with need in Query Result, carrying out data presented as first parameter in the data of selecting among the step S301 to be checked; The table name of tables of data is as second parameter, and self-defined formula filtering screening condition the 3rd parameter is imported in the pacing items filtering screening module 201 as the 3rd parameter.For example, in the above-mentioned example, first parameter is " table1. time, table1. title, table1. content, table1. quantity, table1. remarks "; Second parameter is " table1 "; The 3rd parameter is " table1. time>=constrained parameters 1and table1. time<=constrained parameters 2and table1. title=table2. another name ".
Pacing items filtering screening module 201 is used to be received from first parameter, second parameter, the 3rd parameter that definite condition filtering screening module 202 is imported into; And first, second and third parameter imported in the querying command of database, call this querying command, obtain Query Result.Particularly, first, second and third parameter is imported into respectively among parameter A in the querying command " Select parameter A from B parameter where parameters C ", B, the C.For example; First, second and third parameter in the above-mentioned example is imported parameter A, B, the C in the querying command " Select parameter A from B parameter where parameters C " into; Obtain querying command and be " select (table1. time, table1. title, table1. content; table1. quantity, table1. remarks) from (table1) where ((table1. time>=constrained parameters 1and table1. time<=constrained parameters 2) and table1. title=table2. another name) ".Querying command " Select parameter A from B parameter where parameters C " often has database query command for those skilled in the art, calls this database query command, can obtain Query Result.Except querying command " Select parameter A from B parameter where parameters C "; Those skilled in the art also can order according to other of database and realize inquiry; Do not enumerate one by one, for realizing that the querying command of inquiring about under the self-defining filtering screening condition all should be regarded as protection scope of the present invention according to the technical scheme of the embodiment of the invention here.
Be received from first parameter, second parameter, the 3rd parameter that definite condition filtering screening module 202 is imported in pacing items filtering screening module 201; And first, second and third parameter imported in the querying command of database; Call this querying command; After successfully obtaining Query Result, pacing items filtering screening module 201 is returned Query Result to custom condition filtering screening module 202, shows Query Result by custom condition filtering screening module 202 to the user.
Further, in above-mentioned steps S301, select in first parameter of input,, can also be included in the data after the computing that shows in the Query Result except need in Query Result, carrying out data presented in the data to be checked.For example, the user need to have selected the data of computing, like " table1. quantity ", and has selected this operation of data mode like " sum " (summation), and is provided with after computing the data after the computing that needs output shows: " total amount ".Data after this computing can not be the data in the tables of data, but the data that the user defines voluntarily are used for representing certain operation result.For example, the data after the computing that the user defines voluntarily " total amount " are to be used for representing the operation result to after the summation of table1. quantity.First parameter that has increased the data after the computing in the above-mentioned example is " table1. time, table1. title, table1. content, table1. quantity, table1. remarks, (sum (table1. quantity) as total amount) "; After importing first, second and third parameter into querying command; The querying command that forms be " select (table1. time; table1. title, table1. content, table1. quantity; table1. remarks), (sum (table1. quantity) as total amount)) from (table1) where ((table1. time>=constrained parameters 1 and table1. time<=constrained parameters 2) and table1. title=table2. calls) ".After calling this querying command, in Query Result, will demonstrate the calculated value of data " total amount ".
Further, custom condition filtering screening module 202 obtains the data that can supply the user to select in the tables of data through visit pacing items filtering screening module 201; That is to say; Pacing items filtering screening module 201 can also provide alternative data in the tables of data for custom condition filtering screening module 202; Provide to the user through the interface by custom condition filtering screening module 202 again, thereby the user can select data to be checked in the tables of data.
More excellent, in data filter screening washer 200, can also comprise: combined type condition filtering screening module 203.
In pacing items filtering screening module 201 after custom condition filtering screening module 202 is successfully returned Query Result; Custom condition filtering screening module 202 sets up the user on their own through the interface filtering screening condition is saved in the combined type condition filtering screening module 203; Like this; When using this filtering screening condition to carry out data query next time, needn't re-define, further made things convenient for the user.Particularly; First parameter that custom condition filtering screening module 202 will generate, second parameter, the 3rd parameter are saved in the combined type condition filtering screening module 203 as modular filter screening conditions; And can name called after " filtering screening condition 1 " for example for it.
When using these modular filter screening conditions to inquire about next time; The user selects " filtering screening condition 1 " through combined type condition filtering screening module 203; And the constrained parameters in the 3rd parameter are set; After then combined type condition filtering screening module 203 receives the constrained parameters of user's input, in order to replace the constrained parameters in the 3rd parameter in " filtering screening condition 1 "; And with first and second parameter in " filtering screening condition 1 ", and the 3rd parameter of having replaced constrained parameters imports in the above-mentioned querying command, calls this querying command, obtains Query Result.
The embodiment of the invention is receiving the filtering screening condition that the user sets up on their own to each data to be checked owing to can select data to be checked voluntarily by the user for the user provides the data in the tables of data; After forming the filtering screening condition of final self-defined formula, carry out data query according to the filtering screening condition of this self-defined formula, thereby; When the user changes query demand; The user can define new filtering screening condition voluntarily, needn't design again, develop software, and has practiced thrift manpower and materials greatly; Avoid the work of frequent updating software, significantly reduced software development cost.
Further; Also user-defined filtering screening condition is preserved in the embodiment of the invention; When next user need carry out data query under this self-defining filtering screening condition, the user only need access this self-defining filtering screening condition, and the constrained parameters in the condition once are set; Can realize inquiry, further facilitate the user.
One of ordinary skill in the art will appreciate that all or part of step that realizes in the foregoing description method is to instruct relevant hardware to accomplish through program; This program can be stored in the computer read/write memory medium, as: ROM/RAM, magnetic disc, CD etc.
The above only is a preferred implementation of the present invention; Should be pointed out that for those skilled in the art, under the prerequisite that does not break away from the principle of the invention; Can also make some improvement and retouching, these improvement and retouching also should be regarded as protection scope of the present invention.

Claims (10)

1. data qualification filtering screening method comprises:
Be used for receiving the data to be checked of the tables of data that the user selects;
To each need carry out the data of filtering screening in the said data to be checked, receiving the user is the set filtering screening conditions of these data, forms sub-filtering screening condition;
Logical operator between each sub-filtering screening condition of reception user input generates self-defined formula filtering screening condition;
With need in Query Result, carrying out data presented as first parameter in the said data to be checked, the table name of said tables of data is as second parameter, and said self-defined formula filtering screening condition is as the 3rd parameter;
First, second and third parameter is imported in the querying command of database, and called this querying command, obtain Query Result.
2. the method for claim 1, said querying command is specially:
Select parameter A from B parameter where parameters C; Wherein,
First parameter is imported parameter A into, and second parameter is imported B parameter into, and the 3rd parameter is imported parameters C into.
3. method as claimed in claim 2, said user is the set filtering screening conditions of these data to be checked, specifically comprises: data operation symbol and constrained parameters.
4. method as claimed in claim 3, said obtain Query Result after, also comprise:
First parameter, second parameter, the 3rd parameter are preserved as the modular filter screening conditions; And,
In the time need obtaining the Query Result under these modular filter screening conditions next time, behind the constrained parameters of reception user input, in order to replace the constrained parameters in the 3rd parameter; And with first and second parameter, and the 3rd parameter of having replaced constrained parameters imports in the said querying command, calls this querying command, obtains Query Result.
5. like the described method of claim 1-4, before the self-defined formula filtering screening of said generation condition, also comprise:
Receive the bracket that the user imports between sub-filtering screening condition; And,
Also, generate said self-defined formula filtering screening condition according to the bracket between the sub-filtering screening condition.
6. data qualification filtering screening device comprises:
Custom condition filtering screening module is used for receiving the data to be checked of the tables of data that the user selects; To each need carry out the data of filtering screening in the said data to be checked, receiving the user is the set filtering screening conditions of these data, forms sub-filtering screening condition; Logical operator between each sub-filtering screening condition of reception user input generates self-defined formula filtering screening condition;
Pacing items filtering screening module is used to receive first parameter, second parameter, the 3rd parameter that said custom condition filtering screening module is imported into; And first, second and third parameter imported in the querying command of database, call this querying command, obtain Query Result; Wherein, first parameter is need in Query Result, carry out data presented in the said data to be checked, and second parameter is the table name of said tables of data, and the 3rd parameter is said self-defined formula filtering screening condition.
7. screening washer as claimed in claim 6 is characterized in that, said querying command is specially:
Select parameter A from B parameter where parameters C; Wherein,
First parameter is imported parameter A into, and second parameter is imported B parameter into, and the 3rd parameter is imported parameters C into.
8. screening washer as claimed in claim 7 is characterized in that, said user is the set filtering screening conditions of these data to be checked, specifically comprises: data operation symbol and constrained parameters.
9. screening washer as claimed in claim 8 is characterized in that, also comprises: combined type condition filtering screening module; And,
Said custom condition filtering screening module also is used for first parameter, second parameter, the 3rd parameter are saved in said combined type condition filtering screening module as the modular filter screening conditions;
After said combined type condition filtering screening module is used to receive the constrained parameters of user's input, in order to replace the constrained parameters in the 3rd parameter; And with first and second parameter, and the 3rd parameter of having replaced constrained parameters imports in the said querying command, calls this querying command, obtains Query Result.
10. screening washer as claimed in claim 8 is characterized in that,
Said pacing items filtering screening module also is used for the data that provide said tables of data can supply the user to select to said custom condition filtering screening module.
CN2011104363602A 2011-12-22 2011-12-22 Data condition filtering and screening method and screener Pending CN102436503A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN2011104363602A CN102436503A (en) 2011-12-22 2011-12-22 Data condition filtering and screening method and screener

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN2011104363602A CN102436503A (en) 2011-12-22 2011-12-22 Data condition filtering and screening method and screener

Publications (1)

Publication Number Publication Date
CN102436503A true CN102436503A (en) 2012-05-02

Family

ID=45984565

Family Applications (1)

Application Number Title Priority Date Filing Date
CN2011104363602A Pending CN102436503A (en) 2011-12-22 2011-12-22 Data condition filtering and screening method and screener

Country Status (1)

Country Link
CN (1) CN102436503A (en)

Cited By (10)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104462346A (en) * 2014-12-04 2015-03-25 北京国双科技有限公司 Method and device for processing filtration condition data
CN104462134A (en) * 2013-09-23 2015-03-25 北大方正集团有限公司 Retrieval method and system
CN105354698A (en) * 2015-10-28 2016-02-24 无锡澳优汇国际贸易有限公司 Enterprise business data tracking and processing system
CN105930258A (en) * 2015-11-13 2016-09-07 中国银联股份有限公司 Parameter filtering method and apparatus
CN106447441A (en) * 2016-09-21 2017-02-22 上海鲶鱼网络科技有限公司 Data processing system and method
CN106843845A (en) * 2016-12-26 2017-06-13 北京五八信息技术有限公司 Data screening method and device
CN107451204A (en) * 2017-07-10 2017-12-08 阿里巴巴集团控股有限公司 A kind of data query method, apparatus and equipment
CN108446344A (en) * 2018-03-06 2018-08-24 政采云有限公司 Custom condition querying method and system
CN110020114A (en) * 2017-09-28 2019-07-16 北京国双科技有限公司 Processing method, device and the equipment of data query
WO2021012817A1 (en) * 2019-07-24 2021-01-28 中兴通讯股份有限公司 Self-definable counter-based filtering method and device, and computer readable storage medium

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101246495A (en) * 2008-03-21 2008-08-20 深圳国人通信有限公司 Method for constructing query scheme and executing data query and statistics
CN101464862A (en) * 2007-12-21 2009-06-24 英业达股份有限公司 SQL generating system and method
CN102073648A (en) * 2009-11-23 2011-05-25 英业达股份有限公司 System and method for generating query syntax according to input data

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101464862A (en) * 2007-12-21 2009-06-24 英业达股份有限公司 SQL generating system and method
CN101246495A (en) * 2008-03-21 2008-08-20 深圳国人通信有限公司 Method for constructing query scheme and executing data query and statistics
CN102073648A (en) * 2009-11-23 2011-05-25 英业达股份有限公司 System and method for generating query syntax according to input data

Cited By (13)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104462134A (en) * 2013-09-23 2015-03-25 北大方正集团有限公司 Retrieval method and system
CN104462346B (en) * 2014-12-04 2018-05-18 北京国双科技有限公司 The data processing method and device of filter condition
CN104462346A (en) * 2014-12-04 2015-03-25 北京国双科技有限公司 Method and device for processing filtration condition data
CN105354698A (en) * 2015-10-28 2016-02-24 无锡澳优汇国际贸易有限公司 Enterprise business data tracking and processing system
CN105930258B (en) * 2015-11-13 2019-04-26 中国银联股份有限公司 A kind of method and device of parameter filtering
CN105930258A (en) * 2015-11-13 2016-09-07 中国银联股份有限公司 Parameter filtering method and apparatus
CN106447441A (en) * 2016-09-21 2017-02-22 上海鲶鱼网络科技有限公司 Data processing system and method
CN106843845A (en) * 2016-12-26 2017-06-13 北京五八信息技术有限公司 Data screening method and device
CN107451204A (en) * 2017-07-10 2017-12-08 阿里巴巴集团控股有限公司 A kind of data query method, apparatus and equipment
CN110020114A (en) * 2017-09-28 2019-07-16 北京国双科技有限公司 Processing method, device and the equipment of data query
CN108446344A (en) * 2018-03-06 2018-08-24 政采云有限公司 Custom condition querying method and system
WO2021012817A1 (en) * 2019-07-24 2021-01-28 中兴通讯股份有限公司 Self-definable counter-based filtering method and device, and computer readable storage medium
US11777828B2 (en) 2019-07-24 2023-10-03 Zte Corporation Self-definable counter-based filtering method and device, and computer readable storage medium

Similar Documents

Publication Publication Date Title
CN102436503A (en) Data condition filtering and screening method and screener
US7505983B2 (en) Extending data flows
KR101368068B1 (en) Method of constructing database, server performing the same and storage media storing the same
CN104111828A (en) Automatic generation method and system of human-computer interaction interface
CN106446019B (en) A kind of software function treating method and apparatus
CN103489061A (en) Batch data processing device and batch data processing method
US20080183741A1 (en) Method and system for querying a database
US11100126B2 (en) Creating reports using dimension trees
KR20130115654A (en) Method of rendering user interface, server performing the same and stroage media sotring the same
CN102436473A (en) Menu management device and menu management method
US20170289731A1 (en) Mobile Database Access Application Development System and Method
CN101093512A (en) Data filtering method and data filtering system
US20130144880A1 (en) Business partner grouping
CN111949832A (en) Method and device for analyzing dependency relationship of batch operation
CN101655942A (en) Configuration method of business cooperation flow, business cooperation method and device
CN103077192A (en) Data processing method and system thereof
CN103164573A (en) Product data management (PDM) design system
CN111047434B (en) Operation record generation method and device, computer equipment and storage medium
CN102722784A (en) Method for setting list or quota rapidly
CN101377746A (en) System and method for updating arranged task
CN114371845A (en) Form generation method and device
CN102567517A (en) Device and method for issuing data of database
CN107423035B (en) Product data management system in software development process
US20140114728A1 (en) Method and system for database benchmarking
CN115510361A (en) Data chart page generation method based on visual configuration and related equipment

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
C12 Rejection of a patent application after its publication
RJ01 Rejection of invention patent application after publication

Application publication date: 20120502