Data integration apparatus, data integration method, and computer product

• US 8,639,670 B2
• Filed: 08/24/2012
• Issued: 01/28/2014
• Est. Priority Date: 01/18/2006
• Status: Active Grant

• Current Assignee: Fujitsu Limited
• Original Assignee: Fujitsu Limited
• Inventors: Mineno, Kazuo
• Primary Examiner(s): PHILLIPS, III, ALBERT M
• Application Number:
  US13/594,192
• Publication Number:
  US 20120323841A1
• Time in Patent Office: 522 Days
• Field of Search: 707/602, 707/692, 707/736, 707/722, 707/810
• US Class Current: 707/692
• CPC Class Codes: G06F 16/256 in federated or virtual databases
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database

Abstract

When collecting and integrating data present in separately managed information sources, data are collected from the information sources through a physical model of the information sources. Integration is executed by a process of converting a data configuration (mapping) into a logical model predefined for each utilization-side application and a process of converting and conforming values (cleansing); and the result thereof is provided as a view (logical model) for each application to the utilization-side application.

Claims

1. A data integration apparatus collecting and integrating data in a plurality of information sources, comprising:

a storing unit that stores meta information that includes;

a physical model, which is a model corresponding to each information source and includes data items and a primary key constraint for a data item that serves as a primary key,

a logical model, which is a data model defined for a utilization-side application utilizing integrated data and includes data items and a primary key constraint for a data item that serves as a primary key, and

a mapping definition that defines a correspondence relation between a data item of the physical model and a data item of the logical model as a correspondence relation between a FROM column and a TO column;

a converting unit that receives a search condition for the logical model from the utilization-side application and converts the search condition for the logical model into one or a plurality of search conditions for the physical model based on the meta information;

a collecting unit that issues the search condition for the physical model to an information source and collects from the information source physical-model-compliant data matching the search condition for the physical model;

an outputting unit that integrates data by converting, based on the meta information, the collected physical-model compliant data into logical-model-compliant data and outputs the logical-model-compliant data to the utilization-side application; and

a cleansing controlling unit that determines whether a type of the data item in the FROM column is the same as a type of the corresponding data item in the TO column, and if not, a type conversion processing unit attempts to convert the data item in the FROM column and the corresponding data item in the TO column to the same type.