Apparatus, method, and program for integrating information

An information integration apparatus for transforming data extracted from an information source and loading the transformed data onto a storage destination, comprising:

• a correspondence table storage unit to store an attribute value included in schema information and item information of a data model with the attribute value mapped to the item information;
• a metadata information storage unit to store a pre-modified data model corresponding to first schema information acquired from the information source;
• a schema collector unit to detect a schema modification of the information source by comparing the first schema information with second schema information acquired from the information source subsequent to modifying the first schema information;
• a data model corrector unit to search the correspondence table storage unit for an attribute value of an item related to the schema modification, generating a post-modified data model when the attribute value of the item related to the schema modification is hit, by correcting the pre-modified data model stored on the metadata information storage unit using the item information corresponding to the attribute value of the item related to the schema modification;
• and
• a generating unit to generate a post-modified integration logic and store the post-modified integration logic on the metadata information storage unit, the post-modified integration logic transforming the generated post-modified data model into a data model corresponding to the storage destination.

An information integration method performed by a computer that transforms data extracted from an information source and loads the transformed data onto a storage destination, the information integration method comprising:

• detecting a schema modification of the information source by comparing first schema information acquired from the information source with second schema information acquired from the information source prior to modifying the first schema information;
• searching a correspondence table storage unit for an attribute value of an item related to the schema modification, the correspondence table storage unit storing the attribute value included in schema information and item information of a data model, with the attribute value mapped to the item information;
• generating a post-modified data model by correcting a pre-modified data model stored on a metadata information storage unit using the item information corresponding to the attribute value of the item related to the schema modification when the attribute value of the item related to the schema modification is hit in the correspondence table storage unit, the metadata information storage unit storing the pre-modified data model corresponding to the second schema information, and storing the post-modified data model on a storage device;
• and
• generating a post-modified integration logic and storing the post-modified integration logic on the metadata information storage unit, the post-modified integration logic transforming the post-modified data model stored on the storage device into a data model corresponding to the storage destination.

An information integration apparatus for transforming data extracted from an information source and loading the transformed data onto a storage destination, comprising:

• a memory that stores an attribute value included in schema information and item information of a data model with the attribute value mapped to the item information, and stores a pre-modified data model corresponding to first schema information acquired from the information source;
• and
• a processor that executes a procedure, the procedure including:
• detecting a schema modification of the information source by comparing the first schema information with second schema information acquired from the information source subsequent to modifying the first schema information;
• searching the memory for an attribute value of an item related to the schema modification, generating a post-modified data model when the attribute value of the item related to the schema modification is hit, by correcting the pre- modified data model stored on the memory using the item information corresponding to the attribute value of the item related to the schema modification;
• and
• generating a post-modified integration logic and storing the post- modified integration logic on the memory, the post-modified integration logic transforming the generated post-modified data model into a data model corresponding to the storage destination.