发明名称 |
Processing data in data migration |
摘要 |
A computer-implemented method for processing information related to an extract-transform-load (ETL) data migration, including aggregating operational metadata and determining: a plurality of metrics, organized by business object, corresponding to the migration; a number of business object instances not successfully loaded; a first end-to-end execution time for at least one business object; relevant input metadata; load readiness status per business object; impact of a business object that is not load ready by analyzing business process hierarchies; business object load readiness by reference to incomplete development status or data defects; scope per test cycle based, at least in part, upon business object load readiness; and high-priority defects of business objects that stop testing based, at least in part, upon analysis of business process hierarchies. |
申请公布号 |
US9460171(B2) |
申请公布日期 |
2016.10.04 |
申请号 |
US201314074996 |
申请日期 |
2013.11.08 |
申请人 |
International Business Machines Corporation |
发明人 |
Marrelli Carl M.;Narayanan Ram S.;Oberhofer Martin;Rashidi Solmaz |
分类号 |
G06F7/00;G06F17/00;G06F17/30 |
主分类号 |
G06F7/00 |
代理机构 |
|
代理人 |
Darrow Stephen;Chung Matthew H. |
主权项 |
1. A computer implemented method for processing information related to an extract-transform-load (ETL) data migration including a plurality of business objects, the method comprising:
aggregating, by a data flow aggregator portion of an algorithmic aggregator framework, operational metadata produced by information integration ETL functions; aggregating, for each business object of the plurality of business objects and by a conversion object aggregator of the algorithmic aggregator framework, a set of metric(s) relating to data conversion performed in the scope of the ETL data migration; determining, by an area comparator of the algorithmic aggregator framework, a difference between a number of business object instances successfully loaded and a number of business object instances which have been at least attempted to be loaded; projecting a projected end-to-end execution time for the ETL data migration on a by business object by business object basis based on at least one of the following: project planned time and/or historical data related to previous ETL data migration jobs; and creating a dashboard display data set that corresponds to a dashboard display, with the dashboard display including a human understandable visual indication of each of the following with respect to at least one business object of the plurality of business objects: the operational metadata produced by information integration ETL functions, the a set of metric(s) relating to data conversion performed in the scope of the ETL data migration, the difference between a number of business object instances successfully loaded and a number of business object instances which have been at least attempted to be loaded, and the projected end-to-end execution time for the ETL data migration. |
地址 |
Armonk NY US |