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. Download our eBook “Data Modeling in the Age of JSON” and learn how to:
- Transform JSON data into traditional relational models
- Turn JSON into three form factor (3NF) and a Data Vault model
- Handle document changes in Schema-on-Read, and more