COMMON Fall Conference & Expo | October 15-17 | Pittsburgh, PA | www.common.org/fall
Wednesday, October 17 • 9:15am - 10:15am
32AA 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.

This is Session ID:180174

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 →

Wednesday October 17, 2018 9:15am - 10:15am
City Center A