Difference between revisions of "Capacity Forecasting Tool"

From PeformIQ Upgrade
Jump to navigation Jump to search
Line 27: Line 27:
|-
|-
|Python  
|Python  
| style="color:black;background-color:#ff00cc;"|Application
| style="color:black;background-color:#aa00cc;"|Application
|http://www.python.org
|http://www.python.org



Revision as of 19:48, 15 December 2007

Introduction

A web based tool to analyse data extracted from various devices via MRTG and generate a capacity forecast.

Implementation

MRTG clients which POST data to data repository. Web based application displays data and performs periodic forecasting runs for which graphs are generated for display via a web server. The application will have the ability to download forecasts as Excel Spreadsheets.

Generating Excel Files

See Generating Excel Spreadsheets Programatically

Parsing MRTG Files

See Parsing MRTG Files

Generating Graphs

Us the Python module matplotlib to generate images for data encapsulated in a MySQL database. Images will be displayed via a web server.

UNIX Packages Required

Name Required by Download Location
Python Application http://www.python.org
matplotlib http://matplotlib.sourceforge.com
numpy matplotlib http://sourceforge.net/projects/numpy/
ATLAS numpy http://sourceforge.net/projects/math-atlas/
BLAS numpy
PERL http://ww.perl.org/
SpreadSheet::WriteExcel http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-2.20/lib/Spreadsheet/WriteExcel.pm
Parse::RecDescent SpreadSheet::WriteExcel http://search.cpan.org/~dconway/Parse-RecDescent-v1.95.1/lib/Parse/RecDescent.pm
OLE::StorageLite SpreadSheet::WriteExcel http://search.cpan.org/~jmcnamara/OLE-Storage_Lite-0.15/Storage_Lite.pm

See Help onTables