Re: XML to DB

<jeffrey.h.hill@xxxxxxxxx> wrote in message
news:1144875702.962637.75920@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi Everyone,

I'm looking to make a piece of software that basically takes in large
XML files and stores this information in the database.

The tricks are that the XML will have similar qualities, but different
repeating fields, and I have to be able to store each XML as I get it
programmatically.

Basically I want a system that can...
(1) Read Large XML (SAX Parser)
(2) Take any XML and automatically determine a schema to store it.
(3) Possible automatically create the tables.
(4) Preferrably JAVA based.

There is a student at Wayne State University who has developed a system to
do something like that; he recently gave a presentation to the departent
about XML processing in general, and here are links to the abstract and
slideshow he presented:

http://www.cs.wayne.edu/courses/gradsem_w06/abstracts/Mustafa%20Atay.doc
http://www.cs.wayne.edu/courses/gradsem_w06/slides/Atay_XML2REL_SeminarWSU.ppt

Another student asked him whether his software would be able to read in a
10-GB bioinformatics database, and he replied that he believed it would,
but that he had not tried it; the largest file he had processed with this
algorithm was about 100-MB in size.


.

Relevant Pages

  • Re: SQL SERVER
    ... It's not only an Explorer problem. ... number of files you need to store: it's the same problem in every file ... Here is sample you want for why storing XML in a database: ... XML column of the table the definition you want (it's not relational any ...
    (microsoft.public.sqlserver.msde)
  • Re: DataBase
    ... > You can use XML to store the data pretty easily. ... > with ADO.net you can import or export the data to XML. ... > Andrew J. Kelly SQL MVP ... >> database, but I need it not to use any SQl server. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Wanted:MAIL.MAI structure definition
    ... exports using XML. ... SMTP mail and all the software out there which processes RFC-compliant headers ... I would maintain that to store mail messages you would need to use CLOB ... Every mail message arriving into an OpenVMS system gets its format converted. ...
    (comp.os.vms)
  • Re: ruby / rexml / xpath bug?
    ... puts of the XML. ... end # end each store ... Longitude: -74.107299 ...
    (comp.lang.ruby)
  • RE: Embedd XML within XML - Possible ??
    ... it is not quite recommended that we store such ... If you do want to store complex XML data into the attribute field. ... Microsoft MSDN Online Support Lead ... ID Field and String Field ...
    (microsoft.public.dotnet.languages.csharp)