System and method for providing an aggregation tool

• US 10,402,901 B2
• Filed: 09/14/2018
• Issued: 09/03/2019
• Est. Priority Date: 01/31/2007
• Status: Active Grant

• Current Assignee: Experian Information Solutions Incorporated (Experian plc)
• Original Assignee: Experian Information Solutions Incorporated (Experian plc)
• Inventors: Courbage, Magali, Rodenbusch, Richard, Morani, Jean-Dominique
• Primary Examiner(s): Nguyen, Tien C
• Application Number:
  US16/132,156
• Publication Number:
  US 20190012736A1
• Time in Patent Office: 354 Days
• Field of Search: 705 38, 705 39, 705 40, 705 26, 705 34, 705 16, 705 50, 715249, 707748, 707718, 707108, 709217, 345581, 706 15
• CPC Class Codes: G06F 1/00 Details not covered by groups G06F3/00 - G06F13/00 and G06F21/00 architectures of general purpose stored program computers G06F15/76
• CPC Class Codes: G06F 11/07 Responding to the occurrence of a fault, e.g. fault tolerance
• CPC Class Codes: G06F 11/22 Detection or location of defective computer hardware by testing during standby operation or during idle time, e.g. start-up testing
• CPC Class Codes: G06F 16/90 Details of database functions independent of the retrieved data types
• CPC Class Codes: G06Q 40/03 Credit; Loans; Processing thereof
• CPC Class Codes: G06Q 40/04 Trading; Exchange, e.g. stocks, commodities, derivatives or currency exchange

Abstract

Embodiments of the present invention assist in the development, management, and deployment of aggregated data attributes for multiple data sources. One embodiment provides a development interface that allows for elements of attributes, including filters, to be moved into a coding area in which an attribute or an attribute element is being edited. In another embodiment, the user interface presents data fields to assist in the development of filters for multiple data sources with divergent formats. The application further provides a validation interface through which users can validate attributes and trace the results returned by various elements referenced by the attributes under validation. Another embodiment provides a system for managing attributes and deploying them to various systems by creating a deployment file that is used by an attribute calculation system. In one embodiment, the attribute calculation system is a scalable system that dynamically calculates attributes for multiple data sources.

Claims

1. A computer-implemented method for generating attributes, the computer-implemented method comprising:

receiving, via a validation user interface that includes options that enable a user to define and deploy filters and attributes associated with different data sources having different data formats, a user selection of an attribute, wherein the attribute relates to a type of credit data;

identifying a credit data attribute formula expression based on the received user selection of the attribute;

displaying, via the validation user interface, dependencies between the attribute and a plurality of filters, wherein a first filter of the plurality of filters is configured to extract data from a first data source having a first data format by mapping one or more data fields in the first data source to the type of credit data and a second filter of the plurality of filters is configured to extract data from a second data source having a second data format by mapping one or more data fields in the second data source to the type of credit data;

generating a deployment package by compiling the credit data attribute formula expression into computer executable code; and

deploying the deployment package to a computing system, wherein the deployment package includes one or more computer instructions that when executed, generates an attribute value by at least;

extracting a subset of data associated with the attribute from the first data source in accordance with the first filter; and

applying the subset of data associated with the attribute from the first data source to the credit data attribute formula expression.

2. The computer-implemented method of claim 1 further comprising:

accessing a dependency tracing indicative of a dependency between the attribute, and an operator; and

displaying a result of applying the data associated with the attribute to at least a portion of the computer executable code of the credit data attribute formula expression.

3. The computer-implemented method of claim 1, further comprising:

receiving, from the validation user interface, user information associated with a user;

generating a user profile;

adding the received user information to data fields of the user profile; and

storing the identified credit data attribute formula expression in the user profile.

4. The computer-implemented method of claim 3, further comprising:

receiving, from the validation user interface, user information associated with a client of the user;

adding the received user information to data fields of the user profile; and

associating the identified credit data attribute formula expression with the received user information in the user profile.

5. The computer-implemented method of claim 1, further comprising retrieving, from the validation user interface, a user selection of a version command to store the credit data attribute formula expression as one version of a plurality of versions of the credit data attribute formula expression.

6. The computer-implemented method of claim 1, further comprising retrieving, from the validation user interface, a user selection of other user access authorization, wherein the user selection includes at least authorization to use the credit data attribute formula expression without authorization to edit the credit data attribute formula expression.

7. The computer-implemented method of claim 1, further comprising determining at least one weighting to be applied to the attribute.

8. The computer-implemented method of claim 1, further comprising causing display of dependencies between the attribute, and an operator.

9. A system for generating attributes, the system comprising:

one or more processors; and

non-transitory computer storage comprising code executable by the one or more processors, the executable code causing the one or more processors to perform operations including;

receiving, via a validation user interface that includes options that enable a user to define and deploy filters and attributes associated with different data sources having different data formats, a user selection of an attribute, wherein the attribute relates to a type of credit data;

identifying a credit data attribute formula expression based on the received user selection of the attribute;

displaying, via the validation user interface, dependencies between the attribute and a plurality of filters, wherein a first filter of the plurality of filters is configured to extract data from a first data source having a first data format by mapping one or more data fields in the first data source to the type of credit data and a second filter of the plurality of filters is configured to extract data from a second data source having a second data format by mapping one or more data fields in the second data source to the type of credit data;

generating a deployment package by compiling the credit data attribute formula expression into computer executable code; and

deploying the deployment package to a computing system, wherein the deployment package includes one or more computer instructions that when executed, generates an attribute value by at least;

extracting a subset of data associated with the attribute from the first data source in accordance with the first filter; and

applying the subset of data associated with the attribute from the first data source to the credit data attribute formula expression.

10. The system of claim 9 wherein the operations further include:

accessing a dependency tracing indicative of a dependency between the attribute, and at least one function or operator; and

displaying a result of applying the data associated with the attribute to at least a portion of the credit data attribute formula expression.

11. The system of claim 9 wherein the operations further include:

receiving, from the validation user interface, user information associated with a user;

generating a user profile;

adding the received user information to data fields of the user profile; and

storing the identified credit data attribute formula expression in the user profile.

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

receiving, from the validation user interface, client information associated with a client of the user;

adding the received user information to data fields of the user profile; and

associatinng the identified credit data attribute formula expression to the received user information in the user profile.

13. The system of claim 9, wherein the operations further include retrieving, from the validation user interface, a user selection of a version command to store the credit data attribute formula expression as one version of the credit data attribute formula expression.

14. The system of claim 9, wherein the operations further include retrieving, from the validation user interface, a user selection of a lock command to lock the identified credit data attribute formula expression.

15. A non-transitory computer storage medium which stores a client application comprising executable code, the executable code causing a computing device to perform operations that comprise at least:

receiving, via a validation user interface that includes options that enable a user to define and deploy filters and attributes associated with different data sources having different data formats, a user selection of an attribute, wherein the attribute relates to a type of credit data;

identifying a credit data attribute formula expression based on the received user selection of the attribute;

displaying, via the validation user interface, dependencies between the attribute and a plurality of filters, wherein a first filter of the plurality of filters is configured to extract data from a first data source having a first data format by mapping one or more data fields in the first data source to the type of credit data and a second filter of the plurality of filters is configured to extract data from a second data source having a second data format by mapping one or more data fields in the second data source to the type of credit data;

generating a deployment package by compiling the credit data attribute formula expression into computer executable code; and

deploying the deployment package to a computing system, wherein the deployment package includes one or more computer instructions that when executed, generates an attribute value by at least;

extracting a subset of data associated with the attribute from the first data source in accordance with the first filter; and

applying the subset of data associated with the attribute from the first data source to the credit data attribute formula expression.

16. The non-transitory computer storage medium of claim 15, wherein the operations further comprise:

accessing a dependency tracing indicative of a dependency between the attribute, and at least one function or operator; and

displaying a result of applying the data associated with the attribute to the at least one function or operator.

17. The non-transitory computer storage medium of claim 15, wherein the operations further comprise:

receiving, from the validation user interface, user information associated with a user;

generating a user profile;

adding the received user information to data fields of the user profile;

storing the attribute, and at least one function or operator in the user profile;

receiving, from the validation user interface, client information associated with a client of the user;

adding the received client information to data fields of the user profile; and

associating the attribute, and the at least one function or operator with the received client information in the user profile.

18. The non-transitory computer storage medium of claim 15, wherein generating the attribute value for the attribute includes generating the attribute value using a simulation file, and wherein the first data source is a simulated data source.

19. The non-transitory computer storage medium of claim 15, wherein the executable code is configured to be executed in response to a calling function.