From: | Greg Lindstrom <greg(dot)lindstrom(at)novasyshealth(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: XML and Postgres |
Date: | 2005-03-17 14:46:33 |
Message-ID: | 42399849.7000404@novasyshealth.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<a class="moz-txt-link-abbreviated" href="mailto:brew(at)theMode(dot)com">brew(at)theMode(dot)com</a> wrote:<br>
<blockquote cite="midPine(dot)BSF(dot)4(dot)58(dot)0503170223470(dot)35543(at)themode(dot)com"
type="cite">
<pre wrap="">Hopefully someone can tell you of a direct solution, but I can tell you my
experiences using perl.</pre>
</blockquote>
Thanks for the reply. Can I ask some more basic questions before I
jump into this?<br>
<br>
<ol>
<li>Do I understand correctly that using one of these tools I can
hand my xml-formatted data file to postgres and it will be inserted
into the database?</li>
<li>How does the database "know" the layout? I am dealing with
health case claim data using the EDI X12 standard (such as it is). It
is well defined, but large and complex (well beyond the "mailing list"
examples I've seen). Do I need to post a DTD or Schema to Postgres?
Or does it simply (!) create tables and links to accommodate whatever
relationships are defined in the data file? Or is the xml dumped into 1
large field?<br>
</li>
<li>When I add additional data to the database (another claim file
from another vendor or day), will it be added to the existing data, or
-- I assume -- entered into the base using the new root node?</li>
<li>How do I extract data from the database? Do I use XPath type
queries?</li>
<li>Is it possible to insert, update, change, delete data from the
data file on the base? If so, can I issue a command to extract the
entire document with the modified data?</li>
<li>Can you point me to documentation on any of this? Is it worth
the trouble? Or should I dissect the file into traditionally
normalized tables?</li>
</ol>
Thank-you so much for your help and advice. This is a new world to me
and I'd like to understand what I might be getting in to.<br>
<br>
--greg<br>
<pre class="moz-signature" cols="72">Greg Lindstrom 501 975.4859
Computer Programmer <a class="moz-txt-link-abbreviated" href="mailto:greg(dot)lindstrom(at)novasyshealth(dot)com">greg(dot)lindstrom(at)novasyshealth(dot)com</a>
NovaSys Health
Little Rock, Arkansas
"We are the music makers, and we are the dreamers of dreams." W.W.
</pre>
</body>
</html>
Attachment | Content-Type | Size |
---|---|---|
unknown_filename | text/html | 2.4 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Si Chen | 2005-03-17 16:03:20 | what is and who owns postgresql type of questions |
Previous Message | Sean Davis | 2005-03-17 11:50:57 | Re: XML and Postgres |