search for books and compare prices
Tables of Contents for Oracle Design
Chapter/Section Title
Page #
Page Count
Preface
xi
 
I. Getting Started With Design
1
98
1. Introduction
3
32
What Is Design?
3
1
A Case Study
4
11
Looking at Alternative Methods and Approaches
15
3
Planning the Design Phase
18
2
Design Tasks
20
15
2. Why Is Design So Important for Oracle?
35
25
Designing for Specific Architectures
35
4
Designing for Performance
39
3
Other Design Considerations
42
2
Designing for Oracle7
44
14
Introducing Oracle8
58
2
3. Data Modeling
60
39
Types of Models
61
1
What Is Data Modeling?
62
3
Entity Relationship Diagrams
65
4
Quality-Assuring the Conceptual Information Model
69
23
Entity Life Histories and Data Flow Diagrams
92
4
Data-Driven Design and Meta Models
96
3
II. Designing the Database
99
166
4. Deciding When to Denormalize
101
12
Denormalization: What, Why, and When?
101
4
Methods of Implementing Denormalization
105
2
Other Types of Denormalization
107
6
5. Choosing Datatypes and Nulls
113
18
Available Datatypes
114
1
Numeric Data
115
2
Date and Time (Temporal) Data
117
2
String Data
119
3
Unstructured Data and BLOBs
122
1
Other Datatypes
123
2
Null Values
125
6
6. Choosing Keys and Indexes
131
33
Primary Keys
132
9
Other Keys
141
2
Indexes: An Overview
143
4
Index Types and Indexing Techniques
147
17
7. Dealing with Temporal Data
164
27
The Problem with Temporal Data
164
4
Design Issues for Temporal Databases
168
21
Temporal Data: A Summary
189
2
8. Loading and Unloading Data
191
24
Dealing with External Systems
191
3
Data Compatibility Issues
194
7
Data Migration Steps
201
2
Data Transformation
203
4
File Formats
207
1
Ordering, Recovery, and Commit Frequency
208
1
Using SQL*Loader
209
2
Oracle7 to Oracle7: a Special Case
211
2
Outbound Data
213
2
9. Deciding on Object Placement and Storage
215
10
Specifying Object Placement
215
3
Sizing
218
2
Specifying Storage Parameters
220
3
Creating Scripts
223
1
Implementation Planning
223
2
10. Safeguarding Your Data
225
40
Archiving
226
7
Auditing
233
10
Security
243
12
Backup
255
10
III. Designing for Specific Architectures
265
126
11. Designing for Client/Server
267
32
Why Client/Server?
268
1
What Is Client/Server?
269
1
What Kind of Hardware?
270
2
Basic Design Issues for Client/Server
272
1
Designing for Client/Server
273
3
SQL*Net Basics
276
1
Anatomy of a SQL Statement
277
3
Cutting in the Middle Man
280
2
Special Design Considerations
282
17
12. Designing for Distributed Databases
299
36
When Should You Use Distributed Databases?
299
1
Evolution of Oracle Support for Data Distribution
300
12
Selecting a Data Distribution Strategy
312
16
Example Scenarios
328
4
Using Distributed Database for Fallback
332
1
Other Design Considerations
332
1
Data Distribution Summary
333
2
13. Designing for Data Warehouses
335
34
Why Data Warehouses?
335
2
What Is a Data Warehouse?
337
10
Design Issues for Data Warehouses
347
11
Extracting and Loading the Data
358
6
Meta Data
364
1
Transformation Types and Methods
364
3
Retrieving the Data via Data Mining and OLAP Tools
367
2
14. Designing for Parallel Processing
369
22
Why Do We Need Parallelism?
370
5
Designing to Achieve Parallelism
375
5
Parallel Query Option (PQO)
380
4
Oracle Parallel Server (OPS)
384
7
IV. Designing the Code Modules
391
84
15. Introduction to Code Design
393
17
Analysis Deliverables
394
3
Mapping Functions to Modules
397
2
Don't Forget the System Modules
399
3
Source and Version Control
402
3
Template Code
405
1
Designing for Testing
406
1
CASE Products in Run Unit Design
407
3
16. Determining Where to Locate the Processing
410
13
Data Rules vs. Process Rules vs. Interface Rules
410
6
Logic Placement
416
2
Locking Issues
418
2
How Does This Relate to Three-Tier Architectures?
420
3
17. Metrics, Prototypes, and Specifications
423
14
Developing Design and Build Metrics for Modules
423
2
Banishing Megamodules
425
3
Shall We Prototype?
428
5
Where are my Specs? Guidelines for Module Specifications
433
2
Specifying Screens and Reports
435
1
Specifying Batch Processes
436
1
18. Locking
437
9
Locking Strategies
437
3
Deadlocks
440
1
Serializability
441
1
Other Design Issues
442
4
19. Selecting the Toolset
446
7
Types of Tools
446
1
Which Selection Criteria Are Important?
447
1
Client/Server Tools
448
3
Designing for the World Wide Web
451
2
20. Designing Screens, Reports, Batch Programs, and More
453
22
Designing Screens
453
3
Designing Reports
456
2
Designing Batch Programs
458
10
Error Handling
468
1
Navigation
469
2
Online Help
471
4
V. Appendixes
475
38
A. Off-the-Shelf Packages
477
10
Evaluating a Package
478
1
Does It Fit?
479
4
Can It Be Tailored?
483
2
The Big Data Model Issue
485
2
B. Tricks of the Trade
487
26
Fixing Those Mutating Tables
487
8
Dealing with the Millennium Date Problem: An Oracle Perspective
495
8
Providing User Extensibility
503
10
Index
513