Method and apparatus for normalizing and converting structured content

• US 7,680,867 B2
• Filed: 01/10/2006
• Issued: 03/16/2010
• Est. Priority Date: 06/26/2000
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Silver Creek Systems, Inc. (Oracle Corporation)
• Inventors: Markey, Kevin L., Krosley, Ramon, Green, Edward A.
• Primary Examiner(s): Truong; Cam Y T
• Application Number:
  US11/328,715
• Publication Number:
  US 20060277029A1
• Time in Patent Office: 1,526 Days
• Field of Search: 707/101
• US Class Current: 707/811
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: G06F 16/972 Access to data in other repository systems, e.g. legacy data or dynamic Web page generation
• CPC Class Codes: G06F 40/30 Semantic analysis
• CPC Class Codes: G06F 40/58 Use of machine translation, e.g. for multi-lingual retrieval, for server-side translation for client devices or for real-time translation

Abstract

A method and apparatus are disclosed for transforming information from one semantic environment to another. In one implementation, a SOLx system (1700) includes a Normalization/Translation NorTran Workbench (1702) and a SOLx server (1708). The NorTran Workbench (1702) is used to develop a knowledge base based on information from a source system (1712), to normalize legacy content (1710) according to various rules, and to develop a database (1706) of translated content. During run time, the SOLx server (1708) receives transmissions from the source system (1712), normalizes the transmitted content, accesses the database (1706) of translated content and otherwise translates the normalized content, and reconstructs the transmission to provide substantially real-time transformation of electronic messages.

Claims

1. A method for use in converting content of electronic data from a source form to a target form, said electronic data having a machine format and an informational content independent of said machine format and any machine instructions, said method comprising the steps of:

defining, by utilizing a computer, a transformation matrix for use by a machine tool involving;

providing a set of source content elements reflecting a source environment, wherein said source content elements include human readable informational content entered by one or more human users in a form free from compliance with any device format, said source content elements reflecting inconsistencies of linguistics, at least including different terms to identify same subject matter, and syntax, at least including different ordering of terms;

providing a set of normalized content elements that are amenable to transformation to the target form;

establishing a normalization structure for normalizing said set of source content elements to said set of normalized content elements with respect to linguistics and syntax, wherein the source content elements correspond to a single normalized content element, and wherein said normalization structure is based on a knowledge base developed from information about said set of source content elements, the establishing the normalization structure comprises utilizing grammar rules to identify one or more attributes of at least a subset of said set of source content elements and utilizing linguistics rules to identify attributes or attribute values of said source content elements that are expressed in a plurality of forms;

defining a set of rules for converting said normalized content elements to target content elements;

receiving an item of electronic data having a machine format and information content including at least one source content element and extracting said information content using said machine format;

using a first operating of said machine tool to apply said transformation matrix by;

identifying a first source content element under consideration;

applying said normalization structure to said first source content element to identify a first normalized content element; and

using said set of rules with respect to said first normalized content element to convert said first source content element to said target form,

assisting in applying said normalization structure by associating contextual information with said normalized content elements, wherein said associating contextual information comprises providing tags for schematizing source information; and

providing, by using second operating of said machine tool, an output including said first source content element converted to said target form.

2. The method as set forth in claim 1, wherein one of said source content elements and said target content elements comprises business content.

3. The method as set forth in claim 1, wherein said step of applying said normalization structure comprises accessing a knowledge base developed from an analysis of source content element.

4. The method as set forth in claim 1, wherein said normalization structure reflects a standardized terminology and syntax for said source content elements.

5. The method as set forth in claim 1, wherein said step of establishing comprises assisting in prioritizing individual source content elements for normalization to said set of normalized content elements by performing a statistical analysis of said source content elements.

6. The method as set forth in claim 1, further comprising the step of providing assisting in developing said normalization structure by providing a graphical representation of said normalization structure in development.

7. The method as set forth in claim 1, further comprising the step of providing assisting in completing said normalization structure by providing a graphical user interface for identifying source content elements that have been normalized to said set of normalized content elements.

8. The method as set forth in claim 1, wherein said step of establishing a normalization structure comprises assisting in applying said transformation matrix by associating on textual information with said normalized content element.

9. The method as set forth in claim 8, wherein said step of associating contextual information comprises providing tags for schematizing said source information.

10. An apparatus for use in converting content of electronic data from a source form to a target form, said electronic data having a machine format and an informational content independent of said machine format and any machine instructions, said apparatus comprising:

a storage medium for establishing and storing a normalization structure for normalizing source content elements with respect to linguistics and syntax to standardized content elements amenable to a transformation to the target form, and for storing a second conversion structure for converting said standardized content elements to target content elements of said target form, wherein the source content elements correspond to a single normalized content element, wherein said source content elements include human informational content entered by one or more human users in a form free from compliance with any device format, said source content elements reflecting inconsistencies of linguistics, at least including different terms to identify same subject matter, and syntax, at least including different ordering of terms, and wherein said normalization structure is based on a knowledge base developed from information related to said set of source content elements, the establishing the normalization structure comprises utilizing grammar rules to identify one or more attributes of at least a subset of said set of source content elements and utilizing linguistics rules to identify attributes or attribute values of said source content elements that are expressed in a plurality of forms;

an input structure for receiving input content having the machine format and information content including a first source content element and for extracting said information content using said machine format;

a processor for accessing said normalization structure and said second conversion structure from said storage medium and using said normalization structure and said second conversion structure to convert said first source content element to at least one target content element;

a first operating of said machine tool to apply a transformation matrix by;

applying said normalization structure to said first source content element to identify a first normalized content element; and

using said set of rules with respect to said first normalized content element to convert said first source content element to said target form; and

the processor further for assisting in the applying said normalization structure by associating contextual information with said normalized content elements, wherein said associating contextual information comprises providing tags for schematizing said source information;

an output structure for providing an output including said at least one target content element.

11. The apparatus as set forth in claim 10, wherein one of said first source content element and said at least one target content element comprises business content.

12. The apparatus as set forth in claim 10, wherein said processor is operative for accessing a knowledge base developed from an analysis of said source content element.

13. The apparatus as set forth in claim 10, wherein said normalization structure reflects a standardized terminology and syntax for said source content elements.

14. The apparatus as set forth in claim 10, wherein said processor is operative for assisting in prioritizing individual source content elements for normalization to said set of normalized content element by performing a statistical analysis of said source content elements.

15. The apparatus as set forth in claim 10, further comprising a development module for use in establishing said normalization structure, said development module being operative to assist in developing said normalization structure by providing a graphical representation of said normalization structure in development.

16. The apparatus as set forth in claim 10, further comprising a development module operative for providing a graphical user interface for assisting in completing said normalization structure by identifying source content elements that have been normalized to said set of normalized content elements.