blog   contact    

SQL/MapReduce Case Study - Sessionization

The Camtasia Studio video content presented here requires a more recent version of the Adobe Flash Player. If you are you using a browser with JavaScript disabled please enable it now. Otherwise, please update your version of the free Flash Player by downloading here.

A social network uses the SQL/MR function sessionize to break user data into sessions based on the length of time between activity on the network. With sessionize, the SQL code dropped from more than 1000 lines to less than 100 and performance improved dramatically.

Download Now:
MapReduce for Data Warehousing and Analytics
Scaling Up to Support Large-Scale Reporting and Analytics
Beyond Reporting: Requirements for Large-Scale Analytics
"We're excited about In-Database MapReduce and the promise it offers of scalable execution of advanced statistics without having to move data to a separate statistics platform."

Scott Becker, CTO
Invite Media

"Aster is already pushing the envelope for in-database analytics through its unique integration of SQL with MapReduce that scales to potentially thousand of nodes and petabytes of data."

Wayne Eckerson, Director of Research for TDWI