Popular Post

Tuesday, March 27, 2012

R-Script to Aggregate (ETL to MySQL) Actual data with Base-line data for IT-Control Charts

At my previous post (R-script to plot IT-Control Chart against MySQL) the task was given to write a R-script to pre-process (ETL) the raw date-hour stamped data to the DATA-cubical format for Control Charting.

Here is the solution:
I have just transformed the already developed SQL script to the RODBC based R-Script which can be seen below:











The result of the script run is the "ActualVsHistorical" table in the servermentrics database on MySQL with the following data that is identical with the data used for plotting IT-Control Chart published in the previous post. The data itself can be seen by just typing the data frame name in the R-Console window:
























So, all main elements of SEDS-lite project were prototyped and published on my posts. Maybe one more task is left, which is to illustrate on R how the exceptional (based on EV meta-metric filtering)  list of objects (servers) can be created as a part of anomalies detection. So far that was done and published in this blog and so far it is only in the "DB2"-like SQL format to run within BIRT. See the post about that here: UCL=LCL : How many standard deviations do we use for Control Charting? Use ZERO!

.

4 comments:

  1. Greetings! I've been following your weblog for a while now and finally got the courage to go ahead and give you a shout out from Houston Tx! Just wanted to tell you keep up the great work!

    My blog: rentzio.com

    ReplyDelete
  2. Hi there! I realize this is sort of off-topic
    however I needed to ask. Does building a
    well-established blog like yours take a massive
    amount work? I am completely new to writing a blog but
    I do write in my diary daily. I'd like to start a blog so I can easily share my own experience and views online. Please let me know if you have any suggestions or tips for new aspiring bloggers.
    Appreciate it!

    Take a look at my website :: Go to my website
    My web page :: View here

    ReplyDelete
  3. Your style is very unique compared to other people I
    have read stuff from. Thanks for posting when you have the opportunity, Guess I will just book mark this page.


    my page Dayton Movers

    ReplyDelete
  4. It's going to be finish of mine day, but before end I am reading this fantastic article to improve my experience.

    Feel free to surf to my webpage :: Ohio Movers

    ReplyDelete