Re: XML and Postgres

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.&nbsp; 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?&nbsp; I am dealing with
health case claim data using the EDI X12 standard (such as it is).&nbsp; It
is well defined, but large and complex (well beyond the "mailing list"
examples I've seen).&nbsp; Do I need to post a DTD or Schema to Postgres?&nbsp;
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?&nbsp; Do I use XPath type
queries?</li>
<li>Is it possible to insert, update, change, delete data from the
data file on the base?&nbsp; 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?&nbsp; Is it worth
the trouble?&nbsp; Or should I dissect the file into traditionally
normalized tables?</li>
</ol>
Thank-you so much for your help and advice.&nbsp; 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

In response to

Responses

Browse pgsql-novice by date

  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