Optum, Inc.

Srivatsan Srinivasan

Priyadarshni Natarajan

Sanjeeva L Fernando

John Jose Gerard Anto Arokiasamy

John Jose Anto Gerard Arokiasamy

Various embodiments of the present disclosure provide federated query processing techniques for monitoring data access patterns through federated queries and intelligently caching disparate data segments based on the data access patterns. The techniques include determining a relative priority for a data segment of a third-party data source based on a plurality of federated queries. Each of the plurality of federated queries may reference data segments from a plurality of disparate data sources. The relative priority may be indicative of a priority of the data segment relative to other data segments. In response to a determination that the relative priority satisfies a priority threshold, the techniques include storing a data segment in an intermediary local data source and initiating the performance of a data segment redirect configured to redirect a subsequent federated query associated with the data segment to the intermediary local data source.

Priority-driven federated query-based data caching

Various embodiments of the present disclosure provide federated query processing techniques for quality evaluation and augmentation of data provided by a federated query system. The techniques include receiving an execution plan for a federated query. The techniques also include receiving one or more data segments from a plurality of third-party data sources and receiving quality evaluation data using a set of data accessing tasks for the execution plan. The techniques also include generating a result set for the federated query using a set of data processing tasks for the execution plan. Additionally, the techniques include generating quality metrics data for the one or more data segments based on the quality evaluation data and generating an augmented result set for the federated query based on the result set and the quality metrics data.

Quality evaluation and augmentation of data provided by a federated query system

Various embodiments of the present disclosure provide federated query processing techniques for dynamically tailoring the use and parameters of intermediary local sources based on the identification of federated query. The techniques include receiving an execution plan for executing a federated query that include a plurality of executable tasks for generating a result set from a plurality of third-party data sources. The techniques include generating a result set hash for the result set based on the execution plan and determining a query uniqueness status for the federated query based on a comparison between the result set hash and a plurality of historical result set hashes. In response to determining that the federated query is a unique query, the techniques include generating a time interval that is tailored to the unique query.

Growing community of inventors

Lake Stevens, WA, United States of America

Srivatsan Srinivasan