XML to DB

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.

I have found:
http://www.skyhawksystems.com (Unresponsive sales team after 3-weeks)
http://www.rpbourret.com/xmldbms/index.htm (Very Nice, but uses DOM,
ie. only can process small XML files)

Thanks,
Jeff

Example XML.

XML 1
------------
<xml>
<customer>
<customer_name>Elvis Presley</customer_name>
<residences>
<residence>
<address>1234 Graceland</address>
<zip>98521</zip>
<residence>
</residences>
</customer>
....

XML 2
----------
<xml>
<customer>
<customer_name>Elvis Presley</customer_name>
<account_number>000999</account_number
<age></age>
</customer>

.

Relevant Pages

  • 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: Why choose SQL Express over Access?
    ... I am thinking of coding a data store that many store locations will use to ... get national sales averages. ... Each location sends in its data in in XML ... Ability to do asynch apps ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: XML file to Database
    ... Is it that you want to store the XML into a single column in a table or do ... configuration information is lost. ... can I read the XML file into a database? ...
    (microsoft.public.sqlserver.programming)
  • Re: XML in Relational Database
    ... is the standard practice to just store the XML along with the DB record as a BLOB? ... I am concerned about having to constantly modify the database schema in the backend due to unforseen stuff that I have to account for in the front end. ...
    (comp.text.xml)