Eliminating execution of jobs-based operational costs of related reports

Patent metadata

Field	Value
Publication number	US-9483309-B2
Application number	US-201615062712-A
Country	US
Kind code	B2
Filing date	Mar 7, 2016
Priority date	Nov 25, 2013
Publication date	Nov 1, 2016
Grant date	Nov 1, 2016

Abstract

Optimizing operational costs in a computing environment includes identifying high-cost jobs that are executed to generate one or more reports in the computing environment, identifying one or more reports the generation of which is dependent on the execution of the high-cost jobs, and culling at least a first job from among the high-cost jobs, in response to determining that a benefit achieved from the reports that depend on the first job does not justify costs associated with generating the reports.

First claim

What is claimed is:

1. A computer system for optimizing operational costs in a computing, environment, comprising:
a processor; and
a memory storing computer executable instructions having
a first logic unit configured to identify one or more jobs from a plurality of jobs that are executed to generate one or more reports in the computing environment;
a second logic unit configured to identify one or more reports, wherein generation of the one or more reports is dependent on the one or more jobs identified; and
a third logic unit configured to cull at least a job from the one or more jobs identified, in response to determining that a benefit achieved from the one or more reports that depend on the job does not justify costs associated with generating the one or more reports,
when executed by the processor, the computer executable instructions cause the processor to perform:
identifying, via the first logic unit, one or more high-cost jobs from the plurality of jobs that are executed to generate the one or more reports in the computing environment by determining costs associated with generation of the one or more reports as a function of computer resource usage; and
repeatedly performing one or more of, until a threshold condition is reached:
identifying, via the second logic unit, one or more high-cost reports from among the one or more reports identified, wherein generation of the one or more high-cost reports identified is dependent on the one or more high-cost jobs identified; and

culling, via the third logic unit, at least a first job from among the one or more high-cost jobs identified, in response to determining that a benefit achieved from the one or more high-cost reports identified that depend on the first job does not justify costs associated with generating the one or more high-cost reports, wherein costs associated with generating the one or more high-cost reports are calculated based on aggregated cost of all of the individual job on which the reports depend;
wherein cost of the individual job is determined by following:
a) if the job is not executing during the highest peak of resource usage, then its individual cost is zero; and
b) if the job is executing during the highest peak of resource usage but is needed by other reports too, then its individual cost is zero; and
c) if the job is executing during the highest peak of resource usage and is needed only by a particular report, then the job cost is added to the report's individual cost.

Assignees

• IBM

Inventors

• Fankhauser Michael
• Haber Marc N
• Halberstadt Benjamin
• Hecker Roger K

Classifications

• G06F16/254

  Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses · CPC title

• G06Q10/0639

  Performance analysis of employees; Performance analysis of enterprise or organisation operations · CPC title

• G06F9/4881

  Scheduling strategies for dispatcher, e.g. round robin, multi-level priority queues · CPC title

• G06Q10/0631 Primary

  Resource planning, allocation, distributing or scheduling for enterprises or organisations · CPC title

• G06Q10/0637

  Strategic management or analysis, e.g. setting a goal or target of an organisation; Planning actions based on goals; Analysis or evaluation of effectiveness of goals · CPC title