Presentation Title: The Importance of Having an Appropriate Data Segmentation (Partitioning)
Speaker: Mr Gancho Dimitrov
Company: CERN
Presentation abstract: In this presentation will be shown real life examples from database applications in the ATLAS experiment at the LHC (Large Hadron Collider) where we make use of many Oracle partitioning techniques available in Oracle 11g. With the broadly used range partitioning and its option of automatic interval partitioning we add our own logic in PLSQL for sustaining data sliding windows in order to enforce various data retention policies. We also make use of the reference partitioning in some use cases, however the most challenging was to segment the data of a large bookkeeping system which resulted in tens of thousands list partitions and list sub-partitions. Partition and sub-partition management, index strategy, statistics gathering and queries execution plan stability are important factors when choosing an appropriate for use case data management model. The gained experience with all of those will be shared with the audience.

Presentation begins: 10/12/2014 14:30
Presentation duration: 50
Presentation content level: 3 (1 = indepth, 5 = strategic overview)
Audience experience: Basic Working Knowledge
Audience function: Oracle, Product Expert, Product User
Speaker biography:  Oracle application DBA in the ATLAS experiment at CERN since 2006 with a liaison role between the CERN DBAs who provide the core Oracle DB services and the ATLAS database developers community. My focus is on database schema design, data management, index strategy and performance tuning.
Related topics: Database: Database Features & Options
Hall: 3B