发明名称 DATA INTEGRATION USING AUTOMATED DATA PROCESSING BASED ON TARGET METADATA
摘要 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.
申请公布号 US2016063082(A1) 申请公布日期 2016.03.03
申请号 US201514927641 申请日期 2015.10.30
申请人 International Business Machines Corporation 发明人 Majumdar Gautam;Saha Tarun K.;Wang Michael Q.
分类号 G06F17/30 主分类号 G06F17/30
代理机构 代理人
主权项 1. A method for data integration using automated data processing based on target metadata, the method comprising the computer-implemented steps of: defining an intermediate data table built from target metadata of a target source destination containing a set of data objects; loading a mapped data set containing a set of source data objects from a source into the intermediate data table based on a configuration object; sorting the set of data objects built from target metadata and generating a target data snapshot that represents an entire record set from which the set of data objects is a part; sorting and validating source data in the intermediate data table using the target metadata; comparing the set of data objects to the sorted and validated source data to identify differences using the target metadata; generating a set of programming language statements to map the differences in the source data based on the target metadata using the target metadata; and loading the mapped source data to a target storage destination using the set of programming language statements.
地址 Armonk NY US