Oracle8 Architecture

Oracle8 Architecture

by Steven M. Bobrowski


$29.23 $34.99 Save 16% Current price is $29.23, Original price is $34.99. You Save 16%.

Product Details

ISBN-13: 9780078822742
Publisher: McGraw-Hill Companies, The
Publication date: 09/28/1997
Pages: 343
Product dimensions: 7.38(w) x 9.13(h) x 0.92(d)

Table of Contents

Part I: Introduction to Oracle.1: Introducing Oacle8.Information Management.Databases.Database Management Systems.Oracle8, Building on Oracle.Oracle8 and High-End Database Environments.Partitioned Tables and Indexes.Management of Large User Populations.Advanced Queueing.Parallel Processing Enhancements.Oracle8 and Oracle's Network Computing Architecture (NCA).Oracle8, the Object-Relational DBMs.Sedona, Oracle's New Application Development Environment.Oracle8 Database Management and Security.Backup and Recovery.Password Management.Oracle8 and Distributed Databases.Replication Enhancements.Distributed Security Domains.Heterogeneous Data Access.Onward.Part II: Oracle8 Fundamentals.2: Basic Relational Database Structures.Schemas: Organizing Database Objects.The Correlation of Schemas and Database User Accounts.The Data Dictionary: A Unique Schema.Database Tables.Columns and Datatypes.Data Integrity and Integrity Constraints.Views: A Different Way of Looking at Table Data.Read-Only Views.Updated Views.Other Types of Views.Indexes: Improving the Performance of Table Access.B-Tree Indexes.Bitmap Indexes.Index-Organized Tables.Other Indexing Options.Data Clusters: A Unique Way of Storing Table Data.Indexed Data Clusters.Hash Clusters.Sequences: Efficient Generation of Unique Values.Synonyms: Objects by a Different Name.An Example Application Schema.3: Using SQL and Transactions.SQL--Communicating with Oracle8.Queries.DML Statements.DDL Statements.DCL Statements.Application Portability and ANSI/ISO SQL Standard.The Optimizer: Executing SQL Statements.Optimizer Statistics.Optimizer Choices.Hints and Optimizer Control.Transactions: Getting Work Done.All or Nothing.Types of Transactions.Designing Transactions.4: Programming the Server.PL/SQL: Adding the Power of Procedural Flow to SQL.Blocks.Program Comments.Program Declarations.Program Functionality.Program Exception Handling.Types of PL/SQL Programs.Anonymous PL/SQL Programs.Stored Procedures and Functions.Packages.Database Triggers.External Procedures.5: Extending Oracle with Objects.Oriented Toward Objects.Oracle8 and Object-Oriented Database Terms and Concepts.How Will You Use Objects? Do I Have to Use Object Types? Working with Object Types.Designing Object Types.Creating Object Types.Examples of Creating and Using Object Types.More About Methods.Objects and Views.Object Views of Object Tables.Views of Relational Tables.Views and INSTEAD OF Triggers.Oracle8 Database Structures.6: Controlling Database Access.User Management.User Authentication.A User's Default Tablespace.A User's Temporary Tablespace.Locked and Unlocked User Accounts.Privilege Management.Types of Database Privileges.Granting and Revoking Privileges.Privilege Management with Roles.Resource Limitation.Tablespace Quotas.Resource Limit Profiles.Database Auditing.Selective Auditing.Audit Records and the Audit Trail.Setting Audit Options.What Is Trusted Oracle? 7: Database Storage.Tablespaces.The SYSTEM Tablespace.Other Tablespaces.Online and Offline Tablespaces.Permanent and Temporary Tablespaces.Read-Only and Read-Write Tablespaces.More About Data Files.A Tablespace's Number of Data Files.Use of Data File Space.Data File Sizes.Data File Corruption.Online and Offline Data Files.Control Files.Mirrored Control Files.Segments, Extents, and Data Blocks.Data and Index Segments.Temporary Segments.Temporary Tablespaces.Rollback Segments.How Oracle Writes to a Rollback Segment.The SYSTEM Rollback Segments.Multiple Rollback Segments.Online and Offline Rollback Segments.Public and Private Rollback Segments.Deferred Rollback Segments.Other Functions of Rollback Segments.Data Blocks.Data Block Allocation.Data Block Availability and Free Lists.Row Chaining and Data Block Size.Object Storage Settings.Tablespace Placement.Extent Settings.Data Block Settings.Setting Defaults for Object Storage.Unique Data Storage for Multimedia Data.More About LOB Locators.Data Partitioning.Partitioned Tables.Placing Rows into Data Partitions.Using MAXVALUE.Partitioned Indexes.Partitioned Index Options.Partition-Extended Table Names.Partition Management.Part IV: Oracle8 Software Architecture.8: Oracle Software Structures.Database Servers and Database Instances.Server Startup and Shutdown.Server Connections.Oracle8 Processes.Server-Side Background Processes.Process Options to Support User Connections.Oracle-Specific Process Architectures.Memory Areas and Data Caching.Cache Hits, Misses, and Reloads.Oracle8 Memory Areas.Buffer Cache.The Shared Pool.The System Global Area (SGA).Program Global Areas (PGA).Soft Areas.Oracle8 Networking and Net8.Transparent Network Substrate (TNS) and Other Net8 Layers.TNS Connections, Initiators, and Destinations.The TNS Listener.TNS Addressing.Multiple Network and MultiProtocol Interchanges.Net8 Configuration.9: Shared Database Access Mechanisms.The Three Cs: Contention, Concurrency, and Consistency.Oracle's Concurrency and Consistency Mechanisms.Transactions and Interference.Isolation Levels.Oracle's Locking Mechanisms.Automatic and Explicit Locking.Lock Levels.DML Locks.DDL Locks.Internal Latches.Multiversioning.System Change Number.Non-Blocking Queries.Multiversioning and Transaction-Level Read Consistency.Snapshot Too Old Errors.Remember, It's All Automatic.10: Database Protection.Different Types of Problems.System and Server Crashes.File Loss from User Error, Corruption, or Disk Failure.Site Disaster.Overview of Database Protection Mechanisms.An Example Backup and Recovery Scenario.Introduction to Recovery Manager.The Transaction Log or Redo Log.Transaction Log Structure.Checkpoints.Protect the Database Control File.Database Backups.Whole Database Backups.Tablespace Backups.Recovery Manager Backup Concepts.Logical Database Backups.Database Recovery.Roll-Forward and Roll-Back Recovery Stages.Crash Recovery.Media Recovery: Recovery from File Damage.Complete Recovery.Incomplete Recovery.Recovery Optimizations.What About Damage to Log Groups and the Control File? High-Availability Options.Standby Databases.Failover Sites and Data Replication.Part V: Specialized Oracle Environments.11: Distributing and Replicating Data.Distributed Database Architecture.Cooperation and Autonomy.An Extension of Client/Server.Networks and Distributed Database Systems.Database Services and Naming in a Distributed Database.Database Links.Heterogeneous Distributed Databases.Applications and Distributed Databases.Remote Queries.Distributed Queries.Remote Updates.Distributed Updates.Remote Procedure Calls.Remote Transactions.Distributed Transactions.Distributed Database Transparency.Unique Distributed Database Security Issues.Global Users and Roles.Introduction to Data Replication.Uses for Data Replication.Types of Data Replication.Basic Replication and Read-Only Snapshots.Complex Snapshots.Snapshot Data Storage.Snapshot Refreshes.Advanced Replication Environments.Multimaster Replication.Snapshot Sites and Updated Snapshots.Comparing Advanced Replication Options.Advanced Replication System Architecture.Replication Objects and Replication Groups.Master Sites and Snapshot Sites.Replication Catalogs.Oracle's Replication Management API.Oracle's Advanced Replication Software Mechanisms.Row-Level Replication.Asynchronous (Store-and-Forward) Data Propagation.An Example.Replication Conflicts in Advanced Replication Systems.Types of Replication Conflicts.Conflict Avoidance.Conflict Detection and Resolution.Other Advanced Replication Options.Procedural Replication.Synchronous (Real-Time) Data Propagation.12: Oracle's Parallel Processing Options.Introduction to Parallel Processing.Unprocessor versus Multiprocessor Computers.Shared Memory Systems.Shared Disk Systems.Shared Nothing Systems.Processing SQL in Parallel.Serial Processing.Parallel SQL Processing.Parallel SQL Processing Architecture.Data Partitioning and Parallel SQL Processing.Oracle's Parallel Server Option: Multiple Instances for High-Availability.What is Parallel Database Access? Parallel Server Architecture.Parallel Server Database Administration.Automatic Instance Recovery.Transparent Application Fallover.Database Recovery from Media Failure.Unique Database Features for Parallel Server Configurations.Sequence Generation.Data Block Free Lists.Instance-Specific Extent Allocation.Private Rollback Segments.Reverse Key Indexes.Mixing Parallel SQL and Parallel Server Processing.

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews

Oracle8 Architecture 3 out of 5 based on 0 ratings. 1 reviews.
Guest More than 1 year ago
Although I gained some interesting knowledge from this book, it isn't for the beginner! LOADS of info, but if your new to Oracle have plenty of reference books to rely on. Also, I felt the author wasn't clear on some of the relatively more difficult technical concepts, especially PL/SQL and object technology.