System and method for optimizing computation of metrics facilitating monitoring of service level agreements (SLA)

Patent metadata

Field	Value
Publication number	US-9703851-B2
Application number	US-201414538347-A
Country	US
Kind code	B2
Filing date	Nov 11, 2014
Priority date	Nov 11, 2013
Publication date	Jul 11, 2017
Grant date	Jul 11, 2017

Abstract

A system and method for optimizing the computation of metrics facilitating monitoring of service level agreements (SLA) in an IT-enabled framework to reduce computational overhead. A receiving module receives data associated with activities performed by one or more service providers. A transforming module transforms the data into a user-defined data structure using a transforming technique. A selecting module selects an attribute and parameters associated with a key performance indicator (KPI) of the one or more service providers. A view creating module creates a materialized view of the user-defined data structure based on the selected attribute. A query generating module m generates a query to be executed on the materialized view. A metric executing module executes the query on the materialized view in order to compute the metric.

First claim

What is claimed is:

1. A method for optimizing computation of a metric in an Information Technology (IT)-enabled framework to reduce computational overhead, the method comprising:
providing a processor and a non-transitory memory coupled to the processor, wherein the processor is capable of executing a plurality of modules stored in the memory;
receiving data associated with activities performed by one or more service providers;
transforming, via the processor, the data into a user-defined data structure using a transforming technique, wherein the user-defined data structure comprises one or more attributes associated with the data;
selecting an attribute of the one or more attributes, and one or more parameters associated with a key performance indicator of the one or more service providers;
creating a materialized view of the user-defined data structure based on the selected attribute, wherein the materialized view includes a database table comprising a sub-set of the data, and wherein the sub-set is retrieved from the data, via the processor, based upon the selected attribute;
generating, via the processor, a query to be executed on the materialized view, wherein the query comprises the attribute and the one or more parameters; and
executing the query on the materialized view, via the processor, in order to compute the metric, wherein the execution of the query facilitates the optimization of the computation of the metric.

2. The method of claim 1 , wherein the transforming technique comprises an extraction, transformation, and loading (ETL) technique.

3. The method of claim 1 , further comprising defining the one or more attributes, wherein a definition of each attribute includes a name of the attribute, a class type of the attribute, a data type of the attribute, and a description of the attribute.

4. The method of claim 1 , wherein the one or more parameters comprises a name of the query, a description of the query, a periodicity of the query, a resource data table associated with the query, a frequency of the query, a complexity associated with the query, a service level agreement (SLA) associated with the one or more service providers, and a combination thereof.

5. The method of claim 1 , further comprising a step of modifying the query based upon a selection of various filtering criteria including a grouping option, a mathematical function, a date of execution of the query, and combinations thereof.

6. The method of claim 1 , wherein the computation of the metric is implemented by initiating a batch process at a pre-defined time interval.

7. The method of claim 6 , wherein the computation of the metric facilitates generating a report depicting service level compliance data associated with the one or more service providers, and wherein the report enables monitoring a performance of the one or more service providers.

8. The method of claim 7 , further comprising a step of generating a notification alert based upon the report.

9. A system for optimizing computation of a metric in an Information Technology (IT)-enabled framework to reduce computational overhead, the system comprising:
a processor; and
a non-transitory memory coupled to the processor, wherein the processor is capable of executing a plurality of modules stored in the memory, and wherein the plurality of modules comprise:
a receiving module that receives data associated with activities performed by one or more service providers;
a transforming module that transforms the data into a user-defined data structure using a transforming technique, wherein the user-defined data structure comprises one or more attributes associated with the data;
a selecting module that selects an attribute of the one or more attributes, and one or more parameters associated with a key performance indicator of the one or more service providers;
a view creating module that creates a materialized view of the user-defined data structure based on the selected attribute, wherein the materialized view represents a database table comprising sub-set of the data, and wherein the sub-set is retrieved from the data based upon the attribute;
a query generating module that generates a query to be executed on the materialized view, wherein the query comprises the selected attribute and the one or more parameters;
a metric executing module that executes the query on the materialized view in order to compute the metric, wherein the execution of the query facilitates the optimization of the computation of the metric.

10. The system of claim 9 , wherein the query is executed by initiating a batch process at the pre-defined time interval.

11. The system of claim 10 , further comprising a dashboard that generates a report depicting service level compliance data associated with the one or more service providers, wherein the report enables monitoring a performance of the one or more service providers.

12. The system of claim 11 , wherein the dashboard further generates a notification alert based upon the report.

13. A computer program product having embodied thereon a computer program for optimizing computation of a metric in an Information Technology (IT)-enabled framework to reduce computational overhead, the computer program product comprising a set of instructions, the set of instructions comprising instructions for:
receiving data associated with activities performed by one or more service providers;
transforming the data into a user-defined data structure using a transforming technique, wherein the user-defined data structure comprises one or more attributes associated with the data;
selecting an attribute of the one or more attributes, and one or more parameters associated with a key performance indicator of the one or more service providers;
creating a materialized view of the user-defined data structure based on the attribute, wherein the materialized view represents a database table comprising a sub-set of the data, and wherein the sub-set is retrieved from the data based upon the selected attribute;
generating a query to be executed on the materialized view, wherein the query comprises the selected attribute and the one or more parameters; and
executing the query on the materialized view in order to compute the metric, wherein the execution of the query facilitates optimization of the computation of the metric.

14. The computer program product of 13 , further comprising instructions for generating a report depicting service level compliance data associated with the one or more service providers, wherein the report enables monitoring a performance of the one or more service providers.

Assignees

• Tata Consultancy Services Ltd

Inventors

• Ramesh Rajini
• Tupakula Srikanth
• Sherly Reshma
• Pandian Dhinakaran

Classifications

• G06Q10/0637 Primary

  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

• H04L43/04

  Processing captured monitoring data, e.g. for logfile generation · CPC title

• G06F16/254 Primary

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

• G06F17/30563 Primary

  Physics · mapped topic