DB2 Express: Easy Development and Administration (Paperback)
暫譯: DB2 Express:簡易開發與管理(平裝本)
Paul Yip, Kit Man Cheung, Jason Gartner, Clara Liu, Stephen J O'Connell
相關主題
商品描述
IBM DB2 UDB Express Edition Version 8.2 delivers everything small to medium-sized businesses need to accelerate time-to-value and dramatically reduce TCO in their database applications. Now, IBM's own experts show exactly how to get started with DB2 Express, and use it to develop, deploy, and manage superior applications from start to finish.
Like DB2 Express itself, this book cuts out the complexity--helping you achieve the full business benefits of today's most advanced database platform simply and quickly. You'll find step-by-step guidance and expert tips for every facet of DB2 Express development and administration, including: application design; development with both Visual Basic .NET and Java; security; deployment; performance tuning; day-to-day administration; and more.
IBM's own DB2 specialists demonstrate how to use DB2 Express' graphical tools to manage DB2 more easily than any other full-function relational database. Along the way, they help you make the most of DB2 Express' powerful "autonomic" features for self-administration, self-tuning, and self-healing to drive down costs throughout the entire application lifecycle.
This book will help you:
- Understand DB2 Express architecture and its implications for development and administration
- Install DB2 Express, create databases, and master essential DB2 Express tools
- Work with database objects: schemas, data types, tables, relationships, views, and indexes
- Develop VB.NET applications with ADO.NET and the DB2 .NET Data Provider
- Develop Java applications with JDBC and SQLJ
- Leverage DB2's concurrency model to design efficient transactions and improve user experience
- Introduce database functions, stored procedures, and triggers to improve application design
- Generate and manipulate data efficiently: LOAD, IMPORT, exporting to Microsoft Excel, reporting, and more
- Tune performance: optimize your configuration, analyze SQL with Visual Explain, and optimize SQL with Design Advisor
- Secure your applications: authentication, authorization, group privileges, and more
- Deploy to production, and master silent DB2 installations
- Define a solid database maintenance plan that fully leverages DB2 Express autonomic features
- Troubleshoot DB2 Express and avoid common pitfalls
Whether you're a developer, administrator, IT manager, or end-user, this definitive single-source guide will help you achieve results fast... and maximize DB2 Express' business value, every step of the way.
0131463977B08252004
商品描述(中文翻譯)
IBM DB2 UDB Express Edition 版本 8.2 提供中小型企業所需的一切,以加速價值實現並顯著降低其資料庫應用程式的總擁有成本 (TCO)。現在,IBM 的專家將詳細說明如何開始使用 DB2 Express,並利用它從頭到尾開發、部署和管理優越的應用程式。
與 DB2 Express 本身一樣,本書簡化了複雜性,幫助您快速簡單地實現當今最先進的資料庫平台的全部商業利益。您將找到針對 DB2 Express 開發和管理的每個方面的逐步指導和專家提示,包括:應用程式設計;使用 Visual Basic .NET 和 Java 的開發;安全性;部署;性能調優;日常管理;等等。
IBM 的 DB2 專家展示了如何使用 DB2 Express 的圖形工具,比其他任何全功能關聯資料庫更輕鬆地管理 DB2。在此過程中,他們幫助您充分利用 DB2 Express 強大的「自動化」功能,以實現自我管理、自我調整和自我修復,從而降低整個應用程式生命週期的成本。
本書將幫助您:
- 理解 DB2 Express 架構及其對開發和管理的影響
- 安裝 DB2 Express,創建資料庫,並掌握基本的 DB2 Express 工具
- 使用資料庫物件:架構、資料類型、表格、關係、視圖和索引
- 使用 ADO.NET 和 DB2 .NET Data Provider 開發 VB.NET 應用程式
- 使用 JDBC 和 SQLJ 開發 Java 應用程式
- 利用 DB2 的併發模型設計高效的交易並改善用戶體驗
- 引入資料庫函數、儲存過程和觸發器以改善應用程式設計
- 高效生成和操作資料:LOAD、IMPORT、導出到 Microsoft Excel、報告等
- 調整性能:優化配置,使用 Visual Explain 分析 SQL,並使用 Design Advisor 優化 SQL
- 確保應用程式安全:身份驗證、授權、群組權限等
- 部署到生產環境,並掌握靜默安裝 DB2
- 定義一個穩固的資料庫維護計劃,充分利用 DB2 Express 的自動化功能
- 排除 DB2 Express 的故障並避免常見陷阱
無論您是開發人員、管理員、IT 經理還是最終用戶,這本權威的單一來源指南將幫助您快速達成結果,並在每一步中最大化 DB2 Express 的商業價值。