買這商品的人也買了...
-
深入淺出設計模式 (Head First Design Patterns)$880$695 -
重構─改善既有程式的設計, 2/e (Refactoring: Improving The Design of Existing Code)$800$632 -
DB2 Developer's Guide: A Solutions-Oriented Approach to Learning the Foundation and Capabilities of DB2 for z/OS, 6/e (Paperback)$2,980$2,920 -
笑談軟體工程：敏捷開發法的逆襲－導入 Scrum，讓你的軟體開發人生從黑白變彩色！$550$435 -
JavaScript & jQuery: The Missing Manual 國際中文版, 2/e
$580$458 -
![ASP.NET 4.5 專題實務 [I]－C# 入門實戰篇-cover](https://cf-assets1.tenlong.com.tw/images/71291/medium/9789572240601_bc.jpg)
ASP.NET 4.5 專題實務 [I]－C# 入門實戰篇$780$616 -
Arduino 錦囊妙計, 2/e (Arduino Cookbook, 2/e)$980$774 -
無瑕的程式碼－敏捷軟體開發技巧守則 + 番外篇－專業程式設計師的生存之道 (雙書合購)$940$700 -
$474讓 DB2 跑得更快－DB2 內部解析與性能優化 -
Visual C# 2013 程式設計經典 (書附雙光碟 VS 2013 Express 中文版, 範例檔)$650$514 -
$414Splunk 大數據分析(Big Data Analytics Using Splunk: Deriving Operational Intelligence from Social Media, Machine Data, Existing Data Warehouses, and Other Real-Time Streaming Sources) -
敏捷與 Scrum 軟體開發速成 (The Elements of Scrum)$300$234 -
王者歸來－jQuery 開發權威指南$720$612 -
改變世界的九大演算法 : 讓今日電腦無所不能的最強概念 (Nine Algorithms That Changed the Future: The Ingenious Ideas That Drive Today’s Computers)$360$284 -
實戰雲端作業系統建置與維護－VMware vSphere 5.5 虛擬化全面啟動$690$545 -
Java 網路程式設計, 4/e (Java Network Programming, 4/e)$680$537 -
Eclipse 完全攻略(第三版)：從基礎 Java 到 PDE 外掛開發$620$484 -
Continuous Delivery 中文版：利用自動化的建置、測試與部署完美創造出可信賴的軟體發佈 (Continuous Delivery: Reliable Software Releases through Build, Test, and Deployment Automation)$650$507 -
松本行弘談程式世界的未來$450$383 -
啊哈！圖解演算法必學基礎$350$298 -
養成 iOS 8 App 程式設計實力的 25 堂課－最新 Swift 開發教學(A Practical Guide to Building Your First App from Scratch: Beginning iOS 8 Programming with Swift)$580$452 -
晉身世界第一流程式設計師：188 個完美化 JavaScript 的建議$620$527 -
UNIX\Linux 網絡日誌分析與流量監控$474$450 -
Android 程式設計入門、應用到精通--增訂第三版 (適用 5.X~1.X, Android Wear 穿戴式裝置)$560$442 -
Raspberry Pi 2 Model B$1,680$1,596
相關主題
商品描述
The Definitive Solutions-Oriented Guide to IBM® DB2® for z/OS®: Now Fully Updated for Both v9 and v10!
The largest database tuning performance gains can often be obtained from tuning application code, and applications that use SQL to retrieve data are the best candidates for tuning. This well-organized, easy-to-understand reference brings together more than 100 SQL-related skills and techniques that any developer can use to build and optimize DB2 applications for consistently superior performance.
DB2 tuning expert Tony Andrews (“Tony the Tuner”) draws on more than 20 years of DB2-related experience, empowering you to take performance into your own hands, whether you’re writing new software or tuning existing systems. Tony shows you exactly how to clear bottlenecks, resolve problems, and improve both speed and reliability.
This book fully reflects the latest SQL programming best practices for DB2 V9 and DB2 V10 on z/OS: techniques that are taught in no other book and are rarely covered in general DB2 SQL courses. Drawing on his extensive consulting experience and highly praised training with Themis Inc., Tony also presents practical checklists and an invaluable 15-step methodology for optimizing virtually any DB2 application.
Coverage includes
The largest database tuning performance gains can often be obtained from tuning application code, and applications that use SQL to retrieve data are the best candidates for tuning. This well-organized, easy-to-understand reference brings together more than 100 SQL-related skills and techniques that any developer can use to build and optimize DB2 applications for consistently superior performance.
DB2 tuning expert Tony Andrews (“Tony the Tuner”) draws on more than 20 years of DB2-related experience, empowering you to take performance into your own hands, whether you’re writing new software or tuning existing systems. Tony shows you exactly how to clear bottlenecks, resolve problems, and improve both speed and reliability.
This book fully reflects the latest SQL programming best practices for DB2 V9 and DB2 V10 on z/OS: techniques that are taught in no other book and are rarely covered in general DB2 SQL courses. Drawing on his extensive consulting experience and highly praised training with Themis Inc., Tony also presents practical checklists and an invaluable 15-step methodology for optimizing virtually any DB2 application.
Coverage includes
- Empowering developers on knowing what to do and where to look in resolving performance problems in queries or programs
- Providing many programming and SQL coding examples
- Establishing standards and guidelines that lead to high-performance SQL
- Implementing time-efficient code walkthroughs to ensure that your standards are followed
- Focusing on the small number of SQL statements that consume the most resources
- Identifying simple solutions that deliver the most sizable benefits
- Optimizing performance by rewriting query predicates more efficiently
- Providing a better understanding of SQL optimization and Runstat statistics
- Recognizing opportunities to tweak your code more effectively than the Optimizer
- Optimizing SQL code with COBOL applications
- Efficiently checking for the existence of data, rows, or tables
- Using Runstats’ newest capabilities to consistently optimize paths to data
商品描述(中文翻譯)
《IBM® DB2® for z/OS® 的權威解決方案導向指南：現在已全面更新至 v9 和 v10！》
最大的資料庫調優性能提升通常可以通過調整應用程式代碼來獲得，而使用 SQL 來檢索資料的應用程式是調優的最佳候選者。這本組織良好、易於理解的參考書匯集了超過 100 種與 SQL 相關的技能和技術，任何開發人員都可以使用這些技能來構建和優化 DB2 應用程式，以實現持續卓越的性能。
DB2 調優專家 Tony Andrews（“調優專家 Tony”）擁有超過 20 年的 DB2 相關經驗，讓您能夠掌握性能，無論您是在編寫新軟體還是調整現有系統。Tony 會詳細告訴您如何消除瓶頸、解決問題，並提高速度和可靠性。
本書充分反映了 DB2 V9 和 DB2 V10 在 z/OS 上的最新 SQL 程式設計最佳實踐：這些技術在其他書籍中未曾教授，且在一般的 DB2 SQL 課程中也很少涵蓋。Tony 還根據他豐富的顧問經驗和備受讚譽的 Themis Inc. 培訓，提供實用的檢查清單和一個無價的 15 步驟方法論，以優化幾乎任何 DB2 應用程式。
內容涵蓋：
- 使開發人員了解在查詢或程式中解決性能問題時應該做什麼和查看哪裡
- 提供許多程式設計和 SQL 編碼範例
- 建立導致高性能 SQL 的標準和指導方針
- 實施時間高效的代碼檢查，以確保遵循您的標準
- 專注於消耗最多資源的少數 SQL 語句
- 確定能夠帶來最大利益的簡單解決方案
- 通過更有效地重寫查詢條件來優化性能
- 提供對 SQL 優化和 Runstat 統計的更好理解
- 辨識出比優化器更有效地調整代碼的機會
- 與 COBOL 應用程式優化 SQL 代碼
- 高效檢查資料、行或表的存在性
- 使用 Runstats 的最新功能持續優化資料訪問路徑
