Invention Grant
- Patent Title: Automated ETL resource provisioner
-
Application No.: US15900947Application Date: 2018-02-21
-
Publication No.: US10701140B2Publication Date: 2020-06-30
- Inventor: Michael Bender , David E. Nachman , Michael P. Shute
- 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: Daugherty & Del Zoppo Co. LPA
- Agent Patrick J. Daugherty
- Main IPC: H04L12/919
- IPC: H04L12/919 ; H04L12/24 ; H04L29/08

Abstract:
Aspects automatically provision cloud resources for Extract, Transform and Load job execution as a function of optimizer output data. Aspect access paths identify overall cost and individual step operator costs and statistics relative to cloud resources for executing structured English query language command against a relational database. In one aspect operator steps having high step costs are identified and amounts, types or speeds of a cloud resources associated with the step are adjusted to reduce step cost and access path overall cost. In another aspect structured English query language text descriptors and step costs and function statistics are compared to knowledge base criteria for matches to criteria associated inefficient configurations cloud resources for revision to improve corresponding operation efficiency. In another aspect usages of cloud resources by operator steps are monitored and logged and compared to historic data of similar steps to determine under or over-utilization of resources.
Public/Granted literature
- US20180183863A1 AUTOMATED ETL RESOURCE PROVISIONER Public/Granted day:2018-06-28
Information query