Effective Oracle by Design

Contents

ACKNOWLEDGMENTS

INTRODUCTION

1 The Right Approach to Building Applications

It’s a Team Effort

DBA and Developer Roles

Read the Documentation

A Guide to the Guides

Road Maps to Reading

Avoid the Black Box Syndrome

Database Independence versus Database Dependence

Dangers of Black Box Syndrome

It’s a Database, Not a Data Dump

Use Primary and Foreign Keys

Test the Overhead of Referential Integrity

Middle Tier Checking Is Not a Panacea

Build a Test Environment

Test Against Representative Data

Don’t Test with a Single User

Don’t Test in a Dust-Free Lab

Design to Perform; Don’t Tune to Perform

Don’t Use Generic Data Models

Design Your Data Model for Efficiency

Define Your Performance Goals from the Start

Work to Clear, Specific Metrics

Collect ...