|
|
 |
SQL Server 2000 XML Distilled
|
| Authors:
Andrew Novick, Kevin Williams, Daryl Barnes, Bryant Likes, Stephen Mohr, Paul Morris, Andrew Polshaw, Simon Sabin, Jeni Tennison
 |
|
Download the programs
and example files from the publisher here!
XML is one of a family of web standards for data description, validation,
manipulation, and interchange. It enables the construction of
application-specific data languages, which can be handled by generic tools. Its
other main benefits are its platform independence, self-describing structure,
and human readability. All the big relational database vendors are adding XML
support to their databases – and their confidence in XML as a maturing data
standard is strengthening. Microsoft's commitment to XML extends beyond the
database to include application and presentation layers, particularly in .NET.
The nascent field of web services will depend on the effective interface between
relational databases and the XML messages that link them.
SQL Server 2000 XML Distilled is for you if:
You are an experienced SQL Server professional (a DBA or data-tier developer) with a knowledge of the basics of XML who is being asked either to present relational data in an XML format, or to store XML data
You are wondering what the motivation is in combining SQL Server 2000 and XML
You want to understand what support SQL Server 2000 provides for these tasks
You need the detail on the latest SQL Server XML features provided in SQLXML 3.0
You are concerned about the security and performance consequences of the
design choices you make
SQL Server 2000 XML Distilled shows you:
Where XML as a data model makes sense
When and how best to get both relational databases and XML to work together
How to set up and configure the SQL Server XML environment
How to query SQL Server data and return an XML format – FOR XML, URL, and template queries
Ways to map between relational and XML schemas
SQL Server Annotated Schemas, XML Views, and XPath queries
How to store XML data in a relational database – OPENXML, Updategrams, and SQLXML BulkLoad
.NET support for XML in SQL Server 2000 – SQLXML Managed Classes and DiffGrams
Case studies of multi-client data access and Biztalk working with SQL Server 2000
The future of XML support in SQL Server – web services and XQueryTable
of Contents:
Chapter 1: SQL Server XML and the DBA
Chapter 2: Architecture and Setup
Chapter 3: Mapping Data from SQL Server to XML
Chapter 4: FOR XML
Chapter 5: URL Queries and Template Queries
Chapter 6: Annotating schemas
Chapter 7: XML Views
Chapter 8: XPATH Queries
Chapter 9: Mapping Data from XML to SQL Server
Chapter 10: OPENXML
Chapter 11: Updategrams
Chapter 12: SQLXML Bulk Load (Andrew Novick)
Chapter 13: Programmatic Access with SQLXML (Andrew Novick)
Chapter 14: SQL Server as a Web Service
Chapter 15: Case study: Detecting Web Site Clients
Chapter 16: Case Study: BizTalk Integration
Chapter 17: Emergent Technologies
Appendix A: XPATH Reference
Appendix B: XML Schema Reference
Appendix C: A Query Tool (Andrew Novick)
|
|
