+612 9045 4394
 
CHECKOUT
Rdb : A Comprehensive Guide - Lilian Hobbs

Rdb

A Comprehensive Guide

Paperback

Published: 28th September 1999
Ships: 7 to 10 business days
7 to 10 business days
$216.50
or 4 easy payments of $54.13 with Learn more

The definitive book on Oracle's Rdb database. Written by a team of bestselling database experts, including a principal product architect, this is unquestionably the definitive book on Oracle's Rdb8, the latest version of the powerful database for advanced enterprise applications. Rdb: A Comprehensive Guide, Third Edition teaches administrators, programmers, database designers and IT managers the critical components and functions of the new version 8 and explains how to develop powerful Rdb8 programs. The book specifically addresses new Rdb8 management, tuning and scalability tools and describes the new Rdb/NT Workbench for Windows NT. No other source gives readers the authoritative and timely information provided by Rdb: A Comprehensive Guide, Third Edition.

  • Only book on Rdb8
  • Written by Rdb8 experts from Oracle, including the principal product architect
  • Explains how to use Rdb8 on both Windows NT and OpenVMS

Forewordp. xi
Prefacep. xii
Componentsp. 1
What is Oracle Rdb?p. 1
Components of Rdbp. 1
Key Areas of Rdbp. 7
Documentationp. 16
Data Definitionp. 19
Basic Relational Termsp. 20
Creating a Single-File Rdb Databasep. 22
Creating Multifile Databasesp. 31
Deleting Database Metadatap. 31
The Multischema Databasep. 33
The Banking Databasep. 37
Data Manipulationp. 45
SQL Data Manipulation Optionsp. 45
SQLp. 46
Row Operationsp. 60
MultiStatement Proceduresp. 66
Procedures and Functionsp. 76
Sequence Numbersp. 81
Temporary Tablesp. 83
Rdb SQL Worksheetp. 84
What's Next for SQL?p. 86
Storage Structuresp. 89
Why Use Multifile Databases?p. 89
Creating Multifile Databasesp. 91
Creating Storage Areasp. 92
Displaying Database Pagesp. 102
The Database Page Structurep. 103
Space Area Management (SPAM) Pagesp. 109
Snapshot Filesp. 116
Read-Only Areasp. 120
Write Once Read Many (WORM) Areasp. 120
Rdb Storage Managerp. 121
Table Accessp. 125
Indexed Accessp. 125
The Structure of Sorted Indexesp. 127
The Structure of Hashed Indexesp. 136
The Database Buffer Poolp. 148
The Optimizerp. 173
Methods of Retrieving Datap. 173
Choosing a Strategyp. 176
Influencing the Optimizerp. 184
Collecting Additional Statisticsp. 190
Transaction Managementp. 195
Transactionsp. 196
Rdb Lockingp. 197
Table Lockingp. 200
RMU/Show Locksp. 213
Prestarted Transactionsp. 215
Fast Commit Transaction Processingp. 216
Securityp. 221
Using Open VMS Securityp. 221
Security Strategyp. 223
Rdb Securityp. 224
Alternative Security Mechanismsp. 232
Controlling RMU Commandsp. 234
Security Auditingp. 235
Database Integrityp. 239
Data Integrityp. 239
Constraintsp. 240
Using Indexes to Maintain Integrityp. 245
Triggersp. 245
Database Structure Integrityp. 248
Backups and Journalingp. 253
Restorep. 265
Restore by Areap. 270
Recovering a Database Pagep. 270
Changing Database Parameters on Restorep. 271
Run-Unit Journalingp. 272
Open VMS Cluster Failoverp. 272
Distributed Transactionsp. 273
Hot Standbyp. 273
Database Restructuringp. 275
Changing the Metadata Definitionsp. 276
Changing the Physical Creation Parametersp. 286
RMU/Unload and Loadp. 290
Export and Importp. 294
Why Reorganize?p. 294
Tuning and Optimizationp. 295
Understanding the Physical Designp. 296
A Tuning Planp. 304
Tuning Toolsp. 304
The Need to Tunep. 348
Distributing Rdb Databasesp. 349
Remote Database Accessp. 350
Rdb Replication Optionp. 351
Rdb Distributed and Parallel Query Optionsp. 358
Distributed Transaction Managementp. 365
Interoperabilityp. 373
SQL/Servicesp. 373
SQL*Netp. 379
Rdb Transparent Gatewaysp. 381
ODBC Driverp. 383
The Internet and Rdbp. 387
Architecturesp. 389
Getting startedp. 391
Customizing your web applicationp. 395
Database Toolsp. 399
Oracle Tracep. 399
Oracle Expertp. 404
Oracle Toolsp. 408
Application Programmingp. 417
SQL Precompilersp. 419
SQL Module Languagep. 420
Dynamic SQLp. 422
2-Phase Commit Protocolsp. 423
Rdb/NT Workbenchp. 427
The Architecturep. 427
Getting Startedp. 431
Using RMU on NTp. 437
NT Securityp. 438
Oracle Enterprise Manager and Rdbp. 439
Moving the Database to NTp. 442
Other NT Issuesp. 443
Banking Database Definitionp. 445
Indexp. 455
Table of Contents provided by Syndetics. All Rights Reserved.

ISBN: 9781555581862
ISBN-10: 1555581862
Audience: General
Format: Paperback
Language: English
Number Of Pages: 480
Published: 28th September 1999
Publisher: DIGITAL PR
Country of Publication: US
Dimensions (cm): 23.34 x 17.81  x 2.52
Weight (kg): 0.75
Edition Number: 3
Edition Type: Revised