文档介绍：To access the contents, click the chapter and section titles.
Oracle® Programming with Visual Basic®
(Publisher: Sybex, Inc.)
Author(s): Nick Snowdon
ISBN: 0782123228
Publication Date: 10/01/98
Brief Full
Advanced
Search Search this book:
Search Tips
Introduction
Foreword
Acknowledgments
PART I—Introducing Oracle
CHAPTER 1—Oracle and Visual Basic
A Brief History of Oracle
The Architecture of a Relational Database
File-Based Systems
Client/Server Architecture
Multitier Architecture
puting Architecture
Client
Application Server
Universal Data Server
The Oracle Server
Standard Features
Scalability
The Oracle Server Advanced Features
Distributed Databases
Parallel Server
Replication
Visual Basic in an Oracle World
The Past
The Present
The Future
Moving Up to Oracle
Moving from Microsoft Access
Moving from Microsoft SQL Server
Summary
CHAPTER 2—Oracle Database Architecture
Instances and Databases
Memory Structures
The Database Buffer Cache
Redo Log Buffer
Shared Pool
Library Cache
Data Dictionary Cache
Additional Memory Areas
Processes
Database Writer (DBWR)
Log Writer (LGWR)
System Monitor (SMON)
Process Monitor (PMON)
Archiver (ARCH)
Server Processes
Listener Process
Database Files
Control Files
Parameter File
Online Redo Log Files
Data Files
The Logical Structure
Data Concurrency and Data Consistency
Locking Strategies for Concurrency
How Is Consistency Achieved?
Schemas
Users
Tables
Indexes
Clusters
Sequence Generators
Procedures
Views
Synonyms
Tying It All Together: How Oracle Works
Summary
CHAPTER 3—Creating a Database
Administration Tools
SQL*Plus
Server Manager
NT Instance Manager
Oracle Enterprise Manager
Other Utility Programs
Oracle Installation
Services on NT
Oracle Database Assistant
Initialization Files
Starting Up and Shutting Down the Database
Starting Up a Database
Shutting Down a