System and method for transforming and using content in other systems
AssigneeTheoris Software, LLC
InventorGregory E. Aldridge
Life of this patent
Estimating the term…
Abstract
A computer system and method is disclosed that transforms data for use in other applications. Several client workstations and servers are coupled together over a network. A client computer contains a user interface for performing the mapping and transformation. Data elements are mapped from a data source to a multi-dimensional cube. The multi-dimensional cube is transformed into a test recordset to determine if the data elements are mapped correctly. The mapping information is saved to a template. A server includes business logic for using the saved template to create a final recordset from the data source using the template. The server sends at least part of the recordset to a browser user interface on a client computer for display.
Claims20
A method comprising:
- identifying an unstructured data source;
- receiving from the user at least one user-defined data dimension indicated by a plurality of data elements within the unstructured data source;
- mapping a plurality of data elements from the data source to a multi-dimensional cube based upon said at least one user-defined dimension, wherein the mapping step includes:
- creating at least one level for a user-defined dimension;
- adding a first set of values to a selected one of the at least one level for each user-defined dimension;
- creating at least one measure representing a type of data within the at least one data source;
- and
- adding a second set of values selected from the data source to the at least one measure;
- wherein at least one value in the second set is associated with at least one value selected from the first set;
- transforming the multi-dimensional cube into a test recordset to determine if the plurality of data elements are mapped correctly;
- saving the mapping information to a template;
- and
- generating a final recordset from the data source using the template.
A method comprising:
- identifying an unstructured electronic data source;
- mapping a plurality of data elements from the data source to a multi-dimensional cube by creating at least one user-specified data dimension as indicated by the plurality of data elements, creating at least one level for each dimension, adding a first set of values to a selected one of the at least one level for each dimension, creating at least one measure, and adding a second set of values to the at least one measure;
- transforming the multi-dimensional cube into a test recordset by determining a plurality of intersections in a plurality of dimension trees in the multi-dimensional cube and building the test recordset from the intersections;
- saving the mapping information to a template;
- generating a final recordset from the data source using the template by determining a plurality of intersections in the plurality of dimension trees in the multi-dimensional cube and building the final recordset from the intersections;
- and
- using at least part of the final recordset in an application.
A system comprising:
- one or more servers;
- one or more client computers coupled to the server over a network, wherein each client computer includes a conversion tool interface;
- wherein said conversion tool interface is operable to:
- map a plurality of data elements from an unstructured data source to a multi-dimensional cube by creating at least one user-specified data dimension as indicated by the plurality of data elements, creating at least one level for each dimension, adding a first set of values to a selected one of the at least one level for each dimension, creating at least one measure, and adding a second set of values to the at least one measure;
- transform the multi-dimensional cube into a test recordset to determine if the plurality of data elements are mapped correctly;
- and
- save the mapping information to a template that is accessible by the one or more servers;
- wherein one or more of said servers contain business logic that is operable to obtain a final recordset from the data source using the template and to send at least part of the final recordset to a user interface for display.
Dependencies are inferred from the claim text.