Dismiss
InnovationQ will be updated on Sunday, Oct. 22, from 10am ET - noon. You may experience brief service interruptions during that time.
Browse Prior Art Database

BI System performance monitoring and analysis through problem discovery, single view presentation and guided recommendations for modelers and report authors.

IP.com Disclosure Number: IPCOM000236742D
Publication Date: 2014-May-14
Document File: 4 page(s) / 191K

Publishing Venue

The IP.com Prior Art Database

Abstract

Disclosed is a system for Performance Monitoring and Analysis (PMA). This near real-time application helps the BI Admin to quickly pinpoint performance problems and discover the areas for potential improvement.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 40% of the total text.

Page 01 of 4

BI System performance monitoring and analysis through problem discovery, single view presentation and guided recommendations for modelers and report authors.

Business Intelligence (BI) system performance issues, such as poor report performance or slowed warehouse processes, are commonly addressed by enabling extensive logging on a system. Typically, a system needs to be restarted to change the logging level and the system performance worsens for some period while detailed logging is enabled. After logs are captured, a BI

Administrator(admin) goes through all generated log files trying to piece the information together and understand the source of the problem. In a typical distributed environment, the BI admin needs to go through thousands of log files spread across different servers. This is a time consuming and a technical task. Linking the information together from different servers to get the complete picture and quickly pin point a problem is a difficult task.

In many cases, poor report performance problems are related to poor model design or incorrect report authoring . The BI admin needs to have adequate modeling and reporting knowledge to link the discovered problem to an appropriate solution . Because the information in log files is not in common modeling and reporting terms, modelers and report authors find it difficult to use, understand, and link to a solution. Modelers and report authors cannot be self-sufficient in finding and solving performance problems; the BI admin needs to contact those people for model and report adjustments to improve the performance . This process is manual and takes time. While this is all happening, the BI system continues to be slow.

The novel contribution is Performance Monitoring and Analysis (PMA). This near real-time application helps the BI Admin to quickly pinpoint performance problems and discover the areas for potential improvement. It also helps the modeler and the report authors to easily find and fix modeling and reporting issues through guided analysis and best practice recommendations .

"Always on" monitoring provides a record of what just happened all the time; no stopping, flipping switches, restarting and trying to "do it again". Detailed information about who, what, when, where, and why provides insights into problems.

All BI System processes from all servers are unified, linked together, and captured in a single data store.

Captured information is translated from technical terms to common data modeling and reporting terms .

Captured information is analyzed based on system workload, moving averages of system response times, time trends, usage patterns, common system characteristics and automatically detects problem areas and anomalies .

1


Page 02 of 4

Problem areas and anomalies are then linked to potential solutions captured in knowledge base system . Potential solutions are scored and ranked by a possibility of solving a problem.

A user is presented with a single view of...