XML and relational database management systems: inside Microsoft® SQL Server™ 2005

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.

REFERENCES

• 1: Michael Rys, Bringing the Internet to Your Database: Using SQLServer 2000 and XML to Build Loosely-Coupled Systems, Proceedings of the 17th International Conference on Data Engineering, p.465-472, April 02-06, 2001
• 2: <u>http://msdn.microsoft.com/sqlxml</u>
• 3: <u>http://msdn.microsoft.com/XML/BuildingXML/XMLandDatabase/default.aspx</u>
• 4: Patrick O'Neil , Elizabeth O'Neil , Shankar Pal , Istvan Cseri , Gideon Schaller , Nigel Westbury, ORDPATHs: insert-friendly XML node labels, Proceedings of the 2004 ACM SIGMOD international conference on Management of data, June 13-18, 2004, Paris, France [doi>10.1145/1007568.1007686]
• 5: S. Pal. I. Cseri, O. Seeliger, M. Rys et al.: XQuery Implementation in a Relational Database System. Submitted for publication.
• 6: S. Pal, I. Cseri, O. Seeliger, G. Schaller, L. Giakoumakis, V. Zolotov. Indexing XML Data Stored in a Relational Data base. In Proceedings of VLDB Conference, Toronto, 2004.
• 7: M. Rys. What's New in FOR XML in Microsoft SQL Server 2005 at <u>http://msdn.microsoft.com/library/enus/dnsql90/html/forxml2k5.asp</u>
• 8: M. Rys. XQuery and Relational Database Systems. In XQuery from the Experts, Howard Katz (ed.), Addison-Wesley, 2003.
• 9: M. Haustein and T. Haerder. Adjustable Transaction Isolation in XML Database Management Systems. In XSym 2004, Springer LNCS 3186, 2004.