This is the mail archive of the
xsl-list@mulberrytech.com
mailing list .
Re: Using XSLT for complicated database mapping
- To: <xsl-list at mulberrytech dot com>
- Subject: Re: Using XSLT for complicated database mapping
- From: "Steve Muench" <smuench at us dot oracle dot com>
- Date: Tue, 11 Apr 2000 17:27:29 -0700
- References: <md5:90E823E643689295A9C64965AA79090C> <38F3B0C3.9776857B@dtai.com>
- Reply-To: xsl-list at mulberrytech dot com
Jeff,
| > I have two relational databases, based on complicated schemas. The
| > organization of data within each is completely different, but logically it
| > is possible to map data from one database to another.
|
| I was hoping that someone really knowledgable would answer this,
XSLT is designed to handle XML to XML transformations.
That means that this gentleman's question of:
(Relational-Schema-1)---->(Relational-Schema-2)
Needs to be understood as:
(Query ) (Insert)
( over )-->XML1-->[XSLT Transform]-->XML2-->( into )
(RSch-1) (RSch-2)
=============== ================= ================
Step 1 Step 2 Step 3
XSLT helps with Step 2, the XML1-->XML2 transformation.
You need a technology like the free Oracle XML SQL Utility
(or equivalent bi-directional SQL<-->XML capability)
to handle Step1 and Step3, in combination with XSLT for Step2.
XSLT is definitely up to the task for Step 2.
______________________________________________________________
Steve Muench, Lead XML Evangelist & Consulting Product Manager
Business Components for Java & XSQL Servlet Development Teams
Oracle Rep to the W3C XSL Working Group
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list