Database Record Processing via Dynamic Query Prioritization
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current systems for managing transaction records in databases face delays due to data anomalies and issues with handling records, which can impact the timely processing of payments and cash flow, especially in healthcare implementations, where timely record processing is critical for avoiding payment contests and ensuring smooth operations.
Innovation Solution
A records management and processing system that utilizes dynamic query sessions, rules engines, and workflow engines to identify and prioritize records based on predefined conditions and actions, applying tags and executing workflows to expedite the processing of critical records while de-prioritizing non-critical ones, thereby enhancing the efficiency of record handling and reducing delays.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If automated processing rules are applied to all database records, then processing speed increases, but complexity of the system increases
Solution Approach 1:
The patent segments the database records into different priority levels (critical, high, normal, low) based on predefined criteria such as payment due dates, account status, and historical data. This segmentation allows the system to apply different processing rules to different segments, improving overall processing efficiency without requiring complex rules for every single record.
Solution Approach 2:
The system dynamically changes processing parameters based on record characteristics. Records are assigned priority levels and processing rules are adjusted according to these parameters, allowing automated processing to be applied selectively rather than uniformly across all records, thus balancing automation benefits with system complexity.
2Reliability
If manual review is performed on all records, then accuracy increases, but processing time increases
Solution Approach 1:
The patent applies local quality by directing manual review resources only to records that require it, rather than uniformly reviewing all records. Critical records with anomalies or high-risk characteristics are flagged for manual review, while routine records are processed automatically, thus maintaining accuracy for important records while minimizing overall processing time.
Solution Approach 2:
The system performs partial manual review action only on a subset of records that meet specific criteria for manual intervention. This partial action approach ensures that records requiring human judgment receive thorough review while the majority of records are processed efficiently through automated rules, balancing accuracy and time consumption.
3Loss of time
If critical records are prioritized for processing, then payment timeliness improves, but system complexity increases
Solution Approach 1:
The patent implements preliminary action by pre-defining priority criteria and processing rules before records are assigned. Records are automatically evaluated against these predetermined criteria and assigned to appropriate processing queues in advance, allowing critical records to be identified and prioritized without adding complex real-time decision-making logic to the system.
Solution Approach 2:
The system introduces an intermediary priority classification layer between record intake and processing execution. This intermediary layer sorts records into priority queues based on predefined rules, serving as a mediator that simplifies the workflow by organizing records before they enter the main processing stream, thus improving timeliness without significantly increasing overall system complexity.
Data Source
AI summary
Embodiments of the present disclosure are directed to methods and systems for the automated processing of database records on a system of record based on results of a dynamic query session. More specifically, one or more templates can be defined. Each template can relate to a pre-defined condition of one or more records of the plurality of records and can define a dynamic query session related to the one or more records and one or more actions directed to the one or more records. The records can be monitored for an occurrence of the pre-defined condition on at least one record. In response to detecting the occurrence of the pre-defined condition on the at least one record, the dynamic query session related to the at least one record can be launched and the one or more actions can be initiated based on results of the dynamic query session.