We see that javascript is disabled or not supported by your browser - javascript is needed for important actions on the site. Read more

What's New - Home - Login

Member $avings: $81,590,857.96 | Books Available: 786,815 | Members Online: 287

Swap Used Books - Buy New Books at Great Prices!

How To Swap Books Sign Up Search submenu

PBS Market (New Books)

Gift Buying Guide

Book Browser Advanced Search Books Posted Today Member Book Reviews Award Winning Books NYT Best Sellers Amazon Best Sellers Most Traveled Copies Club Wish List

Discussion Forums Book Lists

Club Lists My Book Lists My Watched Lists Create a List

Blog Donations

School Donation Program In Memory of... Military Donation Program Friends of PBS

Box-O-Books Maps The Eclectic Pen Fun Stuff

20 Questions Sudoku Bookmark Creator

Top 100

Requests Posts Swappers Referrers Reviewers

Pulse of PBS Spread The Word

Invite Friends Bookmarks Facebook Page Facebook App More Ways...

Photo Gallery Recipes Club Tag Cloud Member Testimonials

Help Center submenu

How To Swap Books Browse Help Docs Ask the Librarian PBS Member Icons Live Help

Kiosk

PBS Market (New Books) Go Shopping Buy Credits Buy PBS Money Upgrade Membership Gift Certificates Transfer Credits

Need Help?

Search - Oracle Design: The Definitive Guide (Nutshell Handbooks)

Oracle Design The Definitive Guide - Nutshell Handbooks
Author: Dave Ensor, Ian Stevenson

Oracle Design looks thoroughly at the field of Oracle relational database design. The design of both databases and applications is an often neglected area of Oracle, but one that has an enormous impact on the ultimate power and performance of a system. If the initial design is poor, then the most powerful hardware, the most sophistic... more »ated software tools, and the most highly tuned data and programs won't make your system run smoothly and efficiently. Indeed, applications that have been designed poorly will never be able to perform well, regardless of the tuning and retrofitting performed later on. There are three main areas of Oracle design:

The design of the specific database objects (e.g., tables, views, indexes, stored functions) that will be implemented in a database.
The design of the screens, reports, and programs that will maintain the data and allow inquiries against it.
Under certain circumstances, the design must also be concerned with the specific environment or technology (e.g., the network topology, the hardware configuration, and the use of a client/server, parallel processing, or distributed database architecture).

This book examines all aspects of database and code design. Part I examines the project life cycle and where design fits in that cycle; it shows a sample case study, identifies the areas of Oracle7 that are of particular interest to designers, takes a look ahead at Oracle8, and provides an in-depth discussion of data modeling (e.g., entities, relationships, attributes, entity models, function hierarchies). Part II describes design issues for the database itself -- denormalization, data types, keys, indexes, temporal data, import/export, backup, recovery, security, and more. Part III explores design issues for specific architectures and environments -- client/server, distributed database, data warehouses, and parallel processing. Part IV describes design issues for the code that accesses the database -- metrics and prototypes, locking, the toolset, design of screens, reports, batch programs, etc. Part V contains summary appendixes. The table of contents follows: Part I: Getting Started with Design

1. Introduction
2. Why is Design so Important for Oracle?
3. Data Modeling

Part II: Designing the Database

4. Deciding When to Denormalize
5. Choosing Data Types and NULLs
6. Choosing Keys and Indexes
7. Dealing with Temporal Data
8. Loading and Unloading Data
9. Deciding on Object Placement and Storage
10. Safeguarding Your Data

Part III: Designing for Specific Architectures

11. Designing for Client/Server
12. Designing Distributed Databases
13. Designing for Data Warehouse
14. Designing for Parallel Processing

Part IV: Designing the Code Modules

15. Introduction to Code Design
16. Determining Where to Locate the Processing
17. Metrics, Prototypes, and Specifications
18. Locking
19. Selecting the Toolset
20. Designing Screens, Reports, Batch Programs, Error Handling, and Help

Part V: Appendixes

A. Off-the-Shelf Packages
B. Tricks of the Trade

ISBN-13: 9781565922686
ISBN-10: 1565922689
Publication Date: 3/1/1997
Pages: 548
Edition: 1
Rating:

0 stars, based on 0 rating

Publisher: O'Reilly Media, Inc.
Book Type: Paperback
Members Wishing: 0
Reviews: Amazon | Write a Review

Genres:

Back to the Top ↑

Search - Oracle Design: The Definitive Guide (Nutshell Handbooks)

Loading...