Method and system for filtering data from data source by using complex conditions
A data source and data technology, applied in the field of data processing, can solve the problems of weak anti-change ability, poor maintainability and reusability, etc., and achieve the effects of strong anti-change ability, improved scalability, and good maintainability
Active Publication Date: 2014-01-15
CHINA UNIONPAY
View PDF1 Cites 0 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0008] In view of this, the object of the present invention is to provide a method and system for filtering data from data sources using complex conditions, so as to effectively solve the existing processing methods and systems that have very poor scalability, maintainability and reusability And many problems such as weak resistance to change
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
[0043] For any type of data filtering using complex conditions, its essence is a complex combination of multiple conditions, that is, to filter data that meets multiple conditions from the data source. This process is called "data filtering" . In the data screening process, those filter conditions that can no longer be decomposed (for example, only for one of the elements such as customer code, transaction time, terminal number, etc., can be directly expressed by operators such as >, <, =, !, etc. ) are referred to as "single filter elements".
[0044]When adopting the method of the present invention to filter data using complex conditions, the complex conditions used in the current data filtering must first be converted into a form of a combination of several filter groups, and these filter groups are connected to each other. The logical relationship is exactly the same, and the logical relationship of "or" is preferably used between them; moreover, each filter group is comb...
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 discloses a method for filtering data from a data source by using complex conditions. The method comprises the following steps of: firstly, converting a selection condition for filtering each type of data into a form in which a plurality of filter groups are combined with each other in the same logical relationship, wherein each filter group comprises a plurality of filter conditions which are combined with each other in the same logical relationship and are all single filter elements; and recording the obtained filter groups and the combination relationships between the filter conditions in a database table; next, writing the value of the selection condition for filtering the present data in the database table; looking up the database table to obtain each filter condition requirement in the filtering of the present data, and orderly selecting out primarily selected data meeting the requirements of each filter group from the data source; and obtaining the data meeting the present data filtering requirements from the data source according to the logical relationships between the filter groups and the primarily selected data. The invention also correspondingly discloses a system which comprises a conversion processing unit, an assignment unit, a first filter unit and a second filter unit. The method and the system are capable of effectively improving extendibility, maintainability and reusability.
Description
【Technical field】 [0001] The invention relates to a data filtering method and system, in particular to a method and system for filtering data from a data source using complex conditions, and belongs to the technical field of data processing. 【Background technique】 [0002] With the development of society and the progress of the times, people's various transaction activities in modern life are also increasing, for example, financial business transactions, utilities transactions such as water and electricity, and network payment transactions. However, at the same time, the types of transaction behaviors and their business logic rules are more complex. At present, when it is necessary to use complex conditions (referring to the combination of multi-level and highly coupled logical relationships by multiple conditions) to process data filtering from data sources, the existing technology is generally modified directly in the business system processing program. Filter conditions ...
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 Patent Type & Authority Patents(China)
IPC IPC(8): G06F17/30
Inventor 黄敬刘志宇冀乃庚傅宜生
Owner CHINA UNIONPAY