Skip to main content

Managing Collections of XML Schemas in Microsoft SQL Server 2005

  • Conference paper

Part of the book series: Lecture Notes in Computer Science ((LNISA,volume 3896))

Abstract

Schema evolution is of two kinds: (a) those requiring instance transformation because the application is simpler to develop when it works only with one version of the schema, and (b) those in which the old data must be preserved and instance transformation must be avoided. The latter is important in practice but has received scant attention in the literature. Data conforming to multiple versions of the XML schema must be maintained, indexed, and manipulated using the same query. Microsoft’s SQL Server 2005 introduces XML schema collections to address both types of schema evolution.

This is a preview of subscription content, log in via an institution.

Buying options

Chapter
USD   29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   129.00
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   169.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Learn about institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. ACORD – Global Insurance Standard, http://www.acord.org/standards/StandardsHome.aspx

  2. Melton, J.: ISO/IEC 9075-14:2003, Information technology — Database languages — SQL— Part 14: XML-Related Specifications, SQL/XML (2004)

    Google Scholar 

  3. Office 2003: XML Reference Schemas, http://www.microsoft.com/downloads/detailsaspx?familyid=fe118952-3547-420a-a412-00a2662442d9&displaylang=en

  4. Pal, S., et al.: Indexing XML Data Stored in a Relational Database. In: Proc VLDB (2004)

    Google Scholar 

  5. SportsML – Sports Markup Language, http://www.sportsml.org/

  6. XML Schema Part 1: Structures and Part 2: Datatypes. W3C Recommendation May 2 (2001), http://www.w3.org/TR/2001/REC-xmlschema-1-20010502 http://www.w3.org/TR/2001/REC-xmlschema-2-20010502

  7. XQuery 1.0: An XML Query Language, http://www.w3c.org/TR/xquery

  8. XSL Transformations (XSLT) Version 2.0, http://www.w3.org/TR/2005/WD-xslt20-20050915/

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2006 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Pal, S., Tomic, D., Berg, B., Xavier, J. (2006). Managing Collections of XML Schemas in Microsoft SQL Server 2005. In: Ioannidis, Y., et al. Advances in Database Technology - EDBT 2006. EDBT 2006. Lecture Notes in Computer Science, vol 3896. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11687238_69

Download citation

  • DOI: https://doi.org/10.1007/11687238_69

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-32960-2

  • Online ISBN: 978-3-540-32961-9

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics