Book Image

IBM DB2 9.7 Advanced Application Developer Cookbook

Book Image

IBM DB2 9.7 Advanced Application Developer Cookbook

Overview of this book

With lots of new features, DB2 9.7 delivers one the best relational database systems in the market. DB2 pureXML optimizes Web 2.0 and SOA applications. DB2 LUW database software offers industry leading performance, scale, and reliability on your choice of platform on various Linux distributions, leading Unix Systems like AIX, HP-UX and Solaris and MS Windows platforms. This DB2 9.7 Advanced Application Developer Cookbook will provide an in-depth quick reference during any application's design and development. This practical cookbook focuses on advanced application development areas that include performance tips and the most useful DB2 features that help in designing high quality applications. This book dives deep into tips and tricks for optimized application performance. With this book you will learn how to use various DB2 features in database applications in an interactive way.
Table of Contents (15 chapters)
IBM DB2 9.7 Advanced Application Developer Cookbook
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface

Chapter 3. General Application Design

In this chapter, we will focus on the following recipes related to advanced application development:

  • Improving concurrency by using a connection concentrator

  • Using trusted contexts for improved security

  • Using trusted connections in JDBC

  • Using trusted connections in PHP

  • Securing data using DB2 encryption

  • Improving concurrency by using enhanced optimistic locking

  • Working with user-defined types (UDT)

  • Working with structured types

Introduction

In this chapter, we will look at some advanced techniques that can be used to design efficient applications. We will see how we can improve security in 3-tier architecture applications. We will also look at the various methods of data encryption provided by DB2. Thereafter, we will see how we can extend the data type support provided by DB2 and apply them in our application design.