[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

RE: New Infoworld article on XML and relational databases

• To: "Ken North" <kennorth@s...>,<xml-dev@l...>
• Subject: RE: New Infoworld article on XML and relational databases
• From: "Michael Rys" <mrys@m...>
• Date: Wed, 16 Jun 2004 17:50:49 -0700
• Cc: "Jonathan Robie" <jonathan.robie@d...>
• Thread-index: AcRT+OWRi/hjIhxNTviqut6B6gt+1AABzVfg
• Thread-topic: New Infoworld article on XML and relational databases

SQL/XML as in ISO/ANSI SQL-2003 is a couple of components:

1. The XML Datatype
	We support this in Yukon/2005
2. The publishing functions (XMLElement, XMLAgg etc)
	We currently do not support them in 2005 (I will at some point
write 
      Why), but we support similar functionality since SQL Server 2000
in 
      form of our rowset aggregator called FOR XML (see
      http://msdn.microsoft.com/library/en-us/dnsql90/html/forxml2k5.asp

      for examples on how it is easier and nicer in 2005 than either the
old 
      explicit mode or the publishing functions).
3. A table and meta data mapping for relational data into XML:
      We support some of the options for data mapping as part of our FOR
XML 
      functionality.

Given the timeline of the product planning (late 2000/early 2001), the
standard being done in 2003, existing functionality, resources etc., we
decided to not provide 2 in Yukon, but will consider adding what our
customers are demanding and where we can deliver value in upcoming
releases.

So the correct answer is that we partially support that spec. The
question whether Sean misinterpreted the name of our mid-tier SQLXML
component (that existed before there was the name SQL/XML coined for the
ANSI stuff), I don't know. I certainly gave him the information above.

Best regards
Michael

PS: Ken, I know you have this information already, just rewind your tape
:-). Or is the water cooler noise garbling it :-)



> -----Original Message-----
> From: Ken North [mailto:kennorth@s...]
> Sent: Wednesday, June 16, 2004 4:26 PM
> To: xml-dev@l...
> Cc: Michael Rys; Jonathan Robie
> Subject: Re:  New Infoworld article on XML and relational
> databases
> 
> > I was just sent a copy of this 10-page article, which discusses XML
> > support in IBM DB2, Microsoft SQL Server, Oracle Database 10g, and
> > Sybase ASE:
> >
> > http://www.infoworld.com/pdf/special_report/2004/17SRxml.pdf
> 
> At the bottom of page 38 of Sean McCown's article is a table labelled
"XML
> Essentials". Under the column "Supports SQL/XML", he has a "Yes" for
all
> of the
> products, including SQL Server 2000.  Is he confusing Microsoft SQLXML
3.0
> with
> the functions in the SQL:2003 standard?
> 
> > You may want to check out my reply at
> http://sqljunkies.com/WebLog/mrys/archive/2004/06/10/3036.aspx
> 
> Looking at your blog reply, his Yukon sidebar, and your TechEd
> presentation
> ("XML In The Database"), it still isn't obvious what Yukon will offer
in
> terms
> of the SQL:2003 functions (xmlagg(),  xmlconcat(), etc.).
> 
> 

• Prev by Date: Microsoft Proves Pronouns Patentable
• Next by Date: Re: ANN: XBIS 0.9.5 and articles (binary XML permathread)
• Previous by thread: Re: New Infoworld article on XML and relational databases
• Next by thread: Microsoft Proves Pronouns Patentable
• Index(es):
  • Date
  • Thread