Method and apparatus for creating and using a master catalog
First Claim
Patent Images
1. A computer-implemented method for updating a master product attribute catalog database for consumer response modeling, comprising:
- receiving data in a customer specific data format from at least one source of product data, wherein the received data includes product data, store data, cost data promotion data and point of sale data;
converting the received data, using a customer specific data map, from the customer specific data format to a common data format useful for updating a master product attribute catalog;
storing the converted received data in a staging database;
performing a data integrity check on the converted received data;
determining if the converted received data exists in the master product attribute catalog, and if the converted received data exists in the master product attribute catalog;
then performing a reconciliation between the converted received data and the master product attribute catalog to determine whether there is a conflict between the converted received data and the master product attribute catalog, and if there is a conflict then performing a vote of the converted received data, and whenever the vote exceeds a threshold then updating the product data in the master product attribute catalog;
else if the converted received data does not exists in the master product attribute catalog, then creating a new record of the converted received data in the master product attribute catalog, and updating the master product attribute catalog by adding the product data to the new record;
adding the converted received data to a modeling database;
adding the product data from the master product attribute catalog to the modeling database;
creating a consumer response model from the converted received data and the product data in the modeling database, wherein the consumer response model includes a sales model;
adding the converted received data to an optimization database;
adding the product data from the master product attribute catalog to the optimization database; and
adding parameters including model coefficients of the consumer response model to the optimization database, and wherein the model coefficients are estimated using Bayesian statistics.
5 Assignments
0 Petitions
Accused Products
Abstract
A method for updating a master product attribute catalog database for consumer response modeling is provided. Data is received from at least one source of product data. A data integrity check is preformed on the received data. A reconciliation is performed between the received data and the master product attribute catalog. The reconciled received data is placed in a master product attribute catalog.
-
Citations
10 Claims
-
1. A computer-implemented method for updating a master product attribute catalog database for consumer response modeling, comprising:
-
receiving data in a customer specific data format from at least one source of product data, wherein the received data includes product data, store data, cost data promotion data and point of sale data; converting the received data, using a customer specific data map, from the customer specific data format to a common data format useful for updating a master product attribute catalog; storing the converted received data in a staging database; performing a data integrity check on the converted received data; determining if the converted received data exists in the master product attribute catalog, and if the converted received data exists in the master product attribute catalog; then performing a reconciliation between the converted received data and the master product attribute catalog to determine whether there is a conflict between the converted received data and the master product attribute catalog, and if there is a conflict then performing a vote of the converted received data, and whenever the vote exceeds a threshold then updating the product data in the master product attribute catalog; else if the converted received data does not exists in the master product attribute catalog, then creating a new record of the converted received data in the master product attribute catalog, and updating the master product attribute catalog by adding the product data to the new record; adding the converted received data to a modeling database; adding the product data from the master product attribute catalog to the modeling database; creating a consumer response model from the converted received data and the product data in the modeling database, wherein the consumer response model includes a sales model; adding the converted received data to an optimization database; adding the product data from the master product attribute catalog to the optimization database; and adding parameters including model coefficients of the consumer response model to the optimization database, and wherein the model coefficients are estimated using Bayesian statistics. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10)
-
Specification