(Mayank Pradhan) The annotated XML schema decomposition feature, introduced in DB2 Viper, can be used to decompose XML documents, wholly or partially, into relational tables. It uses annotations in XML Schema as the mapping language to map information in an XML document to relational tables. The
Other News
Key factors to consider when evaluating third-party file cache systems with SQL Server
This article outlines some of the key factors customers should be aware of when evaluating a third-party file caching system.
Frequent Flier
(Kim Moutsos) As a teenager working part-time hanging tapes, Susan Lawson couldn’t have imagined that her technology interests would eventually take her to Beijing and back, with many exotic stops in between.
Configure Windows Firewall to allow SQL Server connections
(Serdar Yegulalp) The Windows Firewall, which ships standard with Windows Server 2003 in all its incarnations, provides a basic level of protection. It’s nothing spectacular, but it’s a good first line of defense in the absence of more sophisticated products like Microsoft’s own ISA Server or a hard
Open source EnterpriseDB takes aim at Oracle customers
(Mark Brunelli) Open source software vendor EnterpriseDB Corp. kicked off the Collaborate ’06 conference today by unveiling new functionally designed to make it easier for Oracle users to switch to EnterpriseDB’s namesake PostgreSQL-based database management system. (R)
The Beginning of AJAX Standardization
(Pawe³ G³owacki) The W3C is not sleeping. A few weeks ago, the first working draft of the The XMLHttpRequest Object specification was published. The beginnings of this standard may have huge implications for AJAX and Atlas programmers. This is an important step for highly interactive Web application
Serializing XML with stylesheet
(cmumford) The Microsoft .NET framework makes it very easy to serialize an object to XML. It has its shortcomings which I won’t go into here, but all-in-all, it is quite useful. Something I’ve wanted to do for some time now is to write out (serialize) an object in XML format while including a styles
Oracle/PLSQL: ORA-04091 Error
A statement executed a trigger or custom PL/SQL function. That trigger/function tried to modify or query a table that is currently being modified by the statement that fired the trigger/function.
Capacity Planning as a Performance Tuning Tool—Case Study for a Very Large Database Environment
This article discusses the performance and scaleability impact due to severe CPU and I/O bottlenecks in a very large database (over 20 terabytes). It describes the methodologies used to collect performance data in a production environment, and explains how to evaluate and analyze the memory, CPU, ne
Looping, Branching, Selecting and Using XML To Read a File
(Dan Mabbutt) Let’s review the goal of the program. I want a “copy and paste” signature block that I can add to messages. I find that I often want to make small changes in the signature block that is automatically added in my email program and using a signature block in a lot of tools, like newsgrou