Expert One-On-One: Oracle - Softcover

Kyte, Thomas

Softcover

ISBN 10: 1861004826 ISBN 13: 9781861004826

Publisher: WROX Press Ltd, 2001

Synopsis

Tom Kyte has a simple philosophy: you can treat Oracle as a black box and just stick data into it or you can understand how it works and exploit it as a powerful computing environment. If you choose the latter course, then you will find that there are few information management problems that you cannot solve quickly and elegantly.

Tom has selected the most important features and techniques and he teaches them in a proof-by-example manner, not only discussing the features available, but also how to implement software using them and indicating the potential pitfalls.

This book covers:

Core database structures and utilities
Performance tuning
Advanced SQL features
Extensibility using C, Java and OR features
Security
Important supplied packages

About this title

Review

In Expert One-on-One: Oracle Thomas Kyte expounds his philosophy of database application development based on the premise that successful development requires a sound knowledge of the database and its internal workings--that the database cannot be treated merely as a black box to and from which data is passed. Equally, that a development project lacking this knowledge will inevitably fail, particularly when attempts are made to scale the resultant application to large scale multiple concurrent use.

This is a big book packed with lots of Oracle insider knowledge including, among other topics, what the various Oracle server processes and files do, what's happening inside the database during a transaction, and the real meaning of the various options available in Oracle's DML and DDL SQL statements. The likely impact of design decisions on application behaviour and performance is also discussed, particularly where this relates to using, or not using, a database feature.

Expert One-on-One: Oracle is likely to be a valuable resource for both Oracle system designers and application developers looking to find out what's really going on inside the database, albeit one that is likely to be dipped into from time to time rather than read from cover to cover. --Michael O'Connor

From the Publisher

This book offers the knowledge required for both those who build Oracle database applications, and those who administer the database.

It is critical that the DBA knows what the developers are trying to accomplish and the best developers know how to exploit the DBA's data management strategies. Armed with the fundamental knowledge of the Oracle environment that Tom describes, you will be able to build bigger, faster, and more scalable applications.

Knowledge of SQL and PL/SQL is assumed and familiarity with any 3GL language (such as C, Java, or Visual Basic) would be useful.

Edition details

• Publisher: WROX Press Ltd
• Publication date: 2001
• Language: English
• ISBN 10: 1861004826
• ISBN 13: 9781861004826
• Binding: Paperback
• Edition number: 1
• Number of pages: 1265