Invention Grant
- Patent Title: System for analyzing the runtime impact of data files on data extraction, transformation, and loading jobs
-
Application No.: US15411108Application Date: 2017-01-20
-
Publication No.: US10754868B2Publication Date: 2020-08-25
- Inventor: Kumaresan Karuppiah , Seshidhar R. Ammasani
- Applicant: Bank of America Corporation
- Applicant Address: US NC Charlotte
- Assignee: Bank of America Corporation
- Current Assignee: Bank of America Corporation
- Current Assignee Address: US NC Charlotte
- Agency: Moore & Van Allen PLLC
- Agent Michael A. Springs; Peter B. Stewart
- Main IPC: G06F17/00
- IPC: G06F17/00 ; G06F7/00 ; G06F16/25

Abstract:
A system for analyzing the runtime impact of data files on data extraction, transformation, and loading (ETL) jobs typically includes a processor, a memory, and a runtime impact analysis module stored in the memory. The runtime impact analysis module is typically configured for: receiving a user input comprising a designator of a data repository from a user; receiving an ETL job list file from one or more ETL servers; for each ETL job invocation name in the ETL job list file: querying the one or more ETL servers for runtime information, receiving the runtime information from the one or more ETL servers, searching the runtime information for the designator of the data repository, and if the designator of the data repository is identified in the runtime information, adding the ETL job invocation name to an impacted ETL job file; and providing the impacted ETL job file to the user.
Public/Granted literature
Information query