Components of Summary Management【物化视图】

Components of Summary Management

---汇总管理组件

Summary management consists of:

汇总管理组成:

■ Mechanisms to define materialized views and dimensions.

定义物化视图和规格机制

■ A refresh mechanism to ensure that all materialized views contain the latest data.

刷新机制确保物化视图含有最新的数据

■ A query rewrite capability to transparently rewrite a query to use a materialized view.

查询改写的能力通过物化视图进行透明的改写；

■ The SQL Access Advisor, which recommends materialized views and indexes to create.

SQL访问顾问建议创建物化视图和索引

TUNE_MVIEW, which shows you how to make your materialized view fast refreshable and use general query rewrite.

TUNE_MVIEW,指示你如何使你的物化视图更快速刷新化和使用普通表改写。

The use of summary management features imposes no schema restrictions, and can
enable some existing DSS database applications to improve performance without the

need to redesign the database or the application.

汇总管理功能的使用没有强制用户限制，可以开启使得一些存在的DSS数据库应用，不需重新设计数据库和应用来使得性能得以提升。

Figure 8–2 illustrates the use of summary management in the warehousing cycle. After
the data has been transformed, staged, and loaded into the detail data in the
warehouse, you can invoke the summary management process. First, use the SQL
Access Advisor to plan how you will use materialized views. Then, create materialized
views and design how queries will be rewritten. If you are having problems trying to
get your materialized views to work then use TUNE_MVIEW to obtain an optimized

materialized view.

图表8-2描述了在数据仓库中汇总管理的使用。在数据在数据仓库的细节表中已经转换，分阶段和导入，你可以调用汇总管理进程。

首先，使用SQL访问顾去制定你如何用不用物化视图的计划。然后创建物化视图和设计如何让查询重新被改写。如果物化视图在工作

的过程中存在问题那么使用TUNE_MVIEW去获得一个可优化的物化视图.

Understanding the summary management process during the earliest stages of data
warehouse design can yield large dividends later in the form of higher performance,
lower summary administration costs, and reduced storage requirements.

理解汇总管理进程在数据仓库早期的设计阶段可以为今后高性能构成获得好处，更低汇总管理成本，

以及减少存储要求。