DB2 Express Easy Development and Administration | Date: 19 January 2011, 06:26
|
Introduction Among the dozens of major enhancements delivered in DB2 version 8.2 are features created specifically for deployment in small and medium-sized businesses (or in departments within large businesses) where highly skilled database administrators are not available. This book shows you how to leverage these features to dramatically reduce time to market and total cost of ownership for solutions built on DB2. About This Book This book is a concise guide for developing and deploying a DB2 application from the ground up. You will be guided through every step of the way, including Installing DB2 for Windows Creating databases and objects Developing an application Performance tuning Deploying to production and configuring automatic maintainence Troubleshooting techniques To aid your understanding, a sample point-of-sale database application will be developed from start to finish to get you up and running quickly with DB2. We will teach you how to use DB2 tools effectively so that you can focus on what you do best--building applications. When the database application is complete, we'll show you how to deploy the database into production. Each chapter's discussion and examples build on one another, with concrete examples and source code that you can reuse in your own applications. Most chapters have additional exercises to reinforce what you've learned. As you progress through this book you will master core skills to develop and deploy DB2 applications. Code and solutions for each chapter are available from the book's Web site. Who Should Read This Book This book was written for anyone whose day-to-day activities include database application development but whose job description does not include database administration. This book does not discuss advanced database administration; instead it focuses on how to leverage what IBM calls DB2's autonomic (self-managing) capabilities when deployed into production environments where a full-time database administrator may not be available (such as in small and medium-sized businesses). It's been our experience that database application developers just want to get up and running as soon as possible without needing to learn every detail of a product. The DB2 product manuals are very detailed and comprehensive. Although these manuals are good resources for seasoned DB2 application developers, they may not be the ideal starting point for novice DB2 application developers. Therefore, this book is for you if you Are new to DB2 Universal Database Don't want another reference book exhaustively covering every option and feature Don't have the time to learn and memorize command-line commands Just want to cut to the chase: create a database and some objects, load it with data, build an application, and deploy it to production This book Does not assume prior knowledge of DB2 Universal Database (UDB) Is written for anyone who wants to create database applications with minimal grief Shows you how to do the most frequent database application development tasks, using the most common options, while highlighting advanced capabilities Demonstrates how to perform all tasks through graphical tools Shows you how to take an application from design and development to deployment Prerequisites The only skill assumed is a very basic understanding of Structured Query Language (SQL). Some previous database exposure would be beneficial but is not necessary. We will refer to examples that include actual source code. Therefore, you're assumed to have some background in either Visual Basic .NET or Java. Experience with database programming interfaces such as Java Database Connectivity (JDBC) or ADO.NET, however, is not required. What Is DB2 Express? DB2 Express is a member of the DB2 Universal Database family of products. Other members of the family are as follows: DB2 UDB for Linux, UNIX, and Windows Personal Edition Express Edition Workgroup Server Edition and Workgroup Server Unlimited Edition Enterprise Server Edition, with the optional database partitioning facility (DPF) DB2 for z/OS (mainframe) DB2 for iSeries (formerly known as AS400) The Express branding is used to identify IBM software products that have been specifically tailored to meet the needs of small and medium-sized businesses (SMB). "Express" implies simplified installation, enhanced ease of use provided through graphical user interfaces, and autonomic capabilities. DB2 Express has all these qualities while offering professional-grade relational database management features and industry-leading performance. The use of open standards in DB2 simplifies the integration of the product with other software. What's Cool about DB2 Express v8.2 You may have heard about IBM's new major initiative called "on demand." A significant part of this strategy is autonomic computing: software and hardware that is self-managing, self-tuning, and self-healing to reduce the cost and complexity of technology. DB2 v8.2 has industry-leading autonomic technologies that make developing and maintaining DB2 database applications easier. The entire list of new features in DB2 v8.2 is too substantial to list here. Instead, we highlight some key technologies that are relevant to the target audience of this book: Application development features: features that enhance developer productivity Autonomic features: features that are part of DB2's self-monitoring, self-healing, and self-tuning capabilities Application Development Features Application development tooling has been significantly enhanced with DB2 v8.2. For Microsoft Visual Studio .NET Developers An enhanced .NET Data Provider that supports Microsoft's .NET Framework 1.1 and Visual Studio .NET 2003 Support for Microsoft .NET CLR (Common Language Runtime) stored procedures and user-defined functions An enhanced DB2 development add-in for Visual Studio .NET 2003 that allows you to develop for DB2 seamlessly without leaving the Visual Studio .NET development environment For Java Developers Improved DB2 Universal JDBC Driver that supports both JDBC type 2 (client-based) and type 4 (clientless) connections Support for Java Software Development Kit (SDK) 1.4.1 Autonomic Capabilities DB2 provides many features to reduce the strain of database administration. These features work together to automatically manage the health of your database: Automatic database backup Automatic statistics collection Automatic statistics profiling Automatic reorganization Self-tuning backup and restore Autonomic log management Database Design Advisor Database Configuration Advisor Adaptive throttling utilities Health Monitor Learning Objectives After you have completed this book you will be able to Create DB2 Express databases and associated objects Develop applications for DB2 Express databases Apply data manipulation techniques to generate randomized data for testing Tune the performance of your database Work with advanced database objects Package and deploy database applications Set out a strategy for maintaining the database in production
|
DISCLAIMER:
This site does not store DB2 Express Easy Development and Administration on its server. We only index and link to DB2 Express Easy Development and Administration provided by other sites. Please contact the content providers to delete DB2 Express Easy Development and Administration if any and email us, we'll remove relevant links or contents immediately.
|
 |
|
![[HF] How to Cheat at IIS 7 Server Administration](http://i04.s2.imagehosting.ws/2010-11-11/3686/1287069693001799c4mediu.jpg)
Comments (0)
All
