Skip to main content


Showing posts with the label data-warehouse or big data

What are differences between schema on read vs schema on write

Hello friends,  If you are talking about data, database , data-warehouse or big data nothing will complete without schema. Schema plays an important role in Data Platform.  Today I am exploring about Schema on write and schema on read in respect of datawarehouse and data lake.  Let see differences. Schema on write  Structured Data,  RDBMS,  OLAP / Data-warehouse.  Heavy ETL (extract-transform-load) role in data movement.  Change in data-model is costly.  work well in range of Data Mart. User have set of questions. Business Analysis. Collect  Data - Apply Schema - Write Data - Analyze. Schema on read  Structure & Un-structured Data.  RDBMS, NoSQ &  Hadoop.  BigData / Data Lake. ELT (extract-load-transform) & Low cost extraction. Schema is just a structured file can be switched dynamically. Ideal for large volume of data. User is exploring data without pre-defined query. Data science & Research. Collect Data - Write Data - Apply Schema- An