| |
| |
| 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 | |