DB2认证教程：工具、数据仓库与OLAP概览

需积分: 3 20 浏览量更新于2024-08-01 收藏 1.58MB PDF 举报

本篇文档是关于DB2认证的参考资料，主要针对DB2Cert512-A4，专注于DB2工具的介绍以及数据仓库（Data warehousing）和在线分析处理（OLAP）的概念。文档由DB2 Developer Domain提供，由IBM公司软件数据库部门出品，旨在帮助考生准备DB2 Fundamentals Certification (Exam 512) 的考试。文档结构分为多个部分： 1. **介绍**：首先概述了教程的目的，强调这是六门系列教程中的第一部分，主要关注安装与规划部分（Section 1）。链接提供了考试目标，考生需先安装IBM DB2 Universal Database Enterprise Edition，这将有助于后续学习和理解DB2工具的使用。 2. **DB2工具**：这部分会详细介绍DB2的各种实用工具，包括控制中心(The Control Center)和客户端配置助手(Client Configuration Assistant)，这些工具在数据库管理和维护中扮演着核心角色。 3. **控制中心**：作为数据库管理系统的重要组成部分，控制中心提供了用户界面，用于监控、管理和优化数据库性能。 4. **客户端配置助手**：该工具帮助用户配置客户端环境，确保与DB2的良好连接，并可能包括数据源设置和驱动程序管理。 5. **其他DB2工具**：除了上述工具外，文档还会提到其他辅助工具，可能涉及数据导入导出、备份恢复等功能。 6. **数据仓库**：这一章节将深入探讨数据仓库的概念，通常用于存储大量历史数据并支持复杂查询，以支持决策支持和商业智能应用。 7. **OLAP**：在线分析处理是数据仓库的关键特性，它允许用户通过多维数据分析快速获取洞察，常用于创建交互式报告和仪表板。 8. **资源与反馈**：最后，文档提供相关的学习资源和获取反馈的途径，鼓励读者进一步探索和提升自己的DB2技能。阅读这份文档对于想要通过DB2 Fundamentals Certification Exam 512的考生来说至关重要，它不仅涵盖了考试所必需的基础知识，还提供了实践操作所需的工具介绍和概念理解。通过实际安装和使用DB2，考生能够更好地掌握这些关键技能，从而顺利通过考试。

Section 5. Other DB2 tools

Visual Explain

Visual Explain lets you view an access plan for explained SQL statements as a graph.

You can use the information available from the graph to tune your SQL queries for

better performance. Visual Explain also lets you dynamically explain an SQL statement

and view the resulting access plan graph.

The DB2 optimizer chooses an access plan and Visual Explain displays the information

as an access plan graph in which tables and indexes -- and each operation on them --

are represented as nodes, and the flow of data is represented by the links between the

nodes.

The best part of Visual Explain is that you don't even have to run the query to get the

information you are looking for. So, for example, let's say you have a written query that

you suspect is inefficiently written; using Visual Explain, you can graphically look at the

cost of the query without actually running it.

The Performance Monitor

The Performance Monitor provides information about the state of DB2 and the data that

it controls. It is a graphical utility that can be customized for your database

environment. You can define thresholds or zones that trigger warnings or alarms when

the values being collected by the Performance Monitor are not within acceptable

ranges.

You can monitor DB2 objects such as instances, databases, tables, table spaces, and

connections by right-clicking an object in the Object Tree pane or in the Contents pane

in the Control Center. From there, you can choose to start monitoring activity.

When an object is being monitored, the color of the icon appears green, yellow, or red

to indicate the status of the monitor. The colors represent the severity of the problems

as defined by the thresholds that you have set. Green signifies that the monitor is

running and everything is fine. Yellow is a warning and signifies that the monitor is

reaching the thresholds that you have set. Red indicates an alarm and that the monitor

has reached or exceeded the threshold. You can use the predefined monitors that are

included with DB2 or you can create your own monitors.

The Performance Monitor displays information from two monitoring facilities in DB2:

Snapshot Monitor and Event Monitor.

The Snapshot Monitor captures database information at specific points in time. You

determine the time interval between these points and what data will be captured. The

Snapshot Monitor can help analyze performance problems, tune SQL statements, and

identify exception conditions based on limits or thresholds.

ibm.com/software/database/db2

Presented by DB2 Developer Domain

Page 16 of 26 DB2 tools, data warehousing and OLAP

Section 6. Data warehousing

What is data warehousing?

The systems that contain operational data -- the data that runs the daily transactions of

your business -- contain information that is useful to business analysts. Analysts use

this information to better understand how the business is operating. For example, they

can see which products were sold in which regions at which time of year. This helps

identify anomalies or to project future sales.

However, there are several problems if analysts access the operational data directly:

• They might not have the expertise to query the operational database. For example,

querying IMS databases requires an application program that uses a specialized

type of data manipulation language. In general, those programmers who have the

expertise to query the operational database have a full-time job in maintaining the

database and its applications.

• Performance is critical for many operational databases, such as databases for a

bank. The system cannot handle users making ad-hoc queries.

• The operational data generally is not in the best format for use by business analysts.

For example, sales data that is summarized by product, region, and season is much

more useful to analysts than the raw data.

Data warehousing solves these problems. In data warehousing, you create stores of

informational data -- data that is extracted from the operational data and then

transformed for end-user decision making. For example, a data warehousing tool might

copy all the sales data from the operational database, perform calculations to

summarize the data, and write the summarized data to a separate database from the

operational data. End-users can query the separate database (the warehouse) without

impacting the operational databases.

DB2 Products for data warehousing

IBM's DB2 Warehouse Manager (DB2 WM) provides a distributed, heterogeneous

infrastructure for designing, building, maintaining, governing, and accessing highly

scalable, robust DB2 data warehouses.

DB2 WM helps you move data directly from source to target and controls the server on

which transformations -- as well as a host of other data warehousing related actives --

take place with distributed warehouse agents.

DB2 WM is really a suite of four products:

• Data Warehouse Center

• Information Catalog

• Query Patroller

Presented by DB2 Developer Domain

ibm.com/software/database/db2

DB2 tools, data warehousing and OLAP Page 19 of 26

剩余164页未读，继续阅读

lzg2151

粉丝: 1
资源: 8

DB2认证教程：工具、数据仓库与OLAP概览

db2-cert7303-a4.pdf

db2-cert7302-a4.pdf

3 Accessing DB2 data_db2-cert7303-a4.pdf

db2-cert7307-a4.pdf

db2-cert7301-a4.pdf

db2-cert7306-a4.pdf

db2-cert7304-a4.pdf

db2-cert7305-a4.pdf

2 Security_db2-cert7302-a4.pdf

1 Planning_db2-cert7301-a4.pdf

最新资源