Interoperable retrieval and deposit using annotated schema to interface between industrial document specification languages

• US 7,305,614 B2
• Filed: 07/17/2001
• Issued: 12/04/2007
• Est. Priority Date: 07/17/2001
• Status: Active Grant

• Current Assignee: International Business Machines SA (International Business Machines Corporation)
• Original Assignee: International Business Machines Corporation
• Inventors: Yih, Jih-Shyr, Chen, Shyh-Kwei
• Primary Examiner(s): Hong; Stephen
• Assistant Examiner(s): Stork; Kyle R
• Application Number:
  US09/907,240
• Publication Number:
  US 20030018666A1
• Time in Patent Office: 2,331 Days
• Field of Search: 715/513, 715/517, 715/523, 715/530
• US Class Current: 715/230
• CPC Class Codes: G06F 40/143 Markup, e.g. Standard Generalized Markup Language [SGML] or Document Type Definition [DTD]
• CPC Class Codes: G06F 40/151 Transformation

Abstract

In order to achieve interoperability between diverse types of computer systems for the purpose of e-commerce, a system and method are provided for retrieving data from multiple relational databases into an XEDI document. First, a DTDSA is used to create an intermediate format for the data. Then, an annotated interoperable (universal) DTD is used to create the XEDI document. For depositing data from an XEDI document into multiple relational databases, a reverse process is used. The universal DTD is used to create the intermediate format. Then the DTDSA is used to create the relational database format. The deposit process requires analysis of join unions of data sought to be deposited, and also a static reversibility check for the DTDSA. A GUI interface is provided for generating annotations.

Claims

1. A method for creating an electronic communication, comprising executing the following operations in at least one data processing device:

first retrieving data from at least one type of data source into a first electronic format using at least one first annotated schema;

second retrieving data from the first electronic format into a second electronic format using at least one second annotated schema,

further comprising using a GUI tool to create internal representations relating the second format to the at least one type of data source

wherein the GUI tool

can systematically organize a template from combining and merging multiple tables

is adapted to enable operations, the operations including

accepting single annotations for certain repeatable constructs in the template, and

replicating the repeatable constructs a fixed number of times for customized annotation.

2. The method of claim 1, wherein the first electronic format comprises at least one XML document.

3. The method of claim 1, wherein the first electronic format comprises at least one value pair.

4. The method of claim 1, wherein the first and second retrieving are done using a same type of software engine applied first to the at least one type of data source and then to the first electronic format.

5. The method of claim 1, wherein the second electronic format belongs to the category of XML/EDI electronic document specification languages.

6. The method of claim 1, wherein the first annotated schema comprises at least one first annotated DTD and the second annotated schema comprises at least one second annotated DTD.

7. The method of claim 6, wherein the at least one second annotated schema comprises

a single DTD for all possible document types within a single industrial electronic document specification language;

and

annotations for retrieving specifications for a desired document type from the first electronic format.

8. The method of claim 7, wherein the first and second retrieving are done using a same type of software engine applied first to the at least one type of data source and then to the first electronic format.

9. The method of claim 1, wherein the at least one type of data source comprises heterogeneous data bases.

10. The method of claim 1, wherein each schema describes a structure of a target format and each annotation relates to a structure of a source format, so that each annotated schema guarantees that the retrieving steps create data that conforms to the target format, without additional checking.

11. The method of claim 1, wherein the annotations are inserted into the respective schema.

12. At least one data processing device comprising:

at least one memory for storing code and data;

at least one processor for performing the following operations using the least one memory

first retrieving data from at least one type of data source into a first electronic format using at least one first annotated schema;

second retrieving data from the first electronic format into a second electronic format using at least one second annotated schema; and

creating an electronic communication based on the at least one second annotated schema further comprising using a GUI tool to create internal representations relating the second format to the at least one type of data source;

wherein the GUI tool

can systematically organize a template from combining and merging multiple tables;

is adapted to enable operations, the operations including;

accepting single annotations for certain repeatable constructs in the template, and

replicating the repeatable constructs a fixed number of times for customized annotation.

13. The device of claim 12, wherein the first electronic format comprises at least one XML document.

14. The device of claim 12, wherein the first electronic format comprises at least one value pair.

15. The device of claim 12, wherein the first and second retrieving are done using a same type of software engine applied first to the at least one type of data source and then to the first electronic format.

16. The device of claim 12, wherein the second electronic format belongs to the category of XML/EDI electronic document specification languages.

17. The device of claim 12, wherein the first annotated schema comprises at least one first annotated DTD and the second annotated schema comprises at least one second annotated DTD.

18. The device of claim 17, wherein the at least one second annotated schema comprises

a single DTD for all possible document types within a single industrial electronic document specification language;

and

annotations for retrieving specifications for a desired document type from the first electronic format.

19. The device of claim 18, wherein the first and second retrieving are done using a same type of software engine applied first to the data sources and then to the first electronic format.

20. The device of claim 12, wherein the at least one type of data source comprises heterogeneous relational databases.

21. The device of claim 12, wherein each schema describes a structure of a target format and each annotation relates to a structure of a source format, so that each annotated schema guarantees that the retrieving steps create data that conforms to the target format, without additional checking.

22. The device of claim 12, wherein each annotated schema comprises a schema with inserted annotations.

23. A medium readable by a data processing device and embodying code for performing the following operations:

first retrieving data from at least one type of data source into a first electronic format using at least one first annotated schema;

second retrieving data from the first electronic format into a second electronic format using at least one second annotated schema; and

creating an electronic communication based on the at least one second annotated schema further comprising using a GUI tool to create internal representations relating the second format to the at least one type of data source, wherein the GUI tool

can systematically organize a template from combining and merging multiple tables,

is adapted to enable operations, the operation including

accepting single annotations for certain repeatable constructs in the template, and

replicatinge the repeatable constructs a fixed number of times for customized annotation.

24. The medium of claim 23, wherein the first electronic format comprises at least one XML document.

25. The medium of claim 23, wherein the first electronic format comprises at least one value pair.

26. The medium of claim 23, wherein the first and second retrieving are done using a same type of software engine applied first to the at least one type of data source and then to the first electronic format.

27. The medium of claim 23, wherein the second electronic format belongs to the category of XML/EDI electronic document specification languages.

28. The medium of claim 23, wherein the first annotated schema comprises at least one first annotated DTD and the second annotated schema comprises at least one second annotated DTD.

29. The medium of claim 28, wherein the at least one second annotated schema comprises

a single DTD for all possible document types within a single industrial electronic document specification language;

and

annotations for retrieving specifications for a desired document type from the first electronic format.

30. The medium of claim 29, wherein the first and second retrieving are done using a same type of software engine applied first to the at least one type of data source and then to the first electronic format.

31. The medium of claim 23, wherein the at least one type of data source comprises heterogeneous relational databases.

32. The medium of claim 23, wherein each schema describes a structure of a target format and each annotation relates to a structure of a source format, so that each annotated schema guarantees that the retrieving steps create data that conforms to the target format, without additional checking.

33. The medium of claim 23, wherein each annotated schema comprises a schema with inserted annotations.