Re: ingesting a large xml file and formatting it - Mailing list pgsql-novice

From David G Johnston
Subject Re: ingesting a large xml file and formatting it
Date
Msg-id 1415146585031-5825722.post@n5.nabble.com
Whole thread Raw
In response to ingesting a large xml file and formatting it  (sam pendleton <samp4040@gmail.com>)
List pgsql-novice
sam pendleton wrote
> Hi, I have a large XML file that I would like to put into a postgresql
> database. There are certain attributes about elements that aren't needed,
> so I would like to "pre-process" it, removing parts that aren't desired
> before storing the new row.
>
> What are some first steps in making this happen?

This a fairly vague question...can you be more specific about how you want
the process to look and what languages you are familiar with?


> Also, is there a term for "pre-processing data so that data being inserted
> into the database is consistent?"

Normalize, Standardize, or Transform;  the last being the most semantically
correct given that you are talking about XML.

David J.




--
View this message in context:
http://postgresql.1045698.n5.nabble.com/ingesting-a-large-xml-file-and-formatting-it-tp5825699p5825722.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.


pgsql-novice by date:

Previous
From: sam pendleton
Date:
Subject: ingesting a large xml file and formatting it
Next
From: Erwan Tanajaya
Date:
Subject: Re: Trigger difference in 9.0 and 9.3