Automated ETL resource provisioner
US10701140B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Feb 21, 2018 |
| Grant date | Jun 30, 2020 |
| Priority date | — |
| Expiry date | Oct 4, 2038 |
Classification
- Technology area (CPC H)Electricity
- CPC primaryH04L41/024
- WIPO fieldDigital communication
- WIPO sectorElectrical engineering
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.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.