| 利用ORACLE物化视图建立报表数据库 |
| |
| 引用本文： | 冯瑞林.利用ORACLE物化视图建立报表数据库[J].天津职业院校联合学报,2012,14(5):105-108. |
| |
| 作者姓名： | 冯瑞林 |
| |
| 作者单位： | 天津大田集团有限公司,天津市,300191 |
| |
| 摘 要： | 文章阐述了建立独立的报表数据库的必要性,详细介绍了ORACLE物化视图的创建过程与管理方法,论证了通过ORACLE物化视图保障报表数据库与生产数据库实时同步的原理,得出了ORACLE物化视图是创建报表数据库的一种非常有效的方法。
|
| 关 键 词： | 高级复制 物化视图 物化视图日志 数据库链接 刷新组 |
Making Use of ORACLE Materialized Views to Create Reporting Database |
| |
| FENG Rui-lin.Making Use of ORACLE Materialized Views to Create Reporting Database[J].Journal of Tianjin Vocational Institutes,2012,14(5):105-108. |
| |
| Authors: | FENG Rui-lin |
| |
| Institution: | FENG Rui-lin(Tianjin Datian Group Co,Ltd.,Tianjin,China 300191) |
| |
| Abstract: | 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 database with production database,and arrives at that ORACLE materialized view is a very effective way to create a reporting database. |
| |
| Keywords: | high - level replication materialized view materialized view logs database links refresh group |
| 本文献已被 CNKI 万方数据 等数据库收录！ |
|
