(David Kershaw) This morning I find myself pondering one of the more subtle coincidences of my daily life: this month my company, Altova, launched not only a formal standards-based XML certification exam, but also new training classes for our first systems integration-oriented tool, MAPFORCE. Beyond
Other News
BumbleBee, the XQuery Test Harness
(Jason Hunter) Will XQuery be the key that unlocks a new generation of data and content? My money, and the vendor money, says yes. Nearly every vendor, from the well-known old guard (IBM, Oracle, and Microsoft) to the plucky upstarts (Cerisent, X-Hive, and Qizx) has expressed their support for XQuer
Use Oracle’s DBMS_APPLICATION_INFO to Prevent Routines from Running Simultaneously
(Amar Kumar Padhi) On occasion, it may be necessary to implement business logic where, when one routine or business process is being run by a user, certain other routine(s) should not be allowed to run and vice versa. This requirement may be a functional or a technical need.
What’s Your Problem?
(Robert L. Welgan) IBM DB2 Universal Database (UDB) administrators have a real challenge on their hands when trying to succinctly describe their system configuration to IBM support for problem resolution. After all, there are many configuration parameters and database characteristics to describe. Th
Blank Lines and Beginning Spaces with DBMS_OUTPUT.PUT_LINE
(Pasupuleti Sailaja) To display a blank line you can use chr(0) with DBMS_OUTPUT.PUT_LINE. To display beginning spaces you can use chr(9) or chr(160) with DBMS_OUTPUT.PUT_LINE.
MS SQL Server Distributed Partitioned Views
(Don Schlichting) This article will explore the use of Distributed Partitioned Views for accessing multiple MS SQL Severs when configured as a Federated Database.
Reorg and runstats in a ksh script
(Venkat Arikatla) You can reorg and runstats in a single ksh script. Install this script as a crontab to run every day during off-peak hours to get maximum performance in DB2. Change @HOME@ to your DB2 home dir and @SCHEMA@ to your database schema name. (R)
How to retrieve the descendants of all the members of a dimension at a specific level or a specific distance by using the Descendants function in SQL Server 2000 Analysis Services Service Pack 3
This article describes how to retrieve the descendants of all the members of a dimension at a specific level or a specific distance by using an enhanced feature of the Descendants function in Microsoft SQL Server 2000 Analysis Services Service Pack 3 (SP3).
This Way Failure Lies
(Dorian Pyle) Nine simple rules you won’t want to follow. Not all mining projects are successful. This pronouncement may come as a surprise (but it probably won’t). Some mining projects are successful — sometimes spectacularly so. The fact that this second pronouncement may come as a surprise to
Simplifying Your Application Development with the SQL MERGE Statement
(Roman B. Melnyk and Paul C. Zikopoulos) Today’s efficient businesses strive to balance the cost savings of a just-in-time (JIT) inventory system with the potential for lost sales resulting from stock-out situations. A common database design for a JIT procurement system is to have a “master” table t