Oracle Essentials : Oracle8 and Oracle8i

by Greenwald, Rick; Stackowiak, Robert; Stern, Jonathan

• ISBN13: 9781565927087
• ISBN10: 1565927087
• Format: Paperback
• Copyright: 1999-11-01
• Publisher: Oreilly & Associates Inc

Summary

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.

Table of Contents

Preface	xi
Introducing Oracle	1	(28)
The Evolution of the Relational Database	2	(4)
The Oracle8 Family	6	(2)
Summary of Oracle8/8i Features	8	(1)
Database Application Development Features	9	(5)
Database Connection Features	14	(3)
Distributed Database Features	17	(2)
Data Movement Features	19	(2)
Performance Features	21	(2)
Database Management Features	23	(5)
Oracle8i Lite	28	(1)
Oracle8 Architecture	29	(22)
Instances and Databases	29	(1)
The Components of a Database	30	(15)
The Components of an Instance	45	(6)
Installing and Running Oracle8	51	(24)
Installing Oracle8i	51	(3)
Creating a Database	54	(3)
Configuring Net8	57	(4)
Starting Up the Database	61	(2)
Shutting Down the Database	63	(1)
Accessing a Database	64	(7)
Oracle at Work	71	(4)
Data Structures	75	(38)
Datatypes	75	(8)
Basic Data Structures	83	(7)
Additional Data Structures	90	(2)
Data Design	92	(3)
Constraints	95	(2)
Triggers	97	(2)
Query Optimization	99	(8)
Understanding the Execution Plan	107	(3)
Data Dictionary Tables	110	(3)
Managing Oracle8	113	(27)
Implementing Security	114	(9)
Management Through the Oracle Enterprise Manager	123	(5)
Options for Oracle Enterprise Manager	128	(4)
Fragmentation and Recorganization	132	(4)
Backup and Recovery	136	(3)
Working with Oracle Support	139	(1)
Oracle8 Performance	140	(30)
Performance Tuning Basics	140	(4)
Oracle8 and Disk I/O Resources	144	(8)
Oracle and Parallelism	152	(9)
Oracle8 and Memory Resources	161	(6)
Oracle8 and CPU Resources	167	(3)
Multiuser Concurrency	170	(13)
Basics of Concurrent Access	171	(3)
Oracle and Concurrent User Access	174	(1)
Oracle8's Isolation Levels	175	(1)
Oracle8 Concurrency Features	176	(2)
How Oracle8 Handles SQL Operations	178	(2)
Concurrent Access and Performance	180	(3)
Oracle8 and Transaction Processing	183	(21)
OLTP Basics	184	(3)
Oracle's OLTP Heritage	187	(1)
Architectures for OLTP	188	(3)
Oracle8 and ERP Solutions	191	(1)
Oracle8 Features for OLTP	192	(5)
High Availability	197	(3)
Oracle8 Advanced Queuing	200	(2)
Object Technologies and Distributed Components	202	(2)
Oracle8 and Data Warehousing	204	(25)
Data Warehousing Basics	205	(4)
Data Warehouse Design	209	(2)
Query Optimization	211	(3)
OLAP in the Database	214	(1)
Managing the Data Warehouse	215	(1)
Other Data Warehouse Software	216	(8)
The Metadata Challenge	224	(1)
Best Practices	225	(4)
Oracle8 and High Availability	229	(36)
What Is High Availability?	230	(4)
System Crashes	234	(4)
Protecting Against System Crashes	238	(14)
Recovering from Disasters	252	(5)
Complete Site Failure	257	(4)
Data Redundancy Solutions	261	(4)
Oracle8 and Hardware Architecture	265	(14)
System Basics	265	(2)
Uniprocessor Systems	267	(1)
Symmetric Multiprocessing Systems	268	(2)
Clusters	270	(1)
Massively Parallel Processing Systems	271	(2)
NUMA Systems	273	(1)
Disk Technology	274	(2)
Which Hardware Solution?	276	(3)
Distributed Databases and Distributed Data	279	(12)
Accessing Multiple Databases as a Single Entity	279	(3)
Two-Phase Commits	282	(2)
Moving Data Between Distributed Systems	284	(3)
Advanced Queuing	287	(4)
Oracle8/8i Extensions	291	(13)
Object-Oriented Development	291	(6)
Extensibility Options	297	(6)
Using the Extensibility Framework in Oracle8i	303	(1)
Oracle8i and the Web	304	(23)
The Internet Computing Platform	304	(4)
Oracle8i as an Internet Server	308	(4)
Oracle in the Middle Tier	312	(5)
Oracle Tools and the Internet Client	317	(10)
Appendix: Additional Resources	327	(8)
Web Sites	327	(1)
Books and Oracle Documentation	328	(7)
Index	335