Building analytical models with standardized virtual flat files
First Claim
1. A computer-implemented method for building analytical models with standardized virtual flat files, comprising:
- creating at least one view of a database, wherein the at least one view comprises at least one database field and at least one transform, wherein the transform is based on database data;
creating a virtual flat file from the at least one view, wherein the virtual flat file includes an identification data region, a product ownership data region, a behavior data region, a demographics data region, a model scores data region, and a contacts data region;
building at least one analytical model using the virtual flat file as input variables for the analytical model;
wherein the data regions of the virtual flat file comprise a complete input stream needed to perform a plurality of various customer analytical modeling wherein no additional data is required.
1 Assignment
0 Petitions
Accused Products
Abstract
A system and method for creating virtual flat customer records derived from database customer data that may be used as standardized input for analytical models. A Customer Analytic Record (“CAR”) application may be created as a database object to extract, transform, and format all of the customer data needed for customer segmentation and predictive modeling. The CAR may be a set of database views that are defined using virtual stored queries The CAR application may dynamically calculate additional variables using predetermined transformations, including custom transformations of an underlying behavior. The CAR is preferably a dynamic view of the customer record that changes whenever any update is made to the database. The definition of the CAR provides documentation of each data element available for use in models and analytics.
73 Citations
9 Claims
-
1. A computer-implemented method for building analytical models with standardized virtual flat files, comprising:
-
creating at least one view of a database, wherein the at least one view comprises at least one database field and at least one transform, wherein the transform is based on database data;
creating a virtual flat file from the at least one view, wherein the virtual flat file includes an identification data region, a product ownership data region, a behavior data region, a demographics data region, a model scores data region, and a contacts data region;building at least one analytical model using the virtual flat file as input variables for the analytical model; wherein the data regions of the virtual flat file comprise a complete input stream needed to perform a plurality of various customer analytical modeling wherein no additional data is required. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9)
-
Specification