Skip to content

Oracle Unleashed

ISBN-10: 0672315750

ISBN-13: 9780672315756

Edition: 3rd 1999

Authors: Inc. Staff Advanced Information Systems

List price: $49.99
Blue ribbon 30 day, 100% satisfaction guarantee!
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!

Description:

Oracle 8 is one of the most commonly-used databases in the world, and 8i allows full integration of Java programs, Internet content and Web sites. This book shows how to deploy Oracle's latest databases using the most up-to-date Web tools.
Customers also bought

Book details

List price: $49.99
Edition: 3rd
Copyright year: 1999
Publisher: Sams
Publication date: 6/23/1999
Binding: Mixed Media
Pages: 1584
Size: 8.00" wide x 9.50" long x 2.00" tall
Weight: 4.994
Language: English

Introduction
Oracle Company Overview
Understanding the Oracle Corporation
Oracle's Soul Kitchen: The Database Appliance
Introducing the Cartridge
The Universal Data Server, Oracle8i
The Oracle Alliance
Oracle Alliance Value Service
Oracle Support
The Support Olympics: Bronze, Silver, or Gold?
Customer Support Identification Number
Crossing the TAR Pits
Oracle's Automated Support
The Oracle Technology Network
Oracle: A Step Further
What is an RDBMS?
The Relational Database Model
RDBMS Components
Nonprocedural Data Access (SQL)
Databases and the World Wide Web
Oracle, Client/Server, and Enterprise Computing
Client/Server Computing
An Overview of Client/Server Computing
Databases in a Client/Server Architecture
Oracle and Client/Server Computing
Oracle Directions
Overview of the Oracle Architecture
Architecture
Computer Architecture Fundamentals
Global View of the Oracle Architecture
Oracle Files
System and User Processes
Oracle Memory
Storage
System Database Objects
Protecting Your Data
Backup and Recovery
Distributed Databases
National Language Support
Data Warehousing
Following a SQL Statement Through the Architecture
Oracle7 Workgroup Server
Overview of the Oracle7 Workgroup Server
System Requirements
Oracle7 Workgroup Server Tools and Utilities
Oracle7 Workgroup Server Distributed and Replication Features
When to Use Oracle7 Workgroup Server
Oracle8i Server
Architectural Overview
Oracle SGA
New Features for Oracle8 and Oracle8i
Oracle8i Enterprise Server
An Oracle8 Server Feature Overview
An Overview of Oracle8i Server
Personal Oracle8i Overview and Features
Oracle8i Server Overview and Features
Oracle8i Enterprise Edition Overview and Features
Oracle Application Servers Overview
Oracle8i Database Tools and Utilities
Oracle8i Feature Summary
Oracle Web Application Server
Architectural Overview
Component Interaction
Installation and Configuration
Using Supplied Cartridges
Developing Cartridges with the WRB API
Electronic Commerce Server
What Is Electronic Commerce?
Is Electronic Commerce a Solution for My Business?
The Architecture of Oracle's Internet Commerce Server
A Peek at Some of the Third-Party Internet Commerce Server Cartridges
Oracle Applications for the Web
Encryption and Electronic Commerce
SQL
Oracle's SQL: An Overview
Datatypes
The Create Statement
Writing Queries
The Decode Statement
Inserts, Updates, and Deletes
Master/Detail or Parent/Child SQL
Additional Tips
PL/SQL--SQL Procedural Language
Packaged Procedures
Creating Package Subprograms
Cursors
Procedure Variables
Scalar Datatypes
Composite Datatypes
Processing Control
Exception Handling
Comments
Stored Procedures
Commits
The Standard Package
Additional Topics
Oracle8 Enhancements
SQL*Plus
A Brief History of SQL*Plus
Use and Limitations
Platforms
SQL*Plus Commands
Character-Mode Environments
Graphical-Mode Environments
SQL*Plus Reporting
SQL*Plus Additional Functionality
Server Manager
Introduction to Server Manager
Server Manager Operation Modes
Server Manager in Line Mode
Server Manager in Command Mode
Server Manager Command Reference
Enterprise Manager
Oracle Tools and Utilities
Installing Enterprise Manager
The Enterprise Manager Console
Backup Manager
Data Manager
Instance Manager
Schema Manager
Security Manager
Software Manager
SQL Worksheet
Storage Manager
SQL*Loader
Basic SQL*Loader Components
Physical Versus Logical Records
Concatenated Records
SQL*Loader Paths
Parallel Data Loading
Control File Syntax
Command-Line Options and Parameter Files
Import and Export
Import and Export
Export
Import
Import and Export Hints and Tips
Managing the Database
The Parameter File: INIT.ORA
The Oracle SID
Creating a New Database
Startup and Shutdown
The Data Dictionary
Redo Logs
Control Files
Trace and Alert Files
Database Modes
Useful Data Dictionary Views
Managing Disk Space
Obtaining Object Storage
Using the ROWID in Oracle8 and 8i
Using the Storage Clause
Using Rollback Segments
Using Tablespaces
Using Temporary Segments
Analyzing Storage
Estimating Storage for a Table
Managing Users
User Needs Analysis
User Authentication Methods
User Configuration Setup
Resource Management
User Database Accounts
Special Account Considerations
Maintaining User Data
Backup and Recovery
Importance of Backups
Terminology
Requirements for Backups
Optimal Flexible Architecture
Types of Backups
Alternative Backup Methods
Types of Database Failure
Recovery Methods
Sample Database Backup Scripts
Performance Tuning and Optimization
General Concepts in Database Tuning
Parallel Processing
Parallel Server Option
Parallel Query Option
Performance Tools
Tuning Database SGA
Contention Issues
Database Objects
Database Locking
Database Security
Authentication
Why Protect Passwords?
Privileged Accounts
Remote Passwords
Object Versus System Security
Object Seucrity Model
Defining Database Roles
Database Auditing
Designing a Database
Defining Requirements
The Logical Model
The Physical Model
Object-Oriented Programming with Packages
The Package Specification
The Package Body
Package Privileges
Accessing Oracle Packages from Client Applications
Object-Oriented Concepts
Transaction Processing
Introduction to Transactions
Transaction Control
Read Consistency
Types of Transactions
Processing a Standard Transaction
Processing a Remote or Distributed Transaction
Transaction Space
Enforcing Integrity
A Common Integrity Problem
Column Constraints
Table Constraints
Using Sequences
Using Triggers
Application and performance Considerations
Application Security
Reasons for Using Application Security
Using Application-Specific Database Objects
Table-Driven Application Security
Application and Performance Considerations
Oracle8 Cartridges
What Do We Mean by Secure I-Commerce?
What Is SSL X.509 v3?
CORBA/IIOP and Cartridges
Oracle Web Request Broker and Cartridges
Developing Cartridge-Driven Applications
Cartridge Implementations
PL/SQL Cartridge with Java Class Wrapper and HTML Output
Introduction to and Installation of Oracle Designer
Business Process Reengineering
Information Engineering
Rapid Application Development
Legacy-Led Development
Installing Oracle Designer
System Requirements
Back Up, Back Up, Back Up
Upgrading to Oracle Designer
Client Installation
Server Installation
Repository Administration
The Repository Administration Utility
The Matrix Diagrammer
The Repository Object Navigator
Repository Reports
System Modeling and Design
General User Interface
Entity Relationship Diagrammer
Functional Hierarchy Diagrammer
Dataflow Diagrammer
Modeling System Requirements
Database Transformer
Application Design Transformer
Design Editor
Introduction to Oracle Developer
What Is Oracle Developer?
Features of Oracle Developer
Common Tool Set Features
Form Builder
The Forms Environment
Using Boilerplate Text and Graphics to Enhance Forms Applications
Customizing Forms with Properties
Implementing Triggers and Program Units
Using Record Groups and Lists of Values for Data Validation
Using Relationships to Link Separate Blocks in a Form
Mouse Events, Timers, and Other Advanced Widgets
Considerations for Multiple-Form Applications
Techniques for Dynamic Runtime Applications
Working with Menus
Libraries, Object Classes, and Visual Attributes
Quality Considerations for Forms
Report Builder
The Reports 3.0 Environment
Constructing a Tabular Report
Creating a Group Above Report
Using Secondary Queries
Adding Report Break Levels
Customizing Reports with Boilerplate Text and Graphics
Working with Summary and Formula Columns
Formatting Reports
Exploring Complex Reports
Creating Dynamic Reports
Graphics Builder
The Oracle Developer Graphics Environment
Defining Displays
Defining Parameters for Charts
Multiple Chart Applications
Formatting Charts with Text and Breaks
Advanced Formatting Techniques
Oracle Developer Integration
Displaying Graphics in Form Builder
Executing Reports from Form Builder
Displaying Graphics in Report Builder
Interfacing with Non-Oracle Applications
Interfacing with the Windows API and Other DLLs
Looking Ahead to Developer 6.0
Introduction to Oracle Objects for Ole
Components of OO4O
OO4O and the Open Database Connectivity API
Host Environments
Oracle Ole Automation Server
Understanding the OO4O Background
Getting Started
Executing SQL Statements and PL/SQL Blocks
Using Parameters
The OraDynaset Edit, Update, and AddNew Methods
LONG and LONG RAW Column Support
Transactions
Error Handling
Performance Tuning
Thread Safety
The Oracle Data Control
Using the ODC in Visual Basic
Using the ODC and OO4O Automation Server Objects
Introduction to Oracle Discoverer
Multidimensional Database Primer
A Semi-Formal Definition of OLAP
Multidimensional Storage Strategies--A Star Schema Is Born
Discoverer as a Tool for Data Warehousing
Discoverer 3.1--Features, Functions, and Benefits
Using Discoverer for Reports
Creating the Tutorial and Video Databases
Creating the OLAP Database
Creating the Sample Database
Mapping Data from a Database into Discoverer: The Load Wizard
Moving Around in the Land of Folders and Items
The Administration Tasklist: Don't Enter the Dimensions Without It!
The Discoverer 3.1 User Edition
Multidimensional Databases: The Possibilities Are Endless
OLAP of the Mind
Programmer/2000
Oracle Precompilers
Why Precompile Source Code?
General Precompiler Features
Precompiler Languages
ANSI/IO Standards
Precompiler Options
How to Precompile a Program
Conditional Precompiling
Embedded SQL Host Programs
Basics of a Host Program
Host Program Requirements
Error Handling
Host Arrays
Dynamic SQL
Coding Methods for Dynamic SQL Statements
User Exits
Performance Tuning
Oracle Call Interface (OCI)
SQL*Module
Productivity, Security, and Performance
New Features in Version 8.0
Using PowerBuilder
Connecting to the Database
Communicating with the Database
Using Visual Basic
Third-Party Products That Decrease Development Time and Add Value
Immediate Benefits to RAF Users
Rapid Application Foundation
RAF Courses
Connecting to the Database
Using Delphi
Configuring a Data Source
Communicating with the Database
Putting Information on the Web
The Birth of the Web
Why Put Information on the Web--Benefits and Pitfalls
HTML
The Medium Is the Message
The Role of the Browser
HTML and Oracle's Web Server
Oracle's interMedia Product
VRML and Oracle8i Spatial
Oracle Web Programming with Java and Perl
Java Basics
The Java Object Model
The Java Language
Advantages of Using Java
CORBA Fundamentals
CGI Programming with Perl
Web Database Connectivity
Writing JDBC Applets and Applications
Handling JDBC Exceptions
JDBC Debugging
Deployment Issues
Using RMI
Using JavaIDL
Applets Versus Java Application and Security Considerations
Advanced JDBC Application Design
Performance Considerations and Multi-Threading
Writing a JDBC Driver
JDBC-Native Interface Mapping
JDBC Conformance
Using JNI
The Future of JDBC
Putting an Application on the Web
Planning Your Web Applications
Oracle8i and the Cartridge
PL/SQL Web Applications
Creating a Cartridge Using C
Java
Networking
A Quick and Dirty Introduction to Networking
An Overview of Oracle Networking
Host/Terminal Connections
Client/Server Connections
Web/Internet Connections
Database-to-Database Connections
Net/8 and SQL*Net
ODBC, JDBC, and OLE
Sample Configurations
Network Development Tips
Parallel Processing
Understanding the Requirements for Parallel Processing
Leveraging Parallel Processing Platforms
Oracle8i's New Cache Fusion Technology
Oracle Server Scalable Parallel Architecture for Open Data Warehousing
Oracle Parallel Architecture: An Overview
The Oracle Advantage over Pure Systems
Parallel Processing Platform Hardware Configuration Requirements
Making the Right Choice
Routine Parallel Platform Server Maintenance
ODBC
Components of ODBC
Configuring an ODBC Data Source
Connecting to an ODBC Data Source Using the ODBC API
Setting Connection Options
Applying SQL Transactions
Retrieving Result Sets
Handling Errors
Calling Stored Procedures and Functions
Disconnecting and Freeing Resources
Debugging ODBC Applications
Limitations of ODBC
JDBC
JDBC Setup
Using the JDBC Drivers
JDBC Capabilities and Limitations
Data Warehouses and Data Marts
An Introduction to Data Warehouses and Data Marts
Typical Uses of Data Warehouses
Designing a Data Warehouse
Star Join Schema
Tuning Data Warehouses in Oracle
Oracle Data Marts
OLAP Engines
Index