System and method for data format transformation

• US 7,584,422 B2
• Filed: 07/11/2005
• Issued: 09/01/2009
• Est. Priority Date: 07/12/2004
• Status: Active Grant

• Current Assignee: Informatica LLC (Informatica, Inc. (California))
• Original Assignee: Informatica Corporation
• Inventors: Somech, Sam, Ukelson, Jacob P., Ben-Yehuda, Shai
• Primary Examiner(s): HUYNH, THU V
• Application Number:
  US11/177,329
• Publication Number:
  US 20060007466A1
• Time in Patent Office: 1,513 Days
• Field of Search: 715234-236, 715/239
• US Class Current: 715/236
• CPC Class Codes: G06F 16/88 Mark-up to mark-up conversion conversion for visualization in web browsing G06F16/9577
• CPC Class Codes: G06F 40/154 Tree transformation for tree-structured or markup documents, e.g. XSLT, XSL-FO or stylesheets

Abstract

A method for defining a document format transformation process for documents similar to an example document includes the following steps. An example document is provided in a first format. At least one anchor point is then specified within the example document. The anchor points serve to mark out regions of data within the example document. Positions are then defined for respective regions within a central format. During the transformation process, the data extracted from each region is transferred into the respective position. The method enables transforming documents similar to the example document into the central format.

Claims

1. A method executed by a computer system, for defining a document format transformation process for automatically transforming documents with a common format, comprising:

receiving an example document in a first format;

receiving user input indicating an anchor point within the example document and attributes associated with the anchor point, the anchor point indicating a location within the example document and demarcating a region of data at the location, and the attributes defining an operation to be performed on the region of data;

associating the anchor point with a position in a central format corresponding to the location of the anchor point in the example document, such that the demarcated region of data is mapped to the central format according to the attributes;

defining a document format transformation according to the associating of the anchor point with the position in the central format;

storing the document format transformation in the computer system;

receiving a similar document in the first format; and

automatically transforming the similar document into the central format using the document format transformation.

2. The method of claim 1, wherein the similar document is similar to the example document in the first format, and automatically transforming the similar document further comprises:

locating the anchor point within the similar document using the location and the attributes of the anchor point;

extracting data from the region demarcated by the located anchor point; and

inserting the extracted data into the corresponding position in the central format.

3. The method of claim 2, further comprising converting the extracted data prior into an alternate representation to the inserting.

4. The method of claim 2, further comprising specifying an order in which the anchor points are located.

5. The method of claim 2, wherein the anchor point is located in accordance with one of:

an absolute location in the similar document, a location relative to another anchor point in the similar document, according to a structure of the similar document, or a content of the similar document.

6. The method of claim 1, wherein the similar document is a message obtained from a messaging application.

7. The method of claim 1, further comprising:

associating the position in the central format with a corresponding region of a second document in a second format, such that the demarcated region of data is mapped to the corresponding region of the second document;

defining a translation process using the association of the second document;

storing the translation process in the computer system;

receiving a central document received in the central format; and

automatically translating the central document into the second format using the translation process.

8. The method of claim 7, further comprising:

obtaining a document in the central format;

extracting data from the position of the obtained document; and

inserting the extracted data from the position in the central format into the corresponding region of the second document in the second format.

9. The method of claim 7, further comprising translating a document in the central format into a corresponding document in the second format, in accordance with the translation process.

10. The method of claim 7, further comprising:

obtaining a first format document in the first format from a source;

transforming the obtained first format document into the central format at the source;

transferring the transformed document as a message from the source to a destination; and

translating the transformed document into the second format at the destination.

11. The method of claim 10, wherein the message is routed from the source to the destination in accordance with a content of the document.

12. The method of claim 10, further comprising filtering the data in the transformed document according to at least one specified characteristic of the data.

13. The method of claim 7, wherein the second format is for an unstructured document.

14. The method of claim 7, wherein the second format is for a structured document.

15. The method of claim 7, wherein the second format is for a semi-structured document, the semi-structured document having both structured and unstructured portions.

16. The method of claim 1, wherein the first format is for an unstructured document.

17. The method of claim 1, wherein the first format is for a structured document.

18. The method of claim 1, wherein the first format is for a semi-structured document, the semi-structured document having both structured and unstructured portions.

19. The method of claim 1, wherein the central format comprises Extensible Markup Language (XML).

20. The method of claim 1, wherein the central format comprises XML Schema Definition (XSD).

21. A system for defining a document format transformation process for automatically transforming documents with a common format, comprising:

a processor;

a document markup unit executed by the processor configured to receive user input indicating an anchor point and attributes associated with the anchor point, the anchor point indicating a location within an example document in a first format, the anchor point demarcating a region of data at the location, and the attributes defining an operation to be performed on the region of data; and

a transformation generator executed by the processor, communicatively coupled with the document markup unit, configured to;

associate the anchor point with a position in a central format corresponding to the location of the anchor point in the example document, such that the demarcated region of data is mapped to the central format according to the attributes;

define a document format transformation using the association of the example document;

store the document format transformation in a storage medium;

receive a similar document in the first format; and

automatically transform the similar document into the central format using the document format transformation.

22. The system of claim 21, wherein the similar document is similar to the example document in the first format, and the transformation generator is further configured to:

locate the anchor point within the similar document;

extract data from the region demarcated by the located anchor point; and

insert the extracted data into the corresponding position in the central format.

23. The system of claim 21, further comprising a transformation engine for receiving a document in the first format, and transforming the received document into the central format, in accordance with the transformation process.

24. The system of claim 23, wherein the received document is a message obtained from a messaging application.

25. The system of claim 21, wherein the transformation generator is further configured to:

associate the position in the central format with a corresponding region of a second document in a second format, such that the demarcated region of data is mapped to the corresponding region of the second document;

define a translation process using the association of the second document;

store the translation process in the storage medium;

receive a central document received in the central format; and

automatically translate the central document into the second format using the translation process.

26. The system of claim 25, further comprising a translation engine operable to receive a document in the central format, and to translate the received document into a second document in the second format, in accordance with the translation process.

27. The system of claim 26, wherein the translation process further comprises:

obtaining a document the central format;

extracting data from the position of the obtained document; and

inserting the extracted data from the associated position in the central format into the corresponding region of the second document in the second format.

28. The system of claim 25, wherein the second format is for an unstructured document.

29. The system of claim 25, wherein the second format is for a structured document.

30. The system of claim 25, wherein the second format is for a semi-structured document, the semi-structured document having both structured and unstructured portions having both structured and unstructured portions.

31. The system of claim 21, wherein the first format is for an unstructured document.

32. The system of claim 21, wherein the first format is for a structured document.

33. The system of claim 21, wherein the first format is for a semi-structured document, the semi-structured document having both structured and unstructured portions.

34. The system of claim 21, wherein the central format comprises Extensible Markup Language (XML).

35. The system of claim 21, wherein the central format comprises XML Schema Definition (XSD).