25 Books to Read Before You Die
 
 

Recently Viewed clear list


The Powell's Playlist | August 8, 2014

Peter Mendelsund: IMG The Powell's Playlist: Water Music by Peter Mendelsund



We "see" when we read, and we "see" when we listen. There are many ways in which music can create the cross-sensory experience of this seeing...... Continue »
  1. $11.87 Sale Trade Paper add to wish list

spacer

Oracle Design (Nutshell Handbooks)

by

Oracle Design (Nutshell Handbooks) Cover

 

Synopses & Reviews

Publisher Comments:

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

Book News Annotation:

Covers database, code, and architecture design for the Oracle operating system. The text is arranged in four sections including an overview of Oracle and data modeling; aspects of database design including denormalization, data types, nulls, keys, indexes, temporal data, import/export, backup, recovery, security, archiving, and audit; examples of architecture design issues for client/server, distributed databases, data warehouses, and parallel processing; and aspects of code design including metrics and prototypes, locking, and the design of screens, reports, batch programs, online help text, and navigation.
Annotation c. Book News, Inc., Portland, OR (booknews.com)

Synopsis:

Covering database, code, and architecture design for the Oracle operating system, this text is arranged in four sections including an overview of Oracle and data modelling; and aspects of database design including denormalization, data types, nulls, keys and indexes.

Synopsis:

This book focuses exclusively on Oracle database design. It covers the most up-to-date Oracle issues and technologies, including massively parallel processors, very large databases, data warehouses, client-server, and distributed database. The design advice is detailed and thorough. The book delves deeply into design issues and gives advice that will have a major impact on your database and system performance.

About the Author

Dave Ensor spent over 35 years in IT, almost all of it in a hands-on role as a programmer, a designer, or a researcher into the performance characteristics of specific pieces of software. He worked with Oracle databases for 15 years in all three of these roles, also building a worldwide reputation for his ability to present technical material with clarity and humor. He is coauthor of the books "Oracle Design" and "Oracle8 Design Tips", and he's an Honorary Oracle9"i" Certified Master. Dave holds undergraduate degrees in both mathematics and law.
Stevenson is Carlson Professor of Psychiatry and Director of the Division of Personality Studies at the Health Sciences Center, University of Virginia.

Table of Contents

 Table of Contents Preface  I. Getting Started With Design  1. Introduction What Is Design? A Case Study Looking at Alternative Methods and Approaches Planning the Design Phase Design Tasks 2. Why Is Design So Important for Oracle? Designing for Specific Architectures Designing for Performance Other Design Considerations Designing for Oracle7 Introducing Oracle8 3. Data Modeling Types of Models What Is Data Modeling? Entity Relationship Diagrams Quality-Assuring the Conceptual Information Model Entity Life Histories and Data Flow Diagrams Data-Driven Design and Meta Models II. Designing the Database 4. Deciding When to Denormalize Denormalization: What, Why, and When? Methods of Implementing Denormalization Other Types of Denormalization 5. Choosing Datatypes and Nulls Available Datatypes Numeric Data Date and Time (Temporal) Data String Data Unstructured Data and BLOBs Other Datatypes Null Values 6. Choosing Keys and Indexes Primary Keys Other Keys Indexes: An Overview Index Types and Indexing Techniques 7. Dealing with Temporal Data The Problem with Temporal Data Design Issues for Temporal Databases Temporal Data: A Summary 8. Loading and Unloading Data Dealing with External Systems Data Compatibility Issues Data Migration Steps Data Transformation File Formats Ordering, Recovery, and Commit Frequency Using SQLxLoader Oracle7 to Oracle7: a Special Case Outbound Data 9. Deciding on Object Placement and Storage Specifying Object Placement Sizing Specifying Storage Parameters Creating Scripts Implementation Planning 10. Safeguarding Your Data Archiving Auditing Security Backup III. Designing for Specific Architectures  11. Designing for Client/Server Why Client/Server? What Is Client/Server? What Kind of Hardware? Basic Design Issues for Client/Server Designing for Client/Server SQLxNet Basics Anatomy of a SQL Statement Cutting in the Middle Man Special Design Considerations 12. Designing for Distributed Databases When Should You Use Distributed Databases? Evolution of Oracle Support for Data Distribution Selecting a Data Distribution Strategy Example Scenarios Using Distributed Database for Fallback Other Design Considerations Data Distribution Summary 13. Designing for Data Warehouses Why Data Warehouses? What Is a Data Warehouse? Design Issues for Data Warehouses Extracting and Loading the Data Meta Data Transformation Types and Methods Retrieving the Data via Data Mining and OLAP Tools 14. Designing for Parallel Processing Why Do We Need Parallelism? Designing to Achieve Parallelism Parallel Query Option (PQO) Oracle Parallel Server (OPS) IV. Designing the Code Modules  15. Introduction to Code Design Analysis Deliverables Mapping Functions to Modules Don't Forget the System Modules Source and Version Control Template Code Designing for Testing CASE Products in Run Unit Design 16. Determining Where to Locate the Processing Data Rules vs. Process Rules vs. Interface Rules Logic Placement Locking Issues How Does This Relate to Three-Tier Architectures? 17. Metrics, Prototypes, and Specifications Developing Design and Build Metrics for Modules Banishing Megamodules Shall We Prototype? Where are my Specs? Guidelines for Module Specifications Specifying Screens and Reports Specifying Batch Processes 18. Locking Locking Strategies Deadlocks Serializability Other Design Issues 19. Selecting the Toolset Types of Tools Which Selection Criteria Are Important? Client/Server Tools Designing for the World Wide Web 20. Designing Screens, Reports, Batch Programs, and More Designing Screens Designing Reports Designing Batch Programs Error Handling Navigation Online Help V. Appendixes  A. Off-the-Shelf Packages  Evaluating a Package Does It Fit? Can It Be Tailored? The Big Data Model Issue B. Tricks of the Trade Fixing Those Mutating Tables Dealing with the Millennium Date Problem: An Oracle Perspective Providing User Extensibility Index 

Product Details

ISBN:
9781565922686
Author:
Ensor, Dave
Author:
Stevenson, Ian
Publisher:
O'Reilly Media
Location:
Cambridge Eng. ;
Subject:
Computers
Subject:
Database Management - IBM Compatible
Subject:
Database Management - General
Subject:
Relational databases
Subject:
Computer software
Subject:
Database design
Subject:
Database Management - Oracle
Subject:
Oracle (computer system)
Subject:
Oracle (Computer file)
Subject:
Oracle
Subject:
Microcomputer Programming
Subject:
Computer Books: Database
Subject:
data modeling;design;oracle
Subject:
Data processing
Edition Number:
1st ed.
Edition Description:
Print PDF
Series:
Nutshell Handbook
Series Volume:
13
Publication Date:
19970331
Binding:
TRADE PAPER
Language:
English
Illustrations:
Yes
Pages:
552
Dimensions:
9.19 x 7 x 1.17 in 1.69 lb

Other books you might like

  1. Oracle8i: Networking 101 Used Trade Paper $1.25
  2. Oracle Essentials 1ST Edition Oracle... Used Trade Paper $5.95
  3. Oracle PL/SQL Built-Ins Pocket Reference
    Used Trade Paper $1.00
  4. Oracle8i Tips and Techniques Used Trade Paper $1.00
  5. Oracle 8i: a Beginner's Guide Used Trade Paper $5.95
  6. Oracle Scripts with CDROM Used Trade Paper $1.98

Related Subjects

Computers and Internet » Database » Applications
Computers and Internet » Database » Design
Computers and Internet » Software Engineering » Software Management
History and Social Science » Economics » General
History and Social Science » World History » General

Oracle Design (Nutshell Handbooks) Used Trade Paper
0 stars - 0 reviews
$5.95 In Stock
Product details 552 pages O'Reilly & Associates - English 9781565922686 Reviews:
"Synopsis" by , Covering database, code, and architecture design for the Oracle operating system, this text is arranged in four sections including an overview of Oracle and data modelling; and aspects of database design including denormalization, data types, nulls, keys and indexes.
"Synopsis" by ,
This book focuses exclusively on Oracle database design. It covers the most up-to-date Oracle issues and technologies, including massively parallel processors, very large databases, data warehouses, client-server, and distributed database. The design advice is detailed and thorough. The book delves deeply into design issues and gives advice that will have a major impact on your database and system performance.
spacer
spacer
  • back to top
Follow us on...




Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.