Cart
[Home] [By Thread] [By Date] [Recent Entries]
Interesting post, but I am not sure that "now is the time to talk of many things". 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 applications. " OR " 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? Jim -----Original Message----- From: Petite Abeille [mailto:petite.abeille@g...] Sent: Sunday, November 01, 2009 9:56 AM To: xml-dev@l... Subject: Re: 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: http://blogs.tedneward.com/2006/06/26/The+Vietnam+Of+Computer+Science.aspx 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@l... subscribe: xml-dev-subscribe@l... 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] |
