all groups > dotnet xml > april 2006 >
You're in the

dotnet xml

group:

Mapping a big xml-file to relational database



Mapping a big xml-file to relational database A. Nonym
4/28/2006 8:18:13 PM
dotnet xml: 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,
Re: Mapping a big xml-file to relational database Bjoern Hoehrmann
4/29/2006 3:06:33 PM
* A. Nonym wrote in microsoft.public.dotnet.xml:
[quoted text, click to view]

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.
--
Björn Höhrmann · mailto:bjoern@hoehrmann.de · http://bjoern.hoehrmann.de
Weinh. Str. 22 · Telefon: +49(0)621/4309674 · http://www.bjoernsworld.de
AddThis Social Bookmark Button