Oracle Design: The Definitive Guide (Nutshell Handbooks)

2.67 avg rating
( 3 ratings by Goodreads )
 
9781565922686: Oracle Design: The Definitive Guide (Nutshell Handbooks)
View all copies of this ISBN edition:
 
 

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

"synopsis" may belong to another edition of this title.

About the Author:

Dave Ensor is manager of Worldwide Solutions, PATROL R&D, with BMC Software where his roles are to assist customers in their use of both BMC's PATROL product and the Oracle Server, and to feed the results of his field work back into product planning. He has more than 30 years of IT experience and has been involved with the design and performance issues surrounding Oracle since 1987. For many years he led Oracle Worldwide's Performance Studies Group based in the UK, which provided consultancy support to both customer and internal projects with critical performance requirements. Dave is well known as a speaker on performance management and design; he presents his papers at user conferences and writes and delivers one-day seminars. He lives in the UK just outside London, but spends much of the year traveling to user sites and meetings. In his spare time he also travels, but in this case without his laptop and with his wife. He can be reached at dave_ensor@compuserve.com. Ian Stevenson is a freelance consultant specializing in database design and development. He has worked with database technology for 19 years, starting with early hierarchical models. He worked for Oracle (UK) for two years in post-sales support and Human Resources Development. This is where he formed his friendship with Dave Ensor. Ian has a first-class honors degree in mathematics from the University of Southampton and is a member of the British Computer Society. He is married to Brenda and has two children, Todd and Tara. He is a fanatic supporter of the Southampton football club. He can be contacted via ian@westmail.demon.co.uk.

Ian Stevenson is a freelance consultant specializing in database design and development. He has worked with database technology for 19 years, starting with early hierarchical models. He worked for Oracle (UK) for two years in post-sales support and Human Resources Development. This is where he formed his friendship with Dave Ensor. Ian has a first-class honors degree in mathematics from the University of Southampton and is a member of the British Computer Society. He is married to Brenda and has two children, Todd and Tara. He is a fanatic supporter of the Southampton football club. He can be contacted via ian@westmail.demon.co.uk.

"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

1.

Ensor, Dave; Stevenson, Ian
Published by O'Reilly Media
ISBN 10: 1565922689 ISBN 13: 9781565922686
New PAPERBACK Quantity Available: 1
Seller:
Lakeside Books
(Benton Harbor, MI, U.S.A.)
Rating
[?]

Book Description O'Reilly Media. PAPERBACK. Condition: New. 1565922689 BRAND NEW, GIFT QUALITY! NOT OVERSTOCKS OR MARKED UP REMAINDERS! DIRECT FROM THE PUBLISHER!|1.69. Seller Inventory # OTF-Y-9781565922686

More information about this seller | Contact this seller

Buy New
US$ 33.43
Convert currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, rates & speeds

2.

Ian Stevenson, Dave Ensor
Published by O'Reilly Media, Inc, USA, United States (1997)
ISBN 10: 1565922689 ISBN 13: 9781565922686
New Quantity Available: 1
Seller:
Book Depository International
(London, United Kingdom)
Rating
[?]

Book Description O'Reilly Media, Inc, USA, United States, 1997. Book. Condition: New. Language: English. Brand new Book. 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. Seller Inventory # AAH9781565922686

More information about this seller | Contact this seller

Buy New
US$ 37.46
Convert currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, rates & speeds

3.

Dave Ensor, Ian Stevenson
Published by O Reilly Media, Inc, USA, United States (1997)
ISBN 10: 1565922689 ISBN 13: 9781565922686
New Quantity Available: 1
Seller:
The Book Depository
(London, United Kingdom)
Rating
[?]

Book Description O Reilly Media, Inc, USA, United States, 1997. Book. Condition: New. Language: English . Brand New Book. 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. Seller Inventory # AAH9781565922686

More information about this seller | Contact this seller

Buy New
US$ 38.80
Convert currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, rates & speeds

4.

Dave Ensor, Ian Stevenson
Published by O'Reilly Media (1997)
ISBN 10: 1565922689 ISBN 13: 9781565922686
New Paperback Quantity Available: 1
Seller:
Ergodebooks
(RICHMOND, TX, U.S.A.)
Rating
[?]

Book Description O'Reilly Media, 1997. Paperback. Condition: New. 1. Seller Inventory # DADAX1565922689

More information about this seller | Contact this seller

Buy New
US$ 36.63
Convert currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, rates & speeds

5.

Dave Ensor
Published by O'Reilly Media, Inc, USA
ISBN 10: 1565922689 ISBN 13: 9781565922686
New Quantity Available: 2
Seller:
THE SAINT BOOKSTORE
(Southport, United Kingdom)
Rating
[?]

Book Description O'Reilly Media, Inc, USA. Book. Condition: New. New copy - Usually dispatched within 2 working days. Seller Inventory # B9781565922686

More information about this seller | Contact this seller

Buy New
US$ 33.91
Convert currency

Add to Basket

Shipping: US$ 9.12
From United Kingdom to U.S.A.
Destination, rates & speeds

6.

Dave Ensor
ISBN 10: 1565922689 ISBN 13: 9781565922686
New Paperback First Edition Quantity Available: 1
Seller:
Grand Eagle Retail
(Wilmington, DE, U.S.A.)
Rating
[?]

Book Description Paperback. Condition: New. 1st. Paperback. "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 th.Shipping may be from multiple locations in the US or from the UK, depending on stock availability. 552 pages. 0.767. Seller Inventory # 9781565922686

More information about this seller | Contact this seller

Buy New
US$ 43.32
Convert currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, rates & speeds

7.

Dave Ensor (author), Ian Stevenson (author)
Published by O'Reilly Media 1997-03-01, Cambridge (1997)
ISBN 10: 1565922689 ISBN 13: 9781565922686
New paperback Quantity Available: 1
Seller:
Blackwell's
(Oxford, OX, United Kingdom)
Rating
[?]

Book Description O'Reilly Media 1997-03-01, Cambridge, 1997. paperback. Condition: New. Seller Inventory # 9781565922686

More information about this seller | Contact this seller

Buy New
US$ 41.25
Convert currency

Add to Basket

Shipping: US$ 9.86
From United Kingdom to U.S.A.
Destination, rates & speeds

8.

Ian Stevenson
Published by O'Reilly Media
ISBN 10: 1565922689 ISBN 13: 9781565922686
New Paperback Quantity Available: 3
Seller:
BuySomeBooks
(Las Vegas, NV, U.S.A.)
Rating
[?]

Book Description O'Reilly Media. Paperback. Condition: New. 552 pages. Dimensions: 9.1in. x 7.0in. x 1.2in.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 wont 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 clientserver, 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, importexport, backup, recovery, security, and more. Part III explores design issues for specific architectures and environments -- clientserver, 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 Design1. Introduction 2. Why is Design so Important for Oracle 3. Data ModelingPart II: Designing the Database4. 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 DataPart III: Designing for Specific Architectures11. Designing for ClientServer 12. Designing Distributed Databases 13. Designing for Data Warehouse 14. Designing for Parallel ProcessingPart IV: Designing the Code Modules15. 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 HelpPart V: AppendixesA. Off-the-Shelf Packages B. Tricks of the Trade This item ships from multiple locations. Your book may arrive from Roseburg,OR, La Vergne,TN. Paperback. Seller Inventory # 9781565922686

More information about this seller | Contact this seller

Buy New
US$ 52.51
Convert currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, rates & speeds

9.

Dave Ensor; Ian Stevenson
Published by O'Reilly Media (1997)
ISBN 10: 1565922689 ISBN 13: 9781565922686
New Softcover Quantity Available: 1
Seller:
Irish Booksellers
(Portland, ME, U.S.A.)
Rating
[?]

Book Description O'Reilly Media, 1997. Condition: New. book. Seller Inventory # M1565922689

More information about this seller | Contact this seller

Buy New
US$ 49.97
Convert currency

Add to Basket

Shipping: US$ 3.27
Within U.S.A.
Destination, rates & speeds

10.

Ensor, Dave; Stevenson, Ian
Published by O'Reilly Media
ISBN 10: 1565922689 ISBN 13: 9781565922686
New PAPERBACK Quantity Available: 4
Seller:
Russell Books
(Victoria, BC, Canada)
Rating
[?]

Book Description O'Reilly Media. PAPERBACK. Condition: New. 1565922689 Special order direct from the distributor. Seller Inventory # ING9781565922686

More information about this seller | Contact this seller

Buy New
US$ 49.95
Convert currency

Add to Basket

Shipping: US$ 7.00
From Canada to U.S.A.
Destination, rates & speeds

There are more copies of this book

View all search results for this book