Oracle Database Transactions and Locking Revealed: Building High Performance Through Concurrency

Kuhn, Darl, Kyte, Thomas

  • 出版商: Apress
  • 出版日期: 2020-10-15
  • 售價: $1,900
  • 貴賓價: 9.5$1,805
  • 語言: 英文
  • 頁數: 273
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 148426424X
  • ISBN-13: 9781484264249
  • 相關分類: Oracle資料庫
  • 立即出貨 (庫存=1)

買這商品的人也買了...

商品描述

Access much-needed information for building scalable, high-concurrency applications and deploying them against the Oracle Database. This new edition is updated to be current with Oracle Database 19. It includes a new chapter with troubleshooting recipes to help you quickly diagnose and resolve locking problems that are urgent and block production.
Good transaction design is an important facet of highly-concurrent applications that are run by hundreds, even thousands, of users who are executing transactions at the same time. Transaction design, in turn, relies on a good understanding of how the database engine manages the locking of resources to prevent access conflicts and data loss that might otherwise result from concurrent access to data in the database. This book provides a solid and accurate explanation of how locking and concurrency are dealt with by Oracle Database. You will learn how the Oracle Database architecture accommodates user transactions, and how you can write code to mesh with the way in which Oracle Database is designed to operate.
Oracle Database Transactions and Locking Revealed covers in detail the various lock types, and also different locking schemes such as pessimistic and optimistic locking. Then you will learn about transaction isolation and multi-version concurrency, and how the various lock types support Oracle Database's transactional features. You will learn tips for transaction design, as well as some bad practices and habits to avoid. Coverage is also given to redo and undo, and their role in concurrency. The book is loaded with insightful code examples that drive home each concept. This is an important book that anyone developing highly-concurrent applications will want to have handy on their shelf.

What You Will Learn

  • Avoid application lockups due to conflicts over accessing the same resource
  • Understand how Oracle prevents one application from overwriting another's modifications
  • Create transaction designs that mesh with how Oracle Database is designed
  • Build high-throughput applications supporting thousands of concurrent users
  • Design applications to take full advantage of Oracle's powerful database engine
  • Gain a fundamental knowledge of Oracle's transaction and locking architecture
  • Develop techniques to quickly diagnose and resolve common locking issues

Who This Book Is For
Oracle developers and database administrators faced with troubleshooting and solving deadlocks, locking contention, and similar problems that are encountered in high-concurrency environments; and application developers wanting to design their applications to excel at multi-user concurrency by taking full advantage of Oracle Database's multi-versioning and concurrency support

商品描述(中文翻譯)

為了建立可擴展且高併發應用程式,並將其部署在Oracle Database上,您可以獲取所需的資訊。這本新版已更新至與Oracle Database 19相符。它包含了一個新章節,提供疑難排解的解決方案,以幫助您快速診斷和解決緊急的阻塞產生的鎖定問題。

良好的交易設計是高併發應用程式的重要方面,這些應用程式由數百甚至數千個使用者同時執行交易。交易設計則依賴於對資料庫引擎如何管理鎖定資源以防止存取衝突和資料損失的良好理解,否則可能會導致對資料庫中的資料進行並行存取。本書提供了關於Oracle Database如何處理鎖定和併發性的堅實且準確的解釋。您將學習Oracle Database架構如何容納使用者交易,以及如何編寫與Oracle Database設計操作方式相匹配的程式碼。

《Oracle Database Transactions and Locking Revealed》詳細介紹了各種鎖定類型,以及悲觀鎖定和樂觀鎖定等不同的鎖定方案。然後,您將學習事務隔離和多版本併發性,以及各種鎖定類型如何支援Oracle Database的事務功能。您將學習交易設計的技巧,以及一些要避免的不良實踐和習慣。書中還提供了關於重做和撤銷以及它們在併發性中的角色的內容。本書充滿了深入的程式碼示例,以強調每個概念。這是一本重要的書籍,任何開發高併發應用程式的人都會希望在書架上隨手可得。

您將學到什麼

- 避免因為存取相同資源而導致應用程式鎖定
- 了解Oracle如何防止一個應用程式覆蓋另一個應用程式的修改
- 創建與Oracle Database設計相匹配的交易設計
- 構建支援數千個並發使用者的高吞吐量應用程式
- 設計應用程式以充分利用Oracle強大的資料庫引擎
- 獲得對Oracle事務和鎖定架構的基本知識
- 開發快速診斷和解決常見鎖定問題的技巧

本書適合對象

- 面臨在高併發環境中解決死結、鎖定爭用等問題的Oracle開發人員和資料庫管理員
- 應用程式開發人員希望通過充分利用Oracle Database的多版本和併發支援,設計出在多用戶併發性方面表現出色的應用程式的人

作者簡介

Darl Kuhn is a senior-level database administrator with decades of experience. He handles all facets of database administration from design and development to production support. He enjoys documenting and sharing knowledge and has authored several books on Oracle technology.

Thomas Kyte is a former vice president of the Core Technologies Group at Oracle Corporation. He is the same Tom who created the "Ask Tom" website and the Oracle Magazine column of the same name. He has a long history of answering questions about the Oracle database and tools that developers and database administrators struggle with every day.

作者簡介(中文翻譯)

Darl Kuhn是一位具有數十年經驗的高級資料庫管理員。他負責從設計和開發到生產支援的所有資料庫管理工作。他喜歡記錄和分享知識,並撰寫了幾本關於Oracle技術的書籍。

Thomas Kyte是Oracle Corporation核心技術組的前副總裁。他就是那個創建了「Ask Tom」網站和同名Oracle Magazine專欄的Tom。他長期以來一直回答關於Oracle資料庫和開發人員、資料庫管理員每天都在努力解決的問題。