Automated channel market data extraction, validation and transformation
DC CAFCFirst Claim
1. A system for automated delivery of channel market data from product channel participants, the system comprising:
- a data warehouse including aggregate product channel data in product channel participant format from a plurality of product channel participants wherein the aggregate product channel data includes sales and inventory data associated with products from a plurality of enterprises;
a machine operable of executing instructions embodied as software;
a plurality of software portions stored on the storage medium and executable by the machine, whereinone of said software portions is configured to extract from the data warehouse a subset of the aggregate product channel data, the subset comprising product channel data from one or more of the plurality of product channel participants associated with one of the plurality of enterprises;
one of said software portions is configured to transform the subset of product channel data based on one of a plurality of reporting templates forming a transformed subset of aggregate product channel data;
one of said software portions is configured to control, by each of the one or more of the plurality of product channel participants, release of corresponding portions of the transformed subset of aggregate product channel data to the one of the plurality of enterprises; and
one of said software portions is configured to deliver the transformed subset of product channel data to the one of the plurality of enterprises;
a firewall wherein the storage medium, the data warehouse and the machine operate inside the firewall under the control of at least one of the plurality of product channel participants and is inaccessible by the plurality of enterprises; and
a server operating outside of the firewall wherein the server is accessible by the one of the plurality of enterprises and configured to receive the transformed subset of product channel data.
8 Assignments
Litigations
0 Petitions
Accused Products
Abstract
Select portions of product channel data collected by a product channel participant and stored in a data warehouse are periodically extracted based on a previously determined template. The extracted subset of product channel data is thereafter transformed so that the format of the data complies with that of the requesting enterprise. Once transformed, one or more rule sets is applied to the subset of transformed data to guarantee that the information complies with requirements set forth by the enterprise yet does not violate any disclosure rules of the product channel participant. Thereafter and on a scheduled basis, the transformed and validated data is delivered to a delivery server from which the enterprise can retrieve the data at its convenience.
13 Citations
20 Claims
-
1. A system for automated delivery of channel market data from product channel participants, the system comprising:
-
a data warehouse including aggregate product channel data in product channel participant format from a plurality of product channel participants wherein the aggregate product channel data includes sales and inventory data associated with products from a plurality of enterprises; a machine operable of executing instructions embodied as software; a plurality of software portions stored on the storage medium and executable by the machine, wherein one of said software portions is configured to extract from the data warehouse a subset of the aggregate product channel data, the subset comprising product channel data from one or more of the plurality of product channel participants associated with one of the plurality of enterprises; one of said software portions is configured to transform the subset of product channel data based on one of a plurality of reporting templates forming a transformed subset of aggregate product channel data; one of said software portions is configured to control, by each of the one or more of the plurality of product channel participants, release of corresponding portions of the transformed subset of aggregate product channel data to the one of the plurality of enterprises; and one of said software portions is configured to deliver the transformed subset of product channel data to the one of the plurality of enterprises; a firewall wherein the storage medium, the data warehouse and the machine operate inside the firewall under the control of at least one of the plurality of product channel participants and is inaccessible by the plurality of enterprises; and a server operating outside of the firewall wherein the server is accessible by the one of the plurality of enterprises and configured to receive the transformed subset of product channel data. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9)
-
-
10. A computer implemented method for automated delivery of channel market data, the method comprising:
-
storing by a plurality of product channel participants in a data warehouse, aggregate product channel data in product channel participant format wherein the aggregate product channel data includes sales and inventory data associated with products from the plurality of enterprises, and wherein a subset of the aggregate product channel data is associated with one of the plurality of enterprises; extracting the subset of product channel data from the data warehouse based on a first template from the plurality of reporting templates, the subset comprising product channel data from one or more of the product channel participants; transforming the subset of product channel data based on a second template from the plurality of reporting templates forming a transformed subset of aggregate product channel data; controlling by each of the plurality of product channel participants release of corresponding portions of the transformed subset of aggregate product channel data to the one of the plurality of enterprises; delivering released portions of the transformed subset of aggregate product channel data to a server; and accessing at the server by the one of the plurality of enterprises, transformed product channel data. - View Dependent Claims (11, 12, 13, 14, 15, 16, 17, 18, 19)
-
-
20. A non-transitory computer-readable storage medium tangibly embodying a program of instructions executable by a machine wherein said program of instructions comprises a plurality of program codes for automated delivery of channel market data, said program of instructions comprising:
-
one of said program codes for storing by a plurality of product channel participants in a data warehouse aggregate product channel data in a product channel participant format wherein the aggregate product channel data includes sales data associated with products from the plurality of enterprises, and wherein a subset of the aggregate product channel data is associated with one of the plurality of enterprises; one of said program codes for extracting the subset of product channel data from the data warehouse based on a first template from the plurality of reporting templates, the subset comprising product channel data from one or more of the product channel participants; one of said program codes for transforming the subset of aggregate product channel data based on a second template from the plurality of reporting templates forming a transformed subset of aggregate product channel data; one of said program codes for controlling by each of the plurality of product channel participants release of corresponding portions of the transformed subset of aggregate product channel data to the one of the plurality of enterprises; one of said program codes for delivering released portions of the transformed subset of aggregate product channel data to a server; and
one of said program codes for accessing at the server by the one of the plurality of enterprises, transformed channel product data.
-
Specification