Chapter 5. Creating XML Views with XDR Schemas


graphics/chic01.gif

Think back to Chapter 4, "Accessing SQL 2000 via HTTP," and you'll realize that we covered a large amount of information and coding techniques in that chapter. This information enables us to generate XML documents in several ways: by calling stored procedures, by calling template files, and by directly stating SQL in URLs. The template file's contents also can be listed directly in a URL. In addition, we can modify the returned document to suit our requirements by employing XSLT stylesheets.

Even though we learned how to accomplish all this, we still have the full version of the XPath expression and queries to learn, along with the FOR XML and OPENXML Microsoft extensions and Microsoft's version of schemas, XML-Data Reduced (XDR) schemas. We tackle the latter subject matter, XDR schemas, in this chapter.

In Chapter 1, "XML," I mentioned that Microsoft's version on XML schemas differs from the schemas documented in the W3C specification. This came about from Microsoft taking the initial specification, immediately adopting it, modifying it accordingly , and not paralleling the W3C specification. In this chapter, you'll see just how different the two specifications are.

This chapter will cover the following topics:

  • A thorough canvass of Microsoft's XDR schema

  • Microsoft's BizTalk Framework and what it attempts to accomplish

  • Annotations to Microsoft's XDR schema and how they are used to map XML to relational databases

  • Data types and how they map between XML and XDR schemas



XML and SQL Server 2000
XML and SQL Server 2000
ISBN: 0735711127
EAN: 2147483647
Year: 2005
Pages: 104
Authors: John Griffin

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net