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.

Topics Covered:

  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

Full Conference
Location: Stowe North & South Date: May 17, 2018 Time: 9:05 am - 10:05 am Kent Graziano Kent Graziano