Mapping a big xml-file to relational database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

A. Nonym - 28 Apr 2006 19:18 GMT

Hi, everyone!
in the lab couse this semester we are asked to transfer a big xml file
(more than 300MB) with DTD into a relational database. Any ideas how we
can do it effenciently?
Thank you and best wishes,
Nonym

Reply to this Message

Bjoern Hoehrmann - 29 Apr 2006 14:06 GMT

* A. Nonym wrote in microsoft.public.dotnet.xml:

>in the lab couse this semester we are asked to transfer a big xml file
>(more than 300MB) with DTD into a relational database. Any ideas how we
>can do it effenciently?

That depends a bit on the complexity of the mapping. One way would be to
use the pull-parser to transform the XML into a comma separated values
file and import that into the database. Some RDBMS systems also support
importing XML natively, and inserting the data as you parse the document
is another alternative.

Signature

Björn Höhrmann · mailto:bjoern@hoehrmann.de · http://bjoern.hoehrmann.de
Weinh. Str. 22 · Telefon: +49(0)621/4309674 · http://www.bjoernsworld.de
68309 Mannheim · PGP Pub. KeyID: 0xA4357E78 · http://www.websitedev.de/

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...