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
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- Analyze.
Your article provided me with useful information about Azure Data Warehouse Solutions.It's quite beneficial to me as well as others. Thank you for continuing to share this type of information.
ReplyDeleteThanks for publishing such great knowledge. You are doing such a great job. This info is really very helpful for everyone. Keep it up. Thanks. Warehouse shelving
ReplyDeleteThis article provided me with a wealth of information. The article is both educational and helpful. Thank you for providing this information. Keep up the good work. warehouse Japan
ReplyDeleteThis article provided me with a wealth of information. The article is both educational and helpful. Thank you for providing this information. Keep up the good work. warehouse Japan
ReplyDeleteI like this article. I was searching over search engines and found your blog and its really helps thank you very much. IT Warehouse in Japan.
ReplyDeleteGreat job for publishing such a nice article. Your article isn’t only useful but it is additionally really informative. Thank you because you have been willing to share information with us. Read more info about linemarking
ReplyDeleteExcellent article... Thank you for providing such valuable information; the contents are quite intriguing.
ReplyDeleteData Engineering Services
Data Analytics Solutions