(Amyris V. Rada) This article introduces DB2 UDB products and their capabilities, discusses porting databases and applications, and describes the most important aspects of porting applications from Microsoft SQL Server 2000 to DB2 UDB V8. It describes the differences between the two products in data
Other News
Just Like Magic (A look at accidental performance tuning)
(Bonnie Baker) Sometimes we create programs that don’t perform as well as we’d like. We may ignore long runtimes and slow response times for a while, hoping that we’ll eventually find the time to evaluate the program’s access paths and logic and fix the problem. Then one day, for whatever reason, we
A SQL interface for alert log
This is a very handy utility (9i only) which let you query the alert log file from an sql tool (sqlplus/toad /oem …). (script)
Using XML in Reporting Systems
(Casey Kochmer and Erica Frandsen) No matter what the Web application, or where it’s implemented, it’s a safe bet to assume that there will be some reporting involved. Even applications that don’t have databases are likely to have some aspect of reporting. However, non-database systems are more like
Empowering DB2 with your Excel spreadsheets using Apache’s POI and HSSF
(Michael Lee Epley and Kulvir Singh Bhogal) In this article, you’ll learn how to build an application that will allow for the efficient transfer of Microsoft Excel spreadsheet data into a DB2 UDB database using Apache’s POI and HSSF.
Optimizing Your Application – Part 2
(Dinesh Priyankara) My article Optimize your application spoke about web-based application and this is the time to speak about windows-based application. Couple of questions had been arisen regarding first article and I hope that all your questions have been answered now. (R)
DTS Servers and Schedulers for MS SQL
(Muthusamy Anantha Kumar) DTS is a set of graphical tools and programmable objects that let you extract, transform, and consolidate data from disparate sources into single or multiple destinations that can be bundled and saved as a package and executed. In large organizations, it is a usual practice
Supercharging the Pump
(Jonathan Gennick) New import and export features introduced in Oracle Database 10g, called Oracle Data Pump, represent a radical departure from the client/server approach to which database users have grown accustomed over the past several generations of Oracle Database. The server now runs export a
Improving Query Performance Using Materialized XML Views: A Learning-Based Approach
(Ashish Shah and Rada Chirkova) We consider the problem of improving the efficiency of query processing on an XML interface of a relational database, for predefined query workloads. The main contribution of this paper is to show that selective materialization of data as XML views reduces query-e
The Right Solution for Every DB2 Backup and Recovery Need
BMC Software markets a comprehensive, premier line of backup and recovery products for the DB2 OS/390 platform. The product line includes individual DB2 backup and recovery point products that augment the native DB2 utilities with additional functionality and performance. In addition, BMC offers in