Schema on Read vs Schema on Write
来源:互联网 发布:学校网络拓扑图图片 编辑:程序博客网 时间:2024/05/16 01:21
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.
- Schema on Read vs Schema on Write
- Read/Write SD Files on Android
- Schema
- schema
- Schema
- schema
- Schema
- Schema
- Schema
- Schema
- Schema
- schema
- Schema
- Schema
- Schema
- Schema
- Schema
- schema
- 13.控制器的父子关系
- Objective-C 14 代码块Block
- oc中的类的声明和实现
- 欢迎使用CSDN-markdown编辑器
- HDU 4418 Time travel 概率 高斯
- Schema on Read vs Schema on Write
- POJ3691 DNA repair 题解&代码
- java 选择排序算法
- oc中类和对象
- LVS调度算法(下)——动态调度算法
- java观察者模式学习总结
- 纪录片大市。中国 观后感
- handoop2.0上深度学习解决方案
- C语言之linux内核--BCD码转二进制与二进制转BCD码(笔试经典)