Schema-on-Read vs Schema-on-Write

What is Schema-on-Read vs Schema-on-Write?

Schema-on-Read and Schema-on-Write are two different approaches to handling data in the context of data processing and analytics.

Schema-on-Write is a traditional approach where data is first structured and transformed before being loaded into a data storage system. The structure or schema is defined upfront and data must conform to that schema before it can be ingested. This approach ensures data integrity and consistency, but it can be inflexible and time-consuming, especially when dealing with rapidly changing or unstructured data.

On the other hand, Schema-on-Read is a more flexible approach where data is stored in its raw, unstructured form and the schema is applied at the time of data retrieval or analysis. This means that data can be ingested quickly without the need for upfront schema design. The schema is applied on-the-fly during data query or analysis, allowing for more dynamic and agile data exploration and analysis.

How Schema-on-Read vs Schema-on-Write works

In a Schema-on-Write approach, data is first transformed and structured according to a predefined schema. This typically involves extracting, cleaning, and transforming the data before storing it in a structured format like a relational database. The schema defines the structure and data types of the columns in the database table, allowing for efficient storage and retrieval.

In contrast, with Schema-on-Read, data is stored in its raw, unstructured format, often in a data lake or object store. When data needs to be analyzed, a schema is applied dynamically during the query or analysis phase. This allows for more flexibility as the schema can be adjusted or modified based on the specific requirements of the analysis, without the need to transform the underlying data.

Why Schema-on-Read vs Schema-on-Write is important

Schema-on-Read offers several benefits compared to Schema-on-Write:

  • Flexibility: Schema-on-Read allows for agile and exploratory data analysis without the need for upfront data transformation and schema design. This enables faster time-to-insight and the ability to easily adapt to changing business requirements or data formats.
  • Cost savings: Storing data in its raw, unstructured form eliminates the need for expensive and time-consuming data transformation processes. This can lead to cost savings in terms of storage space and data processing resources.
  • Scalability: Schema-on-Read can handle large volumes of data with varying structures and formats. It allows organizations to ingest and analyze diverse data sources without the need for data modeling or schema modification.
  • Real-time analysis: By eliminating the need for upfront schema design and data transformation, Schema-on-Read enables real-time or near real-time analysis of streaming data.

The most important Schema-on-Read vs Schema-on-Write use cases

Schema-on-Read is particularly beneficial in the following scenarios:

  • Big data analytics: Analyzing large volumes of diverse and unstructured data, such as log files, sensor data, social media data, or clickstream data.
  • Data exploration: Exploring and analyzing data with unknown schemas or evolving data structures.
  • Data integration: Integrating data from multiple sources with different schemas or formats without the need for extensive data transformation.
  • Machine learning: Schema-on-Read allows data scientists to quickly iterate and experiment with different data sets and features without the overhead of upfront schema design and transformation.

Schema-on-Read and Schema-on-Write are closely related to other concepts and technologies in the data processing and analytics space:

  • Data Lake: Schema-on-Read is often associated with data lakes, which are large repositories that store raw, unstructured data from various sources.
  • Data Warehouse: Schema-on-Write is more commonly associated with traditional data warehouses, where data is transformed and structured before being loaded for analysis.
  • Data Virtualization: Data virtualization platforms, like Dremio, can provide a unified view of data from different sources and allow for schema-on-read capabilities.

Why Dremio users would be interested in Schema-on-Read vs Schema-on-Write

Dremio is a data virtualization platform that enables users to access and analyze data from multiple sources in a self-service manner. Dremio's schema-on-read capabilities align with the benefits of Schema-on-Read, providing the following advantages:

  • Data agility: Dremio allows users to explore and analyze data without the need for upfront schema design or data transformation. This enables faster time-to-insight and more agile data analysis.
  • Data integration: Dremio's schema-on-read capabilities make it easier to integrate data from multiple sources with different schemas or formats, eliminating the need for extensive data transformation.
  • Real-time analysis: Dremio supports real-time or near real-time analysis of streaming data, enabling users to get immediate insights from live data.
  • Data exploration: Dremio's schema-on-read approach allows users to explore and analyze data with unknown or evolving schemas, making it well-suited for data discovery and data science use cases.
get started

Get Started Free

No time limit - totally free - just the way you like it.

Sign Up Now
demo on demand

See Dremio in Action

Not ready to get started today? See the platform in action.

Watch Demo
talk expert

Talk to an Expert

Not sure where to start? Get your questions answered fast.

Contact Us

Ready to Get Started?

Bring your users closer to the data with organization-wide self-service analytics and lakehouse flexibility, scalability, and performance at a fraction of the cost. Run Dremio anywhere with self-managed software or Dremio Cloud.