Re: Using XML and a relational database

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: xz (xz_at_discussions.microsoft.com)
Date: 10/29/04 

Date: Fri, 29 Oct 2004 15:00:01 -0700

There are couple of nice features of bring XML data in/out from relational
database supported from SQL 2k, and got enhanced using XML data type in Yukon
(SQL 2005). Please look at the following link for more information:

http://msdn.microsoft.com/XML/BuildingXML/XMLandDatabase/default.aspx

There are couple of points to help you seemlessly getting XML In/out of SQL
2000:

1. To get data out using FORXML.
2. To get XML data into Relational Tables using OPENXML.

If you are using Yukon (SQL 2005), you can directly store your XML files and
also the XSLT files into the database with the new native XML data type
support. XPath and XQuery can be also applied to the query to help you
retrieve the proper data.

If you plan to directly build a user interface using XML and XSLT, you can
consider the HTTP ENDPOINT at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sql2005websvc.asp

Well there are lot more to learn in this area.

You can try to read: "SQL Server 2000 with XML" with ISBN 0-7356-1369-9 for
more information.

Hope those pointers will help.

"Gregory Burd" wrote:

> On 2003-08-30 07:19:56 -0400, "comcast" <j.tolson@comcast.net> said:
>
> > Hello all,
> > I am developing an interface system for an application I was written. This
> > interface will connect to other system to share information. I would like
> > to use
> > xml and xsl to generically describe each interface. The trouble I am having
> > is that it seem that if you export in xml by table then it is impossible to
> > combine the xml tables files back together in a hierarchical fashion. I can
> > do it programmatically but I would like to do it with xsl so that knowledge
> > of the database is not in the code but in the xsl. I can write generic code
> > for dumping tables and sql statements. But formatting should be generic.
> > Can this be done is xsl?
>
>
> Why are you using a relational database for XML? We have a native XML
> database that could solve your problems.
>
> -greg
>
> _____________________________________________________________________
>
> Gregory Burd
> Product Manager gburd@sleepycat.com
> Sleepycat Software, Inc. http://www.sleepycat.com/
>
>

Relevant Pages

  • Re: Another idea from pick goes mainstream...
    ... A relational database has nothing to do ... SQL is one of the ... is now considered THE language for any dbms implementing the relational ... Then, XML came out. ...
    (comp.databases.pick)
  • Re: Deviation from object-relational mapping (pySQLFace)
    ... Its goal to separate relational database stuff from algorythmic ... file (XML). ... It provides callable command objects for each sql query. ...
    (comp.lang.python)
  • Is FOR XML EXPLICIT still an accepted technique?
    ... I have inherited an ASP IIS site attached to a SQL ... Server 2000 database. ... I am new at using XML and have done considerable reading. ...
    (microsoft.public.sqlserver.xml)
  • Re: Parsing large amounts of data (200,000 entries) with XML?
    ... since I know the different uses for a database ... and an XML document. ... I didn't invent that either, ... XML and SQL coexist quite nicely. ...
    (microsoft.public.vb.general.discussion)
  • Re: Querying Very Large XML
    ... I was hoping that MSDE (or SQL 2005 Express) might let you get around ... the "we don't want to run a database" argument. ... Yet they provide the same XML ... > XpathDocument at once. ...
    (microsoft.public.dotnet.xml)