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
This special signature edition includes a CD that contains a searchable PDF version of the book and a sample chapter from the forthcoming 10g edition which will be released in fall 2005.
This remains the defining book on the older 8i Oracle database if you are a developer or DBA who works with Oracle-driven database applications. You will encounter wisdom on designing, developing, and administering these applications from one of the world's foremost Oracle experts, Thomas Kyte.
The book covers every important feature and function of the 8i version of Oracle, and it is unique in the technical depth and insight that it provides on each topic. This book will show you how to expertly program with the database and exploit its feature set effectively. The result: you will build fast, effective, scalable, and secure Oracle applications.
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.
About the Author
Thomas Kyte is vice president of the Core Technologies Group at Oracle Corporation and has been with the company since version 7.0.9 was released in 1993. Kyte, however, has been working with Oracle since version 5.1.5c. At Oracle, Kyte works with the Oracle database, and more specifically, he helps clients who are using the Oracle database and works directly with them specifying and building their systems or rebuilding and tuning them. Prior to working at Oracle, Kyte was a systems integrator who built large-scale, heterogeneous databases and applications for military and government clients.Tom Kyte is the same "Ask Tom" whose column appears in Oracle Magazine, where he answers questions about the Oracle database and tools that developers and database administrators struggle with every day.