F05 - Archive Solution with IBM DB2 Analytics Accelerator Query Acceleration High Performance Storage Saver

Session Number: 380
Track: Big Data and Analytics
Session Type: Podium Presentation
Primary Presenter: ruiping li [software engineer - IBM]
Time: May 01, 2013 (09:15 AM - 10:15 AM)
Room: Bonaire 5&6

Speaker Bio: Ruiping Li (ruiping@us.ibm.com) is a Senior Software Engineer in DB2 for z/OS development at IBM's Silicon Valley Lab. She is currently a key designer for DB2 query acceleration support for the IBM DB2 Analytics Accelerator. Over the past decade, Ruiping has designed and implemented several key enhancements in DB2 for z/OS, such as optimistic locking support, timestamp with time zone support, pureXML index exploitation, index on expression, materialized query tables (MQTs), as well as multiple CCSID enhancements.
Audience experience level: Intermediate
Presentation Category: Big Data
Presentation Platform: Cross Platform
Audiences this presentation will apply to: Database Administrators
Technical areas this presentation will apply to: Database Performance (DB2 for LUW)
Objective 1: HPSS overall architecture and business value
Objective 2: Table archiving process
Objective 3: Query handling after the table is archived in the accelerator
Objective 4: Performance and best practices



Abstract:  IBM DB2 Analytics Accelerator new release (V3) introduces the High Performance Storage Saver (HPSS) as a new product feature. HPSS provides high-capacity storage with much lower per unit cost than System z. With HPSS the archived tables or partitions can only exist in the accelerator. Thus, the disk storage requirements for the data on System z are highly reduced and SQL query performance is increased, e.g. due to reduced index sizes. At the same time, transparent SQL access to the moved data is provided by the accelerator with exceptionally good performance.