WO2007100423A1

WO2007100423A1 - Scalable algorithm for sharing edi schemas

Info

Publication number: WO2007100423A1
Application number: PCT/US2007/001550
Authority: WO
Inventors: Suraj Gaurav; Surendra Machiraju
Original assignee: Microsoft Corporation
Priority date: 2006-02-24
Filing date: 2007-01-19
Publication date: 2007-09-07
Also published as: CN101390089A; US20070203921A1; JP2009527853A; US7620645B2; EP1991931A4; KR20080100344A; EP1991931A1; CN101390089B

Abstract

Developing a file corresponding to an electronic data interchange (EDI) schema. The EDI schema is selected for transmission to a destination device. A plurality of syntax structures in the selected EDI schema is identified. The plurality of syntax structures defines a type of transaction associated with the EDI schema. A plurality of EDI data values is extracted from the identified plurality of syntax structures according to the defined type. A file is generated corresponding to the type and including the extracted data values in the generated file such that the EDI schema can be re-created from the generated file.

Description

SCALABLE ALGORITHM FOR SHARING EDI SCHEMAS

BACKGROUND [0001] Electronic data interchange (EDI) is one of the ways businesses use for exchanging computer-to-computer business information based on approved formatting standards and schemas. For example, millions of companies around the world transmit data associated with business transactions (e.g., purchase orders, shipping/air bills, invoices, or the like) using EDI to conduct commerce. [0002] In a typical EDI transaction model, a large business entity or an EDI integration broker trades with numerous partners and has the technical capability to handle numerous EDI transaction data in various EDI formats and schemas. These entities, also known as "hubs," transact with one or more suppliers, also known as "spokes". Each of the spokes typically is a relatively small business entity that is only capable of dealing with one hub. [0003] Before the spokes attempt to initiate transactions via EDI with the hub, the hub typically transmits various EDI schemas to the spokes so that the spokes may properly format the EDI transactions according to the EDI schemas. Currently, EDI schemas are large in size and the file size for each EDI schema typically ranges from 1 MB to 3 MB. In addition, the hub or large trading partners customarily transmit a large amount of schemas to the spokes, without taking into considerations of the spokes' lack of hardware capability. As such, thousands of such schemas, which may occupy several gigabytes in bandwidth during transmission, are transmitted from the hub to the spokes. This practice unduly burdens the spokes' ability to handle schemas efficiently when their data connection bandwidth is limited. SUMMARY

[0004] Embodiments of the invention overcome the deficiencies of existing systems and practice by processing the schemas to enable trading partners to exchange schemas in bulk without placing transmission burdens on the spokes. Embodiments of the invention generate a simple text file embodying the information or data relating to the schemas while removing redundant and repeated information.

[0005] This summary is provided to introduce a selection of concepts in a simplified form that are further described below in the Detailed Description. This Summary is not intended to identify key features or essential features of the claimed subject matter, nor is it intended to be used as an aid in determining the scope of the claimed subject matter. [0006] Other features will be in part apparent and in part pointed out hereinafter.

BRIEF DESCRIPTION OF THE DRAWINGS [0007] FIG. 1 is a block diagram illustrating a system for developing a file corresponding to an electronic data interchange (EDI) schema according to an embodiment of the invention.

[0008] FIG. 2 is a block diagram illustrating an EDI schema to be compacted by the system in FIG. 1 according to an embodiment of the invention. [0009] FIG. 3A is a block diagram illustrating a first exemplary file developed from the

EDI schema in FIG. 2 according to an embodiment of the invention.

[0010] FIG. 3B is a block diagram illustrating a second exemplary file developed from an EDI schema according to an embodiment of the invention.

[0011 ] FIG. 4 is a flow diagram illustrating an exemplary method for developing a file according to an EDI schema according to an embodiment of the invention. [0012] FIG. 5 is a block diagram illustrating an exemplary computer-readable medium on which aspects of the invention may be stored.

[0013] FIG. 6 is a block diagram illustrating one example of a suitable computing system environment in which the invention may be implemented. [0014] Corresponding reference characters indicate corresponding parts throughout the drawings.

DETAILED DESCRIPTION

[0015] Referring first to FIG. 1, a block diagram illustrates a system 100 for developing a file corresponding to an electronic data interchange (EDI) schema according to an embodiment of the invention. The system 100 includes a hub 102 linked to and communicating with one or more spokes 104. In one embodiment, the hub 102 includes a server computer or a computing device serving one or more processors (e.g., processor 106) or processing units for executing computer-executable instructions for serving the spokes 104. In one example, the spokes 104 include a computing device having one or more components included in or coupled with a computer 130, as shown in FIG. 6. [0016] In one example, the hub 1.02 also includes a memory area 108 for storing one or more EDI schemas, such as an EDI schema 110. Initially, the hub 102 and the spokes 104 establish agreements as to the EDI formats or standards to be used for transmitting transaction data therebetween. Once the parties determine the particular EDI formats or standards, the hub 102 selects the appropriate EDI schemas to be transmitted to the spokes 104. In another example, the hub 102 may choose to select all EDI schemas for all types of transactions, such as purchase orders, bills of lading, invoices, payrolls, or the like, to the spokes 104. Although the communications between the hub 102 and the spokes 104 can be a private or public, either wired or wirelessly, communications network, the spokes 104 typically lack the hardware resources to handle large amount of EDI schemas sent from the hub 102. In addition, the type and bandwidth of computing network communications for the spokes 104 are not equipped to handle such demand imposed by the thousands of EDI schemas, which can reach several Gigabytes in data size. For example, the spokes may be connected to a public communications network such as the internet via a dial-up, a digital subscriber line (DSL), or a cable connection, which has a limited data transmission bandwidth.

[0017] As such, the processor 106 of the hub 102 develops a file (e.g., file 112, 114, 116, or 118) for the spokes such that the EDI schema 110 can be re-created from the file, and the file size of the file 112 is substantially smaller than the EDI schema 110.

[0018] Referring now to FIG. 2, a block diagram illustrates an exemplary EDI schema 202 to be processed by the system 100 in FIG. 1 according to an embodiment of the invention. Ih this example, the EDI schema 202 is written in an extensible Markup Language (XML) format and includes one or more XML tags, which are self-describing, but are verbose and demand greater resource requirements in terms of disk space or memory for processing.

[0019] For example, a tag statement 204 indicates that there are three data elements: minimum occurrence, maximum occurrence, and name. As shown in FIG. 2, each data element includes a data value, such as "0", "1", and "SAC04". respectively. [0020] In developing or generating the file 112, embodiments of the invention identify a plurality of syntax structures in the EDI schema 202. For the example, the processor 106 of the hub 102 executes computer-executable instructions for identifying the plurality of syntax structures, such as <XS: element>, <XS: restriction base>, <XS: minlength>, or other XML tags defining a type of transaction associated with the EDI schema 202. In one example, the XML tags may define a purchase order transaction schema while other XML tags may appropriately identify EDI schemas of other transaction type, (e.g., invoice, payroll, or the like).

[0021] Still referring to FIG. 2, once the plurality of syntax structure is identified, a plurality of EDI data values is extracted from the identified plurality of syntax structures according to the defined type. Once the plurality of the EDI data values is extracted, embodiments of the invention generate a file corresponding to the type and include the extracted data values in the generated file such that the EDI schema can be re-created from the generated file. For example, the processor 106 of the hub 102 extracts a data value "AN" from a XML tag statement 206 after identifying the syntax structure of "<XS: Restriction base>". Likewise, a XML tag statement 208 reveals that " 1 " is the data value to be extracted. Similarly, the processor 106 of the hub 102 may also extract a data value "10" from an XML tag statement 210 after identifying the syntax structure of "<XS: Maxlength>". [0022] It is to be understood that embodiments of the invention may appropriately identify EDI scripting languages or programming languages other than XML, such as

HTML or XSLT, in identify the syntax structures of the languages without departing from the scope of the invention.

[0023] Referring now to FIG. 3A, a block diagram illustrates a first exemplary file 302 developed from the EDI schema in FIG. 2 according to an embodiment of the invention. In this example, the file 302 includes the following extracted data values to represent the EDI schema 202: "SAC04 0 1 {AN 1 10}". In one embodiment, the extracted data value in the file 302 is organized according to an encoding rule. In one example, the encoding rule defines or formats the extracted data values by placing data values in the following order: "name" "minimum occurrence" "maximum occurrence" "restriction base" "minlength" "maxlength." It is to be understood that other sequencing order of extracted data values or formatting styles (e.g., delimiter characters, indentation, carriage return symbols, or the like) may be employed without departing from the scope of the invention. [0024] As shown in FIGS. 2 and 3 A, the content of the EDI schema 202 includes about 273 characters (excluding the spaces), while the developed or generated file 302 includes only 19 characters, including the spaces. Both EDI schema 202 and the developed file 302 represent the essential information which defines and describes a format of a transaction type for the spokes. With such a reduced simplicity and data size, embodiments of the invention ease the burden on the spokes to handle numerous EDI schemas transmission. FIG. 3B illustrates another example of a second exemplary file 304 representing an EDI schema having a S ACLoop.

[0025] In the example illustrated in FIG. 3B, the exemplary file 304 includes a compacted SACLoop. The SACLoop is a loop structure and includes other children structure. In this example, the SACLoop includes two children: SAC 306 and CUR 308. In one embodiment, each line representing a child is indented in the file 304 for readability. In addition, each child may also include one or more children. As such, both children SAC 306 and CUR 308 and their respective children (e.g., SACOl to SAC 16, and CUROl to CUR21) are compacted according to the method illustrated above. [0026] In another embodiment, the size of the developed or generated file 302 may be further reduced in size by using any generic data compression algorithm or known compression technique (e.g., zip, tar, rar, or the like) to further compact the size of the file 302.

[0027] FIG. 4 is a flow diagram illustrating an exemplary method for developing a file according to an EDI schema according to an embodiment of the invention. In one example, one or more computer-readable media, such as a computer-readable medium 502 in FIG. 5, includes computer-executable components to implement the method illustrated in FIG. 4.

[0028] For example, a selection component 504 selects an EDI schema for transmission to a destination device, such as a spoke 104-1 at 402. A data component 506 identifies a plurality of syntax structures in the selected EDI schema at 404. At 406, an extracting component 506 extracts a plurality of EDI data values from the identified plurality of syntax structures according to the defined type. A file component 508 generates a file, such as file 302, corresponding to the type and including the extracted data values in the generated file such that the EDI schema can be re-created from the generated file. In another embodiment, a transmission component 510 transmits the generated or developed file from a source (e.g., the hub 102) to the destination device (e.g., the spokes 104). [0029] In operation, embodiments of the invention may be implemented in the following manner. A hub, such as a large business entity which operates a number of computing equipment that is capable of processing thousands of EDI documents or transactions, selects one or more the EDI schema for transmission to a destination device, such as a spoke. Instead of transmitting the schemas in its original format, the hub identifies a plurality of syntax structures in the selected EDI schema. The plurality of syntax structures defines a type of transaction associated with the EDI schema. For example, the hub may select a purchase order type of schema. [0030] The hub next extracts a plurality of EDI data values from the identified plurality of syntax structures according to the defined type. For example, for a purchase order type of EDI transaction, one or more particular data values are extracted according to the purchase order type. Upon extracting, the hub generates a file corresponding to the type and includes the extracted data values in the generated file such that the EDI schema can be re-created from the generated file. [0031] FIG. 6 shows one example of a general purpose computing device in the form of a computer 130. In one embodiment of the invention, a computer such as the computer 130 is suitable for use in the other figures illustrated and described herein. Computer 130 has one or more processors or processing units 132 and a system memory 134. In the illustrated embodiment, a system bus 136 couples various system components including the system memory 134 to the processors 132. The bus 136 represents one or more of any of several types of bus structures, including a memory bus or memory controller, a peripheral bus, an accelerated graphics port, and a processor or local bus using any of a variety of bus architectures. By way of example, and not limitation, such architectures include Industry Standard Architecture (ISA) bus, Micro Channel Architecture (MCA) bus, Enhanced ISA (EISA) bus, Video Electronics Standards Association (VESA) local bus, and Peripheral Component Interconnect (PCI) bus also known as Mezzanine bus. [0032] The computer 130 typically has at least some form of computer readable media. Computer readable media, which include both volatile and nonvolatile media, removable and non-removable media, may be any available medium that may be accessed by computer 130. By way of example and not limitation, computer readable media comprise computer storage media and communication media. Computer storage media include volatile and nonvolatile, removable and non-removable media implemented in any method or technology for storage of information such as computer readable instructions, data structures, program modules or other data. For example, computer storage media include RAM, ROM, EEPROM, flash memory or other memory technology, CD-ROM, digital versatile disks (DVD) or other optical disk storage, magnetic cassettes, magnetic tape, magnetic disk storage or other magnetic storage devices, or any other medium that may be used to store the desired information and that may be accessed by computer 130. Communication media typically embody computer readable instructions, data structures, program modules, or other data in a modulated data signal such as a carrier wave or other transport mechanism and include any information delivery media. Those skilled in the art are familiar with the modulated data signal, which has one or more of its characteristics set or changed in such a manner as to encode information in the signal. Wired media, such as a wired network or direct-wired connection, and wireless media, such as acoustic, RF, infrared, and other wireless media, are examples of communication media. Combinations of any of the above are also included within the scope of computer readable media. [0033] The system memory 134 includes computer storage media in the form of removable and/or non-removable, volatile and/or nonvolatile memory. In the illustrated embodiment, system memory 134 includes read only memory (ROM) 138 and random access memory (RAM) 140. A basic input/output system 142 (BIOS), containing the basic routines that help to transfer information between elements within computer 130, such as during start-up, is typically stored in ROM 138. RAM 140 typically contains data and/or program modules that are immediately accessible to and/or presently being operated on by processing unit 132. By way of example, and not limitation, FIG. 6 illustrates operating system 144, application programs 146, other program modules 148, and program data 150.

[0034] The computer 130 may also include other removable/non-removable, volatile/nonvolatile computer storage media. For example, FIG. 6 illustrates a hard disk drive 154 that reads from or writes to non-removable, nonvolatile magnetic media. FIG. 6 also shows a magnetic disk drive 156 that reads from or writes to a removable, nonvolatile magnetic disk 158, and an optical disk drive 160 that reads from or writes to a removable, nonvolatile optical disk 162 such as a CD-ROM or other optical media. Other removable/non-removable, volatile/nonvolatile computer storage media that may be used in the exemplary operating environment include, but are not limited to, magnetic tape cassettes, flash memory cards, digital versatile disks, digital video tape, solid state RAM, solid state ROM, and the like. The hard disk drive 154, and magnetic disk drive 156 and optical disk drive 160 are typically connected to the system bus 136 by a non-volatile memory interface, such as interface 166. [0035] The drives or other mass storage devices and their associated computer storage media discussed above and illustrated in FIG. 6, provide storage of computer readable instructions, data structures, program modules and other data for the computer 130. In FIG. 6,. for example, hard disk drive 154 is illustrated as storing operating system 170, application programs 172, other program modules 174, and program data 176. Note that these components may either be the same as or different from operating system 144, application programs 146, other program modules 148, and program data 150. Operating system 170, application programs 172, other program modules 174, and program data 176 are given different numbers here to illustrate that, at a minimum, they are different copies. [0036] The computer 130 may operate in a networked environment using logical connections to one or more remote computers, such as a remote computer 194. The remote computer 194 may be a personal computer, a server, a router, a network PC, a peer device or other common network node, and typically includes many or all of the elements described above relative to computer 130. The logical connections depicted in FIG. 6 include a local area network (LAN) 196 and a wide area network (WAN) 198, but may also include other networks. LAN 136 and/or WAN 138 may be a wired network, a wireless network, a combination thereof, and so on. Such networking environments are commonplace in offices, enterprise-wide computer networks, intranets, and global computer networks (e.g., the Internet). [0037] When used in a local area networking environment, computer 130 is connected to the LAN 196 through a network interface or adapter 186. When used in a wide area networking environment, computer 130 typically includes a modem 178 or other means for establishing communications over the WAN 198, such as the Internet. The modem 178, which may be internal or external, is connected to system bus 136 via the user input interface 184, or other appropriate mechanism. In a networked environment, program modules depicted relative to computer 130, or portions thereof, may be stored in a remote memory storage device (not shown). By way of example, and not limitation, FIG. 6 illustrates remote application programs 192 as residing on the memory device. The network connections shown are exemplary and other means of establishing a communications link between the computers may be used. [0038] Generally, the data processors of computer 130 are programmed by means of instructions stored at different times in the various computer-readable storage media of the computer. Programs and operating systems are typically distributed, for example, on floppy disks or CD-ROMs. From there, they are installed or loaded into the secondary memory of a computer. At execution, they are loaded at least partially into the computer's primary electronic memory. Aspects of the invention described herein includes these and other various types of computer-readable storage media when such media contain instructions or programs for implementing the steps described below in conjunction with a microprocessor or other data processor. Further, aspects of the invention include the computer itself when programmed according to the methods and techniques described herein.

[0039] For purposes of illustration, programs and other executable program components, such as the operating system, are illustrated herein as discrete blocks. It is recognized, however, that such programs and components reside at various times in different storage components of the computer, and are executed by the data processor(s) of the computer. [0040] Although described in connection with an exemplary computing system environment, including computer 130, embodiments of the invention are operational with numerous other general purpose or special purpose computing system environments or configurations. The computing system environment is not intended to suggest any limitation as to the scope of use or functionality of any aspect of the invention. Moreover, the computing system environment should not be interpreted as having any dependency or requirement relating to any one or combination of components illustrated in the exemplary operating environment. Examples of well known computing systems, environments, and/or configurations that may be suitable for use with aspects of the invention include, but are not limited to, personal computers, server computers, hand-held or laptop devices, multiprocessor systems, microprocessor-based systems, set top boxes, programmable consumer electronics, mobile telephones, network PCs, minicomputers, mainframe computers, distributed computing environments that include any of the above systems or devices, and the like. [0041 ] Embodiments of the invention may be described in the general context of computer-executable instructions, such as program modules, executed by one or more computers or other devices. Generally, program modules include, but are not limited to, routines, programs, objects, components, and data structures that perform particular tasks or implement particular abstract data types. Aspects of the invention may also be practiced in distributed computing environments where tasks are performed by remote processing devices that are linked through a communications network. In a distributed computing environment, program modules may be located in both local and remote computer storage media including memory storage devices. [0042] An interface in the context of a software architecture includes a software module, component, code portion, or other sequence of computer-executable instructions. The interface includes, for example, a first module accessing a second module to perform computing tasks on behalf of the first module. The first and second modules include, in one example, application programming interfaces (APIs) such as provided by operating systems, component object model (COM) interfaces (e.g., for peer-to-peer application communication), and extensible markup language metadata interchange format (XMI) interfaces (e.g., for communication between web services).

[0043] The interface may be a tightly coupled, synchronous implementation such as in Java 2 Platform Enterprise Edition (J2EE), COM, or distributed COM (DCOM) examples. Alternatively or in addition, the interface may be a loosely coupled, asynchronous implementation such as in a web service (e.g., using the simple object access protocol). In general, the interface includes any combination of the following characteristics: tightly coupled, loosely coupled, synchronous, and asynchronous. Further, the interface may conform to a standard protocol, a proprietary protocol, or any combination of standard and proprietary protocols. [0044] The interfaces described herein may all be part of a single interface or may be implemented as separate interfaces or any combination therein. The interfaces may execute locally or remotely to provide functionality. Further, the interfaces may include additional or less functionality than illustrated or described herein. [0045] In operation, computer 130 executes computer-executable instructions such as those illustrated in the figures, such as FIG. 4, to implement aspects of the invention.

[0046] The order of execution or performance of the operations in embodiments of the invention illustrated and described herein is not essential, unless otherwise specified. That is, the operations may be performed in any order, unless otherwise specified, and embodiments of the invention may include additional or fewer operations than those disclosed herein. For example, it is contemplated that executing or performing a particular operation before, contemporaneously with, or after another operation is within the scope of aspects of the invention.

[0047] Embodiments of the invention may be implemented with computer-executable instructions. The computer-executable instructions may be organized into one or more computer-executable components or modules. Aspects of the invention may be implemented with any number and organization of such components or modules. For example, aspects of the invention are not limited to the specific computer-executable instructions or the specific components or modules illustrated in the figures and described herein. Other embodiments of the invention may include different computer-executable -instructions or components having more or less functionality than illustrated and described herein.

[0048] When introducing elements of aspects of the invention or the embodiments thereof, the articles "a," "an," "the," and "said" are intended to mean that there are one or more of the elements. The terms "comprising," "including," and "having" are intended to be inclusive and mean that there may be additional elements other than the listed elements. [0049] As various changes could be made in the above constructions, products, and methods without departing from the scope of aspects of the invention, it is intended that all matter contained in the above description and shown in the accompanying drawings shall be interpreted as illustrative and not in a limiting sense.

Claims

CLAIMSWhat is claimed is:

1. A method for developing a file corresponding to an electronic data interchange (EDI) schema, said method comprising: selecting the EDI schema for transmission to a destination device; identifying a plurality of syntax structures in the selected EDI schema, said plurality of syntax structures defining a type of transaction associated with the EDI schema; extracting a plurality of EDI data values from the identified plurality of syntax structures according to the defined type; and generating a file corresponding to the type and including the extracted data values in the generated file such that the EDI schema can be re-created from the generated file.

2. The method of claim 1, wherein identifying the plurality of syntax structures comprises identifying the plurality of syntax structures of extensible Markup Language (XML) tags.

3. The method of claim 2, wherein identifying the plurality of syntax structures of XML tags includes identifying one or more of the following properties of the XML tags: name, minimum number of occurrences, and maximum number of occurrences.

4. The method of claim 1, wherein extracting comprises identifying data elements having one or more of the following properties: data type name, minimum length, and maximum length.

5. The method of claim 1, wherein generating the file comprises generating a text file, said text file having a file size substantially smaller than the data size of the EDI schema.

6. The method of claim 5, wherein the extracted data values in the text file are organized according to an encoding rule.

7. The method of claim 1, wherein one or more computer-readable media have computer- executable instructions for performing the method of claim 1.

8. A system for generating a file based on an electronic data interchange (EDI) schema, said system comprising: a memory area for storing the EDI schema; and a processor for executing computer-executable instructions for: identifying a plurality of syntax structures in the stored EDI schema, said plurality of syntax structures defining a type of transaction associated with the EDI schema; extracting a plurality of EDI data values from the identified plurality of syntax structures according to the defined type; and generating a file corresponding to the type and including the extracted data values in the generated file such that the EDI schema can be re-created from the generated file.

9. The system of claim 8, wherein the processor is configured to identify the plurality of syntax structures of extensible Markup Language (XML) tags.

10. The system of claim 9, wherein the processor is configured to identify one or more of the following properties of the XML tags: name, minimum number of occurrences, and maximum number of occurrences.

11. The system of claim 8, wherein the processor extracts the plurality of EDI data values by identifying data elements having one or more of the following properties: data type name, minimum length, and maximum length.

12. The system of claim 8, wherein the processor generates a text file, said text file having a file size substantially smaller than the data size of the EDI schema.

13. The system of claim 12, wherein the extracted data values in the text file are organized according to an encoding rule.

14. One or more computer-readable media having computer-executable components for developing a file according to an electronic data interchange (EDI) schema, said computer-executable components comprising: a selection component for selecting the EDI schema for transmission from a hub to a spoke; a data component for identifying a plurality of syntax structures in the selected EDI schema, said plurality of syntax structures defining a type of transaction associated with the EDI schema; an extracting component for extracting a plurality of EDI data values from the identified plurality of syntax structures according to the defined type; and a file component for generating a file corresponding to the type and including the extracted data values in the generated file such that the EDI schema can be re-created from the generated file.

15. The computer-readable media of claim 14j wherein the data component identifies the plurality of syntax structures of extensible Markup Language (XML) tags.

16. The computer-readable media of claim 15, wherein the data component identifies one or more of the following properties of the XML tags: name, minimum number of occurrences, and maximum number of occurrences.

17. The computer-readable media of claim 14, wherein the extracting component extracts the plurality of EDI data values by identifying data elements having one or more of the following properties: data type name, minimum length, and maximum length.

18. The computer-readable media of claim 14, wherein the file component generates a text file, said text file having a file size substantially smaller than the data size of the EDI schema.

19. The computer-readable media of claim 18, wherein the extracted data values in the text file are organized according to an encoding rule.

20. The computer-readable media of claim 14, further comprising a transmission component for transmitting the generated file from the hub to the spoke.