Schema on Read vs Schema on Write-CSDN博客

本文探讨了商业智能(BI)领域中两种不同的数据处理方式：读时模式(Schema on Read)与写时模式(Schema on Write)。读时模式强调数据存储的灵活性，适合快速变化的数据源；而写时模式则注重数据查询效率，适用于预定义好的数据结构。通过对比这两种模式的特点，帮助企业选择合适的BI策略。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Schema on Read vs Schema on Write in Business Intelligence

When starting build out a new BI strategy. There are more options now than ever before. Gone are the days of just creating a massive star or snowflake schema to store THE data warehouse. In today’s business, you need to store data in structured and unstructured formats and deliver BI value to the users as quickly as possible. This is where the schema on read and schema on write comes into play.

Schema on Read

When using schema on read, you are storing you data in a non RDMS database structure. This allows you to quickly store any type of document or data required for analysis. The flexibility gained by having a limitless format to store any data is trading for speed of a structured RDMS table structure.

Schema on Write

A traditional data model requires the data to be parsed and loaded into specific tables and columns. This makes the load operations slower than schema on read, however, the ability to query pre-designed tables that can contain indexes makes the queries faster.