F01 - Offically Amazing - DB2 10 powers the world's largest data warehouse

Session Number: 328
Track: Big Data and Analytics
Session Type: Podium Presentation
Primary Presenter: Austin Clifford [IBM]
Time: Apr 30, 2013 (12:45 PM - 01:45 PM)
Room: Bonaire 5&6

Speaker Bio: Austin is a DB2 Data Warehouse QA Specialist in Dublin Information Management. Austin is technical lead of the Very Large Database Team which in 2012 achieved the Guinness World Record for the Largest Data Warehouse. Prior to joining IBM in 2009 Austin worked as a database consultant in the Banking sector and has 15 years industry experience in Data Modelling, Database Design, Database Administration and design of ETL applications.
Audience experience level: Beginner, Intermediate, Advanced
Presentation Category: Data Warehousing and Business Intelligence
Presentation Platform: DB2 for Linux, UNIX, Windows
Audiences this presentation will apply to: Application Developers, Data Architects, Database Administrators, New Users, IT Managers
Technical areas this presentation will apply to: Data Warehousing and Business Intelligence, Database Performance (DB2 for LUW)
Objective 1: Understand the real-life challenges presented by large data warehouses.
Objective 2: Identify which are the key enhancements in DB2 10 for data warehouse solutions.
Objective 3: Understand what is the real and tangible benefits of each of the DB2 10 enhancements.
Objective 4: Gain practical insights on tuning and configuration of DB2 10 features.

Abstract:  In January 2012, IBM's VLDB was recognized by Guinness World Records as the world's largest data warehouse. Since January, VLDB has been upgraded from DB2 97 to DB2 10. This presentation will look at the positive and real impact DB2 10 is having on this giant of warehouses. See how adaptive compression, temporal tables, ingest utility and new query optimization features of DB2 10 are performing at the very largest scale. Attend this presentation to understand the important design, implementation & tuning consideration for DB2 10 on your largest databases.