Mapping Disparate Database Schemas Using Artificial Intelligence

An apparatus for mapping a source database schema to a destination database schema, comprising:

• one or more processors;
• and
• memory storing instructions that, when executed by the one or more processors, cause the apparatus to:
• generate a source database schema graph having a plurality of nodes, each node corresponding to a data object in the source database schema;
• generate graphical context data for the source database schema graph nodes;
• using a trained artificial intelligence (AI) model, compare the graphical context data for a selected source database schema graph node to graphical context data for a selected destination database schema graph node;
• and
• label a mapping between the selected source database schema graph node and the selected destination database schema graph node where the AI model determines that the selected nodes are sufficiently similar.

A computer-implemented system for mapping a source database schema to a destination database schema, comprising:

• a feature identifier configured to identify attributes of the source database schema and destination database schema;
• a graph engine configured to convert the identified attributes of the source database schema and destination database schema into respective graph representations;
• and
• a graph analyzer configured to:
• compare the graph representations to identify nodes in the destination database schema that are analogous to corresponding nodes in the source database schema;
• and
• label as a match a mapping between selected source database schema graph nodes and corresponding destination database schema graph nodes where the graph analyzer determines that the nodes are sufficiently similar.