|
Oracle Design
 |
Author: Ian Stevenson, Dave Ensor
List Price: $49.95
Our Price: Click to see the latest and low price
ISBN: 1565922689
Publisher: O'Reilly & Associates (01 March, 1997)
Edition: Paperback
Sales Rank: 24,014
Average Customer Rating: 3.71 out of 5
|
Customer ReviewsRating: 5 out of 5
For Designers, techies and smart users
"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.
Rating: 2 out of 5
Good ideas, bad presentation
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.
Rating: 5 out of 5
Unique book on Design
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.
Similar Products
· Oracle PL/SQL Programming, Third Edition
· Oracle PL/SQL Interactive Workbook (2nd Edition)
· Oracle Essentials : Oracle9i, Oracle8i & Oracle8 (2nd Edition)
· Oracle in a Nutshell
· Oracle Data Dictionary Pocket Reference
|
