AUTOMATED CHANNEL DATA EXTRACTION AND TRANSFORMATION

US 20090327452A1
Filed: 05/30/2008
Published: 12/31/2009
Est. Priority Date: 06/01/2007
Status: Active Grant

First Claim

Patent Images

1. A system for automated delivery of channel market data from a product channel participant, the system comprising:

a storage medium configured to store a plurality of reporting templates and a plurality of rules;

a data warehouse including product channel data;

a machine capable 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 a subset of product channel data from the data warehouse;

one of said software portions is configured to transform the subset of product channel data based on one of the plurality of reporting templates; and

one of said software portions is configured to deliver the transformed subset of product channel data;

a firewall wherein the storage medium, the data warehouse and the machine operate inside the firewall; and

a server operating outside of the firewall wherein the server is accessible by an enterprise and configured to receive the transformed subset of product channel data.

View all claims

8 Assignments

Timeline View

Assignment View

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.

14 Citations

View as Search Results

22 Claims

1. A system for automated delivery of channel market data from a product channel participant, the system comprising:
- a storage medium configured to store a plurality of reporting templates and a plurality of rules;
  
  a data warehouse including product channel data;
  
  a machine capable 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 a subset of product channel data from the data warehouse;
  
  one of said software portions is configured to transform the subset of product channel data based on one of the plurality of reporting templates; and
  
  one of said software portions is configured to deliver the transformed subset of product channel data;
  
  a firewall wherein the storage medium, the data warehouse and the machine operate inside the firewall; and
  
  a server operating outside of the firewall wherein the server is accessible by an enterprise and configured to receive the transformed subset of product channel data.
- View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11)
- - 2. The system of claim 1 wherein each template identifies desired product channel data and a format for said product channel data.
  - 3. The system of claim 1 wherein each template is based on data requests from the enterprise and is configured to be compatible with the data warehouse.
  - 4. The system of claim 1 wherein content of each template is approved by the product channel participant.
  - 5. The system of claim 1 wherein the firewall prevents unauthorized access to the data warehouse.
  - 6. The system of claim 1 wherein the wide area network includes the Internet.
  - 7. The system of claim 1 wherein the subset of product channel data is based on at least one of the plurality of reporting templates.
  - 8. The system of claim 1 wherein the transformed subset of product channel data is encrypted prior to being delivered to the server.
  - 9. The system of claim 1 wherein one or more rules is associated with each of the plurality of templates and, responsive to transformation of the subset of product channel data, at least one rule verifies that the transformed product channel data includes enterprise required data.
  - 10. The system of claim 1 further comprising a log verifying delivery of transformed product channel data to the server.
  - 11. The system of claim 1 wherein the storage medium includes reference data supplied by the enterprise and used to verify that transformed product channel data is within an acceptable content range.

12. A computer implemented method for automated delivery of channel market data, the method comprising:
- storing in a storage medium a plurality of reporting templates and a plurality of rules received from a plurality of enterprises;
  
  storing by a channel product participant in a data warehouse product channel data;
  
  extracting a subset of product channel data from the data warehouse based on a first template from the plurality of reporting templates;
  
  transforming the subset of product channel data based on a second template from the plurality of reporting templates;
  
  validating transformed product channel data based on one of the plurality of rules;
  
  delivering transformed product channel data to a server; and
  
  accessing at the server by the enterprise transformed channel product data.
- View Dependent Claims (13, 14, 15, 16, 17, 18, 19, 20, 21)
- - 13. The method of claim 12 wherein extracting includes identifying product channel data desired by the enterprise.
  - 14. The method of claim 12 wherein each reporting template is configured to be compatible with the data warehouse.
  - 15. The method of claim 12 further comprising validating each reporting template by the product channel participant.
  - 16. The method of claim 12 wherein extracting, transforming and validating occur within the confines of a firewall controlled by the channel product participant.
  - 17. The method of claim 16 wherein a wide area network is interposed between the server and the firewall and wherein the wide area network includes the Internet.
  - 18. The method of claim 12 further comprising encrypting the transformed product channel data prior to being delivered to the server.
  - 19. The method of claim 12 wherein, responsive to transformation of the subset of product channel data, verifying transformed product channel data includes data required by the enterprise.
  - 20. The method of claim 12 further comprising maintaining a log of delivery verification of transformed product channel data to the server.
  - 21. The method of claim 12 wherein validating includes comparing transformed product channel data to reference data supplied by the enterprise to verify that the transformed product channel data is within an acceptable content range.

22. A 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 in a storage medium a plurality of reporting templates and a plurality of rules received from a plurality of enterprises;
  
  one of said program codes for storing by a channel product participant in a data warehouse product channel data;
  
  one of said program codes for extracting a subset of product channel data from the data warehouse based on a first template from the plurality of reporting templates;
  
  one of said program codes for transforming the subset of product channel data based on a second template from the plurality of reporting templates;
  
  one of said program codes for validating transformed product channel data based on one of the plurality of rules;
  
  one of said program codes for delivering transformed product channel data to a server; and
  
  one of said program codes for accessing at the server by the enterprise transformed channel product data.

Specification

Resources

Litigation Campaign Assessment

Current Assignee
Model N, Inc.
Original Assignee
Infonow Corporation
Inventors
Joshi, Vineet, Rosenblum, Irwin, Rand, Nahum

Granted Patent

US 8,296,258 B2
Time in Patent Office

Days
Field of Search
US Class Current

709/219
CPC Class Codes

G06Q 30/06 Buying, selling or leasing ...

AUTOMATED CHANNEL DATA EXTRACTION AND TRANSFORMATION

First Claim

8 Assignments

0 Petitions

Accused Products

Abstract

14 Citations

22 Claims

Specification

Solutions

Use Cases

Quick Links

AUTOMATED CHANNEL DATA EXTRACTION AND TRANSFORMATION

First Claim

8 Assignments

Subscription Required

Subscription Required

0 Petitions

Subscription Required

Accused Products

Subscription Required

Abstract

14 Citations

22 Claims

Specification

Subscription Required

Solutions

Use Cases

Quick Links