Web Services for DB2 Intelligent Miner is a collection of Web services that allow clients to describe and perform basic data-mining tasks using XML, XML Schema, and XPath on top of DB2 Intelligent Miner. It provides simple access to the main functions of DB2 Intelligent Miner Modeling and Scoring wi
Other News
XML Tower of Babel – bring on UBL
(Peter Abrahams) XML is taking over the world for all sorts of good reasons. But just as we thought that it would solve all our problems and let us build a tower up to the gods babble intervenes. (R)
XUL: The Gatekeeper to Higher-level Web UIs
(Laurence Moroney) For almost a year now Microsoft has been touting XAML, its XML Application Markup Language, as being a significant disruptive technology changing how you will develop your applications, and in particular the presentation layer for .NET applications. But thanks to a juggling of
SAMPLE: How to Retrieve Data Using a Template File in ATL OLE DB
OLEDBTemplate.exe demonstrates how to extract an XML stream from a SQL Server 2000 database using an XML template file.
Oracle Tip: Kill runaway Oracle processes on Windows with OraKill
A user’s process will occasionally hang or spin and lock out other sessions. If the DBA still has access to the database, she can usually just issue the following query. (R)
Importing an Oracle text file into SQL Server 2000, part 2
(Greg Robidoux and Jeremy Kadlec) One last item, keep in mind that once the DTS Package is developed it can be scheduled to execute on a regular basis via a SQL Server Agent Job. For more information visit How to schedule a DTS package using the Schedule Package option (Enterprise Manager). (R)
PRB: Missing device causes database to be marked suspect
SQL Server marks a database suspect if any of the device files for the database are unavailable when it attempts to start. You may see either of the following sets of messages in the SQL Server error log.
DB2 UDB Stinger and autonomic computing
(Paul C Zikopoulos and Jessica Escott) In IBM DB2 Universal Database V8.1, a host of rich functional tooling and monitors were implemented in DB2 such that the DB2 database truly began to monitor its own health status – independent of the DBA. DB2 “Stinger" enriches and extends the current autonomic
Recursive Relationships
(Michelle A. Poolet) Supporting a recursive relationship—like you find in a typical bill of materials (BOM)—is one of the hardest problems to solve in relational databases. A BOM is a hierarchical structure that describes relationships among components. For example, a car is made up of component
Fragmentation 101
(Christoffer Hedgate) Even though SQL Server is very good at more or less automatically maintaining most statistics, physical data structuring and configurations etc (especially compared to some of it’s competitors), there are still some situations where you need to perform a little manual work to h