恒星模型构造（Oracle）的物质视图与表格
下午好的朋友，
我对甲骨文有一些疑问，以及建立星模（BI模型）会更好。
建立尺寸和事实表，实现的视图或表格会更好？ 为了获得最佳性能，我可以想到物有的观点和表格之间的一些差异。
实体视图的优势：
VM易于开发。 增量负载管理很容易，不需要太多开发。
物质观点的缺点：
对于非常大的数据量，在我看来，它们不支持分区。
我将感谢您向我推荐的任何帮助或观点，或者如果有人开发了具有实体视图的整个星形模型，他们可以提供什么建议。
我尚不清楚的是，尽管我可以在什么时间或确定一个或另一个使用的因素上制作模型和实体视图。 多谢，
Good afternoon friends,
I have some queries regarding oracle and what would be better to build star models (BI models).
which would be better to build dimensions and fact tables, materialized views or tables?
In order to have the best performance, I can think of some differences between materialized views and tables.
ADVANTAGE of Materialized Views:
VMs are easy to develop.
incremental load management is easy, it does not need much development.
DISADVANTAGE of materialized views:
for very large data volumes, it seems to me that they do not support partitioning.
I would appreciate any help or point of view that you would recommend to me, or if someone developed their entire star model with materialized views, what suggestions could they provide.
what is not clear to me is, although I can make the model with tables and materialized views, at what time or what would be the factor that determines the use of one or the other.
Thanks a lot,
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论