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

Sitemap

Main Page

Table of content

Copyright

Dedication

Preface

Goals of This Book

Audience for This Book

About the Third Edition (Oracle Database 10''g'')

Structure of This Book

Conventions Used in This Book

How to Contact Us

Acknowledgments

Chapter 1. Introducing Oracle

1.1 The Evolution of the Relational Database

1.2 The Oracle Family

1.3 Summary of Oracle Features

1.4 Database Application Development Features

1.5 Database Connection Features

1.6 Distributed Database Features

1.7 Data Movement Features

1.8 Performance Features

1.9 Database Management Features

1.10 Oracle Developer Suite

1.11 Oracle Lite

Chapter 2. Oracle Architecture

2.1 Instances and Databases

2.2 The Components of a Database

2.3 The Components of an Instance

2.4 The Data Dictionary

Chapter 3. Installing and Running Oracle

3.1 Installing Oracle

3.2 Creating a Database

3.3 Configuring Oracle Net

3.4 Starting Up the Database

3.5 Shutting Down the Database

3.6 Accessing a Database

3.7 Oracle at Work

Chapter 4. Data Structures

4.1 Datatypes

4.2 Basic Data Structures

4.3 Additional Data Structures

4.4 Data Design

4.5 Constraints

4.6 Triggers

4.7 Query Optimization

4.8 Understanding the Execution Plan

4.9 SQL Tuning Advisor

4.10 Data Dictionary Tables

Chapter 5. Managing Oracle

5.1 Management and Enterprise Manager

5.2 Oracle Database 10g Self-Tuning and Management

5.3 Implementing Security

5.4 Fragmentation and Reorganization

5.5 Backup and Recovery

5.6 Working with Oracle Support

Chapter 6. Oracle Performance

6.1 Performance Tuning Basics

6.2 Oracle and Disk I/O Resources

6.3 Oracle and Parallelism

6.4 Oracle and Memory Resources

6.5 Oracle and CPU Resources

6.6 Database Resource Manager

6.7 Monitoring

6.8 Real Application Clusters and Performance

Chapter 7. Multiuser Concurrency

7.1 Basics of Concurrent Access

7.2 Oracle and Concurrent User Access

7.3 Oracle''s Isolation Levels

7.4 Oracle Concurrency Features

7.5 How Oracle Handles Locking

7.6 Concurrent Access and Performance

7.7 Workspaces

Chapter 8. Oracle and Transaction Processing

8.1 OLTP Basics

8.2 Oracle''s OLTP Heritage

8.3 Architectures for OLTP

8.4 Oracle Features for OLTP

8.5 High Availability

8.6 Oracle Advanced Queuing and Streams

8.7 Object Technologies and Distributed Components

Chapter 9. Oracle and Data Warehousing

9.1 Business Intelligence Basics

9.2 Data Warehouse Design

9.3 Query Optimization

9.4 Analytics, OLAP, and Data Mining in the Database

9.5 Managing the Data Warehouse

9.6 Other Data Warehouse Software

9.7 The Metadata Challenge

9.8 Best Practices

Chapter 10. Oracle and High Availability

10.1 What Is High Availability?

10.2 System Crashes

10.3 Protecting Against System Crashes

10.4 Recovering from Disasters

10.5 Complete Site Failure

10.6 Data Redundancy Solutions

Chapter 11. Oracle and Hardware Architecture

11.1 System Basics

11.2 Uniprocessor Systems

11.3 Symmetric Multiprocessing Systems

11.4 Clusters

11.5 Massively Parallel Processing Systems

11.6 Non-Uniform Memory Access Systems

11.7 Grid Computing

11.8 Disk Technology

11.9 Which Platform Deployment Solution?

Chapter 12. Distributed Databases and Distributed Data

12.1 Accessing Multiple Databases as a Single Entity

12.2 Two-Phase Commits

12.3 Moving Data Between Distributed Systems

12.4 Advanced Queuing

12.5 Oracle Streams

Chapter 13. Extending Oracle Datatypes

13.1 Object-Oriented Development

13.2 Extensibility Features and Options

13.3 Using the Extensibility Framework in Oracle

Chapter 14. Network Deployment Models

14.1 The Impact of the Internet

14.2 The Oracle Database and the Internet

14.3 Oracle Application Server

14.4 Grid Computing

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

A.1 Chapter 1 , Introducing Oracle

A.2 Chapter 2 , Oracle Architecture

A.3 Chapter 3 , Installing and Running Oracle

A.4 Chapter 4 , Data Structures

A.5 Chapter 5 , Managing Oracle

A.6 Chapter 6 , Oracle Performance

A.7 Chapter 7 , Multiuser Concurrency

A.8 Chapter 8 , Oracle and Transaction Processing

A.9 Chapter 9 , Oracle and Data Warehousing

A.10 Chapter 10 , Oracle and High Availability

A.11 Chapter 11 , Oracle and Hardware Architecture

A.12 Chapter 12 , Distributed Databases and Distributed Data

A.13 Chapter 13 , Extending Oracle Datatypes

A.14 Chapter 14 , Network Deployment Models

Appendix B. Additional Resources

B.1 Web Sites

B.2 Books and Oracle Documentation

Colophon

Index

Index SYMBOL

Index A

Index B

Index C

Index D

Index E

Index F

Index G

Index H

Index I

Index J

Index K

Index L

Index M

Index N

Index O

Index P

Index Q

Index R

Index S

Index T

Index U

Index V

Index W

Index X