(Erika Morphy) IBM is adding new technologies to its content management portfolio, with a focus on managing unstructured data with improved XML handling. The additions to DB2 content manager and DB2 document manager will help customers graphically design content flow.

(Gilles Roux) Developing an Apache Derby application involves performing many tasks, such as creating and connecting to a database, writing a Java Java Database Connectivity (JDBC) client application and stored procedures, and deploying the resulting pieces to a production environment. Discover how

David W. Coleman and Charles F. Bowman) Availability has always been a key measure for IT infrastructures. Unfortunately, achieving high availability is quite difficult. Complicating any effort to attain high availability is that there is usually no simple stopping point — in almost all cases there

(Philip Howard) IBM, and especially the DB2 group, is referring to itself as a business intelligence vendor. How realistic is this and, even if it is realistic, how much will it take to persuade the market to think of IBM in this way?

(Jianing Fan) If you are an Informix DBA, do you want to know how to create tables and indexes more efficiently? In order to achieve better performance, you need to think of the physical aspect of your database before you create tables and indexes. The author elaborates on each of those consideratio

(V. Markl, G. M. Lohman and V. Raman) Structured Query Language (SQL) has emerged as an industry standard for querying relational database management systems, largely because a user need only specify what data are wanted, not the details of how to access those data. A query optimizer uses a mathema

(Rohit Malhotra) Daffodil Software, a Java database and replication technology company, has released Daffodil Replicator v1.6 (an open source data replication tool), equipped with the much awaited IBM DB2 support. This version also provides for increased performance and high data availability.

(Jamie Nisbet and Jack Ng) Using the partitioning feature of DB2 Universal Database Enterprise Server Edition? For peak performance, you’ll want to understand how to tune Fast Communication Manager, the DB2 UDB component that handles communication between partitions. This article explains how it wor

(Wei Shi, Qi Deng and Boyong Liang) The pre-computation of data cubes is critical to improving the response time of On-Line Analytical Processing (OLAP) systems and can be instrumental in accelerating data mining tasks in large data warehouses. In order to meet the need for improved performance

(Danna Nicholson) An IBM DB2 Universal Database (UDB) user-defined function allows you to build functions that meet your business needs. Learn how to use WebSphere Studio Application Developer to develop DB2 SQL user-defined functions.