Expert Oracle Exadata (Paperback)
暫譯: 專家級 Oracle Exadata (平裝本)

Kerry Osborne, Randy Johnson, Tanel Poder

  • 出版商: Apress
  • 出版日期: 2011-08-09
  • 售價: $2,030
  • 貴賓價: 9.5$1,929
  • 語言: 英文
  • 頁數: 588
  • 裝訂: Paperback
  • ISBN: 1430233923
  • ISBN-13: 9781430233923
  • 相關分類: Oracle
  • 已過版

相關主題

商品描述

Throughout history, advances in technology have come in spurts. A single great idea can often spur rapid change as the idea takes hold and is propagated, often in totally unexpected directions. Exadata embodies such a change in how we think about and manage relational databases. The key change lies in the concept of offloading SQL processing to the storage layer. That concept is a huge win, and its implementation in the form of Exadata is truly a game changer. 

Expert Oracle Exadata will give you a look under the covers at how the combination of hardware and software that comprise Exadata actually work. Authors Kerry Osborne, Randy Johnson, and Tanel Põder share their real-world experience, gained through multiple Exadata implementations with the goal of opening up the internals of the Exadata platform. This book is intended for readers who want to understand what makes the platform tick and for whom—"how" it does what it is does is as important as what it does. By being exposed to the features that are unique to Exadata, you will gain an understanding of the mechanics that will allow you to fully benefit from the advantages that the platform provides.

  • Will changes the way you think about managing SQL performance and processing
  • Provides a roadmap to laying out the Exadata platform to best support your existing systems
  • Dives deeply into the internals, removing the “black box” mystique and showing how Exadata actually works

What you’ll learn

  • Configure Exadata from the ground up
  • Optimize for mixed OLTP/DW workloads
  • Migrate large data sets from existing systems
  • Connect Exadata to external systems
  • Support consolidation strategies using the Resource Manager
  • Configure high-availability features of Exadata, including real application clusters (RAC) and automatic storage management (ASM)
  • Apply tuning strategies utilizing the unique features of Exadata

Who this book is for

Expert Oracle Exadata is for database administrators and developers who want to understand what makes Exadata unique so that they can take advantage of all the platform has to offer. It is also for anyone who needs to plan and execute migrations of systems to the Exadata platform. Finally, the book will be invaluable to those who support and maintain such systems.

Table of Contents

  1. What Is Exadata?
  2. Offloading / Smart Scan
  3. Hybrid Columnar Compression
  4. Storage Indexes
  5. Exadata Smart Flash Cache
  6. Exadata Parallel Operations
  7. Resource Management
  8. Configuring Exadata
  9. Recovering Exadata
  10. Exadata Wait Events
  11. Understanding Exadata Performance Metrics
  12. Monitoring Exadata Performance
  13. Migrating to Exadata
  14. Storage Layout
  15. Compute Node Layout
  16. Unlearning Some Things We Thought We Knew

商品描述(中文翻譯)

歷史上,技術的進步往往是突發性的。單一的偉大想法常常能促進快速變革,因為這個想法被接受並推廣,通常會朝著完全意想不到的方向發展。Exadata 代表了我們對關聯式資料庫的思考和管理方式的重大變革。這一變化的關鍵在於將 SQL 處理卸載到儲存層的概念。這一概念是一個巨大的勝利,而其以 Exadata 形式的實現確實是遊戲規則的改變者。

Expert Oracle Exadata 將讓您深入了解組成 Exadata 的硬體和軟體的實際運作。作者 Kerry OsborneRandy JohnsonTanel Põder 分享了他們在多次 Exadata 實施中獲得的實際經驗,目的是揭示 Exadata 平台的內部運作。本書適合那些希望了解該平台運作原理的讀者,對他們來說,'如何' 做到這一點與它所做的事情同樣重要。通過接觸 Exadata 獨特的功能,您將能夠理解其機制,從而充分利用該平台所提供的優勢。

  • 將改變您對管理 SQL 性能和處理的思考方式
  • 提供一個路線圖,以最佳方式佈局 Exadata 平台以支持您現有的系統
  • 深入探討內部運作,消除“黑箱”神秘感,展示 Exadata 實際運作的方式

您將學到什麼

  • 從零開始配置 Exadata
  • 針對混合 OLTP/DW 工作負載進行優化
  • 從現有系統遷移大型數據集
  • 將 Exadata 連接到外部系統
  • 使用資源管理器支持整合策略
  • 配置 Exadata 的高可用性功能,包括實際應用集群 (RAC) 和自動儲存管理 (ASM)
  • 應用利用 Exadata 獨特功能的調整策略

本書適合誰

Expert Oracle Exadata 適合希望了解 Exadata 獨特之處的資料庫管理員和開發人員,以便他們能夠利用該平台所提供的所有優勢。它也適合需要計劃和執行系統遷移到 Exadata 平台的任何人。最後,本書對於支持和維護這些系統的人來說將是無價的。

目錄

  1. 什麼是 Exadata?
  2. 卸載 / 智能掃描
  3. 混合列壓縮
  4. 儲存索引
  5. Exadata 智能快閃快取
  6. Exadata 並行操作
  7. 資源管理
  8. 配置 Exadata
  9. 恢復 Exadata
  10. Exadata 等待事件
  11. 理解 Exadata 性能指標
  12. 監控 Exadata 性能
  13. 遷移到 Exadata
  14. 儲存佈局
  15. 計算節點佈局
  16. 重新學習我們認為已知的某些事物