Analytic services portal

• US 9,916,590 B2
• Filed: 05/10/2012
• Issued: 03/13/2018
• Est. Priority Date: 05/10/2011
• Status: Active Grant

• Current Assignee: IQVIA, Inc. (IQVIA Holdings, Inc.)
• Original Assignee: Quintiles IMS Incorporated (IQVIA Holdings, Inc.)
• Inventors: Brogan, Tom, Brogan, Michael, Fraelic, Chris, Dobinson, Matt, Soto, Roberto, Perkins, Tina, Peckham, Trent
• Primary Examiner(s): Chng, Joy
• Application Number:
  US13/468,890
• Publication Number:
  US 20130013329A1
• Time in Patent Office: 2,133 Days
• Field of Search: 705 2- 3
• CPC Class Codes: G06Q 30/02 Marketing; Price estimation or determination; Fundraising

Abstract

Provided are methods and systems for providing analytic services, as well as computer programs encoded on computer storage devices and configured to perform the actions of the methods. One or more processors create an alignment associated with a client, where the alignment organizes data in a database, and where the data in the database comprises prescription information, store information, and product information. A request for a report is received, where the request identifies the client. The requested report is generated based on the alignment, where the report comprises one or more indicators derived from data contained in the database.

Claims

1. A computer-implemented method comprising:

receiving, from a client device and by a data processing module of a computer system that includes (i) the data processing module, (ii) a computational module, (iii) an output module, and (iv) one or more databases, data indicating a report request that identifies;

a first transaction source from among a plurality of transaction sources, and

a performance metric for to the first transaction source;

in response to receiving the data indicating the report request;

obtaining, by the data processing module of the computer system and from a first set of database systems configured to exchange data with the computer system over a second network, a first stream of transaction data including one or more transaction records for the first transaction source;

obtaining, by the data processing module of the computer system and from a second set of database systems configured to exchange data with the computer system over the second network, a second stream of transaction data including one or more transaction records for a second transaction source within the plurality of transaction sources that is not the first transaction source;

processing, by the data processing module of the computing system, contents of the one or more transaction records for the first transaction source to generate a first relational database model, the processing comprising;

identifying transaction records that are distributed at the first transaction source;

determining, for each of the transaction records, a total number of transactions at the first transaction source that are associated with a transaction record;

generating, within the one or more databases, the first relational database model specifying the total number of transactions for each of the transaction records at the first transaction source;

processing, by the computing system, contents of the one or more transaction records for the second pharmacy to generate a second relational database model, the processing comprising;

identifying transaction records that are distributed at the designated transaction source;

determining, for each of the transaction records, a total number of transactions at the second transaction source that are associated with a transaction record;

generating, within the one or more databases, the second relational database model specifying the total number of transactions for each of the transaction records at the second transaction source;

generating, by the data processing module of the computing system and within the one or more databases, a mapping between the first relational database model and the second relational database model;

comparing, by the computational module of the computer system and using the longitudinal mapping, corresponding data fields within the first relational database model and the second relational database model;

computing, by the computational module of the computer system and for the first transaction source, a performance score corresponding to the performance metric for the first transaction source identified within the report request based on comparing the corresponding data fields within the first relational database model and the second relational model;

generating, by the output module of the computer system, a report responsive to the received report request, the report including the computed performance score for the first transaction source; and

providing, by the output module of the computer system, the generated report for output to the client device over the first network.

2. The method of claim 1, further comprising:

identifying, by the computational module of the computer system, a user associated with the client device based on a username identified by the received report request; and

identifying, by the computational module of the computer system, a set of permissions associated with the username;

wherein the requested report is generated based at least on the set of permissions associated with the username.

3. The method of claim 1, wherein at the computed performance score included in the generated report represents a relative increase in distribution of a transaction record at the first transaction source compared to a corresponding increase in distribution of the transaction record at the second transaction source.

4. The method of claim 1, further comprising:

receiving, by the data processing module of the computer system and from the client device over the first network, one or more user inputs selecting a transaction record from among the transaction records; and

adjusting, by the data processing module of the computer system and within the one or more databases, the first relational database model and the second relational database model to include one or more transaction records of the transaction record; and

wherein the performance score corresponding to the performance metric for the first transaction source is computed based on comparing the contents of the adjusted first relational database model and the adjusted second relational database model.

5. The method of claim 1, further comprising:

receiving, by the data processing module of the computer system and from the client device, data indicating a request for an additional report, the request for the additional report identifying the first transaction source and information relating to one or more additional performance metrics that are different from the performance metric for the first transaction source identified within the report request;

computing, by the computational module of the computer system, additional performance scores corresponding to the additional performance metrics based on comparing the contents of the first relational database model and the contents of the second relational model; and

generating, by the output module of the computer system, an additional report that includes the computed one or more additional performance scores.

6. A non-transitory computer-readable storage device encoded with computer program instructions that, when executed by one or more computers, cause the one or more computers to perform operations comprising:

receiving, from a client device and by a data processing module of a computer system that includes (i) the data processing module, (ii) a computational module, (iii) an output module, and (iv) one or more databases, data indicating a report request that identifies;

a first transaction source from among a plurality of transaction sources, and

a performance metric for to the first transaction source;

in response to receiving the data indicating the report request;

obtaining, by the data processing module of the computer system and from a first set of database systems configured to exchange data with the computer system over a second network, a first stream of transaction data including one or more transaction records for the first transaction source;

obtaining, by the data processing module of the computer system and from a second set of database systems configured to exchange data with the computer system over the second network, a second stream of transaction data including one or more transaction records for a second transaction source within the plurality of transaction sources that is not the first transaction source;

processing, by the data processing module of the computing system, contents of the one or more transaction records for the first transaction source to generate a first relational database model, the processing comprising;

identifying transaction records that are distributed at the first transaction source;

determining, for each of the transaction records, a total number of transactions at the first transaction source that are associated with a transaction record;

generating, within the one or more databases, the first relational database model specifying the total number of transactions for each of the transaction records at the first transaction source;

processing, by the computing system, contents of the one or more transaction records for the second pharmacy to generate a second relational database model, the processing comprising;

identifying transaction records that are distributed at the designated transaction source;

determining, for each of the transaction records, a total number of transactions at the second transaction source that are associated with a transaction record;

generating, within the one or more databases, the second relational database model specifying the total number of transactions for each of the transaction records at the second transaction source;

generating, by the data processing module of the computing system and within the one or more databases, a mapping between the first relational database model and the second relational database model;

comparing, by the computational module of the computer system and using the longitudinal mapping, corresponding data fields within the first relational database model and the second relational database model;

computing, by the computational module of the computer system and for the first transaction source, a performance score corresponding to the performance metric for the first transaction source identified within the report request based on comparing the corresponding data fields within the first relational database model and the second relational model;

generating, by the output module of the computer system, a report responsive to the received report request, the report including the computed performance score for the first transaction source; and

providing, by the output module of the computer system, the generated report for output to the client device over the first network.

7. The device of claim 6, wherein the operations further comprise:

identifying, by the computational module of the computer system, a user associated with the client device based on a username identified by the received report request; and

identifying, by the computational module of the computer system, a set of permissions associated with the username;

wherein the requested report is generated based at least on the set of permissions associated with the username.

8. The device of claim 6, wherein at the computed performance score included in the generated report represents a relative increase in distribution of a transaction record at the first transaction source compared to a corresponding increase in distribution of the transaction record at the second transaction source.

9. The device of claim 6, wherein the operations further comprise:

receiving, by the data processing module of the computer system and from the client device over the first network, one or more user inputs selecting a transaction record from among the transaction records; and

adjusting, by the data processing module of the computer system and within the one or more databases, the first relational database model and the second relational database model to include one or more transaction records of the transaction record; and

wherein the performance score corresponding to the performance metric for the first transaction source is computed based on comparing the contents of the adjusted first relational database model and the adjusted second relational database model.

10. The device of claim 6, wherein the operations further comprise:

receiving, by the data processing module of the computer system and from the client device over the first network, one or more user inputs selecting a transaction record from among the transaction records; and

adjusting, by the data processing module of the computer system and within the one or more databases, the first relational database model and the second relational database model to include one or more transaction records of the transaction record; and

wherein the performance score corresponding to the performance metric for the first transaction source is computed based on comparing the contents of the adjusted first relational database model and the adjusted second relational database model.

11. A system comprising:

one or more computers; and

one or more storage devices storing instructions that, when executed by the one or more computers, cause the one or more computers to perform operations comprising;

receiving, from a client device and by a data processing module of a computer system that includes (i) the data processing module, (ii) a computational module, (iii) an output module, and (iv) one or more databases, data indicating a report request that identifies;

a first transaction source from among a plurality of transaction sources, and

a performance metric for to the first transaction source;

in response to receiving the data indicating the report request;

obtaining, by the data processing module of the computer system and from a first set of database systems configured to exchange data with the computer system over a second network, a first stream of transaction data including one or more transaction records for the first transaction source;

obtaining, by the data processing module of the computer system and from a second set of database systems configured to exchange data with the computer system over the second network, a second stream of transaction data including one or more transaction records for a second transaction source within the plurality of transaction sources that is not the first transaction source;

processing, by the data processing module of the computing system, contents of the one or more transaction records for the first transaction source to generate a first relational database model, the processing comprising;

identifying transaction records that are distributed at the first transaction source;

determining, for each of the transaction records, a total number of transactions at the first transaction source that are associated with a transaction record;

generating, within the one or more databases, the first relational database model specifying the total number of transactions for each of the transaction records at the first transaction source;

processing, by the computing system, contents of the one or more transaction records for the second pharmacy to generate a second relational database model, the processing comprising;

identifying transaction records that are distributed at the designated transaction source;

determining, for each of the transaction records, a total number of transactions at the second transaction source that are associated with a transaction record;

generating, within the one or more databases, the second relational database model specifying the total number of transactions for each of the transaction records at the second transaction source;

generating, by the data processing module of the computing system and within the one or more databases, a mapping between the first relational database model and the second relational database model;

comparing, by the computational module of the computer system and using the longitudinal mapping, corresponding data fields within the first relational database model and the second relational database model;

computing, by the computational module of the computer system and for the first transaction source, a performance score corresponding to the performance metric for the first transaction source identified within the report request based on comparing the corresponding data fields within the first relational database model and the second relational model;

generating, by the output module of the computer system, a report responsive to the received report request, the report including the computed performance score for the first transaction source; and

providing, by the output module of the computer system, the generated report for output to the client device over the first network.

12. The system of claim 11, wherein the operations further comprise:

identifying, by the computational module of the computer system, a user associated with the client device based on a username identified by the received report request; and

identifying, by the computational module of the computer system, a set of permissions associated with the username;

wherein the requested report is generated based at least on the set of permissions associated with the username.

13. The system of claim 11, wherein at the computed performance score included in the generated report represents a relative increase in distribution of a transaction record at the first transaction source compared to a corresponding increase in distribution of the transaction record at the second transaction source.

14. The system of claim 11, further comprising:

receiving, by the data processing module of the computer system and from the client device over the first network, one or more user inputs selecting a transaction record from among the transaction records; and

adjusting, by the data processing module of the computer system and within the one or more databases, the first relational database model and the second relational database model to include one or more transaction records of the transaction record; and

wherein the performance score corresponding to the performance metric for the first transaction source is computed based on comparing the contents of the adjusted first relational database model and the adjusted second relational database model.

15. The system of claim 11, further comprising:

receiving, by the data processing module of the computer system and from the client device, data indicating a request for an additional report, the request for the additional report identifying the first transaction source and information relating to one or more additional performance metrics that are different from the performance metric for the first transaction source identified within the report request;

computing, by the computational module of the computer system, additional performance scores corresponding to the additional performance metrics based on comparing the contents of the first relational database model and the contents of the second relational model; and

generating, by the output module of the computer system, an additional report that includes the computed one or more additional performance scores.