DATA ACQUISITION, NORMALIZATION, AND EXCHANGE IN A RETAIL ECOSYSTEM

• US 20140222712A1
• Filed: 01/31/2014
• Published: 08/07/2014
• Est. Priority Date: 02/01/2013
• Status: Abandoned Application

• Current Assignee: SPS Commerce, Inc. (China)
• Original Assignee: SPS Commerce, Inc. (China)
• Inventors: Samaha, Luke, Zielieke, La Moine, Bjerstedt, Scott, Bolduc, Scott
• Application Number:
  US14/169,347
• Publication Number:
  US 20140222712A1
• Time in Patent Office: Days
• US Class Current: 705/342
• CPC Class Codes: G06Q 10/00 Administration; Management

Abstract

A method for normalizing and exchanging document data between trading partners in a retail ecosystem. The method may include acquiring electronic documents from a plurality of sending trading partners, each electronic document from the sending trading partners provided in a format corresponding to which trading partner the electronic document came from, and each electronic document having a document type. The method may transform the electronic documents to a normalized format based on map objects, each relating to a corresponding document type, the map objects generated based on specification models defined by the trading partners, the specification models defining relationships between data specifications of the trading partners for the document types and data specifications for the normalized format for the document types. Each transformed electronic document may de-normalized from the normalized format to one or more output formats based on the map objects for the corresponding document type.

Claims

1. A method for normalizing and exchanging document data relating to an exchange of goods between trading partners in a retail ecosystem, the method comprising:

acquiring electronic document data from a first trading partner through an electronic network, the electronic document data provided in a first format and relating to a document type utilized by the first trading partner in exchanging goods between one or more other trading partners in the retail ecosystem;

transforming the electronic document data to a normalized format based on a dynamic map object for the document type generated based on a first specification model defined by the first trading partner, the first specification model defining relationships between data specifications of the first trading partner for the document type and data specifications for the normalized format for the document type;

storing the transformed electronic document data in the normalized format in a normalized data storage repository comprised of one or more computer readable storage devices;

de-normalizing the transformed electronic document data from the normalized format to a second format based on a dynamic map object for the document type generated based on a second specification model defined by a second trading partner, the second specification model defining relationships between data specifications of the second trading partner for the document type and data specifications for the normalized format for the document type; and

transmitting the de-normalized electronic document data in the second format to the second trading partner through the electronic network.

2. The method of claim 1, wherein acquiring electronic document data from a first trading partner through an electronic network comprises acquiring electronic document data through a universal adapter module, permitting polling of one or more of the first trading partner'"'"'s systems for new document data and acquiring the new document data.

3. The method of claim 1, further comprising storing the electronic document data provided in a first format in a storage repository comprised of one or more computer readable storage devices.

4. The method of claim 1, wherein transformation of the electronic document data to a normalized format is independent of where the electronic document data is destined.

5. The method of claim 1, wherein the first specification model defined by the first trading partner further defines one or more data constraints for data within the electronic document data.

6. The method of claim 5, wherein transforming the electronic document data to a normalized format comprises validating data within the electronic document data based on the one or more data constraints defined by the first trading partner.

7. The method of claim 1, further comprising:

de-normalizing the transformed electronic document data from the normalized format to a third format based on a dynamic map object for the document type generated based on a third specification model defined by a third trading partner, the third specification model defining relationships between data specifications of the third trading partner for the document type and data specifications for the normalized format for the document type; and

transmitting the de-normalized electronic document data in the third format to the third trading partner through the electronic network.

8. The method of claim 1, wherein de-normalizing the transformed electronic document data from the normalized format to a second format further comprises modifying the electronic document data based on specifications defined by the second trading party relating to at least one of an identification of the first trading party and an identification of a relationship between the first and second trading partners.

9. The method of claim 1, wherein de-normalizing the transformed electronic document data from the normalized format further comprises modifying the electronic document data based on data cross-referenced from data sources other than the electronic document data.

10. The method of claim 1, further comprising correlating the electronic document data acquired from the first trading partner with other document data acquired by another trading partner based on data within the electronic document data from the first trading partner.

11. A system for normalizing and exchanging document data relating to an exchange of goods between trading partners in a retail ecosystem, the system comprising:

a data intake module, operably connected with an electronic network, acquiring electronic document data from a first trading partner through the electronic network, the electronic document data provided in a first format and relating to a document type utilized by the first trading partner in exchanging goods between one or more other trading partners in the retail ecosystem;

one or more transformation engines receiving the electronic document data from the intake module and transforming the electronic document data to a normalized format based on a dynamic map object for the document type generated based on a first specification model defined by the first trading partner, and de-normalizing the transformed electronic document data from the normalized format to a second format based on a dynamic map object for the document type generated based on a second specification model defined by a second trading partner;

a normalized data storage repository, comprised of one or more computer readable storage devices, storing the transformed electronic document data in the normalized format; and

a data export module, operably connected with the electronic network, transmitting the de-normalized electronic document data in the second format to the second trading partner through the electronic network;

wherein the first specification model defines relationships between data specifications of the first trading partner for the document type and data specifications for the normalized format for the document type; and

wherein the second specification model defines relationships between data specifications of the second trading partner for the document type and data specifications for the normalized format for the document type.

12. The system of claim 11, further comprising an Internet-based user interface, accessible over an electronic network, through which each trading partner of the retail ecosystem may define one or more specification models for one or more corresponding document types.

13. The system of claim 12, wherein the Internet-based user interface comprises a graphical user interface through which each trading partner of the retail ecosystem may define its one or more specification models using graphical interface widgets, without requiring an underlying understanding of computer programming code.

14. The system of claim 13, wherein the Internet-based user interface further comprises a trading partner accessible programming code editing pane, permitting a trading partner to utilize computer programming code to define at least a portion of its one or more specification models.

15. The system of claim 13, further comprising a transformation library, comprised of one or more computer readable storage devices, storing the dynamic map objects.

16. The system of claim 13, further comprising a document rules engine modifying the electronic document data based on specifications defined by the second trading party relating to at least one of an identification of the first trading party and an identification of a relationship between the first and second trading partners.

17. The system of claim 13, wherein the one or more transformation engines further de-normalize the transformed electronic document data from the normalized format to a third format based on a dynamic map object for the document type generated based on a third specification model defined by a third trading partner, wherein the third specification model defines relationships between data specifications of the third trading partner for the document type and data specifications for the normalized format for the document type.

18. The system of claim 17, wherein the data export module further transmits the de-normalized electronic document data in the third format to the third trading partner through the electronic network

19. A method for normalizing and exchanging document data relating to an exchange of goods between trading partners in a retail ecosystem, the method comprising:

acquiring electronic documents from a plurality of sending trading partners through an electronic network, each electronic document from the sending trading partners provided in a format corresponding to which trading partner the electronic document came from, and each electronic document having a document type;

transforming the electronic documents to a normalized format based on dynamic map objects, each relating to a corresponding document type, the map objects generated based on specification models defined by the trading partners, the specification models defining relationships between data specifications of the trading partners for the document types and data specifications for the normalized format for the document types;

storing the transformed electronic documents in the normalized format in a normalized data storage repository comprised of one or more computer readable storage devices;

de-normalizing each transformed electronic document from the normalized format to one or more output formats based on the dynamic map objects for the corresponding document type; and

transmitting the de-normalized electronic documents in the one or more output formats to receiving trading partners through the electronic network.

20. The method of claim 19, wherein transformations occurring during the transforming of electronic documents to a normalized format are isolated from the transformations occurring during the de-normalizing of transformed electronic documents from the normalized format.