Real-time query transformation and data retrieval
First Claim
1. A computer-implemented method to retrieve data from one or more datasets, comprising:
- receiving at least one query in a first query language, wherein the at least one query includes one or more key performance indicators that are related to a performance of an entity;
retrieving configuration information from a configuration database, wherein the configuration information includes at least key performance indicator configurations;
validating the one or more key performance indicators in the at least one query based on the retrieved configuration information;
splitting the at least one query in the first query language into a plurality of sub-queries;
transforming the plurality of sub-queries into one or more second query languages, wherein the one or more second query languages correspond to the one or more datasets;
processing the one or more transformed queries to retrieve one or more query results from the one or more datasets; and
processing the one or more query results to generate a data presentation, wherein the processing the one or more query results to generate the data presentation further comprises;
processing the one or more query results based on at least one exchange rate parameter;
factoring the one or more processed query results based on at least one factoring parameter, wherein the at least one factoring parameter is based on at least one of a therapeutic benefit of a dosage of a medicine and a market share of a medicine for a disease; and
generating one or more calculated values based on the one or more factored query results.
8 Assignments
0 Petitions
Accused Products
Abstract
A method and system to retrieve data dynamically from one or more datasets are disclosed. The method comprises receiving at least one query in a first query language. Thereafter, splitting the at least one query in the first query language into a plurality of sub-queries and transforming the plurality of sub-queries into one or more second query languages, wherein the one or more second query languages correspond to the one or more datasets. Other embodiments include a method that comprises processing the one or more transformed queries to retrieve one or more query results from the one or more datasets, and processing the one or more query results to generate a data presentation.
-
Citations
18 Claims
-
1. A computer-implemented method to retrieve data from one or more datasets, comprising:
-
receiving at least one query in a first query language, wherein the at least one query includes one or more key performance indicators that are related to a performance of an entity; retrieving configuration information from a configuration database, wherein the configuration information includes at least key performance indicator configurations; validating the one or more key performance indicators in the at least one query based on the retrieved configuration information; splitting the at least one query in the first query language into a plurality of sub-queries; transforming the plurality of sub-queries into one or more second query languages, wherein the one or more second query languages correspond to the one or more datasets; processing the one or more transformed queries to retrieve one or more query results from the one or more datasets; and processing the one or more query results to generate a data presentation, wherein the processing the one or more query results to generate the data presentation further comprises; processing the one or more query results based on at least one exchange rate parameter; factoring the one or more processed query results based on at least one factoring parameter, wherein the at least one factoring parameter is based on at least one of a therapeutic benefit of a dosage of a medicine and a market share of a medicine for a disease; and generating one or more calculated values based on the one or more factored query results. - View Dependent Claims (2, 3, 4, 5, 6)
-
-
7. A system to retrieve data from one or more datasets, comprising:
-
a query analysis module configured to; receive the at least one query in a first query language, wherein the at least one query includes one or more key performance indicators that are related to a performance of an entity; retrieve configuration information from a configuration database, wherein the configuration information includes at least key performance indicator configurations; validate the one or more key performance indicators in the at least one query based on the retrieved configuration information; and split the at least one query in the first query language into a plurality of sub-queries; a sub-query engine coupled, at least, to the query analysis module, wherein the sub-query engine is configured to; transform the plurality of sub-queries into one or more second query languages, wherein the one or more second query languages correspond to the one or more datasets; and process the one or more transformed queries to retrieve one or more query results from the one or more datasets; and an output module coupled, at least to, the sub-query engine, wherein the output module is configured to process the one or more query results to generate a data presentation, wherein the output module is further configured to; process the one or more query results based on at least one exchange rate parameter; factor the one or more processed query results based on at least one factoring parameter, wherein the at least one factoring parameter is based on at least one of a therapeutic benefit of a dosage of a medicine and a market share of a medicine for a disease; and generate one or more calculated values based on the one or more factored query results. - View Dependent Claims (8, 9, 10, 11, 12, 13)
-
-
14. A computer-implemented method to retrieve data from one or more datasets, comprising:
-
receiving a query to retrieve data and configuration of one or more datasets, wherein the query is in a first query language, and wherein the query includes a list of key performance indicators related to a performance of an entity; retrieving configuration information from a configuration database, wherein the configuration information includes at least key performance indicator configurations; validating the list of key performance indicators in the query based on the retrieved configuration information; splitting the at least one query in the first query language into a plurality of sub-queries; transforming the plurality of sub-queries into one or more second query languages, wherein the one or more second query languages correspond to the one or more datasets; configuring one or more data models in the one or more datasets based on the one or more sub-queries; processing the one or more transformed queries to retrieve one or more query results from the one or more datasets; and processing the one or more query results to generate a data presentation, wherein the processing the one or more query results to generate the data presentation further comprises; processing the one or more query results based on at least one exchange rate parameter; factoring the one or more processed query results based on at least one factoring parameter, wherein the at least one factoring parameter is based on at least one of a therapeutic benefit of a dosage of a medicine and a market share of a medicine for a disease; and generating one or more calculated values based on the one or more factored query results. - View Dependent Claims (15, 16, 17, 18)
-
Specification