Rdb

A Comprehensive Guide

By: Lilian Hobbs, Ian Smith, Ken England

Write A Review

Paperback | 30 June 2006 | Edition Number 3

At a Glance

Paperback
480 Pages

Edition Type
Revised

Dimensions(cm)
23.5 x 19.05 x 2.46

Paperback

$241.75

or 4 interest-free payments of $60.44 with

Ships in 10 to 15 business days

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

Shipping

	Standard Shipping	Express Shipping
Metro postcodes:	$9.99	$14.95
Regional postcodes:	$9.99	$14.95
Rural postcodes:	$9.99	$14.95

Orders over $79.00 qualify for free shipping.

How to return your order

At Booktopia, we offer hassle-free returns in accordance with our returns policy. If you wish to return an item, please get in touch with Booktopia Customer Care.

Additional postage charges may be applicable.

Defective items

If there is a problem with any of the items received for your order then the Booktopia Customer Care team is ready to assist you.

For more info please visit our Help Centre.

You Can Find This Book In

Non-Fiction Computing & I.T.Databases Database Software Oracle

This product is categorised by

Non-Fiction Computing & I.T.Databases Database Software Oracle

Foreword	p. xi
Preface	p. xii
Components	p. 1
What is Oracle Rdb?	p. 1
Components of Rdb	p. 1
Key Areas of Rdb	p. 7
Documentation	p. 16
Data Definition	p. 19
Basic Relational Terms	p. 20
Creating a Single-File Rdb Database	p. 22
Creating Multifile Databases	p. 31
Deleting Database Metadata	p. 31
The Multischema Database	p. 33
The Banking Database	p. 37
Data Manipulation	p. 45
SQL Data Manipulation Options	p. 45
SQL	p. 46
Row Operations	p. 60
MultiStatement Procedures	p. 66
Procedures and Functions	p. 76
Sequence Numbers	p. 81
Temporary Tables	p. 83
Rdb SQL Worksheet	p. 84
What's Next for SQL?	p. 86
Storage Structures	p. 89
Why Use Multifile Databases?	p. 89
Creating Multifile Databases	p. 91
Creating Storage Areas	p. 92
Displaying Database Pages	p. 102
The Database Page Structure	p. 103
Space Area Management (SPAM) Pages	p. 109
Snapshot Files	p. 116
Read-Only Areas	p. 120
Write Once Read Many (WORM) Areas	p. 120
Rdb Storage Manager	p. 121
Table Access	p. 125
Indexed Access	p. 125
The Structure of Sorted Indexes	p. 127
The Structure of Hashed Indexes	p. 136
The Database Buffer Pool	p. 148
The Optimizer	p. 173
Methods of Retrieving Data	p. 173
Choosing a Strategy	p. 176
Influencing the Optimizer	p. 184
Collecting Additional Statistics	p. 190
Transaction Management	p. 195
Transactions	p. 196
Rdb Locking	p. 197
Table Locking	p. 200
RMU/Show Locks	p. 213
Prestarted Transactions	p. 215
Fast Commit Transaction Processing	p. 216
Security	p. 221
Using Open VMS Security	p. 221
Security Strategy	p. 223
Rdb Security	p. 224
Alternative Security Mechanisms	p. 232
Controlling RMU Commands	p. 234
Security Auditing	p. 235
Database Integrity	p. 239
Data Integrity	p. 239
Constraints	p. 240
Using Indexes to Maintain Integrity	p. 245
Triggers	p. 245
Database Structure Integrity	p. 248
Backups and Journaling	p. 253
Restore	p. 265
Restore by Area	p. 270
Recovering a Database Page	p. 270
Changing Database Parameters on Restore	p. 271
Run-Unit Journaling	p. 272
Open VMS Cluster Failover	p. 272
Distributed Transactions	p. 273
Hot Standby	p. 273
Database Restructuring	p. 275
Changing the Metadata Definitions	p. 276
Changing the Physical Creation Parameters	p. 286
RMU/Unload and Load	p. 290
Export and Import	p. 294
Why Reorganize?	p. 294
Tuning and Optimization	p. 295
Understanding the Physical Design	p. 296
A Tuning Plan	p. 304
Tuning Tools	p. 304
The Need to Tune	p. 348
Distributing Rdb Databases	p. 349
Remote Database Access	p. 350
Rdb Replication Option	p. 351
Rdb Distributed and Parallel Query Options	p. 358
Distributed Transaction Management	p. 365
Interoperability	p. 373
SQL/Services	p. 373
SQL*Net	p. 379
Rdb Transparent Gateways	p. 381
ODBC Driver	p. 383
The Internet and Rdb	p. 387
Architectures	p. 389
Getting started	p. 391
Customizing your web application	p. 395
Database Tools	p. 399
Oracle Trace	p. 399
Oracle Expert	p. 404
Oracle Tools	p. 408
Application Programming	p. 417
SQL Precompilers	p. 419
SQL Module Language	p. 420
Dynamic SQL	p. 422
2-Phase Commit Protocols	p. 423
Rdb/NT Workbench	p. 427
The Architecture	p. 427
Getting Started	p. 431
Using RMU on NT	p. 437
NT Security	p. 438
Oracle Enterprise Manager and Rdb	p. 439
Moving the Database to NT	p. 442
Other NT Issues	p. 443
Banking Database Definition	p. 445
Index	p. 455
Table of Contents provided by Syndetics. All Rights Reserved.

Rdb

A Comprehensive Guide

At a Glance

Paperback

Shipping

How to return your order

Defective items

You Can Find This Book In

More in Databases

Microsoft Power BI For Dummies

For Dummies (Computer/Tech)

Designing Data-Intensive Applications

Big Ideas Behind Reliable, Scalable, and Maintainable Systems

SPSS Survival Manual

7th Edition - A step by step guide to data analysis using IBM SPSS

Python All-in-One For Dummies

3rd Edition

Designing Data-Intensive Applications

The Big Ideas Behind Reliable, Scalable, and Maintainable Systems

Database Systems

A Practical Approach

Tools and Applications of Data Mining

Big Data Analytics

A Practical Guide

The Data Science and Psychology

Data Mining

Concepts, Techniques and Applications

Social Research Methods

4th Edition

Mindf*ck

Inside Cambridge Analytica's Plot to Break the World

The Art of Explanation

How to Communicate with Clarity and Confidence

Database Systems 6ed

A Practical Approach to Design, Implementation, and Management, Global Edition

Hands-On Programming with R

Write Your Own Functions and Simulations

Building a Scalable Data Warehouse with Data Vault 2.0

Fundamentals of Database Systems, Global Edition

7th edition

SQL Cookbook

Query Solutions and Techniques for All SQL Users 2nd Edition

Fundamentals of Data Engineering

Plan and Build Robust Data Systems

R for Data Science

Import, Tidy, Transform, Visualize, and Model Data

Data Science for Business

What You Need to Know About Data Mining and Data-Analytic Thinking

Modern Data Analytics in Excel

Using Power Query, Power Pivot and More for Enhanced Data Analytics

The Data Hero Playbook

Developing Your Data Leadership Superpowers

Learning Data Science

Data Wrangling, Exploration, Visualization, and Modeling with Python

This product is categorised by