(Ronald Bourret) This paper gives a high-level overview of how to use XML with databases. It describes how the differences between data-centric and document-centric documents affect their usage with databases, how XML is commonly used with relational databases, and what native XML databases are and

(Edd Dumbill) Jeff Barr, Amazon’s web services evangelist, explained to XML 2003 attendees the decisions facing Amazon in opening up their systems for public use via web services. Barr’s case study, delivered to a full room, formed part of the product presentations track on the first day of the conf

In our XSLT tutorial you will learn what XSLT is. You will learn how to use XSLT to transform XML documents into other XML formats, like XHTML.

(Benoit Marchal) How many times have you witnessed this scenario? Developer: “So the quantity is always stored in the OQTY field?” Administrator: “That’s right. Just pick it up from there.” Developer: (Later) “Could you help me out? These lines have no quantity?” Administrator: “Oh, yeah

(Michael M. David) Part 1 of this article demonstrated how standard ANSI SQL can integrate fully, naturally, and seamlessly with XML. This was accomplished by naturally raising SQL processing to a hierarchical level, enabling relational data (including XML-shredded data) to integrate at a full hiera

(Bob DuCharme) XPath 1.0 has a special data type called Result Tree Fragments. For example, an xsl:variable element can store a single string, but it can also store an XML element with all the descendants and attributes you like. This structure is a Result Tree Fragment. (I try to avoid using the ac

(David S. Linthicum) Although a number of standards exist for information interchange and process definition, industry standards have yet to emerge for defining common integration server and B2B integration server services such as routing, rules processing, and transformation. In the absence of such

The SELECT statement is the most fundamental data access query in SQL Server. It allows you to retrieve and aggregate information from tables in a database and return the results as a rowset. In SQL Server 2000, the FOR XML clause was added as an extension to SELECT, which transforms the rowset outp

This article describes how to insert a column in an XSLT Data View that counts the number of records in that Data View.

(Jeff Browning) Web services provide a way to allow efficient communication between disparate services. For years, enterprises have struggled to find reliable, cost-effective ways to integrate and automate critical processes between different application packages. Web services technology has the pot