Practical Oracle8i(TM): Building Efficient Databases |  | Author: Jonathan Lewis
Publisher: Addison-Wesley Professional
Category: Book
List Price: $49.99
Buy Used: $0.83
as of 9/9/2010 03:39 CDT details
You Save: $49.16 (98%)
New (15) Used (30) from $0.83
Seller: green_earth_books
Rating:  20 reviews
Sales Rank: 654154
Media: Paperback
Edition: 1
Pages: 672
Number Of Items: 1
Shipping Weight (lbs): 2.4
Dimensions (in): 8.9 x 7.1 x 1.5
ISBN: 0201715848
Dewey Decimal Number: 005.7585
UPC: 785342715842
EAN: 9780201715842
ASIN: 0201715848
Publication Date: December 28, 2000
Availability: Usually ships in 1-2 business days
| |
| Similar Items:
| |
| Editorial Reviews:
Product Description
In this book, one of the world's leading Oracle database consultants covers the real-world design and development issues most Oracle books ignore! Jonathan Lewis presents powerful techniques -- and errors to avoid -- if you want to build databases that meet their objectives, stay on budget, scale to support growth, and are easy to manage. Jonathan Lewis focuses on helping database designers and developers answer two essential questions: "How should I think when designing an Oracle-based application? And, how can I select the most appropriate Oracle features for my application, taking into account their interrelationships?" Drawing upon fifteen years experience as an Oracle database designer and consultant, he delivers an intimate understanding of the Oracle database engine, and all the guidance you need to use its key features most effectively. Coverage includes: tables and tablespaces, indexing, temporary space, files, views, partitioning, lots, simple and collection objects, LOBs, integrity, PL/SQL, autonomous transactions, RLS, PQO and OPS, replication, fallback, and much more. For every Oracle database designer, developer, and manager; and for any professional called upon to maintain or optimize Oracle-based databases.
|
| Customer Reviews:
Showing reviews 1-5 of 20
 What works well and what does not December 13, 2000
Steve Adams (Sydney, Australia)
23 out of 25 found this review helpful
Whatever the job, Oracle offers many different ways to do it, and they are not all equal. This book is an invaluable aid in deciding which features to choose and how to use them. Each feature is clearly explained with some real-world illustrations of how it might be used. The author then examines the potential functionality, performance, security, and maintenance traps associated with the feature and concludes with some helpful guidelines on when and how to use it (or not). The style is relaxed and personal, but there is no lack of technical accuracy, and although the main arguments and recommendations are accessible to relative newcomers to Oracle, many of the detailed explanations assume considerable familiarity with Oracle system architecture and performance issues. In summary, this book is particularly valuable for people who are designing new Oracle-based systems, but has plenty of practical advice for all Oracle developers and DBAs.
A break from the norm... January 24, 2001
17 out of 19 found this review helpful
Unlike many other weighty tomes regarding Oracle, this book does much more than reword the 8i Concepts manual. There is a lot in this book, but if you just read the "Problems & Quirks" and "Strategy Notes" sections at the end of each chapter you'll be well on your way to understanding the implications of using 8i features.One concern many people have when experimenting with database features is how to be sure it's working properly. Jonathan's book goes a long way to help with this as with most of his examples, some low-level tracing or queries are provided to prove the point. Overall, a superbly detailed and valuable addition to my Oracle library.
Maybe the best I've found January 30, 2001
13 out of 15 found this review helpful
This may be the best Oracle book I've found so far.A lot of books seem to give canned explanations of how oracle works - geared towards rote memorization as opposed to understanding. This book does a great job of taking the next step. For example, The detail with which the author goes through the process of how updating a row actually works in an Oracle database was tremendous. His explanation of how a select statement could actually cause a row to be marked as committed ( i.e. a read causes a write ) was great. I've only been a DBA (or pseudo-DBA) for about 6 months now, so I'm certainly no expert in this area. Yet I found all of his explanations very clear and easy to understand. If you're looking for a new Oracle book, get this one.
Practical Oracle October 13, 2002
6 out of 6 found this review helpful
I have dozens of Oracle books and this the single best one. I think I'm going to get extra copies so I can assign reading it to everyone who works for me. The content should be the basic starting point of knowledge for serious development and management. I just wish it was updated for 9i
Great Introduction August 14, 2001
8 out of 9 found this review helpful
I can't imagine a better introduction to the Oracle RDBMS. The author's conversational style is more akin to a discussion among colleagues, rather than a professor lecturing a student. A quick scan of the table of contents reveals a clearly organized sequence of topics, making it easy for the reader to dive into a subject of particular interest. By randomly scanning through a half dozen chapters, I was able to quickly develop a solid feel for Oracle's implementation of tables, objects, partitioning, indexing, and data integrity. This text provides a great overview of the Oracle RDBMS, and a solid foundation for any potential database administrators.
Showing reviews 1-5 of 20
|
|
|
