For ISVs: Faster Data Reduction and Smoothing for Analysis & Archival in MySQL

ScienceLogic embeds MySQL in its EM7 network management appliances. An installation of EM7 can perform over half a billion database queries daily, storing massive amounts of data for both real-time and trended performance reporting. The product’s need for high-scale data handling and storage required solutions to increase efficiency and get to scale. One solution is to utilize data smoothing techniques in MySQL, using "group by". Data smoothing is the act of translating high-resolution data into lower resolution data for lower frequency trend analysis over a long period, and more importantly, to reduce unneeded resolution for data archival storage. Any application that performs frequent polling for data and archives this data for long (or infinite duration) has run into the situation of 'too much data'. Tables become huge and unsearchable, performance goes down, and over time - the resolution of this data becomes worthless compared to the cost to store it.

In this webinar we will show how data smoothing can provide a solution to these problems, covering the following topics:

• Business needs and use cases for data smoothing
• Techniques for different normalization needs and different data sets
• Benchmark comparison between scripted/programmed solutions versus database-side, SQL query-side solutions.
• Simple ‘gauge data’ smoothing process, the more complicated 'counter data' smoothing process, and the 'waterfall smoothing' technique for multiple levels of archival and smoothing.
• Optimal indexing for efficient grouping.
• If time permits, we will also show how partitioning can be used for maintenance and quick deletion of archived data, and stored procedures can be used for more complex smoothing applications.

WHO:

• Michael McFadden, Sr. Software Architect, ScienceLogic
• Rebecca Hansen, Group Product Marketing Manager, Sun MySQL

WHAT:

For ISVs: Faster Data Reduction and Smoothing for Analysis & Archival in MySQL web presentation.

WHERE:

Simply access the web seminar from the comfort of your own office.

WHY:

Verify your browser and operating system compatibility with Webex

If you already have a MySQL.com account, save time by logging in now.