This is the mail archive of the
xsl-list@mulberrytech.com
mailing list .
Using XSLT for complicated database mapping
- To: "'xsl-list at mulberrytech dot com'" <xsl-list at mulberrytech dot com>
- Subject: Using XSLT for complicated database mapping
- From: Noam Rotem <noamr at federationWeb dot com>
- Date: Mon, 10 Apr 2000 13:12:15 +0200
- Cc: Shahar Tzafrir <shahart at federationWeb dot com>, Guy Beit-Halahmi <guyb at federationWeb dot com>
- Reply-To: xsl-list at mulberrytech dot com
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. Some special cases I
can already point out:
1. One row of the source is mapped into two rows of the destination, with
relations between them (i.e. - a unique key must be generated and planted on
the fly)
2. Two rows are combined into one on the destination database.
3. A row is mapped according to a list of if else tests
4. A row is not mapped at all, due to a certain mapping rule
5. Keys of one database do not fit the masking methods of the other, so keys
must be changed following some generation rules before data is inserted into
the target database.
Can you tell me whether XSL(T) solves these transformation problems
(provided that I export database data into XML format, of course)? Also, can
you point out some good reference for this particular issue?
Thanks in advance,
Noam Rotem
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list