Temporarily Out of Stock Online
Understand,Plan,and Migrate to Oracle's Revolutionary Database with this Exclusive Insider's Guide It's here! A reliable source of information on Oracle's revolutionary new database system,Oracle8. Nowhere else will you find an accurate account of Oracle8 as richly detailed and revealing as the one you'll read in Oracle8 Architecture.
Working directly with Oracle's Oracle8 development team,Steve Bobrowski has unwrapped the secrets of this next-generation server any its highly advanced object-relational architecture. In this officially endorsed book,he shares his unique perspective of Oracle8's architecture and provides guidance you won't find anywhere else. What's more,every page has been technically reviewed and approved by top Oracle experts to ensure the highest quality of information.
Discover revealing insider information on Oracle8 as you:
- Understand how Oracle8 fits into the world of serious data management applications
- Explore the software architecture of Oracle8
- Come to understand both the concepts and the technical details you'll need to know to successfully work with Oracle8
- Gain solid,intelligent advice not speculation from the author who was there during Oracle8's development
Only Oracle8 Architecture puts you on the inside track to understanding Oracle8.
|Publisher:||McGraw-Hill Companies, The|
|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.
Most Helpful Customer Reviews
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.