Oracle 流和非规范化
我打算使用 Oracle Streams 进行从源到目标的复制。目标将主要用于运行报告。早些时候，所有报告都在源本身上运行。因此，这种安排提供了更好的性能，因为所有报告查询都定向到专用目标。
我还想对目标上的表进行非规范化，以实现更好的报告性能。非规范化可以与 Streams 复制一起完成吗？我知道 Oracle Streams 允许我们编写自己的出队过程。但是，是否有一种简单的基于“GUI”的方法可以在 Streams 复制数据时动态实现非规范化？任何指示都会非常有帮助。
I intend to use Oracle Streams for replication from Source to Target. The Target will be used mainly to run Reports. Earlier, all the reports used to run on the Source itself. Therefore, this arrangement gives better performance as all report queries are directed to a dedicated Target.
I would also like to denormalize the tables on the Target to achieve better reports performance. Can denormalization be done in conjunction with Streams replication ? I know that Oracle Streams allows us to write our own dequeue process. But is there a simple "GUI"-based way to achieve de-normalization on the fly ... as and when Streams replicated the data ? Any pointers would be very helpful.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我认为最干净的非规范化方法是保持 Streams 复制不变（使用表的 1->1 映射）并在目标表上创建物化视图来处理您需要的转换。
我认为随着逻辑变得越来越复杂，这些类型转换的 GUI 界面很快就会变得很麻烦，但如果您确实需要 GUI 解决方案，您可以查看 Oracle Warehouse Builder。一旦在 OWB 中完成 GUI 驱动的设计，您就可以生成 PL/SQL 包来执行 ETL。
I think the cleanest way to denormalize would be to leave the Streams replication intact (with 1->1 mappings of the tables) and create materialized views on the target tables that handle the transformations you need.
I think GUI interfaces to these types of transformations get cumbersome quickly as the logic gets more complicated, but if you really want a GUI solution you can look at Oracle Warehouse Builder. Once the GUI-driven design is complete within OWB, you can generate PL/SQL packages to perform the ETL.