Real-time query transformation and data retrieval

• US 10,055,470 B1
• Filed: 04/26/2015
• Issued: 08/21/2018
• Est. Priority Date: 04/26/2015
• Status: Active Grant

• Current Assignee: IQVIA, Inc. (IQVIA Holdings, Inc.)
• Original Assignee: IMS Health Incorporated (IQVIA Holdings, Inc.)
• Inventors: Manzo, Marcelo, Hahn, Christopher, Hasan, Nazmul
• Primary Examiner(s): Dwivedi, Mahesh H
• Application Number:
  US14/696,443
• Time in Patent Office: 1,213 Days
• CPC Class Codes: G06F 16/24542 Plan optimisation
• CPC Class Codes: G06F 16/256 in federated or virtual databases

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.

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.

2. The method of claim 1, further comprising:

merging the one or more of query results associated with the plurality of sub-queries.

3. The method of claim 1, further comprising:

processing the at least one query in the first query language for one or more objects, wherein the splitting the at least one query is based on the one or more query objects.

4. The method of claim 3, wherein the one or more objects include at least one of a list of attributes, a list of key performance indicators, a filter, an exchange rate, a factor, a for-matter, or a combination thereof.

5. The method of claim 1, further comprising:

generating pivot data based on the calculated values.

6. The method of claim 5, further comprising formatting the pivot data to generate output data, wherein the data presentation is generated based on the output data.

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.

8. The system of claim 7, wherein the sub-query engine is further configured to merge the one or more of query results associated with the plurality of sub-queries.

9. The system of claim 7, wherein the query analyzer is further configured to process the at least one query in the first query language for one or more objects, wherein the splitting the at least one query is based on the one or more query objects.

10. The system of claim 9, wherein the one or more objects include at least one of a list of attributes, a list of key performance indicators, a filter, an exchange rate, a factor, a formatter, or a combination thereof.

11. The system of claim 7, wherein the output module is further configured to:

generate pivot data based on the calculated values.

12. The system of claim 11, wherein the output module is further configured to format the pivot data to generate output data, wherein the data presentation is generated based on the output data.

13. The system of claim 7, wherein the sub-query engine is further configured to configure the one or more datasets based on the one or more query.

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.

15. The method of claim 14, further comprising:

merging the one or more of query results associated with the plurality of sub-queries.

16. The method of claim 14, further comprising:

processing the at least one query in the first query language for one or more objects, wherein the splitting the at least one query is based on the one or more query objects.

17. The method of claim 16, wherein the one or more objects include at least one of a list of attributes, the list of key performance indicators, a filter, an exchange rate, a factor, a formatter, or a combination thereof.

18. The method of claim 14, further comprising formatting the at least one query result, wherein the data presentation is generated based on the formatting of the at least one query result.