- Paperback: 672 pages
- Publisher: Addison Wesley; 1 edition (18 Dec 2000)
- Language English
- ISBN-10: 0201715848
- ISBN-13: 978-0201715842
- Product Dimensions: 23.4 x 18.6 x 3.6 cm
- Average Customer Review: 5.0 out of 5 stars See all reviews (6 customer reviews)
- Amazon Bestsellers Rank: 1,025,289 in Books (See Top 100 in Books)
- See Complete Table of Contents
| ||||||||||||
 Trade In this Item for up to £0.25
Trade in Practical Oracle8i: Building Efficient Databases for an Amazon.co.uk gift card of up to £0.25, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Find more products eligible for trade-in.
|
Product details |
More About the Author
Product Description
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.
From the Back Cover
What is really involved in building effective Oracle database systems, and how do you approach the endeavor in a way that increases your chances for success?
Practical Oracle8i™ offers a real-life approach to constructing Oracle databases--one that is geared toward solving important business problems. This book will help you devise appropriate strategies for database design that takes into account Oracle's technical underpinnings, hardware and user limitations, and tradeoffs between simplicity and efficiency. It discusses selecting the Oracle features needed to perform specific functions and demonstrates how to structure code most effectively for the features being implemented.
Practical Oracle8i™ presents an overview of Oracle that clearly explains the central functions that are key to Oracle's operation. In addition, the book presents the fundamentals of the system, covering the way in which data is stored, packed, and made visible, as well as the dynamic features involved in transactions and calculations. Specific topics covered include:
- A discussion of why Oracle projects fail
- Leveraging tablespaces
- Partitioning
- LOBs
- Autonomous transactions
- Row-level security for virtual private databases
- Parallel query and parallel server
- The new analytical functions introduced in Oracle 8.1.6
This book also provides a summary of the most useful new features of Oracle 8.1.5, practical tips for tuning performance and testing features, and information on the major space-management features of an Oracle database.
Written by one of the world's most knowledgeable and experienced Oracle database designers and programmers, Practical Oracle8i™ reveals the strategies, techniques, and insights that will enable you to understand the technology's full potential and put Oracle to work for successful database systems.
0201715848B04062001
Inside This Book
(Learn More)
First Sentence
When faced with Oracle for the first time, where is the novice supposed to start? Read the first page
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
When faced with Oracle for the first time, where is the novice supposed to start? Read the first page
Explore More
Concordance
Browse Sample PagesConcordance
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Tag this product(What's this?)Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organise and find favourite items. |
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
|
Share your thoughts with other customers:
|
||||||||||||||||||||||
|
Most Helpful Customer Reviews
7 of 7 people found the following review helpful:
5.0 out of 5 stars
The best Oracle DBA Book on the Market,
By A Customer
This review is from: Practical Oracle8i: Building Efficient Databases (Paperback)
Excellent, the best and most coherent oracle book I have read since the original DBA Handbook by Kevin Loney. A practical and succint review of Oracle 8i features.The regularly updated errata and addendums on Johnathan's website are also particularly useful.
6 of 6 people found the following review helpful:
5.0 out of 5 stars
A must-have for every DBA's/Technical Architect's desk,
By A Customer
This review is from: Practical Oracle8i: Building Efficient Databases (Paperback)
At last! A book that tells it like it is!In the age of The Object, many unenlightened I.T. professionals dismiss the database as a mere "persistent object repository". In other words, a big bucket to put data into. At best this approach results in poor performance - at worse, you're looking at project failure, loss of reputation, dismissal, homelessness, etc. Jonathan Lewis's book is not a magic bullet to solve all Oracle project ills nor is it an easy read. The first chapter alone covers some difficult ground regarding redo and rollback. What becomes immediately apparent is that databases are extremely complex beasts. However, when you put the effort in, take heed of good advice, and, most importantly, prove it to yourself, there is a much greater chance of going live with a champ rather than a chump! If you can get through the (essential) first four chapters unscathed, the rest of the book is plain sailing and, to a certain degree, you can dip into them. However, I wouldn't say that the book contains "tips": It contains "pointers to the right direction and away from the wrong turns". Quite often it is tempting to use a feature of Oracle "because it's there". However, Mr. Lewis tells us whether its worth it of not - preventing much potential time-wasting. Also, to his credit, he isn't afraid to speak out: defending RAID 5, debunking Oracle's Objects, and putting RMAN into its proper perspective. No project involving Oracle should be started without this book being read and understood by all it's key players!
3 of 3 people found the following review helpful:
5.0 out of 5 stars
Outstanding contribution to Oracle usage,
By mark.russell@rousselperier.com (Geneva, Switzerland) - See all my reviews
This review is from: Practical Oracle8i: Building Efficient Databases (Paperback)
Of the many (perhaps too many) Oracle books on the market, Jonathan Lewis' contribution stands out as the most useful to the everyday Oracle practitioner. There are usually many ways to achieve the same result in Oracle ... only experience provides the optimal solution; I thoroughly recommend this book to anyone that wants to know how to make optimal Oracle solutions and avoid the common pitfalls.
Share your thoughts with other customers: Create your own review
Would you like to see more reviews about this item?
|
Most Recent Customer Reviews |
Listmania!
Look for similar items by category
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
|
