Oracle Essentials [Electronic resources] : Oracle Database 10g, 3rd Edition نسخه متنی

• Table of Contents

• Index

• Reviews

• Reader Reviews

• Errata

• Academic

Oracle Essentials: Oracle Database 10g, 3rd Edition

By
Publisher: O''''ReillyPub Date: February 2004ISBN: 0-596-00585-7Pages: 368

Copyright

Dedication

Preface

Goals of This Book

Audience for This Book

About the Third Edition (Oracle Database 10g)

Structure of This Book

Conventions Used in This Book

How to Contact Us

Acknowledgments

Chapter 1.
Introducing Oracle

Section 1.1.
The Evolution of the Relational Database

Section 1.2.
The Oracle Family

Section 1.3.
Summary of Oracle Features

Section 1.4.
Database Application Development Features

Section 1.5.
Database Connection Features

Section 1.6.
Distributed Database Features

Section 1.7.
Data Movement Features

Section 1.8.
Performance Features

Section 1.9.
Database Management Features

Section 1.10.
Oracle Developer Suite

Section 1.11.
Oracle Lite

Chapter 2.
Oracle Architecture

Section 2.1.
Instances and Databases

Section 2.2.
The Components of a Database

Section 2.3.
The Components of an Instance

Section 2.4.
The Data Dictionary

Chapter 3.
Installing and Running Oracle

Section 3.1.
Installing Oracle

Section 3.2.
Creating a Database

Section 3.3.
Configuring Oracle Net

Section 3.4.
Starting Up the Database

Section 3.5.
Shutting Down the Database

Section 3.6.
Accessing a Database

Section 3.7.
Oracle at Work

Chapter 4.
Data Structures

Section 4.1.
Datatypes

Section 4.2.
Basic Data Structures

Section 4.3.
Additional Data Structures

Section 4.4.
Data Design

Section 4.5.
Constraints

Section 4.6.
Triggers

Section 4.7.
Query Optimization

Section 4.8.
Understanding the Execution Plan

Section 4.9.
SQL Tuning Advisor

Section 4.10.
Data Dictionary Tables

Chapter 5.
Managing Oracle

Section 5.1.
Management and Enterprise Manager

Section 5.2.
Oracle Database 10g Self-Tuning and Management

Section 5.3.
Implementing Security

Section 5.4.
Fragmentation and Reorganization

Section 5.5.
Backup and Recovery

Section 5.6.
Working with Oracle Support

Chapter 6.
Oracle Performance

Section 6.1.
Performance Tuning Basics

Section 6.2.
Oracle and Disk I/O Resources

Section 6.3.
Oracle and Parallelism

Section 6.4.
Oracle and Memory Resources

Section 6.5.
Oracle and CPU Resources

Section 6.6.
Database Resource Manager

Section 6.7.
Monitoring

Section 6.8.
Real Application Clusters and Performance

Chapter 7.
Multiuser Concurrency

Section 7.1.
Basics of Concurrent Access

Section 7.2.
Oracle and Concurrent User Access

Section 7.3.
Oracle''''s Isolation Levels

Section 7.4.
Oracle Concurrency Features

Section 7.5.
How Oracle Handles Locking

Section 7.6.
Concurrent Access and Performance

Section 7.7.
Workspaces

Chapter 8.
Oracle and Transaction Processing

Section 8.1.
OLTP Basics

Section 8.2.
Oracle''''s OLTP Heritage

Section 8.3.
Architectures for OLTP

Section 8.4.
Oracle Features for OLTP

Section 8.5.
High Availability

Section 8.6.
Oracle Advanced Queuing and Streams

Section 8.7.
Object Technologies and Distributed Components

Chapter 9.
Oracle and Data Warehousing

Section 9.1.
Business Intelligence Basics

Section 9.2.
Data Warehouse Design

Section 9.3.
Query Optimization

Section 9.4.
Analytics, OLAP, and Data Mining in the Database

Section 9.5.
Managing the Data Warehouse

Section 9.6.
Other Data Warehouse Software

Section 9.7.
The Metadata Challenge

Section 9.8.
Best Practices

Chapter 10.
Oracle and High Availability

Section 10.1.
What Is High Availability?

Section 10.2.
System Crashes

Section 10.3.
Protecting Against System Crashes

Section 10.4.
Recovering from Disasters

Section 10.5.
Complete Site Failure

Section 10.6.
Data Redundancy Solutions

Chapter 11.
Oracle and Hardware Architecture

Section 11.1.
System Basics

Section 11.2.
Uniprocessor Systems

Section 11.3.
Symmetric Multiprocessing Systems

Section 11.4.
Clusters

Section 11.5.
Massively Parallel Processing Systems

Section 11.6.
Non-Uniform Memory Access Systems

Section 11.7.
Grid Computing

Section 11.8.
Disk Technology

Section 11.9.
Which Platform Deployment Solution?

Chapter 12.
Distributed Databases and Distributed Data

Section 12.1.
Accessing Multiple Databases as a Single Entity

Section 12.2.
Two-Phase Commits

Section 12.3.
Moving Data Between Distributed Systems

Section 12.4.
Advanced Queuing

Section 12.5.
Oracle Streams

Chapter 13.
Extending Oracle Datatypes

Section 13.1.
Object-Oriented Development

Section 13.2.
Extensibility Features and Options

Section 13.3.
Using the Extensibility Framework in Oracle

Chapter 14.
Network Deployment Models

Section 14.1.
The Impact of the Internet

Section 14.2.
The Oracle Database and the Internet

Section 14.3.
Oracle Application Server

Section 14.4.
Grid Computing

Appendix A.
What''''s New in This Book for Oracle Database10g

Section A.1.
Chapter 1, Introducing Oracle

Section A.2.
Chapter 2, Oracle Architecture

Section A.3.
Chapter 3, Installing and Running Oracle

Section A.4.
Chapter 4, Data Structures

Section A.5.
Chapter 5, Managing Oracle

Section A.6.
Chapter 6, Oracle Performance

Section A.7.
Chapter 7, Multiuser Concurrency

Section A.8.
Chapter 8, Oracle and Transaction Processing

Section A.9.
Chapter 9, Oracle and Data Warehousing

Section A.10.
Chapter 10, Oracle and High Availability

Section A.11.
Chapter 11, Oracle and Hardware Architecture

Section A.12.
Chapter 12, Distributed Databases and Distributed Data

Section A.13.
Chapter 13, Extending Oracle Datatypes

Section A.14.
Chapter 14, Network Deployment Models

Appendix B.
Additional Resources

Section B.1.
Web Sites

Section B.2.
Books and Oracle Documentation

Colophon

Index