Loading…
COMMON Fall Conference & Expo | October 15-17 | Pittsburgh, PA | www.common.org/fall
Back To Schedule
Wednesday, October 17 • 9:15am - 10:15am
32AA Transactional vs. Analytical SQL

Log in to save this to your schedule, view media, leave feedback 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

Speakers
avatar for Rob Bestgen

Rob Bestgen

IBM
Rob Bestgen is an IBM DB2 for i architect and consultant. In his 29 year temporary assignment at IBM, Rob has held a variety of roles including: database developer, database architect, Business Architect, and chief architect of the DB2 for i SQL Query Engine (SQE), to name a few... Read More →


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