Expert Oracle Database Architecture

Thomas Kyte, Darl Kuhn

  • 出版商: Apress
  • 出版日期: 2014-11-05
  • 售價: $3,460
  • 貴賓價: 9.5$3,287
  • 語言: 英文
  • 頁數: 824
  • 裝訂: Paperback
  • ISBN: 1430262982
  • ISBN-13: 9781430262985
  • 相關分類: Oracle
  • 無法訂購



Now in its third edition, this best-selling book continues to bring you some of the best thinking on how to apply Oracle Database to produce scalable applications that perform well and deliver correct results. Tom Kyte and Darl Kuhn share 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, then you’ll find that there are few information management problems that you cannot solve quickly and elegantly.

This fully revised third edition covers the developments up to Oracle Database 12c. Significant new content is included surrounding Oracle's new cloud feature set, and especially the use of pluggable databases. Each feature is taught in a proof-by-example manner, not only discussing what it is, but also how it works, how to implement software using it, and the common pitfalls associated with it.

Don’t treat Oracle Database as a black-box. Get this book. Get under the hood. Turbo-charge your career.

  • Revised to cover Oracle Database 12c
  • Proof-by-example approach: Let the evidence be your guide
  • Dives deeply into Oracle Database’s most powerful features

What you’ll learn

  • Develop an evidence-based approach to problem solving
  • Manage transactions in highly concurrent environments
  • Speed access to data through table and index design
  • Manage files and memory structures for performance and reliability
  • Scale up through partitioning and parallel processing
  • Load and unload data to interface with external systems

Who this book is for

Expert Oracle Database Architecture is aimed at Oracle Database administrators, at PL/SQL and Java developers writing code to be deployed inside the database, and at developers of external applications who use Oracle Database as a data store. It is the go-to book for those wishing to create efficient and scalable applications.

Table of Contents

  1. Developing Successful Oracle Applications
  2. Architecture Overview
  3. Files
  4. Memory Structures
  5. Oracle Processes
  6. Locking and Latching
  7. Concurrency and Multi-versioning
  8. Transactions
  9. Redo and Undo
  10. Database Tables
  11. Indexes
  12. Datatypes
  13. Partitioning
  14. Parallel Execution
  15. Data Loading and Unloading


這本暢銷書的第三版繼續為您帶來如何應用Oracle Database來製作可擴展且性能良好、結果正確的應用程式的最佳思考。Tom Kyte和Darl Kuhn分享了一個簡單的理念:“你可以將Oracle視為黑盒,只需將數據放入其中,或者你可以了解其工作原理並將其作為強大的計算環境來利用。”如果您選擇後者,您會發現幾乎沒有信息管理問題是您無法迅速且優雅地解決的。

這本完全修訂的第三版涵蓋了Oracle Database 12c的最新發展。其中包括Oracle的新雲功能集,特別是可插入式數據庫的使用。每個功能都以實例證明的方式進行教授,不僅討論了它是什麼,還討論了它的工作原理、如何使用它來實現軟件以及與之相關的常見問題。

不要將Oracle Database視為黑盒。獲取這本書。深入了解內部運作。加速您的職業生涯。

這本書的目標讀者包括Oracle Database管理員、在數據庫內部部署代碼的PL/SQL和Java開發人員,以及使用Oracle Database作為數據存儲的外部應用程序開發人員。對於那些希望創建高效且可擴展應用程式的人來說,這是一本必讀的書籍。

1. 開發成功的Oracle應用程式
2. 架構概述
3. 檔案
4. 記憶體結構
5. Oracle進程
6. 鎖定和閂鎖
7. 並發和多版本控制
8. 事務
9. 重做和撤銷
10. 數據庫表
11. 索引
12. 數據類型
13. 分區
14. 平行執行
15. 數據加載和卸載