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

Re: SQL DTD and related questions

• To: Márcio Fernando Keller <mfk@a...>
• Subject: Re: SQL DTD and related questions
• From: Ronald Bourret <rpbourret@r...>
• Date: Mon, 08 Apr 2002 03:37:38 -0700
• Cc: xml-dev@l...
• References: <00ed01c1da68$8ec95e20$0100007f@a...> <3CAABBEF.68BEB435@r...> <006a01c1db37$016a1c20$0100007f@a...> <3CAB83B6.4D9DE0F3@r...> <001901c1dbf1$492446c0$0100007f@a...>

Which type of transformation to use depends on the software you are
using.

The advantage of (1) is that you can write XSLT documents to transform
it to most SQL dialects and get a series of SQL statements that can be
executed directly. (If you write an XSLT generator that takes mapping
information and an XML document and does this, you might want to make it
available as Open Source. People ask for this fairly often, but I have
never seen it implemented.)

The advantage of (2) is that it the resulting XML document can be fed
directly to many different products that use an object-relational
mapping to transfer data from an XML document to the database. Note that
XSLT stylesheets that perform (2) will probably need to perform
structural transformations as well as value transformations. This is
because XML document structure is often different from database
structure.

-- Ron

> Márcio Fernando Keller wrote:
> 
> Ex:
> 
> (1)
> --------------------------------------------------------------------------------------------------------------
> XML
> <Cusmoter>
>     <FirstName>Marcio</FirstName>
>     <LastName>Keller</LastName>
>     <Sex>male</Sex>
> </Cusmoter>
> 
> [XSLT document snipped]
> 
> Result:
> </Statement>
> <Command name = "INSERT" />
>     <Tables>
>     <Table name = "Cust">
>         <Column name = "Name"> Marcio Keller </Column>
>         <Column name = "Sex"> 1 </Sex>
>     </Table>
>     </Tables>
> </Statement>
> (2)
> --------------------------------------------------------------------------------------------------------------
> XML
> <Cusmoter>
>     <FirstName>Marcio</FirstName>
>     <LastName>Keller</LastName>
>     <Sex>male</Sex>
> </Cusmoter>
> 
> [XSLT document snipped]
>
> Result:
> <Cusmoter>
>     <Name>Marcio Keller</Name>
>     <Sex>1</Sex>
> </Cusmoter>
> 
> =======================================================================================
> 
> In the first option I can process the result xml almost directly to a
> database(no look at the mapping again)
> In the second option I can process the result xml and I need look the
> mapping again, if this record is for insert, update, ...

• Follow-Ups:
  • Re: SQL DTD and related questions
    • From: Márcio Fernando Keller <marcio@a...>

• References:
  • SQL DTD and related questions
    • From: Márcio Fernando Keller <marcio@a...>
  • Re: SQL DTD and related questions
    • From: Ronald Bourret <rpbourret@r...>
  • Re: SQL DTD and related questions
    • From: Ronald Bourret <rpbourret@r...>

• Prev by Date: Re: WD for Namespaces 1.1
• Next by Date: Re: A plea for Sanity
• Previous by thread: Re: SQL DTD and related questions
• Next by thread: Re: SQL DTD and related questions
• Index(es):
  • Date
  • Thread