Invention Grant
US09251226B2 Data integration using automated data processing based on target metadata
有权
使用基于目标元数据的自动数据处理的数据集成
- Patent Title: Data integration using automated data processing based on target metadata
- Patent Title (中): 使用基于目标元数据的自动数据处理的数据集成
-
Application No.: US13832645Application Date: 2013-03-15
-
Publication No.: US09251226B2Publication Date: 2016-02-02
- Inventor: Gautam Majumdar , Tarun K. Saha , Michael Q. Wang
- Applicant: International Business Machines Corporation
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Keohane & D'Alessandro PLLC
- Agent John R. Pivnichny; Hunter E. Webb
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
Approaches for data integration between multiple IT sources using automated data processing based on target metadata are provided. Specifically, an integration component is configured to load a mapped data set into a table with delta processing based on a configuration object containing, e.g., the source data location, target table name, and source to target mapping. The integration component uses the target metadata to validate data, identify changes, generate the necessary database programming language (e.g., structured query language (SQL)), and run the database programming language with data binding to perform the actual data updates. The integration component leverages the data target metadata to automate the processing of source data, thus providing a way to validate the data, and identify delta changes at the field level between the source and target. This significantly reduces the overall development effort, while providing consistency in record handling and error reporting.
Public/Granted literature
- US20140279830A1 DATA INTEGRATION USING AUTOMATED DATA PROCESSING BASED ON TARGET METADATA Public/Granted day:2014-09-18
Information query