US 12,737,360 B2Granted

Data processing in an optimized analytics environment

AssigneeAmerican Express Travel Related Services Company, Inc.

InventorsRares Ioan Almasan, Anand Vijai Mavelipatty Rangasamy, Todd W. Oulton, Ravi Peethala

Life of this patent

Estimating the term…

Loading patent…

Abstract

Systems and methods for data Process an optimized analytics environment are disclosed. The system may enable users to create data processing requests, interact with various data sources and datasets, and generate data processing outputs. The system may receive a data processing request from an audio-enabled input source or a UI-based input source. The system may determine whether the data processing request at least partially matches a stored data processing request. The system may receive a data processing request selection comprising the data processing request or the stored data processing request. The system may execute the data processing request selection on a data source.

Claims20

Dependent claims

A method comprising:

receiving, by a processor of a data processing system, an audio data processing request comprising a technical command to interact with one or more data sources of a data processing system;
translating, by the processor, the audio data processing request into a first data processing request in a database query language that is configured to interact with the one or more data sources of the data processing system;
querying a data source of the data processing system specified in the database query language of the first data processing request;
executing, by the processor, the first data processing request using the data source of the data processing system specified in the database query language of the first data processing request;
generating, by the processor, a data processing output based on the executing of the first data processing request by the data processing system;
storing, by the processor, the first data processing request and the data processing output in an analytics database;
generating, by the processor, a process ranking for the stored data processing output based on at least an execution time used to generate the stored data processing output by the data processing system;
obtaining, by the processor, a second data processing request;
determining, by the processor, the second data processing request to be similar to the first data processing request;
presenting, by the processor, a plurality of options for servicing the second data processing request, the plurality of options including an option of processing the second data processing request to generate a new data processing request output and an option to use the stored data processing output for the first data processing request;
transmitting for display, by the processor, processing data associated with the stored data processing output, wherein the processing data comprises an indication of at least a subset of a dataset or data source involved in the stored data processing output and the processing ranking for the stored data processing output;
receiving, by the processor, a data processing request selection comprising one of the plurality of options for servicing the second data processing request;
and
executing, by the processor, the data processing request selection on one or more data sources of the data processing system.

11 more elements

A system comprising:

a processor of a data processing system;
and
a tangible, non-transitory memory configured to communicate with the processor, the tangible, non-transitory memory having instructions stored thereon that, in response to execution by the processor, cause the processor to:
receive an audio data processing request comprising a technical command to interact with one or more data sources of a data processing system;
translate the audio data processing request into a first data processing request in a database query language that is configured to interact with the one or more data sources of the data processing system;
query a data source of the data processing system specified in the database query language of the first data processing request;
execute the first data processing request using the data source of the data processing system specified in the database query language of the first data processing request;
generate a data processing output based on the executing of the first data processing request by the data processing system;
store the first data processing request and the data processing output in an analytics database;
generate, by the processor, a processor ranking for the stored data processing output based on at least an execution time used to generate the stored data processing output by the data processing system;
obtain a second data processing request;
determine the second data processing request to be similar to the first data processing request;
present, by the processor, a plurality of options for servicing the second data processing request, the plurality of options including an option of processing the second data processing request to generate a new data processing request output and an option to use the stored data processing output for the first data processing request;
transmitting for display, by the processor, processing data associated with the stored data processing output, wherein the processing data comprises an indication of at least a subset of a dataset or data source involved in the stored data processing output and the processing ranking for the stored data processing output;
receive, by the processor, a data processing request selection comprising one of the plurality of options for servicing the second data processing request;
and
execute, by the processor, the data processing request selection on one or more data sources of the data processing system.

14 more elements

A non-transitory computer readable medium comprising machine readable instructions that, when executed by a processor of a computing device of a data processing system, cause the computing device to at least:

receive an audio data processing request comprising a technical command to interact with one or more data sources of a data processing system;
translate the audio data processing request into a first data processing request in a database query language that is configured to interact with the one or more data sources of the data processing system;
query a data source of the data processing system specified in the database query language of the first data processing request;
execute the first data processing request using the data source of the data processing system specified in the database query language of the first data processing request;
generate a data processing output based on the executing of the first data processing request by the data processing system;
store the first data processing request and the data processing output in an analytics database;
generate a processor ranking for the stored data processing output based on at least an execution time used to generate the stored data processing output by the data processing system;
obtain a second data processing request;
determine the second data processing request to be similar to the first data processing request;
present a plurality of options for servicing the second data processing request, the plurality of options including an option of processing the second data processing request to generate a new data processing request output and an option to use the stored data processing output for the first data processing request;
transmitting for display processing data associated with the stored data processing output, wherein the processing data comprises an indication of at least a subset of a dataset or data source involved in the stored data processing output and the processing ranking for the stored data processing output;
receive a data processing request selection comprising one of the plurality of options for servicing the second data processing request;
and
execute the data processing request selection on one or more data sources of the data processing system.

11 more elements

Dependencies are inferred from the claim text.

Facts

Application: 18/189,736Filed 24 Mar 2023 · continuation
Priority: 4 Apr 2019
Published: US 2023/0229661 A120 Jul 2023
Granted: 15 Sep 2026
Term ends: Not estimatedThe source records don’t support an estimate.

Classification4 codes

G06F 16/24549
Query rewriting; Transformation: run-time optimisation
G06F 16/903
Details of database functions independent of the retrieved data types: querying
G06F 16/24578
With adaptation to user needs: using ranking
G06F
Computing and data processing

Family

Application16/375,732Parent of this continuation · filed 4 Apr 2019
US 2023/0229661 A1Pre-grant publication · published 20 Jul 2023
US 11,636,109 B2Parent of this continuation
US 2020/0320080 A1Published application
US 12,737,360 B2This patent

From the US filing history. Foreign family members aren’t listed.