SQL Server 2000 XML Distilled - Softcover

Williams, Kevin; Likes, Bryant; Novick, Andrew C.; Barnes, Daryl; Morris, Paul; Sabin, Simon; Mohr, Steve; Polshaw, Andrew; Tennison, Jeni

Softcover

ISBN 10: 1904347088 ISBN 13: 9781904347088

Publisher: Curlingstone, 2002

Synopsis

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 XQuery

Edition details

• Publisher: Curlingstone
• Publication date: 2002
• Language: English
• ISBN 10: 1904347088
• ISBN 13: 9781904347088
• Binding: Paperback
• Edition number: 1
• Number of pages: 600