Oracle9i introduces a family of new features to support more scalable and efficient ETL (Extraction, Transformation, Load) processing for data warehouses and business intelligence systems. One of the most significant ETL additions is the Multitable Insert feature. The multitable insert feature a
Other News
Hints and Tips for DB2 Data Warehouse Enterprise Edition
(Sermsak Sukjirawat) DB2 UDB Data Warehouse Enterprise Edition (DWEE), Version 8.1.2, is IBM’s complete business intelligence platform, bringing together DB2 UDB, DB2 UDB Database Partitioning Feature, DB2 Cube Views, DB2 Intelligent Miner Modeling, Scoring and Visualization, DB2 Office Connect, DB2
A Grouping and Subtotaling Repeater for ASP.NET
(Kurt Mang) A recent project had a user interface requirement where data could be displayed two ways: either in chronological order (easy!) or grouped by family member (less easy). Furthermore, if the user selected a family-member sort, the name of the person was to be shown on a line before the dat
Microsoft SQL Server 2000 Desktop Engine MSDE
(Don Schlichting) Microsoft application developers have often been faced with the decision of using a database engine they liked, versus an engine that was affordable to ship with the completed product. In many cases, the price point wins, and the database standards are changed to accommodate the lo
Content Based Routing Web Services in .NET and J2EE
(Jesus Rodriguez) In the recent years Web Services has been adopted by the developers community as one of the most popular ways to build distributed applications. The Web Services adoption in some scenarios demands higher requirements. The Web Service protocols stack WS-* defines protocols that
XML Namespaces Support in Python Tools, Part Three
(Uche Ogbuji) In the last two articles I’ve discussed namespace handling in Python 2.3’s SAX and minidom libraries and in 4Suite. In this article I focus on ElementTree, libxml/Python and PyRXPU. I recommend reading or reviewing those articles first, as well as the earlier articles in this namespace
Performance Baselining, Benchmarking, and Monitoring for SQL Server 2000
It’s impossible to truly tune a SQL Server without a good understanding of its performance profile and work load. This white paper describes techniques and procedures to assess the baseline performance profile of a SQL Server, benchmark the performance of the server under varying work loads, and
FIX: SQL Server Cluster Resource Fails to Come Online Until Cluster Service Is Restarted
If the SQL Server cluster resource is in an "online pending" state and the cluster service sends a termination request to the resource, the resource may not successfully come online again on the node until the cluster service is restarted. The cluster service usually sends a termination request t
By Popular Demand
(David A. Kelly) It’s a difficult and ultimately futile effort to try to categorize a typical Linux-using enterprise today. Consider, for example, Eu Yan Sang (EYS), a 120-year-old company headquartered in Singapore that specializes in traditional Chinese medicine—including some 3,000-year-old herba
MySQL to DB2 UDB Conversion Guide
DB2 Universal Database (DB2 UDB) has long been known for its technology leadership. This IBM Redbook is an informative guide that describes how to migrate the database system from MySQL to DB2 UDB Version 8.1 on Linux, and how to convert applications to use DB2 UDB instead of MySQL. This guide pr