DB2 9 for Linux Unix and Windows

Wydawnictwo: IBM Press
Autor: G. Baklarz
Liczba stron: 1136
Oprawa: miękka
ISBN: 978-0-13-185514-4

Czas dostawy: 4 - 6 tygodni (na zamówienie)
Cena detaliczna: 152,25 zł
Nasza cena: 152,30 zł

Spis treści DB2 9 for Linux Unix and Windows:

Foreword
PrefacePart ONE: Introduction to DB2
Chapter 1: Product OverviewInformation as a Service
The DB2 for Linux, UNIX, and Windows Data Server
DB2 Connectivity
DB2 Administration
Summary
Chapter 2: Getting StartedProduct Installation
The DB2 Environment
Summary
Chapter 3: Getting ConnectedDB2 Client Overview
Roadmap to Distributed Communications
Summary
Chapter 4: Controlling Data AccessOverview of Security
Auditing
SummaryPart TWO: Using SQL
Chapter 5: Database ObjectsUnderstanding Database Objects
Managing Database Objects
Tables
Database Design and Implementation
Summary
Chapter 6: Manipulating Database ObjectsData Retrieval
Data Modification
View Classification
Summary
Chapter 7: Advanced SQLTriggers
Recursive SQL
Outer Join
OLAP Features
Structured Types and Typed Tables
Summary Tables
Sequences
Advanced Functions
Summary
Chapter 8: pureXML Storage EnginepureXML Feature Pack
The difference: pureXML
Creating an XML-enabled database
Creating tables with pureXML
Inserting data into pureXML columns
Selecting data from pureXML columns
Updating and Deleting pureXML columns
Indexing pureXML columns
XML Schema Repository (XSR)
Summary
Chapter 9: Development SQLUser-Defined Functions
Structured Data Types
Schemas and Aliases
COMMIT and ROLLBACK
SQL Procedural Language
Stored Procedures
Summary
Chapter 10: ConcurrencyConcurrency
Isolation Levels
Locking
SummaryPart THREE: DB2 Administration
Chapter 11: Data Storage ManagementProcessor, Memory, and Disk Resources
DB2 Storage Model
Table Space Design
Implementation Example
Automatic Storage
Table Space Maintenance
Table (Range) Partitioning
Summary
Chapter 12: Maintaining DataMoving Data
Data Movement Utilities
Data Maintenance
Data Maintenance Process
Summary
Chapter 13: Database RecoveryDatabase Recovery ConceptsTypes of Recovery
Recovery Strategies
Use of Log Files
Version Recovery Using Backup and Restore
Roll-Forward Recovery
Managing Log Files
Other Recovery Considerations
High Availability
High Availability Disaster Recovery
Summary
Chapter 14: Monitoring and TuningElements of Performance
DB2 Architecture Overview
DB2 Sorting Methods
Monitoring the DB2 System
Database Monitoring
SQL Monitoring
Diagnostics and Problem Determination
Self-Tuning Memory Manager
SummaryPart FOUR: Developing Applications
Chapter 15: Application Development OverviewDB2 Application Development Environment
DB2 Programming Interfaces
Summary
Chapter 16: Development ConsiderationsEmbedded SQL Overview
Support for CLI and ODBC Programming
Support For Java Programming
DB2 Developer Workbench
SummaryPart FIVE: AppendicesAppendix A: DB2 9 Certification Test ObjectivesDB2 Certification Levels
DB2 9 Fundamentals (730)
DB2 for Linux, UNIX, and Windows Database Administration (731)
DB2 for Linux, UNIX, and Windows Advanced DBA (734)
DB2 9 Database Administrator for LUW Upgrade (736)Appendix B: DB2DEMO InstallationIntroduction
Installation Requirements
Using the DB2DEMO Program
Advanced Programming Information
Support
Index

Księgarnia informatyczna © ksiazki-informatyczne.pl - IBM Press , książka informatyczna - DB2 9 for Linux Unix and Windows