Buy New

or
Sign in to turn on 1-Click ordering.
Buy Used
Used - Good See details
Price: 2.79

or
 
   
More Buying Choices
Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Colour:
Image not available

 
Tell the Publisher!
Id like to read this book on Kindle

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Oracle Design: The Definitive Guide (Nutshell Handbooks) [Paperback]

Dave Ensor , Ian Stevenson
5.0 out of 5 stars  See all reviews (2 customer reviews)
RRP: 32.50
Price: 24.70 & FREE Delivery in the UK. Details
You Save: 7.80 (24%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Only 1 left in stock (more on the way).
Dispatched from and sold by Amazon. Gift-wrap available.
Want it Sunday, 24 Aug.? Choose Express delivery at checkout. Details

Formats

Amazon Price New from Used from
Paperback 24.70  

Book Description

11 Mar 1997 1565922689 978-1565922686 1

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

Product details

  • Paperback: 552 pages
  • Publisher: O'Reilly Media; 1 edition (11 Mar 1997)
  • Language: English
  • ISBN-10: 1565922689
  • ISBN-13: 978-1565922686
  • Product Dimensions: 2.9 x 17.6 x 23 cm
  • Average Customer Review: 5.0 out of 5 stars  See all reviews (2 customer reviews)
  • Amazon Bestsellers Rank: 1,382,443 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Authors

Discover books, learn about writers, and more.

Product Description

From the Publisher

This book looks thoroughly at the field of Oracle relational database design, an often neglected area of Oracle, but one that has an enormous impact on the ultimate power and performance of a system. Focuses on both database and code design, including such special design areas as data models, denormalization, the use of keys and indexes, temporal data, special architectures (client/server, distributed database, parallel processing), and data warehouses.

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.


Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more

Customer Reviews

4 star
0
3 star
0
2 star
0
1 star
0
5.0 out of 5 stars
5.0 out of 5 stars
Most Helpful Customer Reviews
2 of 2 people found the following review helpful
By A Customer
Format:Paperback
After reviewing many books for my company, technical and background this is certainly the first background book to be given to any manager and consultant to ensure that there is a common understanding.
Comment | 
Was this review helpful to you?
1 of 1 people found the following review helpful
5.0 out of 5 stars Very good overview of designing Oracle Databases 17 Feb 1999
By A Customer
Format:Paperback
If you are interested in Oracle design, then you should check this book out. It is a fine reference and well written, by two people who clearly understand their subject. Full of good advice on designing Oracle databases.
This book is about becoming a better Oracle database *designer* (it is not a programming book). It should help you understand how to put together Oracle Database Designs a whole lot better !
Comment | 
Was this review helpful to you?
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 3.7 out of 5 stars  7 reviews
5 of 5 people found the following review helpful
4.0 out of 5 stars Straight Advice from Serious Designers 25 Nov 1998
By A Customer - Published on Amazon.com
Format:Paperback
With this book, the authors help bring focus to the physical design phase. Practical advice can be found that will apply to most RDBMS implementations, and the Oracle-specific topics are "dead on". Though this book covers Oracle v7, their companion "Oracle8 Design Tips" fills the gaps nicely. In my teaching and consulting practice, this book has helped quite a lot. I rarely leave home without it.
4 of 4 people found the following review helpful
5.0 out of 5 stars For Designers, techies and smart users 13 Jan 2003
By Barbara Lauridsen - Published on Amazon.com
Format:Paperback
"Oracle Design" covers the classic steps to accomplish a complete and comprehensive relational database design. This is a book for designers that DBAs should also read. The authors' strengths are that they know what they are discussing and capture it as recommendations and ideas that can be proven with explicit examples. Why read a book published in 1997? Answer is because it is a smart coherent discussion of all of the key factors, from modeling, normalization (when to and when not to), performance, keys & indexes, loading & unloading, different architectures. They do a very sharp job of covering use of nulls. Of special interest is the chapter on temporal data, a characteristic known as "data effectively", designing for values as a point in time. In the data warehouse world, using time dimension is a significant dilemma. We can overlook the dated reference to 3GL tools, swap in knowing that today OLAP tools are a consideration. The book also covers the physical aspects of designing for efficient queries, security and audit trails. The publisher should support the reader by expanding the index and including a CD in the next release in order to make the excellent examples retrievable electronically. For those of us that became hooked on RDBMS because of the improvements offered by Oracle7 series, we can now understand what the big deal is. This book is a solid foundation in the intelligence we need to design effectively for any version of Oracle since rules placed on the server became an option. At full price it would be worth the money but it available at a discount. A very excellent purchase if there are any copies left after I recommend it to my students.
3 of 3 people found the following review helpful
5.0 out of 5 stars Unique book on Design 27 July 1999
By A Customer - Published on Amazon.com
Format:Paperback
By far, the most entertaining Oracle book I have read (and re-read). The book could benefit from some proof-reading and typo-fixing. But it is an excellent reference, and a useful resource for anybody in or interviewing for an Oracle Designer/Developer kind of job.
1 of 1 people found the following review helpful
4.0 out of 5 stars Well written overview of Oracle 7 15 Sep 1998
By A Customer - Published on Amazon.com
Format:Paperback
A great overview of database concepts and how they apply to Oracle. Well written, in plain, easy to understand language.
1 of 2 people found the following review helpful
2.0 out of 5 stars Good ideas, bad presentation 10 April 2000
By A Customer - Published on Amazon.com
Format:Paperback
I was required to purchase and use this book for an Oracle database design class.
Although the authors are experienced DBAs and have good ideas on database design and implementation, they convey their ideas rather poorly. They don't deal with topics one at a time and jump from one idea to the next at times within one paragraph. This book has good ideas, but one has to read this book several times and also must be an intermediate to an advanced level Oracle developer to get the most out of it.
Were these reviews helpful?   Let us know
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

Search Customer Discussions
Search all Amazon discussions
   


Look for similar items by category


Feedback