POWERUp 2019 has ended
Experience the magic of education. 
Tuesday, May 21 • 8:00am - 9:00am
31BP Transactional vs. Analytical SQL

Log in to save this to your schedule and see who's attending!

Understanding and spotting it: what should an appropriate data model look like? What are the red flags that your data model is not best for your usage? This session will discuss these topics along with strategies for doing more analytical processing of your transactional data. Additional topics covered such as: - virtual vs. ETL mapping - using dimension tables for dates, VINs, customer name, zip code, etc.. Operational Data Stores, Dimensional Data Model and why they are best for analytical analysis will also be discussed.

Learning Objectives:

avatar for Rob Bestgen

Rob Bestgen

Rob Bestgen is a Business Architect for IBM i, responsible for development strategy for systems management and external interfaces. He is also chief architect of the DB2 SQL Query Engine for DB2 i. Rob is also a member of the DB2 for i Center of Excellence team in lab services and... Read More →

Tuesday May 21, 2019 8:00am - 9:00am
Fantasy Tower Magic Kingdom 4

Twitter Feed