Database professionals can count on being involved in a database migration at least once – and probably more than once – in their careers. Unless the migration involves a small, trivial system, such operations are not insignificant to say the least. Why do migrations occur? While there can be many r
Other News
.NET Remoting and Event Handling in VB .NET, Part 3
(Paul Kimmel) This final installment of the .NET Remoting and Event Handling in VB .NET series takes a closer look at some of the supporting code in the simple chat client and server application that Parts 1 and 2 demonstrated, including the use of the command, observer, singleton, and factory patte
Providing Database Encryption as a Scalable Enterprise Infrastructure Service
(Ulf T. Mattsson) As databases become networked in more complex multi-tiered applications, their vulnerability to external attack grows. We address scalability as a particularly vital problem and propose alternative solutions for data encryption as an enterprise IT infrastructure component. In
A Roadmap to Access DB2 from Java
(John Mallonee) There are several different options for accessing DB2 data from a Java application deployed to a Java 2 Enterprise Edition (J2EE) application server. This article will review some of the primary approaches available, discuss reasons for using them, and provide an overview of each.
Implementing enterprise taxonomies with WebSphere Information Integrator OmniFind Edition
(Wendi L. Pohs, Stephen C. Gates and Jochen Dörre) Add value to your enterprise by structuring your Web content according to a taxonomy. This article describes the characteristics of high-performance enterprise taxonomies, and shows how you can create these taxonomies at relatively low cost by using
Gems from the Mines: 2002 to 2003
(Uche Ogbuji) In previous articles, I have worked through the archives of the XML-SIG mailing list to gather some of the most useful bits of code and threads of discussion that are still relevant. The previous articles are “Gems From the Archives ” (published Apr. 9, 2003) and “More Gems From th
How to perform anomaly detection
This tip shows you how to use the PredictCaseLikelihood() DMX function to detect anomalous data.
How To Send Batch SQL Statements to Oracle
It is possible to create a batch of SQL statements that run on Microsoft SQL Server by separating each SQL statement with a semicolon (;). You can achieve similar results when you run Oracle with either the OLE-DB Oracle Provider or Oracle driver (provided with the Microsoft Visual Database Tools) i
Oracle Programming with PL/SQL Collections
(Michael Klaene) PL/SQL applications typically consist of SQL statements intermixed with procedural logic to process data retreived from the database. If compiled as a stored procedure, your PL/SQL code will reside on the server, an ideal place for programs that require intensive database interactio
Extreme Availability with IBM WebSphere and DB2
(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 ther