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.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
ACORD – Global Insurance Standard, http://www.acord.org/standards/StandardsHome.aspx
Melton, J.: ISO/IEC 9075-14:2003, Information technology — Database languages — SQL— Part 14: XML-Related Specifications, SQL/XML (2004)
Office 2003: XML Reference Schemas, http://www.microsoft.com/downloads/detailsaspx?familyid=fe118952-3547-420a-a412-00a2662442d9&displaylang=en
Pal, S., et al.: Indexing XML Data Stored in a Relational Database. In: Proc VLDB (2004)
SportsML – Sports Markup Language, http://www.sportsml.org/
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
XQuery 1.0: An XML Query Language, http://www.w3c.org/TR/xquery
XSL Transformations (XSLT) Version 2.0, http://www.w3.org/TR/2005/WD-xslt20-20050915/
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights 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)