Re: ingesting a large xml file and formatting it

From: David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: ingesting a large xml file and formatting it
Date: 2014-11-05 00:16:25
Message-ID: 1415146585031-5825722.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Erwan Tanajaya 2014-11-10 17:59:30 Re: Trigger difference in 9.0 and 9.3
Previous Message sam pendleton 2014-11-04 21:53:18 ingesting a large xml file and formatting it