The Official Introduction to DB2 for the Z/OS: Version 8, 2/e
暫譯: DB2 for Z/OS 官方介紹：第8版，第二版

Susan Graziano Sloan

The Official Introduction to DB2 for the Z/OS: Version 8, 2/e
  • 出版商: Prentice Hall
  • 出版日期: 2004-06-05
  • 定價: $1,798
  • 售價: 6.0 折 $1,079
  • 語言: 英文
  • 頁數: 528
  • 裝訂: Paperback
  • ISBN: 0131477501
  • ISBN-13: 9780131477506
  • 相關分類: 資料庫

    • 立即出貨(限量) (庫存=3)

買這商品的人也買了...

相關主題

商品描述

Table of Contents:

Foreword.


About this book.

Who Should Read This Book.

Conventions and Terminology Used in This Book.

How to Send Comments.

Acknowledgments.

I. OVERVIEW.

1. An Overview of DB2.

Scenarios for Using DB2.

Providing Availability and Scalability to Large Businesses.

Providing Information to Decision Makers.

Distributing Data and Providing Web Access.

The IBM DB2 Information Management Strategy.

The DB2 Universal Database Family.

Enterprise Servers.

DB2 UDB Editions.

Clusters.

More Servers.

The Networks: WANs and LANs.

Personal, Mobile, and Pervasive Environments.

Clients.

Sources of Data.

Management Tools.

Application Development Tools.

Middleware and Client APIs.

The DB2 Universal Database Family Portrait.

Open Standards.

SQL-Related Standards.

DB2 UDB for z/Os Conformance.

For More Information.

Practice Exam Questions.

Answers to Practice Exam Questions.

2. DB2 Concepts.

Structured Query Language.

DB2 Data Structures.

Tables.

Indexes.

Keys.

Views.

Table Spaces.

Index Spaces.

Databases.

Enforcement of Business Rules.

Referential Integrity and Referential Constraints.

Check Constraints.

Triggers.

Application Processes and Transactions.

Packages and Application Plans.

Routines.

Functions.

Procedures.

Distributed Data.

Remote Servers.

Connectivity.

DB2 System Structures.

Catalog.

Active and Archive Logs.

Bootstrap Data Set.

Buffer Pools.

Practice Exam Questions.

Answers to Practice Exam Questions.

3. DB2 UDB for z/OS Architecture.

z/OS Overview.

DB2 in the z/OS Environment.

DB2 Lock Manager.

DB2 and the z/OS Security Server.

DB2 Attachment Facilities.

CICS.

IMS.

TSO.

CAF.

RRS.

Distributed Data Facility.

The Parallel Sysplex Environment.

For More Information.

II. WORKING WITH YOUR DATA.

4. Designing Objects and Relationships.

Logical Database Design with Entity-Relationship Model.

Modeling your Data.

Defining Entities for Different Types of Relationships.

Defining Attributes for the Entities.

Normalizing Your Entities to Avoid Redundancy.

Logical Database Design with Unified Modeling Language.

Physical Database Design.

Denormalizing Tables to Improve Performance.

Using Views to Customize What Data a User Sees.

Determining What Columns to Index.

For More Information.

Practice Exam Questions.

Answers to Practice Exam Questions.

5. Working with SQL: The Language of DB2.

Executing SQL.

Methods of Executing SQL.

Executing SQL from Your Workstation.

Writing SQL Queries to Answer Questions: The Basics.

Example Tables.

Selecting Data from Columns: SELECT.

Processing a SELECT Statement.

Accessing DB2 Data that is Not in a Table.

Using Functions and Expressions.

Filtering the Number of Returned Rows: WHERE.

Putting the Rows in Order: ORDER BY.

Summarizing Group Values: GROUP BY.

Subjecting Groups to Conditions: HAVING.

Merging Lists of Values: UNION.

Joining Data from More Than One Table.

Using Subqueries.

Modifying Data.

Inserting New Data.

Updating Data.

Deleting Data.

For More Information.

Practice Exam Questions.

Answers to Practice Exam Questions.

6. Writing an Application Program.

Using Integrated Development Environments.

DB2 Development Support in Integrated Development Environments.

WebSphere Studio Application Developer.

DB2 Development Add-In for Visual Studio.NET.

Workstation Application Development Tools.

Choosing Programming Languages and Methods to Use.

Preparing an Application Program to Run.

Writing Static SQL Applications.

Overview of Static SQL.

Static SQL Programming Concepts.

Writing Dynamic SQL Applications.

Types of Dynamic SQL.

Dynamic SQL Programming Concepts.

Using ODBC to Execute Dynamic SQL.

Using Java to Execute Static and Dynamic SQL.

SQLJ Support.

JDBC Support.

Using an Application Program as a Stored Procedure.

Choosing a Language for Creating Stored Procedures.

Running Stored Procedures.

Setting Up the Stored Procedure Environment.

Preparing a Stored Procedure.

-Writing and Preparing an Application to Call Stored Procedures.

For More Information.

Practice Exam Questions.

Answers to Practice Exam Questions.

7. Implementing your Database Design.

Defining Tables.

Types of Tables.

Table Definitions.

Defining Columns and Rows in a Table.

Determining Column Attributes.

Choosing a Data Type for the Column.

Using Null and Default Value.

Enforcing Validity of Column Values with Check Constraints.

Designing Rows.

Defining a Table Space.

General Naming Guidelines for Table Spaces.

Coding Guidelines for Defining Table Spaces.

Segmented Table Spaces.

Partitioned Table Spaces.

Large Object Table Spaces.

Assignment of Table Spaces to Physical Storage.

A Few Examples of Table Space Definitions.

Defining Indexes.

Index Keys.

General Index Attributes.

Partitioned Table Index Attributes.

Guidelines for Defining Indexes.

Defining Views.

Coding the View Definitions.

Inserting and Updating Data through Views.

Defining Large Objects.

Defining Databases.

Defining Relationships with Referential Constraints.

How DB2 Enforces Referential Constraints.

Building a Referential Structure.

Defining the Tables in the Referential Structure.

Loading the Tables.

Defining Other Business Rules.

Defining Triggers.

Defining User-Defined Functions.

For More Information.

Practice Exam Questions.

Answers to Practice Exam Questions.

8. Managing DB2 Performance.

Understanding Performance Issues.

Know the Performance Requirements.

Design Applications with Performance in Mind.

Determine the Origin of a Performance Problem.

Use the Tools Available for Performance Analysis.

Moving Data Efficiently through the System.

Caching Data: The Role of Buffer Pools.

Compressing Data.

Keeping Data Organized.

Improving Performance for Multiple Users: Locking and Concurrency.

How Locking Works.

How to Promote Concurrency.

Improving Query Performance.

Access Paths: The Key to Query Performance.

Query and Application Performance Analysis.

Learning about Specific Performance Considerations.

For More Information.

Practice Exam Questions.

Answers to Practice Exam Questions.

9. Managing DB2 Operations.

Using Tools to Manage DB2.

DB2 Control Center and Related Tools.

msys for Setup DB2 Customization Center.

DB2 Administration Tool.

Issuing Commands and Running Utilities.

DB2 Commands.

DB2 Utilities.

Managing Data Sets.

Authorizing Users to Access Data.

Controlling Access to DB2 Subsystems.

Controlling Data Access: The Basics.

Controlling Access to DB2 Objects through Explicit Privileges and Authorities.

Controlling Access by Using Multilevel Security.

Controlling Access by Using Views.

Granting and Revoking Privileges.

Backup and Recovery.

Overview of Backup and Recovery.

Backup and Recovery Tools.

Regular Backups and Data Checks.

Database Changes and Data Consistency.

Events in the Recovery Process.

Optimizing Availability during Backup and Recovery.

For More Information.

Practice Exam Questions.

Answers to Practice Exam Questions.

III. SPECIALIZED TOPICS.

10. DB2 and the Web.

Web Application Environment.

Components of Web-Based Applications.

Architectural Characteristics of Web-Based Applications.

Benefits of DB2 UDB for z/OS Server.

Web-based Applications and WebSphere Studio Application Developer.

XML and DB2.

XML Overview.

XML Use with DB2.

Web Services and DB2.

For More Information.

11. Distributed Data Access.

Introduction to Distributed Data Access.

Programming Techniques for Accessing Remote Servers.

Using Explicit CONNECT Statements.

Using Three-Part Names.

Coding Considerations.

Program Preparation Considerations.

Planning Considerations.

Coordination of Updates.

DB2 Transaction Manager Support.

Servers that Support Two-Phase Commit.

Servers that Do Not Support Two-Phase Commit.

Network Traffic Reduction.

Coding Efficient Queries.

Sending Multiple Rows in a Single Message.

Optimizing for Large and Small Result Sets.

Improving Dynamic SQL Performance.

For More Information.

12. Data Sharing with Your DB2 Data.

Advantages of DB2 Data Sharing.

Improves Availability of Data.

Enables Scalable Growth.

Supports Flexible Configurations.

Leaves Application Interfaces Unchanged.

How Data Sharing Works.

How DB2 Protects Data Consistency.

How an Update Happens.

How DB2 Writes Changed Data to Disk.

Some Data Sharing Considerations.

Tasks That Are Affected by Data Sharing.

Availability Considerations.

For More Information.

IV. APPENDIXES.

Appendix A. Example Tables in This Book.

Employee Table.

Department Table.

Project Table.

Employee-to-Project Activity Table.

Products Table.

Parts Table.

Appendix B. IBM DB2 UDB Certification Program.

Examining the DB2 UDB Version 8 Certification Roadmap.

Exploring Exam 700: DB2 UDB V8.1 Family Fundamentals.

The Role of a Certified Database Associate.

Certification Requirements.

Exam 700 Objectives.

Preparing for the Exam.

Study Guidelines.

Exam Information Sources.

Assessment Exams.

Scheduling Your Exam.

Earning More Advanced Certifications.

Glossary.

Bibliography.

Index

商品描述(中文翻譯)

目錄：

前言。

關於本書。

誰應該閱讀本書。

本書中使用的慣例和術語。

如何發送意見。

致謝。

I. 概述。
1. DB2 概述。
使用 DB2 的場景。

為大型企業提供可用性和可擴展性。

為決策者提供資訊。

分發數據並提供網路訪問。

IBM DB2 資訊管理策略。

DB2 通用資料庫系列。

企業伺服器。

DB2 UDB 版本。

叢集。

更多伺服器。

網路：WAN 和 LAN。

個人、行動和普遍環境。

客戶端。

數據來源。

管理工具。

應用程式開發工具。

中介軟體和客戶端 API。

DB2 通用資料庫系列全景。

開放標準。

SQL 相關標準。

DB2 UDB for z/OS 的符合性。

更多資訊。

練習考題。

練習考題答案。

2. DB2 概念。
結構化查詢語言。

DB2 數據結構。

表格。

索引。

鍵。

視圖。

表空間。

索引空間。

資料庫。

業務規則的執行。

參考完整性和參考約束。

檢查約束。

觸發器。

應用程式過程和交易。

包和應用程式計劃。

例程。

函數。

程序。

分散式數據。

遠端伺服器。

連接性。

DB2 系統結構。

目錄。

活動和存檔日誌。

啟動數據集。

緩衝池。

練習考題。

練習考題答案。

3. DB2 UDB for z/OS 架構。
z/OS 概述。

z/OS 環境中的 DB2。

DB2 鎖管理器。

DB2 和 z/OS 安全伺服器。

DB2 附加設施。

CICS。

IMS。

TSO。

CAF。

RRS。

分散式數據設施。

平行 Sysplex 環境。

更多資訊。

II. 與數據一起工作。
4. 設計物件和關係。
使用實體-關係模型的邏輯資料庫設計。

建模您的數據。

為不同類型的關係定義實體。

為實體定義屬性。

對實體進行正規化以避免冗餘。

使用統一建模語言的邏輯資料庫設計。

物理資料庫設計。

對表進行非正規化以提高性能。

使用視圖自定義用戶所見的數據。

確定要索引的列。

更多資訊。

練習考題。

練習考題答案。

5. 使用 SQL：DB2 的語言。
執行 SQL。

執行 SQL 的方法。

從工作站執行 SQL。

撰寫 SQL 查詢以回答問題：基礎知識。

示例表格。

從列中選擇數據：SELECT。

處理 SELECT 語句。

訪問不在表中的 DB2 數據。

使用函數和表達式。

過濾返回的行數：WHERE。

將行排序：ORDER BY。

彙總組值：GROUP BY。

對組施加條件：HAVING。

合併值列表：UNION。

從多個表中聯接數據。

使用子查詢。

修改數據。

插入新數據。

更新數據。

刪除數據。

更多資訊。

練習考題。

練習考題答案。

6. 撰寫應用程式。
使用整合開發環境。

DB2 在整合開發環境中的開發支持。

WebSphere Studio 應用程式開發者。

Visual Studio.NET 的 DB2 開發附加元件。

工作站應用程式開發工具。

選擇使用的程式語言和方法。

準備應用程式以運行。

撰寫靜態 SQL 應用程式。

靜態 SQL 概述。

靜態 SQL 程式設計概念。

撰寫動態 SQL 應用程式。

動態 SQL 的類型。

動態 SQL 程式設計概念。

使用 ODBC 執行動態 SQL。

使用 Java 執行靜態和動態 SQL。

SQLJ 支持。

JDBC 支持。

使用應用程式作為存儲過程。

選擇創建存儲過程的語言。

運行存儲過程。

設置存儲過程環境。

準備存儲過程。

- 撰寫和準備一個調用存儲過程的應用程式。

更多資訊。

練習考題。

練習考題答案。

7. 實施您的資料庫設計。
定義表格。

表格類型。

表格定義。

定義表格中的列和行。

類似商品