Method for assisting in automated conversion of data and associated metadata

• US 20050144166A1
• Filed: 11/26/2004
• Published: 06/30/2005
• Est. Priority Date: 11/26/2003
• Status: Abandoned Application

• Current Assignee: UBmatrix, Inc. (RR Donnelley & Sons Company)
• Original Assignee: UBmatrix, Inc. (RR Donnelley & Sons Company)
• Inventors: Chapus, Frederic, Fischer, Herman
• Application Number:
  US10/996,449
• Publication Number:
  US 20050144166A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database

Abstract

An exemplary method for the automated, or semi-automated, conversion or reconciliation of metadata from one form into another, includes one or more of: a) identifying data elements and their associated metadata in electronic file(s); b) transforming this metadata into an intermediate metadata format for later use in production of new metadata structure(s); c) developing bodies of re-usable rules for the transformation or mapping of data sets encoded using one set of metadata into another data set encoded using a different set of metadata; d) developing bodies of re-usable metadata sets and rules for the transformation or mapping of metadata into an intermediate metadata structure; e) developing of bodies of re-usable metadata sets and rules for the transformation or mapping of metadata of an intermediate metadata structure into new metadata structure(s); and f) an efficient method for capture of conversion and validation rules.

Claims

1. A method for converting a first set of data having a first logical structure into a second set of data having a second logical structure, wherein the first and second sets include metadata, the method comprising:

classifying an element of the first set of data;

automatically selecting a rule relating the element of the first set of data to the second set of data, based on the classification;

executing the rule to convert the element of the first set of data to an element of the second set of data based on the selected rule;

storing a logical correspondence between the element of the first set of data and the element in the second set of data based on the conversion, in the event information is received from a user in response to an automatic query performed by execution of the rule; and

repeating the classifying, converting and storing for each element in the first set of data.

2. The method of claim 1, wherein the first set of data is a source taxonomy and the second set of data is an intermediate taxonomy.

3. The method of claim 1, wherein the first set of data is an intermediate taxonomy, and the second set of data is a destination taxonomy.

4. The method of claim 1, wherein the first set of data comprises a first Instance document based on a first taxonomy, and the second set of data comprises a second Instance document based on a second taxonomy.

5. The method of claim 1, wherein element classifications comprise:

a first classification wherein an element name in the first set of data is identical to an element name in the second set of data;

a second classification wherein an element in the second set of data is a mathematical function of an element in the first set of data;

a third classification wherein an element in the first set of data corresponds to multiple elements in the second set of data and one of the correspondences is selected based on a pre-existing rule or on an instruction received from a human user; and

a fourth classification wherein an element name in the first set of data is associated with an element name in the second set of data based on an instruction received from a human user.

6. The method of claim 5, wherein the first and second sets of data are instance documents.

7. The method of claim 6, comprising receiving an instruction from a human user.

8. A method for converting a first set of data elements having a first logical structure based on conceptual metadata of a first schema or a first taxonomy, into a second set of data elements having a second logical structure associated with conceptual metadata of a second schema or a second taxonomy, wherein the first and second sets include conceptual metadata from the corresponding schema or taxonomy, contextual metadata and fact values, the method comprising:

classifying a data element of the first set of data, the classifications being based on logical correspondences between concepts of the first and second schemas or taxonomies and including a) a classification wherein the semantic of a concept of the first schema or taxonomy is identical to a concept of the second schema or taxonomy, b) a classification wherein a concept of the first schema or taxonomy is related to a concept of the second schema or taxonomy by a mathematical function that converts the fact value associated with the concept of the first schema or taxonomy into a fact value associated with the corresponding concept of the second schema or taxonomy, c) a classification wherein conversion of a concept of the first schema or taxonomy requires a selection among different options for conversion of a fact value associated with the concept of the first schema or taxonomy into a fact value associated with a corresponding concept of the second schema or taxonomy, and d) a classification wherein conversion of a concept of the first schema or taxonomy requires additional information for conversion of a fact value associated to with the concept of the first schema or taxonomy into a fact value associated with a corresponding concept of the second schema or taxonomy;

automatically selecting a rule relating the data elements of the first set of data to the second set of data, based on the classification;

executing the rule to convert the element of the first set of data to an element of the second set of data based on the selected rule;

storing a logical correspondence between the element of the first set of data and the element in the second set of data based on the conversion, in the event information is received from a user in response to an automatic query performed by execution of the rule; and

repeating the classifying, converting and storing for each element in the first set of data.

9. The method of claim 8, wherein conceptual metadata, contextual metadata and a fact value of the first schema or taxonomy are associated with each other and are converted into different conceptual metadata, different contextual metadata and a different fact value of the second schema or taxonomy.

10. The method of claim 9, wherein the associated contextual metadata identifies a monetary currency and the associated fact value identifies an amount of the monetary currency.

11. A system for converting a first set of data having a first logical structure into a second set of data having a second logical structure, wherein the first and second sets include metadata, the system comprising:

means for classifying an element of the first set of data, automatically selecting a rule relating the element of the first set of data to the second set of data, based on the classification, executing the rule to convert the element of the first set of data to an element of the second set of data based on the selected rule, storing a logical correspondence between the element of the first set of data and the element in the second set of data based on the conversion, in the event information is received from a user in response to an automatic query performed by execution of the rule, and repeating the classifying, converting and storing for each element in the first set of data; and

a display for displaying at least one of the logical correspondence and the second set of data.

12. A machine readable medium comprising a computer program for causing a computation device to convert a first set of data having a first logical structure into a second set of data having a second logical structure, wherein the first and second sets include metadata, by performing:

classifying an element of the first set of data;

automatically selecting a rule relating the element of the first set of data to the second set of data, based on the classification;

executing the rule to convert the element of the first set of data to an element of the second set of data based on the selected rule;

storing a logical correspondence between the element of the first set of data and the element in the second set of data based on the conversion, in the event information is received from a user in response to an automatic query performed by execution of the rule; and

repeating the classifying, converting and storing for each element in the first set of data.