Hierarchical Complex Filter Query for Data Quality

The patent segments the filter system into two distinct types: flat filters for simple column value checks and complex filters for advanced data quality criteria. This segmentation allows each filter type to specialize in its respective strength, maintaining operational simplicity for basic tasks while enabling sophisticated analysis when needed.

The patent introduces a new dimension to the filter system by adding complex filters that operate beyond simple column value comparisons. This dimensional expansion enables the system to handle composite criteria, semantic meaning-based filtering, and rule-based compliance checks, thereby enhancing adaptability without compromising the existing flat filter functionality.

The patent creates a composite filtering system where complex filters combine multiple flat filters and logical operators (AND, OR, NOT) into unified filter expressions. This composite structure enables the system to assess complex data quality criteria such as 'total amount must be greater than sum of individual amounts' by integrating multiple column checks with logical reasoning, thereby improving measurement precision.

The patent introduces logical operators as intermediaries between flat filters and the final filtering result. These operators (AND, OR, NOT) act as mediators that combine multiple simple column value checks into complex logical expressions, enabling precise data quality assessment for composite criteria while maintaining the simplicity of individual flat filter operations.