Invention Grant
- Patent Title: System for determining the impact to databases, tables and views by batch processing
-
Application No.: US16857470Application Date: 2020-04-24
-
Publication No.: US10824602B2Publication Date: 2020-11-03
- Inventor: James C. Pulaski
- 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; James C. Edwards
- Main IPC: G06F16/21
- IPC: G06F16/21 ; G06F9/48 ; G06F16/22

Abstract:
A system for identifying the databases, database tables and views that are impacted by batch processing tasks and the activities performed on the databases, databases tables and views as a result of the batch processing tasks. Static script files and the associated scripts are parsed to identify predetermined keywords, and types of configuration settings and the command line and/or options passed to the script from a scheduler are examined to determine how the logic in the script operates. Based on the keywords, type of configuration settings and knowledge as to how script operates, the databases, databases tables and/or views that are impacted by batch processing task can be determined and the associated activities performed on the databases, databases tables and views identified.
Public/Granted literature
- US20200250152A1 SYSTEM FOR DETERMINING THE IMPACT TO DATABASES, TABLES AND VIEWS BY BATCH PROCESSING Public/Granted day:2020-08-06
Information query