Synopses & Reviews
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 system. And as each new version of the database is released, users find themselves under increasing pressure to learn about a whole range of new technologies.This book distills the enormous amount of information about what Oracle is, where it came from, and what the latest releases do--and packages it into a compact, easy-to-read volume filled with focused text, illustrations and helpful hints. It explains what's new and important about Oracle's revolutionary releases, Oracle8 (the "object-relational database") and Oracle8i (the "Internet database"). It covers:
- Oracle products, options, and overall architecture
- Installing and running Oracle (creating databases, configuring Net8, starting up and shutting down Oracle)
- Oracle data structures
- Managing Oracle (implementing security, using the Oracle Enterprise Manager, dealing with fragmentation and reorganization, and performing backup and recovery)
- Oracle networking
- Monitoring and tuning
- Multi-user concurrency and online transaction processing (OLTP)
- Special issues for high-availability systems
- Hardware architectures (e.g., SMP, MPP, NUMA) and their impact on Oracle
- Data warehousing
- Distributed databases
- Extensions for Oracle8 and Oracle8i, including the latest Java and web technologies
It also includes an appendix full of references to additional online and offline resources.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. But even if you already have a library full of Oracle documentation and books, you'll find that this compact book is the one you turn to, again and again, as your one-stop, truly essential reference.
Synopsis
This concise guide explains what's important about Oracle8 (the object-relational database) and Oracle8i (the Internet database). The text also covers all system products, architecture and data structures; installation, management, security, backup and recovery, and tuning issues; and specific Oracle technologies such as data warehouses, online transaction processing and the system's interfaces to the Web.
Synopsis
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 system. And as each new version of the database is released, users find themselves under increasing pressure to learn about a whole range of new technologies.
This book distills the enormous amount of information about what Oracle is, where it came from, and what the latest releases do--and packages it into a compact, easy-to-read volume filled with focused text, illustrations and helpful hints. It explains what's new and important about Oracle's revolutionary releases, Oracle8 (the object-relational database) and Oracle8i (the Internet database). It covers: Oracle products, options, and overall architecture Installing and running Oracle (creating databases, configuring Net8, starting up and shutting down Oracle) Oracle data structures Managing Oracle (implementing security, using the Oracle Enterprise Manager, dealing with fragmentation and reorganization, and performing backup and recovery) Oracle networking Monitoring and tuning Multi-user concurrency and online transaction processing (OLTP) Special issues for high-availability systems Hardware architectures (e.g., SMP, MPP, NUMA) and their impact on Oracle Data warehousing Distributed databases Extensions for Oracle8 and Oracle8i, including the latest Java and web technologies
It also includes an appendix full of references to additional online and offline resources.
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. But even if you already have a library full of Oracle documentation and books, you'll find that this compact book is the one you turn to, again and again, as your one-stop, truly essential reference.
Synopsis
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 system. And as each new version of the database is released, users find themselves under increasing pressure to learn about a whole range of new technologies.
This book distills the enormous amount of information about what Oracle is, where it came from, and what the latest releases do--and packages it into a compact, easy-to-read volume filled with focused text, illustrations and helpful hints. It explains what's new and important about Oracle's revolutionary releases, Oracle8 (the object-relational database) and Oracle8i (the Internet database). It covers:
Oracle products, options, and overall architecture
Installing and running Oracle (creating databases, configuring Net8, starting up and shutting down Oracle)
Oracle data structures
Managing Oracle (implementing security, using the Oracle Enterprise Manager, dealing with fragmentation and reorganization, and performing backup and recovery)
Oracle networking
Monitoring and tuning
Multi-user concurrency and online transaction processing (OLTP)
Special issues for high-availability systems
Hardware architectures (e.g., SMP, MPP, NUMA) and their impact on Oracle
Data warehousing
Distributed databases
Extensions for Oracle8 and Oracle8i, including the latest Java and web technologies
It also includes an appendix full of references to additional online and offline resources.
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. But even if you already have a library full of Oracle documentation and books, you'll find that this compact book is the one you turn to, again and again, as your one-stop, truly essential reference.
Description
Includes bibliographical references (p. 327-334) and index.
About the Author
Robert Stackowiak is Vice President of Business Intelligence in Oracle's Technology Business Unit. He has worked for over 20 years in business intelligence, data warehousing, and IT-related roles at Oracle, IBM, Harris Corporation, and the U.S. Army Corps of Engineers. His papers regarding business intelligence and computer and software technology have appeared in publications such as "President and CEO Magazine," "Database Trends and Applications," and The Data Warehousing Institute's publications. He also co-authored the books "Oracle Essentials: Oracle Database 10g" (currently in 3rd Edition, February 2004, O'Reilly), "Oracle Application Server 10g Essentials" (1st Edition, August 2004, O'Reilly), and "Professional Oracle Programming" (1st Edition, June 2005, WROX).
Joseph Rayman leads the Oracle Consulting Business Intelligence Practice in North America with over 20 years of business experience in a vast array of industries, including financial services, manufacturing, retail, telecommunications, healthcare, and federal government. His technical and business leadership spans enterprise architecture design, enterprise data modeling, VLDB system tuning, data warehouse design, data mining, and quality assurance activities for data warehouse practices. Joe is a key contributor in defining and authoring Oracle Consulting's Data Warehousing Methodology. Prior to joining Oracle, Joe designed and deployed business intelligence and statistical analysis solutions for a large food manufacturer and provided real-time trading and analysis solutions for a major international financial organization.
Rick Greenwald has worked in the IT field for over 20 years for major vendors, includingOracle, Gupta Technologies, Cognos, and Data General. He has coauthored more than a dozen books, including "Oracle Essentials: Oracle Database 10g" (currently in 3rd Edition, February 2004, O'Reilly), "Oracle Application Server 10g Essentials" (1st Edition, August 2004, O'Reilly), and "Professional Oracle Programming" (1st Edition, June 2005, WROX). Mr. Greenwald currently works for Ingres Corporation.Stackowiak is a data warehousing specialist at Oracle Corporation in Chicago. He works with Oracle's largest customer in the central area of the U.S. providing insight into the company's products and data warehousing strategy.Stern has more than 11 years of IT experience including senior positions in consulting, systems architecture, and technical sales.
Table of Contents
Preface
1. Introducing Oracle
The Evolution of the Relational Database
The Oracle8 Family
Summary of Oracle8/8i Features
Database Application Development Features
Database Connection Features
Distributed Database Features
Data Movement Features
Performance Features
Database Management Features
Oracle8i Lite
2. Oracle8 Architecture
Instances and Databases
The Components of a Database
The Components of an Instance
3. Installing and Running Oracle8
Installing Oracle8i
Creating a Database
Configuring Net8
Starting Up the Database
Shutting Down the Database
Accessing a Database
Oracle at Work
4. Data Structures
Datatypes
Basic Data Structures
Additional Data Structures
Data Design
Constraints
Triggers
Query Optimization
Understanding the Execution Plan
Data Dictionary Tables
5. Managing Oracle8
Implementing Security
Management Through the Oracle Enterprise Manager
Options for Oracle Enterprise Manager
Fragmentation and Reorganization
Backup and Recovery
Working with Oracle Support
6. Oracle8 Performance
Performance Tuning Basics
Oracle8 and Disk I/O Resources
Oracle and Parallelism
Oracle8 and Memory Resources
Oracle8 and CPU Resources
7. Multiuser Concurrency
Basics of Concurrent Access
Oracle and Concurrent User Access
Oracle8's Isolation Levels
Oracle8 Concurrency Features
How Oracle8 Handles SQL Operations
Concurrent Access and Performance
8. Oracle8 and Transaction Processing
OLTP Basics
Oracle's OLTP Heritage
Architectures for OLTP
Oracle8 and ERP Solutions
Oracle8 Features for OLTP
High Availability
Oracle8 Advanced Queuing
Object Technologies and Distributed Components
9. Oracle8 and Data Warehousing
Data Warehousing Basics
Data Warehouse Design
Query Optimization
OLAP in the Database
Managing the Data Warehouse
Other Data Warehouse Software
The Metadata Challenge
Best Practices
10. Oracle8 and High Availability
What Is High Availability?
System Crashes
Protecting Against System Crashes
Recovering from Disasters
Complete Site Failure
Data Redundancy Solutions
11. Oracle8 and Hardware Architecture
System Basics
Uniprocessor Systems
Symmetric Multiprocessing Systems
Clusters
Massively Parallel Processing Systems
NUMA Systems
Disk Technology
Which Hardware Solution?
12. Distributed Databases and Distributed Data
Accessing Multiple Databases as a Single Entity
Two-Phase Commits
Moving Data Between Distributed Systems
Advanced Queuing
13. Oracle8 Extensions
Object-Oriented Development
Extensibility Options
Using the Extensibility Framework in Oracle8i
14. Oracle8i and the Web
The Internet Computing Platform
Oracle8i as an Internet Server
Oracle in the Middle Tier
Oracle Tools and the Internet Client
Appendix: Additional Resources
Web Sites
Books and Oracle Documentation