System and method for transforming documents to and from an XML format

• US 20040205562A1
• Filed: 12/27/2001
• Published: 10/14/2004
• Est. Priority Date: 12/27/2001
• Status: Abandoned Application

• Current Assignee: Foothill Capital Corporation
• Original Assignee: GE Information Services, Inc.
• Inventors: Jeanette, James, Williams, Jamin, Rozek, Matthew
• Application Number:
  US10/026,773
• Publication Number:
  US 20040205562A1
• Time in Patent Office: Days
• US Class Current: 715/513
• 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 a system method for translating between an XML-type document and a first type of document, a data model for the XML-type document is generated based on an XML data source, and a data model for the first type of document is generated based on the XML data source. Mapping rules are created between the data model for the XML-type document and the data model for the first type of document. An executable file may also be created to effect the translation between the XML-type document and the first type of document based on the data model for the XML-type document, the data model for the first type of document and the mapping rules. The executable file is run to translate between the XML-type document and the first type of document.

Claims

1. A method for translating between an XML-type document and a first type of document, comprising:

generating a data model for the XML-type document based on an XML data source;

generating a data model for the first type of document based on the XML data source; and

creating mapping rules between the data model for the XML-type document and the data model for the first type of document.

2. A method according to claim 1, further comprising:

creating an executable file to effect the translation between the XML-type document and the first type of document based on the data model for the XML-type document, the data model for the first type of document and the mapping rules; and

running the executable file to translate between the XML-type document and the first type of document.

3. A method according to claim 1, further comprising:

translating test data based on the data model for the XML-type document, the data model for the first type of document and the mapping rules;

verifying the propriety of the data model for the XML-type document, the data model for the first type of document and the mapping rules based on the result of the translation.

4. A method according to claim 1, further comprising:

modifying the data model for the first type of document to conform to a format associated with the first type of document, and

modifying the mapping rules based on the modification of the data model for the first type of document.

5. A method according to claim 4, wherein the modifying the data model includes adjusting the data model for the first type of document to conform with an import utility of an application associated with the first type of document.

6. A method according to claim 1, wherein the generating of the data model for the first type of document includes omitting formatting that is present in the data model for the XML-type document.

7. A method according to claim 1, further comprising receiving an indication of the direction of the translation.

8. A method according to claim 1, further comprising receiving an indication of the identity of the XML data source.

9. A method according to claim 1, wherein the XML data source is an XML Schema Definition (XSD).

10. A method according to claim 9, wherein the generating of the data model for the XML-type document includes providing a model for numerics in the XSD.

11. A method according to claim 9, wherein the generating of the data model for the XML-type document includes providing a model for grouping and pattern definitions in the XSD.

12. A method according to claim 9, wherein the generating of the data model for the XML-type document includes providing a model for field lengths and value ranges.

13. A method according to claim 1, further comprising:

creating a map component file, which identifies the data model for the XML-type document, the data model for the first type of document,

wherein running the executable file includes referencing the map component file to perform the translation.

14. A method according to claim 1, further comprising receiving an indication of the identity of the XML-type document to be translated.

15. A method according to claim 1, further comprising validating that the translation between the XML-type document and the first type of document is accurate.

16. A method according to claim 15, further comprising receiving an indication of how to perform the validation.

17. A method according to claim 15, wherein the validation includes checking that the XML-type document is well-formed.

18. A method according to claim 17, wherein the checking includes determining that each element in the XML-type document has start and end tags with the same label.

19. A method according to claim 17, wherein the checking includes verifying that the XML-type document is well-formed based upon the data model for the XML-type document.

20. A method according to claim 15, wherein the validation further comprises:

determining that elements in the XML-type document are in the correct order;

determining that the XML-type document includes any specified mandatory elements;

determining if data types in the XML-type document are proper; and

determining if the format of a value in a field in the XML-type document is proper.

21. A computer readable medium on a computer system for translating between an XML-type document and a first type of document, the computer readable medium configured to:

generate a data model for the XML-type document based on an XML data source;

generate a data model for the first type of document based on the XML data source; and

create mapping rules between the data model for the XML-type document and the data model for the first type of document.

22. A computer readable medium according to claim 21, further configured to:

create an executable file to effect the translation between the XML-type document and the first type of document based on the data model for the XML-type document, the data model for the first type of document and the mapping rules; and

run the executable file to translate between the XML-type document and the first type of document.

23. A computer readable medium according to claim 21, further comprising:

translating test data based on the data model for the XML-type document, the data model for the first type of document and the mapping rules;

verifying the propriety of the data model for the XML-type document, the data model for the first type of document and the mapping rules based on the result of the translation.

24. A computer readable medium according to claim 21, further configured to:

modify the data model for the first type of document to conform to a format associated with the first type of document, and

modify the mapping rules based on the modification of the data model for the first type of document.

25. A computer readable medium according to claim 24, further configured to adjust the data model for the first type of document to conform with an import utility of an application associated with the first type of document.

26. A computer readable medium according to claim 21, further configured to omit formatting present in the data model for the XML-type document when generating the data model for the first type of document.

27. A computer readable medium according to claim 21, further configured to receive an indication of the direction of the translation.

28. A computer readable medium according to claim 21, further configured to receive an indication of the identity of the XML data source.

29. A computer readable medium according to claim 21, wherein the XML data source is an XML Schema Definition (XSD).

30. A computer readable medium according to claim 29, further configured to provide a model for numerics in the XSD.

31. A computer readable medium according to claim 29, further configured to provide a model for grouping and pattern definitions in the XSD.

32. A computer readable medium according to claim 29, further configured to provide a model for field lengths and value ranges.

33. A computer readable medium according to claim 21, further configured to:

create a map component file, which identifies the data model for the XML-type document, the data model for the first type of document; and

reference the map component file to perform the translation.

34. A computer readable medium according to claim 21, further configured to receive an indication of the identity of the XML-type document to be translated.

35. A computer readable medium according to claim 21, further configured to validate that the translation between the XML-type document and the first type of document is accurate.

36. A computer readable medium according to claim 35, further configured to receive an indication of how to perform the validation.

37. A computer readable medium according to claim 35, further configured to check that the XML-type document is well-formed.

38. A computer readable medium according to claim 37, further configured to determine that each element in the XML-type document has start and end tags with the same label.

39. A computer readable medium according to claim 37, further configured to verify that the XML-type document is well-formed based upon the data model for the XML-type document.

40. A computer readable medium according to claim 35, further configured to:

determine that elements in the XML-type document are in the correct order;

determine that the XML-type document includes any specified mandatory elements;

determine if data types in the XML-type document are proper; and

determine if the format of a value in a field in the XML-type document is proper.

41. A computer system for translating between an XML-type document and a first type of document, comprising:

a processor; and

a memory, coupled to the processor, comprising a plurality of instructions executed by the processor, the plurality of instructions configured to;

generate a data model for the XML-type document based on an XML data source;

generate a data model for the first type of document based on the XML data source; and

create mapping rules between the data model for the XML-type document and the data model for the first type of document.

42. A computer system according to claim 41, further comprising instructions configured to:

create an executable file to effect the translation between the XML-type document and the first type of document based on the data model for the XML-type document, the data model for the first type of document and the mapping rules; and

run the executable file to translate between the XML-type document and the first type of document.

43. A computer system according to claim 41, further comprising instructions configured to:

modify the data model for the first type of document to conform to a format associated with the first type of document, and

modify the mapping rules based on the modification of the data model for the first type of document.

44. A computer system according to claim 41, further comprising an instruction configured to omit formatting present in the data model for the XML-type document when generating the data model for the first type of document.

45. A computer system for translating between an XML-type document and a first type of document, comprising:

means for generating a data model for the XML-type document based on an XML data source;

means for generating a data model for the first type of document based on the XML data source; and

means for creating mapping rules between the data model for the XML-type document and the data model for the first type of document.

46. A computer system according to claim 45, further comprising:

means for creating an executable file to effect the translation between the XML-type document and the first type of document based on the data model for the XML-type document, the data model for the first type of document and the mapping rules; and

means for running the executable file to translate between the XML-type document and the first type of document.

47. A computer system according to claim 45, further comprising:

means for modifying the data model for the first type of document to conform to a format associated with the first type of document, and

means for modifying the mapping rules based on the modification of the data model for the first type of document.

48. A computer system according to claim 45, further comprising means for omitting formatting present in the data model for the XML-type document when generating the data model for the first type of document.