Tutorial eBooks PDF File Download

ABSTRACT Microsoft SQL Server™ has a long history of XML support dating back to 1999. While first concentrating on enabling the transport of relational data via XML with the SQL Server 2000 release, SQL Server 2005 now additionally provides native XML storage and query support. This part of the tutorial will provide an insight into how SQL Server 2005 fits XML functionality into its core relational database management framework. To address this need, SQL Server 2005 adds native XML man- agement capabilities along the functionality outlined in the intro-duction of this tutorial. While some of the functionality – such as the XML data type – follows the SQL-2003 standard, others – such as the publishing functionality – do not, since they were designed before the standardization effort and provide easier-to-use approaches. Instead of building a new XML-only database system, SQL Server 2005 deeply integrates the XML capabilities into the existing database management framework that provides general services such as backup, restore, replication, concurrency control etc., while both extending and leveraging the relational storage and query infrastructure.