OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index]
RE: [xml-dev] Shredding XML

Interesting post, but I am not sure that "now is the time to talk of many

Let me try to focus: 

Proper software execution comes from the choice of appropriate
actions/technologies to match the driving requirements.  But more
importantly, the greatest Wisdom, is to frame the driving requirements
correctly before "going off half cocked" or doing something that is
unnecessary and unwarranted.  

So lets start by framing the requirements again:

Fraser Gofin wrote:

The basics are we receive XML messages from an external trading partner and
process those messages, enriching and routing to a number of internal
subscriber applications. One of these applications is MI and the deal here
is that they want the data to been put into a relational database so that
they can create a number of interfaces 'files' which are sent to still more


I am mainly interested in the process of LOADING XML data to a database
rather than extracting (at least for the purposes of this discussion).

It is possible that the "mother persistent application datamodel" is
contained in the relational database in all its normalized glory.  If so,
then, "processing the messages" is simply a "data import" operation.  So the
question is, how do I get XML X* to tables T*.  It would strike me that lots
of people are doing this.  Are there common techniques and technologies for
doing this import?

Fraser, is that a proper framing of the question/requirements?


-----Original Message-----
From: Petite Abeille [mailto:petite.abeille@gmail.com] 
Sent: Sunday, November 01, 2009 9:56 AM
To: xml-dev@lists.xml.org
Subject: Re: [xml-dev] Shredding XML

On Oct 29, 2009, at 10:20 PM, Fraser Goffin wrote:

> opinions on the subject of decomposing XML into relational databases

Outside of the most trivial case, this is a major PITA of the same  
epic proportion as the object-relational one:


Good luck.


XML-DEV is a publicly archived, unmoderated list hosted by OASIS
to support XML implementation and development. To minimize
spam in the archives, you must subscribe before posting.

[Un]Subscribe/change address: http://www.oasis-open.org/mlmanage/
Or unsubscribe: xml-dev-unsubscribe@lists.xml.org
subscribe: xml-dev-subscribe@lists.xml.org
List archive: http://lists.xml.org/archives/xml-dev/
List Guidelines: http://www.oasis-open.org/maillists/guidelines.php

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index]

News | XML in Industry | Calendar | XML Registry
Marketplace | Resources | MyXML.org | Sponsors | Privacy Statement

Copyright 1993-2007 XML.org. This site is hosted by OASIS