利用ORACLE物化视图建立报表数据库

Making Use of ORACLE Materialized Views to Create Reporting Database

文章阐述了建立独立的报表数据库的必要性,详细介绍了ORACLE物化视图的创建过程与管理方法,论证了通过ORACLE物化视图保障报表数据库与生产数据库实时同步的原理,得出了ORACLE物化视图是创建报表数据库的一种非常有效的方法。

The article explicates the necessity to build a separate reporting database, makes a detailed exposition of the creation process and management methods of the ORACLE materialized view, argues that ORACLE materialized views ensure the real - time synchronization principle of reporting data- base with production database, and arrives at that ORACLE materialized view is a very effective way to create a reporting database.