Kent Graziano

Kent Graziano

Making Sense of Schema-On-Read

 

Abstract

Kent Graziano is the Chief Technical Evangelist for Snowflake Computing. His is award winning author, speaker, and trainer, in the areas of data modeling, data architecture, and data warehousing. He is a certified Data Vault Master and Data Vault 2.0 Practitioner (CDVP2), an Oracle ACE Director (Alumni), member of the OakTable Network, expert data modeler and solution architect with more than 30 years of experience, including over two decades doing data warehousing and business intelligence (in multiple industries). He is an internationally recognized expert in Data Vault, Oracle SQL Developer Data Modeler, Agile Data Warehousing, and Cloud-based Data Warehousing. Mr. Graziano has created and led many successful software and data warehouse implementation teams, including multiple agile DW/BI teams. He has written numerous articles, authored three Kindle book (available on Amazon.com), co-authored four books (including the 1st Edition of The Data Model Resource Book), and has given hundreds of presentations, nationally and internationally. He was a co-author on the first book on Data Vault, and the technical editor for Super Charge Your Data Warehouse. You can follow Kent on twitter @KentGraziano or on his blog The Data Warrior (http://kentgraziano.com).

presentation

Making Sense of Schema-On-Read

With the increasing prevalence of semi-structured data from IoT devices, web logs, and other sources, data architects and modelers have to learn how to interpret and project data from things like JSON. While the concept of loading data without upfront modeling is appealing to many, ultimately, in order to make sense of the data and use it to drive business value, we have to turn that schema-on-read data into a real schema! That means data modeling! In this session I will walk through both simple and complex JSON documents, decompose them, then turn them into a representative data model using Oracle SQL Developer Data Modeler. I will show you how they might look using both traditional 3NF and data vault styles of modeling.

  1. See what a JSON document looks like
  2. Understand how to read it
  3. Learn how to convert it to a standard data model

Event Timeslots (1)

Friday, September 13th
-
Making Sense of Schema-On-Read

Leave a Reply

PayPal Logo stripe Logo cloudflare Logo