公开(公告)号：US20180183863A1

公开(公告)日：2018-06-28

申请号：US15900947

申请日：2018-02-21

Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION

Inventor： MICHAEL BENDER ,  DAVID E. NACHMAN ,  MICHAEL P. SHUTE

IPC: H04L29/08 ,  H04L12/919 ,  H04L12/24

CPC classification number: H04L67/1008 ,  H04L41/024 ,  H04L41/5054 ,  H04L47/765

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.

公开(公告)号：US20170104627A1

公开(公告)日：2017-04-13

申请号：US14878317

申请日：2015-10-08

Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION

Inventor： MICHAEL BENDER ,  DAVID E. NACHMAN ,  MICHAEL P. SHUTE

IPC: H04L12/24 ,  H04L29/08 ,  H04L12/919

Abstract: Aspects automatically provisioning of cloud resources for ETL job execution as a function of optimizer output data. Access paths identify overall cost and individual step operator costs and statistics relative to cloud resources for executing an SQL commands 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 thereby reduce the step cost and the access path overall cost. In another aspect SQL 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.

公开(公告)号：US20180183864A1

公开(公告)日：2018-06-28

申请号：US15900993

申请日：2018-02-21

Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION

Inventor： MICHAEL BENDER ,  DAVID E. NACHMAN ,  MICHAEL P. SHUTE

IPC: H04L29/08 ,  H04L12/919 ,  H04L12/24

CPC classification number: H04L67/1008 ,  H04L41/024 ,  H04L41/5054 ,  H04L47/765

Abstract: Aspects automatically provisioning of cloud resources for ETL job execution as a function of optimizer output data. Access paths identify overall cost and individual step operator costs and statistics relative to cloud resources for executing an SQL commands 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 thereby reduce the step cost and the access path overall cost. In another aspect SQL 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.

公开(公告)号：US20170370732A1

公开(公告)日：2017-12-28

申请号：US15193299

申请日：2016-06-27

Applicant: International Business Machines Corporation

Inventor： MICHAEL BENDER ,  RHONDA L. CHILDRESS ,  MICHAEL P. SHUTE

IPC: G01C21/34 ,  G05D1/00

CPC classification number: G08G1/096838 ,  A61B5/021 ,  A61B5/0245 ,  A61B5/0531 ,  A61B5/0816 ,  A61B5/082 ,  A61B5/117 ,  A61B5/18 ,  A61B5/225 ,  B60W40/08 ,  G01C21/3484 ,  G01C21/3492 ,  G05D1/0088 ,  G06K9/00791 ,  G06K9/00845 ,  G08G1/096811 ,  G08G1/096827 ,  G08G1/096844 ,  G08G1/096888

Abstract: One or more processors identify an occupant of a passenger vehicle, and then receive biometric sensor readings from a biometric sensor that is monitoring the occupant in real time, where the biometric sensor readings indicate a real-time emotional state of the occupant. The processor(s) generate a personal profile for the occupant of the passenger vehicle based on the biometric sensor readings. The processor(s) receive a desired destination and travel schedule for the occupant of the passenger vehicle, as well as environmental sensor readings indicating a real-time environmental state of the passenger vehicle. The processor(s) then create a travel route for the passenger vehicle based on the biometric sensor readings, the personal profile of the vehicle occupant, the desired destination and travel schedule, and the real-time environmental state of the passenger vehicle. One or more processors then transmit, to the passenger vehicle, directions for the travel route.