Oracle Essentials
Oracle Database 11g
4th Edition
Published on 11. December 2007
Book
406 pages
978-0-596-51454-9 (ISBN)
Description
Oracle is an enormous system, with myriad technologies, options, and releases. Most users-even experienced developers and database administrators-find it difficult to get a handle on the full scope of the Oracle database. And, as each new Oracle version is released, users find themselves under increasing pressure to learn about a whole range of new technologies. The latest challenge is Oracle Database 11g.
This book distills an enormous amount of information about Oracle into a compact, easy-to-read volume filled with focused text, illustrations, and helpful hints. It contains chapters on:
* Oracle products, options, data structures, and overall architecture for Oracle Database 11g, as well as earlier releases (Oracle Database 10g, Oracle9i, and Oracle8i)
* Installing, running, managing, monitoring, networking, and tuning Oracle, including Enterprise Manager (EM) and Oracle's self-tuning and management capabilities; and using Oracle security, auditing, and compliance (a new chapter in this edition)
* Multiuser concurrency, data warehouses, distributed databases, online transaction processing (OLTP), high availability, and hardware architectures (e.g., SMP, clusters, NUMA, and grid computing)
* Features beyond the Oracle database: Oracle Application Express, Fusion Middleware (including Oracle Application Server), and database SOA support as a Web services provider
The latest Oracle Database 11g features: query result set caching, Automatic Memory Management, the Real Application Testing, Advanced Compression, Total Recall, and Active Data Guard Option Options, changes to the OLAP Option (transparently accessed and managed as materialized views), the Flashback transaction command, transparent data encryption, the Support Workbench (and diagnosability infrastructure), and partitioning enhancements (including interval and new composite types)
For new Oracle users, DBAs, developers, and managers, Oracle Essentials provides an invaluable, all-in-one introduction to the full range of Oracle features and technologies, including the just-released Oracle Database 11g features. But even if you already have a library full of Oracle documentation, you'll find that this compact book is the one you turn to, again and again, as your one-stop, truly essential reference.
"Oracle Essentials gives a clear explanation of the key database concepts and architecture underlying the Oracle database. It's a great reference for anyone doing development or management of Oracle databases."
--Andrew Mendelsohn, Senior Vice President, Database Server Technologies, Oracle Corporation
This book distills an enormous amount of information about Oracle into a compact, easy-to-read volume filled with focused text, illustrations, and helpful hints. It contains chapters on:
* Oracle products, options, data structures, and overall architecture for Oracle Database 11g, as well as earlier releases (Oracle Database 10g, Oracle9i, and Oracle8i)
* Installing, running, managing, monitoring, networking, and tuning Oracle, including Enterprise Manager (EM) and Oracle's self-tuning and management capabilities; and using Oracle security, auditing, and compliance (a new chapter in this edition)
* Multiuser concurrency, data warehouses, distributed databases, online transaction processing (OLTP), high availability, and hardware architectures (e.g., SMP, clusters, NUMA, and grid computing)
* Features beyond the Oracle database: Oracle Application Express, Fusion Middleware (including Oracle Application Server), and database SOA support as a Web services provider
The latest Oracle Database 11g features: query result set caching, Automatic Memory Management, the Real Application Testing, Advanced Compression, Total Recall, and Active Data Guard Option Options, changes to the OLAP Option (transparently accessed and managed as materialized views), the Flashback transaction command, transparent data encryption, the Support Workbench (and diagnosability infrastructure), and partitioning enhancements (including interval and new composite types)
For new Oracle users, DBAs, developers, and managers, Oracle Essentials provides an invaluable, all-in-one introduction to the full range of Oracle features and technologies, including the just-released Oracle Database 11g features. But even if you already have a library full of Oracle documentation, you'll find that this compact book is the one you turn to, again and again, as your one-stop, truly essential reference.
"Oracle Essentials gives a clear explanation of the key database concepts and architecture underlying the Oracle database. It's a great reference for anyone doing development or management of Oracle databases."
--Andrew Mendelsohn, Senior Vice President, Database Server Technologies, Oracle Corporation
More details
Language
English
Place of publication
Sebastopol
United States
Target group
Professional and scholarly
Edition type
Revised edition
Product notice
Paperback (trade)
Illustrations
1, black & white illustrations
Dimensions
Height: 233 mm
Width: 178 mm
Thickness: 21 mm
Weight
648 gr
ISBN-13
978-0-596-51454-9 (9780596514549)
Schweitzer Classification
Other editions
Additional editions
E-Book
11/2007
1st Edition
O'Reilly
€33.99
Available for download
E-Book
11/2007
1st Edition
O'Reilly
€31.49
Available for download
Previous edition
Rick Greenwald | Robert Stackowiak | Jonathan Stern
Oracle Essentials, 3rd Edition: Oracle 10g
Oracle Database 10g
Book
03/2004
3rd Edition
O'Reilly
€32.00
Article exhausted; check for reprint
Persons
Rick Greenwald has been active in the world of computer software for nearly two decades, with stints at Data General, Cognos, and Gupta. Currently an analyst with Oracle Corporation, he's published six books and several articles on a variety of technical topics, and has spoken at conferences and training sessions across six continents.Robert Stackowiak is Senior Director of E-Business Intelligence for Oracle Corporation's Enterprise Technology Center. He works with Oracle's largest customers in North America, providing insight into the company's products and data warehousing strategy. In addition, he frequently assists Oracle Corporate in developing product strategy and training. Articles written by Bob have appeared in publications including The Journal of Data Warehousing, Informix Tech Notes, and AIXcellence Magazine.Jonathan Stern has more than 13 years of IT experience, including senior positions in consulting, systems architecture, and technical sales. He has authored papers and presented at internal and external conferences on topics such as scaling with Oracle's dynamic parallelism and the role of reorganizing segments in an Oracle database. He is the Technical Director at Ariba, Inc., the leading vendor of value chain solutions for electronic commerce.
Content
Inhaltsverzeichnis
Preface
1. Introducing Oracle
The Evolution of the Relational Database
The Oracle Database Family
Summary of Oracle Database Features
Database Application Development Features
Database Connection Features
Distributed Database Features
Data Movement Features
Database Performance Features
Database Management Features
Database Security Features
Oracle Development Tools
Embedded Databases
2. Oracle Architecture
Databases and Instances
Deploying Physical Components
Instance Memory and Processes
The Data Dictionary
3. Installing and Running Oracle
Installing Oracle
Creating a Database
Configuring Oracle Net
Starting Up the Database
Shutting Down the Database
Accessing a Database
Oracle at Work
4. Oracle Data Structures
Datatypes
Basic Data Structures
Additional Data Structures
Extended Logic for Data
Data Design
Constraints
Triggers
Query Optimization
Understanding the Execution Plan
SQL Advisors
Data Dictionary Tables
5. Managing Oracle
Manageability Features
Oracle Enterprise Manager
Fragmentation and Reorganization
Backup and Recovery
Working with Oracle Support
6. Oracle Security, Auditing, and Compliance
Security
Auditing
Compliance
7. Oracle Performance
Performance Tuning Basics
Oracle and Disk I/O Resources
Oracle and Parallelism
Oracle and Memory Resources
Oracle and CPU Resources
Database Resource Manager
8. Oracle Multiuser Concurrency
Basics of Concurrent Access
Oracle and Concurrent User Access
Oracle's Isolation Levels
Oracle Concurrency Features
How Oracle Handles Locking
Concurrent Access and Performance
Workspaces
9. Oracle and Transaction Processing
OLTP Basics
Oracle's OLTP Heritage
Architectures for OLTP
Oracle Features for OLTP
High Availability
Oracle Streams and Advanced Queuing
Object Technologies and Distributed Components
10. Oracle Data Warehousing and Business Intelligence
Business Intelligence Basics
Data Warehouse Design
Query Optimization
Analytics, OLAP, and Data Mining in the Database
Managing the Data Warehouse
Other Software for the Data Warehouse
The Metadata Challenge
Best Practices
11. Oracle and High Availability
What Is High Availability?
System Failure
Protecting Against System Failure
Recovering from Failures
Complete Site Failure
Data Redundancy Solutions
Rolling Upgrades
12. Oracle and Hardware Architecture
System Basics
Uniprocessor Systems
Symmetric Multiprocessing Systems
Clusters
Non-Uniform Memory Access Systems
Grid Computing
Disk and Storage Technology
Which Platform Deployment Solution?
13. Oracle Distributed Databases and Distributed Data
Accessing Multiple Databases As a Single Entity
Moving Data Between Distributed Systems
14. Oracle Extended Datatypes
Object-Oriented Development
Extensibility Features and Options
Using the Extensibility Framework in Oracle
15. Beyond the Oracle Database
Application Express
Oracle Fusion Middleware
Oracle SOA Suite
A. What's New in This Book for Oracle Database 11g
B. Additional Resources
Index
Preface
1. Introducing Oracle
The Evolution of the Relational Database
The Oracle Database Family
Summary of Oracle Database Features
Database Application Development Features
Database Connection Features
Distributed Database Features
Data Movement Features
Database Performance Features
Database Management Features
Database Security Features
Oracle Development Tools
Embedded Databases
2. Oracle Architecture
Databases and Instances
Deploying Physical Components
Instance Memory and Processes
The Data Dictionary
3. Installing and Running Oracle
Installing Oracle
Creating a Database
Configuring Oracle Net
Starting Up the Database
Shutting Down the Database
Accessing a Database
Oracle at Work
4. Oracle Data Structures
Datatypes
Basic Data Structures
Additional Data Structures
Extended Logic for Data
Data Design
Constraints
Triggers
Query Optimization
Understanding the Execution Plan
SQL Advisors
Data Dictionary Tables
5. Managing Oracle
Manageability Features
Oracle Enterprise Manager
Fragmentation and Reorganization
Backup and Recovery
Working with Oracle Support
6. Oracle Security, Auditing, and Compliance
Security
Auditing
Compliance
7. Oracle Performance
Performance Tuning Basics
Oracle and Disk I/O Resources
Oracle and Parallelism
Oracle and Memory Resources
Oracle and CPU Resources
Database Resource Manager
8. Oracle Multiuser Concurrency
Basics of Concurrent Access
Oracle and Concurrent User Access
Oracle's Isolation Levels
Oracle Concurrency Features
How Oracle Handles Locking
Concurrent Access and Performance
Workspaces
9. Oracle and Transaction Processing
OLTP Basics
Oracle's OLTP Heritage
Architectures for OLTP
Oracle Features for OLTP
High Availability
Oracle Streams and Advanced Queuing
Object Technologies and Distributed Components
10. Oracle Data Warehousing and Business Intelligence
Business Intelligence Basics
Data Warehouse Design
Query Optimization
Analytics, OLAP, and Data Mining in the Database
Managing the Data Warehouse
Other Software for the Data Warehouse
The Metadata Challenge
Best Practices
11. Oracle and High Availability
What Is High Availability?
System Failure
Protecting Against System Failure
Recovering from Failures
Complete Site Failure
Data Redundancy Solutions
Rolling Upgrades
12. Oracle and Hardware Architecture
System Basics
Uniprocessor Systems
Symmetric Multiprocessing Systems
Clusters
Non-Uniform Memory Access Systems
Grid Computing
Disk and Storage Technology
Which Platform Deployment Solution?
13. Oracle Distributed Databases and Distributed Data
Accessing Multiple Databases As a Single Entity
Moving Data Between Distributed Systems
14. Oracle Extended Datatypes
Object-Oriented Development
Extensibility Features and Options
Using the Extensibility Framework in Oracle
15. Beyond the Oracle Database
Application Express
Oracle Fusion Middleware
Oracle SOA Suite
A. What's New in This Book for Oracle Database 11g
B. Additional Resources
Index