The Data Access Handbook: Achieving Optimal Database Application Performance and Scalability (Paperback)

John Goodson, Robert A. Steward

  • 出版商: Prentice Hall
  • 出版日期: 2009-03-01
  • 定價: $1,650
  • 售價: 8.0$1,320
  • 語言: 英文
  • 頁數: 360
  • 裝訂: Paperback
  • ISBN: 0137143931
  • ISBN-13: 9780137143931
  • 相關分類: JVM 語言資料庫
  • 立即出貨

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

商品描述

The Data Access Handbook

 

Achieving Optimal Database Application Performance and Scalability

 

John Goodson • Robert A. Steward

 

Drive breakthrough database application performance by optimizing middleware and connectivity

 

Performance and scalability are more critical than ever in today’s enterprise database applications, and traditional database tuning isn’t nearly enough to solve the performance problems you are likely to see in those applications. Nowadays, 75-95% of the time it takes to process a data request is typically spent in the database middleware. Today’s worst performance and scalability problems are generally caused by issues with networking, database drivers, the broader software/hardware environment, and inefficient coding of data requests. In The Data Access Handbook, two of the world’s leading experts on database access systematically address these issues, showing how to achieve remarkable improvements in performance of real-world database applications.

 

Drawing on their unsurpassed experience with every leading database system and database connectivity API, John Goodson and Rob Steward reveal the powerful ways middleware affects application performance and guide developers with designing and writing API code that will deliver superior performance in each leading environment. In addition to covering essential concepts and techniques that apply across database systems and APIs, they present many API examples for ODBC, JDBC, and ADO.NET as well as database system examples for DB2, Microsoft SQL Server, MySQL, Oracle, and Sybase.

Coverage includes

 

  • Clearly understanding how each component of database middleware can impact performance and scalability
  • Writing database applications to reduce network traffic, limit disk I/O, optimize application-to-driver interaction, and simplify queries—including examples for ODBC, JDBC, and ADO.NET
  • Managing connections, transactions, and SQL statement execution more efficiently
  • Making the most of connection and statement pooling
  • Writing good benchmarks to predict your application’s performance
  • Systematically resolving performance problems—including eight start-to-finish case-study examples

 

If you’re a software architect, system designer, or database application developer, The Data Access Handbook will be your most indispensable database application performance resource. It’s the one book that focuses on the areas where you can achieve the greatest improvements—whether you’re designing new database applications or troubleshooting existing ones.

 

John Goodson is vice president and general manager of the DataDirect division of Progress Software, a leader in
data connectivity and mainframe integration. For 20 years, he has worked with Sun, Microsoft, and others to develop database connectivity standards such as J2EE, JDBC, ODBC, and ADO. He served on the ANSI H2 committee that built the SQL standard and now participates in the JDBC Expert Group and Java Rowsets standards committees.

 

Rob Steward, vice president of R&D at the DataDirect
division of Progress Software,
is responsible for the development, strategy, and oversight of the company’s data connectivity products. Rob has spent the past 15 years developing high-performing database driver and data providers, including ODBC, JDBC, and ADO.NET.

Both authors have spoken on database application performance at many industry events.

 

Visit www.dataaccesshandbook.com to get the code examples presented in this book and other supplemental information for DB2, MicrosoftSQL Server, MySQL, Oracle, and Sybase.

 

商品描述(中文翻譯)

《資料存取手冊》

達到最佳的資料庫應用程式效能和可擴展性

約翰·古德森(John Goodson)• 羅伯特·A·斯圖爾特(Robert A. Steward)

通過優化中間件和連接性來實現突破性的資料庫應用程式效能

在當今企業資料庫應用程式中,效能和可擴展性比以往任何時候都更加關鍵,傳統的資料庫調整已經遠遠不足以解決您在這些應用程式中可能遇到的效能問題。現在,處理資料請求所花費的時間中,通常有75-95%的時間花在資料庫中介軟體上。當今最嚴重的效能和可擴展性問題通常是由於網路、資料庫驅動程式、更廣泛的軟體/硬體環境以及資料請求的效率低下所引起的。在《資料存取手冊》中,兩位世界領先的資料庫存取專家系統地解決了這些問題,展示了如何在實際的資料庫應用程式中實現顯著的效能改進。

約翰·古德森和羅伯特·斯圖爾特憑藉他們對每個主要資料庫系統和資料庫連接API的無與倫比的經驗,揭示了中間件如何影響應用程式效能的強大方式,並指導開發人員在每個主要環境中設計和編寫API程式碼,以提供卓越的效能。除了涵蓋適用於各種資料庫系統和API的基本概念和技術外,他們還提供了ODBC、JDBC和ADO.NET的許多API範例,以及DB2、Microsoft SQL Server、MySQL、Oracle和Sybase的資料庫系統範例。

內容包括:

- 清楚了解資料庫中介軟體的每個組件如何影響效能和可擴展性
- 編寫資料庫應用程式以減少網路流量、限制磁碟I/O、優化應用程式與驅動程式的互動,以及簡化查詢,包括ODBC、JDBC和ADO.NET的範例
- 更有效地管理連接、交易和SQL語句執行
- 充分利用連接和語句池
- 編寫良好的基準測試以預測應用程式的效能
- 系統地解決效能問題,包括八個從頭到尾的案例研究範例

如果您是軟體架構師、系統設計師或資料庫應用程式開發人員,《資料存取手冊》將成為您最重要的資料庫應用程式效能資源。這是唯一一本專注於您可以實現最大改進的領域的書籍,無論您是設計新的資料庫應用程式還是疑難解答現有應用程式。

約翰·古德森是Progress Software的DataDirect部門副總裁兼總經理,該公司是資料連接和主機整合領域的領導者。他在過去的20年中與Sun、Microsoft等公司合作,開發了J2EE、JDBC、ODBC和ADO等資料庫連接標準。他曾參與建立SQL標準的ANSI H2委員會,現在參與JDBC專家組和Java Rowsets標準委員會的工作。

羅伯特·斯圖爾特是Progress Software的DataDirect部門研發副總裁,負責該公司資料連接產品的開發、策略和監督。羅伯特在過去的15年中開發了高效的資料庫驅動程式和資料提供者,包括ODBC、JDBC和ADO.NET。

兩位作者都曾在各種國際會議上發表演講,並在相關領域的期刊上發表了許多文章。