| |
| |
| Foreword | |
| |
| |
| Preface | |
| |
| |
| |
| Components | |
| |
| |
| |
| What is Oracle Rdb? | |
| |
| |
| |
| Components of Rdb | |
| |
| |
| |
| Key Areas of Rdb | |
| |
| |
| |
| Documentation | |
| |
| |
| |
| Data Definition | |
| |
| |
| |
| Basic Relational Terms | |
| |
| |
| |
| Creating a Single-File Rdb Database | |
| |
| |
| |
| Creating Multifile Databases | |
| |
| |
| |
| Deleting Database Metadata | |
| |
| |
| |
| The Multischema Database | |
| |
| |
| |
| The Banking Database | |
| |
| |
| |
| Data Manipulation | |
| |
| |
| |
| SQL Data Manipulation Options | |
| |
| |
| |
| SQL | |
| |
| |
| |
| Row Operations | |
| |
| |
| |
| MultiStatement Procedures | |
| |
| |
| |
| Procedures and Functions | |
| |
| |
| |
| Sequence Numbers | |
| |
| |
| |
| Temporary Tables | |
| |
| |
| |
| Rdb SQL Worksheet | |
| |
| |
| |
| What's Next for SQL? | |
| |
| |
| |
| Storage Structures | |
| |
| |
| |
| Why Use Multifile Databases? | |
| |
| |
| |
| Creating Multifile Databases | |
| |
| |
| |
| Creating Storage Areas | |
| |
| |
| |
| Displaying Database Pages | |
| |
| |
| |
| The Database Page Structure | |
| |
| |
| |
| Space Area Management (SPAM) Pages | |
| |
| |
| |
| Snapshot Files | |
| |
| |
| |
| Read-Only Areas | |
| |
| |
| |
| Write Once Read Many (WORM) Areas | |
| |
| |
| |
| Rdb Storage Manager | |
| |
| |
| |
| Table Access | |
| |
| |
| |
| Indexed Access | |
| |
| |
| |
| The Structure of Sorted Indexes | |
| |
| |
| |
| The Structure of Hashed Indexes | |
| |
| |
| |
| The Database Buffer Pool | |
| |
| |
| |
| The Optimizer | |
| |
| |
| |
| Methods of Retrieving Data | |
| |
| |
| |
| Choosing a Strategy | |
| |
| |
| |
| Influencing the Optimizer | |
| |
| |
| |
| Collecting Additional Statistics | |
| |
| |
| |
| Transaction Management | |
| |
| |
| |
| Transactions | |
| |
| |
| |
| Rdb Locking | |
| |
| |
| |
| Table Locking | |
| |
| |
| |
| RMU/Show Locks | |
| |
| |
| |
| Prestarted Transactions | |
| |
| |
| |
| Fast Commit Transaction Processing | |
| |
| |
| |
| Security | |
| |
| |
| |
| Using Open VMS Security | |
| |
| |
| |
| Security Strategy | |
| |
| |
| |
| Rdb Security | |
| |
| |
| |
| Alternative Security Mechanisms | |
| |
| |
| |
| Controlling RMU Commands | |
| |
| |
| |
| Security Auditing | |
| |
| |
| |
| Database Integrity | |
| |
| |
| |
| Data Integrity | |
| |
| |
| |
| Constraints | |
| |
| |
| |
| Using Indexes to Maintain Integrity | |
| |
| |
| |
| Triggers | |
| |
| |
| |
| Database Structure Integrity | |
| |
| |
| |
| Backups and Journaling | |
| |
| |
| |
| Restore | |
| |
| |
| |
| Restore by Area | |
| |
| |
| |
| Recovering a Database Page | |
| |
| |
| |
| Changing Database Parameters on Restore | |
| |
| |
| |
| Run-Unit Journaling | |
| |
| |
| |
| Open VMS Cluster Failover | |
| |
| |
| |
| Distributed Transactions | |
| |
| |
| |
| Hot Standby | |
| |
| |
| |
| Database Restructuring | |
| |
| |
| |
| Changing the Metadata Definitions | |
| |
| |
| |
| Changing the Physical Creation Parameters | |
| |
| |
| |
| RMU/Unload and Load | |
| |
| |
| |
| Export and Import | |
| |
| |
| |
| Why Reorganize? | |
| |
| |
| |
| Tuning and Optimization | |
| |
| |
| |
| Understanding the Physical Design | |
| |
| |
| |
| A Tuning Plan | |
| |
| |
| |
| Tuning Tools | |
| |
| |
| |
| The Need to Tune | |
| |
| |
| |
| Distributing Rdb Databases | |
| |
| |
| |
| Remote Database Access | |
| |
| |
| |
| Rdb Replication Option | |
| |
| |
| |
| Rdb Distributed and Parallel Query Options | |
| |
| |
| |
| Distributed Transaction Management | |
| |
| |
| |
| Interoperability | |
| |
| |
| |
| SQL/Services | |
| |
| |
| |
| SQL*Net | |
| |
| |
| |
| Rdb Transparent Gateways | |
| |
| |
| |
| ODBC Driver | |
| |
| |
| |
| The Internet and Rdb | |
| |
| |
| |
| Architectures | |
| |
| |
| |
| Getting started | |
| |
| |
| |
| Customizing your web application | |
| |
| |
| |
| Database Tools | |
| |
| |
| |
| Oracle Trace | |
| |
| |
| |
| Oracle Expert | |
| |
| |
| |
| Oracle Tools | |
| |
| |
| |
| Application Programming | |
| |
| |
| |
| SQL Precompilers | |
| |
| |
| |
| SQL Module Language | |
| |
| |
| |
| Dynamic SQL | |
| |
| |
| |
| 2-Phase Commit Protocols | |
| |
| |
| |
| Rdb/NT Workbench | |
| |
| |
| |
| The Architecture | |
| |
| |
| |
| Getting Started | |
| |
| |
| |
| Using RMU on NT | |
| |
| |
| |
| NT Security | |
| |
| |
| |
| Oracle Enterprise Manager and Rdb | |
| |
| |
| |
| Moving the Database to NT | |
| |
| |
| |
| Other NT Issues | |
| |
| |
| |
| Banking Database Definition | |
| |
| |
| Index | |