(Benoît Marchal) SOAP’s strength is that it builds on the familiar and widely deployed Web infrastructure. That can also be a weakness because Web servers can make assumptions about Web services that are simply not true. In this installment, we discuss some issues with error handling in Web services
Other News
The Many Faces of XML
(Kelli Wiseth) Before the advent of Extensible Markup Language (XML), enterprises that wanted to integrate either systems or data had just a few choices. They could implement gateways to support interactions among disparate systems. They could create central data or message hubs, into which all comm
A survey of XML standards: Part 3
(Uche Ogbuji) The world of XML is vast and growing, with a huge variety of standards and technologies that interact in complex ways. It can be difficult for beginners to navigate the most important aspects of XML, and for users to keep track of new entries and changes in the space. XML is a basic sy
Database Optimization: The logic of the User Mode Scheduler in SQL Server
(Mark Kaelin) Achieving and maintaining optimal operational performance is the holy grail of every database designer and administrator who has created a normalized table. And, like that elusive icon, the search is seemingly never-ending and all-consuming. Before you can optimize a SQL Server dat
SQL Server 2000 DTS Part 9 – DTS Designer Tasks
(Marcin Policht) In our previous article, we started discussing basic principles and applications of the Transform Data task. We will continue this topic here, focusing on its more advanced features. So far, we have described the purpose of four of the tabs of the Transform Data Task Properties dial
IBM DB2 Data Archive Expert for z/OS: Put Your Data in Its Place
(Paolo Bruni) Databases are growing tremendously. Because of legal requirements, or trend analysis, or need for historical data, terabytes of data are kept on-line causing performance and operational problems. Not all data is frequently accessed though, nor needs to be kept on fast media. Here archi
Lightweight XML Search Servers, Part 2
(Jon Udell) In last month’s installment I showed a simple search service that uses libxslt to reduce a file of XML content (my weblog writing) to just the elements matching an XPath expression. This month’s challenge was to scale up to a database-backed implementation using Berkeley DB XML. Sinc
DSS Performance in Oracle Database 10g
Two of the key requirements for data warehouses are to improve performance and to reduce manageability costs. Oracle Database 10g delivers on both requirements by providing significant performance enhancements automatically, with no extra deployment costs or resources to implement these enhancements
DB2 UDB for LUW V8 SQL Enhancements
(Julian Stuhler) Welcome to the fourth and final part of our exploration of the new features in Version 8 of DB2 UDB for Linux, UNIX and Windows. This time round, we’re going to look at some of the many SQL enhancements that can be found in the new release. DB2 UDB for Linux, UNIX and Windows has
Using DB2 routines to ease migration
(Marina Greenstein, Art Sammartino and Knut Stolze) Migrating to DB2 from another RDBMS? Here are some routines that will help you easily migrate some frequently-used functionality in other database products.