Consolidation of multiple source content schemas into a single target content schema

A computer-implemented method for mapping a plurality of source content schemas into a single target content schema, comprising:

• receiving user input specifying one or more source schemas for mapping to a target schema, each source schema being associated with a corresponding source database that stores content according to the source schema, each source schema comprising one or more source classes that each comprises one or more source properties, the target schema being associated with a corresponding database that is operable to receive content extracted from one or more source databases and store the extracted content according to the target schema, the target schema comprising one or more target classes that each comprises one or more target properties;
• for each source schema to be mapped to the target schema:
• providing a source class tree representing the source schema classes and a target class tree representing the target schema classes for display to a user;
• receiving user input specifying one or more source properties within one or more source classes of the source schema;
• determining one or more target properties within one or more target classes of the target schema for mapping to the one or more source properties of the source schema;
• and
• generating a schema map file comprising a mapping of the one or more target properties of the target schema classes to the one or more source properties of the source schema classes;
• accessing the schema map file for each source schema mapped to the target schema;
• according to the one or more accessed schema map files, determining the one or more mapped source properties for which content is to be extracted from the one or more corresponding source databases;
• applying the one or more schema map files to generate information used for extracting the content associated with the one or more mapped source properties and information used for loading the extracted content into the target database;
• extracting the content associated with the one or more mapped source properties from the one or more corresponding source databases;
• and
• loading the extracted content associated with the one or more mapped source properties into the target database according to the information for loading the extracted content.

Software for mapping a plurality of source content schemas into a single target content schema, the software being embodied in computer-readable media and when executed operable to:

• receive user input specifying one or more source schemas for mapping to a target schema, each source schema being associated with a corresponding source database that stores content according to the source schema, each source schema comprising one or more source classes that each comprises one or more source properties, the target schema being associated with a corresponding database that is operable to receive content extracted from one or more source databases and store the extracted content according to the target schema, the target schema comprising one or more target classes that each comprises one or more target properties;
• for each source schema to be mapped to the target schema:
• provide a source class tree representing the source schema classes and a target class tree representing the target schema classes for display to a user;
• receive user input specifying one or more source properties within one or more source classes of the source schema;
• determine one or more target properties within one or more target classes of the target schema for mapping to the one or more source properties of the source schema;
• and
• generate a schema map file comprising a mapping of the one or more target properties of the target schema classes to the one or more source properties of the source schema classes;
• access the schema map file for each source schema mapped to the target schema;
• according to the one or more accessed schema map files, determine the one or more mapped source properties for which content is to be extracted from the one or more corresponding source databases;
• apply the one or more schema map files to generate information used for extracting the content associated with the one or more mapped source properties and information used for loading the extracted content into the target database;
• extract the content associated with the one or more mapped source properties from the one or more corresponding source databases;
• and
• load the extracted content associated with the one or more mapped source properties into the target database according to the information for loading the extracted content.

A computer-implemented system for mapping a plurality of source content schemas into a single target content schema, comprising:

• means for receiving user input specifying one or more source schemas for mapping to a target schema, each source schema being associated with a corresponding computer-implemented source database that stores content according to the source schema, each source schema comprising one or more source classes that each comprises one or more source properties, the target schema being associated with a corresponding computer-implemented database that is operable to receive content extracted from one or more computer-implemented source databases and store the extracted content according to the target schema, the target schema comprising one or more target classes that each comprises one or more target properties;
• means for providing, for each source schema to be mapped to the target schema, a source class tree representing the source schema classes and a target class tree representing the target schema classes for display to a user;
• means for receiving, for each source schema to be mapped to the target schema, user input specifying one or more source properties within one or more source classes of the source schema;
• means for determining, for each source schema to be mapped to the target schema, one or more target properties within one or more target classes of the target schema for mapping to the one or more source properties of the source schema;
• means for generating, for each source schema to be mapped to the target schema, a schema map file comprising a mapping of the one or more target properties of the target schema classes to the one or more source properties of the source schema classes;
• means for accessing the schema map file for each source schema mapped to the target schema;
• means for according to the one or more accessed schema map files, determining the one or more mapped source properties for which content is to be extracted from the one or more corresponding computer-implemented source databases;
• means for applying the one or more schema map files to generate information used for extracting the content associated with the one or more mapped source properties and information used for loading the extracted content into the computer-implemented target database;
• means for extracting the content associated with the one or more mapped source properties from the one or more corresponding computer-implemented source databases;
• and
• means for loading the extracted content associated with the one or more mapped source properties into the computer-implemented target database according to the information for loading the extracted content.