商品描述
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 Version 8.2提供了小型和中型企業在其數據庫應用程序中加快價值實現和大幅降低總體成本所需的一切。現在，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數據提供程序開發VB.NET應用程序
- 使用JDBC和SQLJ開發Java應用程序
- 利用DB2的並發模型設計高效的事務並改善用戶體驗
- 引入數據庫函數、存儲過程和觸發器以改善應用程序設計
- 高效生成和操作數據：LOAD、IMPORT、導出到Microsoft Excel、報表等
- 調優性能：優化配置、使用Visual Explain分析SQL、使用Design Advisor優化SQL
- 保護應用程序：身份驗證、授權、群組權限等
- 部署到生產環境，並掌握無聲DB2安裝
- 定義一個堅實的數據庫維護計劃，充分利用DB2 Express的自主功能
- 解決DB2 Express的問題，避免常見陷阱
無論您是開發人員、管理員、IT經理還是最終用戶，這本權威的單一來源指南將幫助您快速實現結果，並最大限度地發揮DB2 Express的商業價值，每一步都有所助益。
