Abstract: Systems and methods for diagnosing an aftertreatment system are provided. The system includes an aftertreatment system having a diesel particulate filter (DPF). The system includes a controller configured to: receive sensor data including pressure change data and flow rate data from a sensor; determine a flow resistance of the DPF and a pressure change value; determine that the flow resistance is less than a flow resistance threshold; determine whether the pressure change value is less than a pressure change value threshold; trigger a first failure warning based on determining that the flow resistance is less than the flow resistance threshold and that the pressure change value is less than the pressure change value threshold; and trigger a second failure warning based on determining that that the flow resistance is less than the flow resistance threshold and that the pressure change value is greater than the pressure change value threshold.

Abstract: Optimizing query statements in relational databases including determining filtering performance for each of at least two complex predicates in a predetermined layer of the query statement based on a result of a query performed on predetermined data records by using only the complex predicate. The results are ranked based on the filtering performance and re-ordered so that a complex predicate with a higher filtering performance is ranked before a complex predicate with a lower filtering performance. These techniques produce shortened data query response times and improved execution efficiency.