Microsoft's David Turner drew a distinction between structured data,
semi-structured data (e.g., a Purchase Order [PO], which are
structured mainly at the line item level) and unstructured data
(e.g., text documents).
He mentioned some new capabilities in SQL Server 2000's support for
XML, such as a SQL
extension called FORXML, XML Views (XPath to query), and OpenXML (technical implementation of a relational view of XML), specifying
row/column selectors using XPath, and something called Updategrams
and Bulk Load. Readers interested in these topics can search for them
on MSDN.
"With XML support in SQL Server 2000, you can query SQL
over HTTP with a URL, bring the data down to the browser, and
manipulate it on the client machine. By adding Internet Explorer 5.0
to the mix and using XSL to convert the XML to HTML, you can lighten
the load on your database server. "
Turner announced something called XfA. The XML for Analysis
(XfA) beta specification is available from Microsoft's Universal Data Access page. A
beta SDK will be released in early 2001, with the final spec and SDK
in mid 2001, according to Turner. The UDA web site describes XfA
as:
"The XML for Analysis specification advances the OLE DB
standard by allowing standardized, universal data access to
analytical data sources (OLAP and Data Mining) residing over the web.
The specification is built upon open standards and is independent of
platform, language or technology. XML for Analysis is built upon
HTTP, XML and SOAP Internet standards and is specifically optimized
for web services interaction."
For more info on the XML 2000 conference, check out WDVL's complete coverage.
Stonebroom.ASP2XML(c) is an interface component designed to make building
applications that transport data in XML format much easier. It can be used
to automatically pass updates back to the original data source.
Right now the latest buzzword around town is AJAX. AJAX is an acronym for Asynchronous JavaScript and XML and is a method used to implement remote calling. The problem is that AJAX is only implemented in ASP.NET 2.0. This article will show you one way to implement remote calling without using AJAX or the XMLHttpRequest object. The technique outlined can even be used from classic ASP and is sufficient for most remote calling needs. [Read This Article][Top]
This article is the third and final installment of Alex Homer's series covering the new XML support in Microsoft SQL Server 2005. In it he covers updating the contents of xml columns, comparing traditional XML update techniques with XQuery, and using XQuery in a managed code stored procedure. [Read This Article][Top]
In the second part of his series on SQL Server 2005's new XML support, Alex Homer looks at extracting data from XML columns, comparing traditional XML data access approaches with XQuery, and combining XQuery and XSL-T. [Read This Article][Top]
Microsoft SQL Server 2005 now offers great support for and close integration with XML as a data persistence format. In the first article of his series examining this new support, Alex Homer offers an overview of how SQL Server 2005 stores XML documents and schemas, examines how it supports querying and manipulating XML documents, and provides a simple test application that allows you to experiment with XQuery. [Read This Article][Top]
In the final article of his series on reading and writing XML in .NET 2.0, Alex Homer looks at how the updated XML document store objects XmlDocument, XmlDataDocument and PathDocument can be used to read, persist and write XML documents and fragments more easily and more efficiently than in .NET 1.x. [Read This Article][Top]
In the final article of his series on reading and writing XML in .NET 2.0, Alex Homer looks at how the updated XML document store objects XmlDocument, XmlDataDocument and PathDocument can be used to read, persist and write XML documents and fragments more easily and more efficiently than in .NET 1.x. [Read This Article][Top]
Alex Homer continues his series on reading and writing XML in .NET 2.0. In part one, we focused on the reading side of things, examining the XmlReader and XmlReaderSettings classes. In this article, we move on to look at the XmlWriter and XmlWriterSettings classes, and how they can be used to write XML documents and fragments more easily and more efficiently than in version 1.x of .NET. [Read This Article][Top]
Alex Homer continues his series on reading and writing XML in .NET 2.0. In part one, we focused on the reading side of things, examining the XmlReader and XmlReaderSettings classes. In this article, we move on to look at the XmlWriter and XmlWriterSettings classes, and how they can be used to write XML documents and fragments more easily and more efficiently than in version 1.x of .NET. [Read This Article][Top]
In the first part of his series on reading and writing XML in .NET 2.0, Alex Homer discusses the XmlReader and XmlReaderSettings classes. The XmlReader exposes several useful new features and the all new XmlReaderSettings class makes it easy to generate single or multiple instances of an XmlReader with a range of useful properties. [Read This Article][Top]
In the first part of his series on reading and writing XML in .NET 2.0, Alex Homer discusses the XmlReader and XmlReaderSettings classes. The XmlReader exposes several useful new features and the all new XmlReaderSettings class makes it easy to generate single or multiple instances of an XmlReader with a range of useful properties. [Read This Article][Top]
Mailing List Want to receive email when the next article is published? Just Click Here to sign up.
