Loading…
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:


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 →


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

Twitter Feed