×

Get Access

First Name
Last Name
Company
Job Title
Country
No. I do NOT want Snowflake to e-mail me about products and events that it thinks may interest me.
Yes. I do want Snowflake to send e-mail me about products and events that it thinks may interest me.
By clicking the button below, you understand Snowflake will process your personal information in accordance with our Privacy Notice.
Thank You!
Error - something went wrong!
   

Data Modeling in the Age of JSON

July 25, 2019

Businesses that employ the Schema-on-Write methodology know the importance of data modeling. In Schema-on-Write, a data modeler or database designer creates a structure, or “schema,” for the data before it is loaded, or “written,” into the system. 


With the more recent advent of the Schema-on-Read methodology, in which the goal is to load data into the system as quickly as possible and without upfront design and modeling, data modeling has taken a backseat. Still, it remains no less important: Data modeling helps define the structure and semantics of data, so business users and data scientists can properly query, manipulate, and analyze it. 


Schema-on-Read requires that data be transformed into an understandable relational model in order to allow business users to make sense of it. As it turns out, semi-structured data can be transformed into a relational model by applying data modeling best practices. We describe these best practices in detail in our new ebook, “Data Modeling Best Practices: How to Convert Schema-on-Read into Schema-on-Write.”


Download our ebook to learn how to:

  • Transform JSON data into traditional relational models
  • Turn JSON into three form factor (3NF)
  • Turn JSON into a Data Vault model
  • Handle document changes in Schema-on-Read, and more

 

Previous Flipbook
5 Steps to Successful Data Governance
5 Steps to Successful Data Governance

Next Flipbook
5 Best Practices for Data Warehouse Development
5 Best Practices for Data Warehouse Development