Schema mapping and data transformation on the basis of layout and content
First Claim
1. A computer-implemented method for schema mapping and the transformation of data associated with first and second documents, the method comprising:
- retrieving at least a portion of the first document;
generating one or more labels representing schema information for the at least a portion of the first document based on a schema of the first document;
displaying simultaneously to a user, with a graphical user interface (GUI), a representation of the schema of the first document comprising the at least a portion of the first document and the one or more labels representing schema information for the at least a portion of the first document and a representation of a schema of the second document within cells of a spreadsheet application, the first and second documents having different schemas;
acquiring, from the user, at least one association usable to map at least a first element of the first document to at least a second element of the second document, wherein each of the first and second elements contain layout data; and
storing the association.
2 Assignments
0 Petitions
Accused Products
Abstract
Systems and methods are provided for schema mapping and the transformation of data. In accordance with one implementation, a computer-implemented method is provided that includes the steps of simultaneously displaying to a user, via a graphical user interface, layouts of the first and second documents, wherein the first and second documents have different data schemas and are instantiated with elements containing data values, and acquiring one or more associations from the user to map a first element of the first document to a second element of the second document. The method further includes the steps of indicating to the user a second association between elements in the first and second documents based on the association acquired from the user, and storing the association including the layout data corresponding to the first and second elements.
39 Citations
26 Claims
-
1. A computer-implemented method for schema mapping and the transformation of data associated with first and second documents, the method comprising:
-
retrieving at least a portion of the first document; generating one or more labels representing schema information for the at least a portion of the first document based on a schema of the first document; displaying simultaneously to a user, with a graphical user interface (GUI), a representation of the schema of the first document comprising the at least a portion of the first document and the one or more labels representing schema information for the at least a portion of the first document and a representation of a schema of the second document within cells of a spreadsheet application, the first and second documents having different schemas; acquiring, from the user, at least one association usable to map at least a first element of the first document to at least a second element of the second document, wherein each of the first and second elements contain layout data; and storing the association. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10)
-
-
11. A computer-readable storage medium containing instructions for performing a method for schema mapping and data transformation, the method comprising:
-
retrieving at least a portion of the first document; generating one or more labels representing schema information for the at least a portion of the first document based on a schema of the first document; displaying simultaneously to a user, with a graphical user interface (GUI), a representation of the schema of the first document comprising the at least a portion of the first document and the one or more labels representing schema information for the at least a portion of the first document and a representation of a schema of the second document within cells of a spreadsheet application, the first and second documents having different schemas; acquiring, from the user, at least one association usable to map at least a first element of the first document to at least a second element of the second document, wherein each of the first and second elements contain layout data; and storing the association. - View Dependent Claims (12, 13, 14, 15, 16)
-
-
17. A system for schema mapping and data transformation, comprising:
-
means for retrieving at least a portion of the first document; means for generating one or more labels representing schema information for the at least a portion of the first document based on a schema of the first document; means for displaying simultaneously to a user, with a graphical user interface (GUI), a representation of the schema of the first document comprising the at least a portion of the first document and the one or more labels representing schema information for the at least a portion of the first document and a representation of a schema of the second document within cells of a spreadsheet application, the first and second documents having different schemas; means for acquiring, from the user, at least one association usable to map at least a first element of the first document to at least a second element of the second document, wherein each of the first and second elements contain layout data; and means for storing the association. - View Dependent Claims (18, 19, 20, 21, 22, 23, 24, 25, 26)
-
Specification