초록 ▼

A system and method for transforming a data object from a source form into a destination form is described. In one embodiment, the data object is stored in its source form as a set of related source components forming a source data structure having a first hierarchical configuration. The data object

A system and method for transforming a data object from a source form into a destination form is described. In one embodiment, the data object is stored in its source form as a set of related source components forming a source data structure having a first hierarchical configuration. The data object is stored in its destination form as a different set of related destination components forming a destination data structure having a different hierarchical configuration. A user is enabled to define a transformation map including a set of transformation mapping expressions declared by the user for transforming the data object between its source form and its destination form. The data object is then automatically transformed from its source form into its destination form based on the transformation map defined by the user and the source and destination data structures.

대표청구항 ▼

What is claimed is: 1. A computer-implemented method comprising: creating a source data structure corresponding to a source form, wherein a data object is stored in the source form in a source database, the source data structure comprises a plurality of source components that are related through a

What is claimed is: 1. A computer-implemented method comprising: creating a source data structure corresponding to a source form, wherein a data object is stored in the source form in a source database, the source data structure comprises a plurality of source components that are related through a first set of parent-child relationships, and the first set of parent-child relationships form a first source hierarchical structure; creating a destination data structure corresponding to a destination form, wherein the destination data structure comprises a plurality of destination components that are related through a second set of parent-child relationships, the second set of parent-child relationships form a second destination hierarchical structure, and the creating the destination data structure comprises extracting metadata from a destination database to define the destination data structure, and determining, based on the metadata extracted from the destination database, a type of the data object in the destination database; receiving a transformation map, wherein the transformation map comprises a set of transformation mapping expressions for transforming the data object between the source form and the destination form, the set of transformation mapping expressions comprises an object map, the object map comprises a component map, and the component map comprises mappings between at least one component in a first source hierarchical level of the first source hierarchical structure, and at least one component in a second destination hierarchical level of the second destination hierarchical structure, wherein the second destination hierarchical level differs from the first source hierarchical level; automatically transforming the data object from the source form into the destination form based on the transformation map, wherein the transforming is performed by one or more processors; and storing the transformed data object, using a machine-readable storage medium, in the destination form into the destination database. 2. The method of claim 1, wherein the source database is accessed by a source application, and the destination database is accessed by a destination application. 3. The method of claim 1, wherein: the source components of the data object are stored in the source database as a plurality of data records in related source tables having the first source hierarchical structure; and the destination components are to be stored in the destination database as a plurality of data records in related destination tables having the second destination hierarchical structure. 4. The method of claim 1, comprising: receiving the data object, in the source form, from a source schema running in the source database as a plurality of data records in related source tables having the first source hierarchical structure; and receiving the transformation map from a plurality of database tables, wherein the database tables comprise a first database table comprising an identifier of the object map, an identifier of the data object in the source database, and an identifier of the data object in the destination database, and a second database table, distinct from the first database table, comprising an identifier of the component map, an identifier of a parent map, an identifier of the at least one component in the first source hierarchical level of the first source hierarchical structure, and an identifier of the at least one component in the second destination hierarchical level of the second destination hierarchical structure, storing the data object, in the destination form, in a destination schema running in the destination database as a plurality of data records in related destination tables having the second destination hierarchical structure. 5. The method of claim 1, comprising enabling a user to define a precondition to check whether a source component contains data that meets a predetermined criteria. 6. The method of claim 1, comprising enabling a user to define a postcondition to check whether a destination component contains data that meets a predetermined criteria. 7. The method of claim 1, comprising creating an in-memory representation of the source data structure form for the data object being transformed, wherein the in memory representation comprises an in-memory hierarchical structure comprises one or more instances of the plurality of source components and one or more parent-child relationships defined between those instances of the source components. 8. The method of claim 7, comprising traversing the in-memory hierarchical structure while applying transformation mapping expressions to appropriate source component instances occupying a level of the in-memory hierarchical structure as the in-memory hierarchical structure is traversed. 9. The method of claim 1, comprising creating an in-memory representation of the destination data structure form for the data object being transformed, wherein the in-memory representation comprises an in-memory hierarchical structure comprising one or more instances of the plurality of destination components and one or more parent-child relationships defined between those instances of the destination components. 10. The method of claim 1, wherein: the source data structure comprises relationships among the plurality of source components and attributes for components among the plurality of source components; the destination data structure comprises relationships among the plurality of destination components and attributes for components among the plurality of destination components; the component map comprises a field map that relates the attributes for the components among the plurality of source components to the attributes for the components among the plurality of destination components: and the method comprises receiving the transformation map from a plurality of database tables, wherein the database tables comprise a first database table comprising an identifier of the object map, an identifier of the data object in the source database, and an identifier of the data object in the destination database, a second database table, distinct from the first database table, comprising an identifier of the component map, an identifier of a parent map, an identifier of the component in the first source hierarchical level of the first source hierarchical structure, and an identifier of the component in the second destination hierarchical level of the second destination hierarchical structure, and a third database table comprising an identifier of the field map, a plurality of expressions, comprising, for each attribute for the component in the second destination hierarchical level of the second destination hierarchical structure a corresponding expression defining the attribute based upon one or more attributes of the component in the first source hierarchical level of the first source hierarchical structure. 11. The method of claim 1, wherein the creating the source data structure comprises extracting metadata from the source database to define the source data structure. 12. The method of claim 11, comprising providing a user-interface, wherein the user-interface enables a user to: define the source data structure by selecting source components corresponding to the data object from the metadata extracted from the source database, and define the destination data structure by selecting destination components corresponding to the destination form from the metadata extracted from the destination database. 13. The method of claim 12, wherein the user-interface enables the user to graphically define the source data structure and the destination data structure. 14. The method of claim 11, comprising providing a user-interface, wherein the user-interface enables a user to: define the source data structure by selecting source components corresponding to the data object from the metadata corresponding to the source schema; and define the destination data structure by selecting destination components corresponding to the destination form from the metadata corresponding to the destination schema. 15. The method of claim 14, wherein the user-interface enables the user to graphically define the source data structure and the destination data structure. 16. The method of claim 1, wherein the transforming comprises: sorting a plurality of components for the destination data structure according to criteria specified in the transformation map. 17. The method of claim 1, comprising: eliminating, based on the metadata extracted from the destination database, a data object that was duplicatively stored in the source database from being duplicatively stored in the destination database. 18. A computer system comprising: a first circuit configured to extract data corresponding to a data object from a source database; a second circuit configured to enable a user to define a source data structure for the data object, define a destination data structure for the data object, based on metadata extracted from a destination database, determine, based on the metadata extracted from the destination database, a type of the data object in the destination database, and define a transformation map, wherein the transformation map comprises a plurality of declarative expressions for mapping the data object from a source form into a destination form, the data object is stored in the source form in the source database, the data object is stored in the destination form in the destination database, the source database comprises a plurality of source components that are related through a first set of parent-child relationships forming a first source hierarchical structure, the destination database comprises a plurality of destination components that are related through a second set of parent-child relationships forming a second destination hierarchical structure, the transformation map comprises an object map, the object map comprises a component map, and the component map comprises mappings between at least one component in a first source hierarchical level of the first source hierarchical structure, and at least one component in a second destination hierarchical level of the second destination hierarchical structure, wherein the second destination hierarchical level differs from the first source hierarchical level; a third circuit configured to transform the data object from the source form into the destination form based on the declarative expressions in the transformation map; and a fourth circuit configured to store the data object in the destination form in the destination database. 19. The system of claim 18, wherein: the data object is stored, in the source form, in a source schema running in the source database as a plurality of data records in related source tables having the first source hierarchical structure; and the data object is stored, in the destination form, in a destination schema running in the destination database as a plurality of data records in related destination tables having the second destination hierarchical structure. 20. The system of claim 18, wherein: the source data structure comprises relationships among the plurality of source components and attributes for components among the plurality of source components; the destination data structure comprises relationships among the plurality of destination components and attributes for components among the plurality of destination components; and the component map comprises a field map that relates the attributes for the components among the plurality of source components to the attributes for the components among the plurality of destination components. 21. The system of claim 18, wherein the second circuit is configured to enable the user to define the source data structure for the data object based on metadata extracted from the source database. 22. The system of claim 18, wherein the third circuit is configured to: sort a plurality of components for the destination data structure according to criteria specified in the transformation map. 23. The system of claim 18, wherein the second circuit is configured to: eliminate, based on the metadata extracted from the destination database, a data object that was duplicatively stored in the source database from being duplicatively stored in the destination database. 24. A machine-readable storage medium, having encoded therein, instructions which, when executed by a processing system, cause the processing system to perform a method comprising: creating a source data structure corresponding to a source form, wherein a data object is stored in the source form in a source database, the source data structure comprises a plurality of source components that are related through a first set of parent-child relationships, and the first set of parent-child relationships form a first source hierarchical structure; creating a destination data structure corresponding to a destination form, wherein the destination data structure comprises a plurality of destination components that are related through a second set of parent-child relationships, the second set of parent-child relationships form a second destination hierarchical structure, and the creating the destination data structure comprises extracting metadata from a destination database to define the destination data structure, and determining, based on the metadata extracted from the destination database, a type of the data object in the destination database; enabling a user to define a transformation map, wherein the transformation map comprises a set of transformation mapping expressions for transforming the data object between the source form and the destination form, the set of transformation mapping expressions comprises an object map, the object map comprises a component map, and the component map comprises mappings between at least one component in a first source hierarchical level of the first source hierarchical structure, and at least one component in a second destination hierarchical level of the second destination hierarchical structure, wherein the second destination hierarchical level differs from the first source hierarchical level; and automatically transforming the data object from the source form into the destination form based on the transformation map. 25. The machine-readable medium of claim 24, wherein the source database is accessed by a source application, and the destination database is accessed by a destination application. 26. The machine-readable medium of claim 24, wherein the method comprises enabling the user to define a precondition to check whether a source component contains data that meets a predetermined criteria. 27. The machine-readable medium of claim 24, wherein the method comprises enabling the user to define a postcondition to check whether a destination component contains data that meets a predetermined criteria. 28. The machine-readable medium of claim 24, wherein the method comprises creating an in-memory representation of the source data structure form comprising an in-memory hierarchical structure comprising one or more instances of the plurality of source components and one or more parent-child relationships defined between those instances of the source components. 29. The machine-readable medium of claim 28, wherein the method comprises traversing the in-memory hierarchical structure while applying transformation mapping expressions to appropriate source component instances occupying a level of the in-memory hierarchical structure as the structure is traversed. 30. The machine-readable medium of claim 24, wherein the method comprises creating an in-memory representation of the destination data structure form for the data object comprising a hierarchical structure including one or more instances of the plurality of destination components and one or more parent-child relationships defined between those instances of the destination components. 31. The machine-readable medium of claim 24, wherein: the source data structure comprises relationships among the plurality of source components and attributes for components among the plurality of source components; the destination data structure comprises relationships among the plurality of destination components and attributes for components among the plurality of destination components; and the component map comprises a field map that relates the attributes for the components among the plurality of source components to the attributes for the components among the plurality of destination components. 32. The machine-readable medium of claim 24, wherein the creating the source data structure comprises extracting metadata from the source database to define the source data structure. 33. The machine-readable medium of claim 32, wherein the method comprises providing a user-interface that enables the user to: define the source data structure by selecting source components from the metadata extracted from the source database; and define the destination data structure by selecting destination components from the metadata extracted from the destination database. 34. The machine-readable medium of claim 33, wherein the user-interface enables the user to graphically define the source data structure and the destination data structure. 35. The machine-readable medium of claim 32, wherein: the data object is stored, in the source form, in a source schema running in the source database as a plurality of data records in related source tables having the first source hierarchical structure; and the data object is stored, in the destination form, in a destination schema running in the destination database as a plurality of data records in related destination tables having the second destination hierarchical structure. 36. The machine-readable medium of claim 35, wherein the method comprises providing a user-interface, wherein the user-interface enables the user to: define the source data structure by selecting source components corresponding to the data object from the metadata corresponding to the source schema; and define the destination data structure by selecting destination components corresponding to the destination data structure form from the metadata corresponding to the destination schema. 37. The machine-readable medium of claim 24, wherein the transforming comprises: sorting a plurality of components for the destination data structure according to criteria specified in the transformation map. 38. The machine-readable medium of claim 24, wherein the method comprises: eliminating, based on the metadata extracted from the destination database, a data object that was duplicatively stored in the source database from being duplicatively stored in the destination database.