A Case Study: Click Stream Analysis on Terabytes of Data with MySQL and Infobright

This webinar will present a case study of how a large online ad network uses MySQL and the Infobright storage engine to analyze web log files with the goal of improving campaign effectiveness.

In less than 1 TB the system houses up to 9 TB of data collected every 6 months. More than 100 million rows of data are collected per day. The data includes details such as viewed ads, ads acted on, geographical location and demographics information. Using this information analytics are used to determine the attributes of a user with the goal of finding out which users should be presented with which ads to maximize clicks and conversions.

The queries executed on this system are extremely complex. Billions of rows of data are compared to determine what the unique attributes of a user are. This talk will examine these queries and discuss how they can be executed with excellent performance.

Features of this Case Study

• 9 Terabytes of data analyzed.
• over 100 million rows of data per day collected.
• Data compression up to 10:1
• Billions of rows analyzed to determine user profiles and campaign effectiveness
• Extremely complex queries with fast performance.

WHO:

• Victoria Eastwood, VP Engineering, Infobright

WHAT:

A Case Study: Click Stream Analysis on Terabytes of Data with MySQL and Infobright web presentation.

WHERE:

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

WHY:

To understand how to do extremely complex analysis over a very large amount of data using MySQL.

To verify your browser and operating system compatibility with Webex, please click here »

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