Method and apparatus for converting from a source database system to a destination database system

A system comprising:

• one or more computing devices including at least one processor, and
• a non-transitory computer-readable medium coupled to the one or more computing devices having instructions stored thereon which, when executed by the one or more computing devices, cause the one or more computing devices to perform operations comprising:
• importing system tables (“imported system tables”) and semantic metadata (“imported semantic metadata”) from a source database system into a metadata database,
• parsing the imported semantic metadata and identifying associations between table elements of the imported system tables,
• generating a conversion scheme in the metadata database, and
• defining an attribute in the conversion scheme in accordance with a meta-model of a destination database system for each association identified,
• wherein defining each attribute corresponding to an association includes:
• identifying, for each imported system table that includes a table element specified in the association, additional attributes,
• determining an inter-cardinality between the specified table elements,
• setting, according to the determined inter-cardinality, for each additional attribute identified, an intra-cardinality between a table element of the additional attribute and a specified table element included in a same one of the imported system tables that includes the table element of the additional attribute,
• defining, for each additional attribute identified, a relationship between the attribute and the additional attribute according to the determined inter-cardinality and a respective intra-cardinality, and
• grouping together the specified table elements and any defined relationships in a metadata definition of the attribute in the conversion scheme.

A non-transitory computer-readable medium having instructions stored thereon which, when executed by the one or more computing devices, cause the one or more computing devices to:

• import system tables (“imported system tables”) and semantic metadata (“imported semantic metadata”) from a source database system into a metadata database;
• parse the imported semantic metadata and identify associations between table elements of the imported system tables;
• generate a conversion scheme in the metadata database;
• and
• define an attribute in the conversion scheme in accordance with a meta-model of a destination database system for each association identified,
• wherein, to define each attribute corresponding to an association, the non-transitory computer-readable medium causes the one or more computing devices to:
• identify, for each imported system table that includes a table element specified in the association, additional attributes,
• determine an inter-cardinality between the specified table elements,
• set, according to the determined inter-cardinality, for each additional attribute identified, an intra-cardinality between a table element of the additional attribute and a specified table element included in a same one of the imported system tables that includes the table element of the additional attribute,
• define, for each additional attribute identified, a relationship between the attribute and the additional attribute according to the determined inter-cardinality and a respective intra-cardinality, and
• group together the specified table elements and any defined relationships in a metadata definition of the attribute in the conversion scheme.