Temporal Data in DB2 10 - "When did you want to ask that question?"

Session Number: 1837
Track: DB2 10 for z/OS (A)
Session Type: Podium Presentation
Primary Presenter: Phil Grainger [Lead Product Manager, DB2 - BMC Software]
Time: Nov 14, 2011 (04:00 PM - 05:00 PM)
Room: Tycho

Speaker Bio: Phil has over 20 years experience of DB2, from DB2 Version 1.2 to DB2 10 From a DBA for the largest user of DB2 at that time in the UK, through his time at PLATINUM technology and his Senior Principal Product Manager role for CA, Phil has always supported user groups, as well as being a member of the IDUG EMEA Planning Committee and a member of the IDUG Volunteer Hall of Fame In 2009 and 2010, Phil was honoured by IBM as an Information Champion Currently Phil is running Grainger Database Solutions, working with Cogito, providing DB2 consultancy and product design & development services in support of Cogito’s EZ-DB2 family of tools
Audience experience level: Beginner, Intermediate
Presentation Category: Application Design
Presentation Platform: DB2 for z/OS
Audiences this presentation will apply to: Application Developers, Data Architects, Database Administrators, New Users, IT Managers
Technical areas this presentation will apply to: New Release (DB2 for z/OS)
Objective 1: What on earth IS temporal data
Objective 2: Why do I need to ask questions about the past
Objective 3: How will DB2 allow me to go back to prior points in time to ask my questions
Objective 4: What about current data - is that catered for?
Objective 5: Questions and discussions

Abstract:  We're used to asking questions and we know how to code them in SQL - but how do you ask a question about a specific point in time. Temporal data support allows the user/programmer to concentrate on WHAT the questions are whilst DB2 manages the underlying data to provide the answers Want to know your bank balance? That's easy - but what about your bank balance 56 days ago - not quite so simple is it? This presentation will take a brief look at the concepts of temporal data before looking in a little detail about how DB2 manages this SQL time machine