Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsWhite Papers
Discussion GroupsFirst AidDatabasesJavaBeansGUIJava 3DVirtual MachineCORBASecurityToolsGeneral
Java DirectoryOpen Source ProjectsSample Book ChaptersUser GroupsWeb Resources
Related Topics
Databases.NETMore Topics ...

Java Forum / General / April 2006

Tip: Looking for answers? Try searching our database.

XML to DB

Thread view: 
jeffrey.h.hill@gmail.com - 12 Apr 2006 22:00 GMT
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>
Oliver Wong - 12 Apr 2006 22:31 GMT
> Hi Everyone,
>
[quoted text clipped - 10 lines]
> (3)  Possible automatically create the tables.
> (4)  Preferrably JAVA based.

   I believe step (2) is either impossible or will result in a "useless"
schema, unless you make a lot of simplifying assumptions. I guess you'd have
to elaborate on your "similar qualities, but different repeating fields"
description. I think your needs are specialized enough that I wouldn't
expect an off-the-shelf solution to be available.

   - Oliver
senges - 13 Apr 2006 04:12 GMT
Hi,

saving xml in a database (doesn't matter what kind of type) leeds you
to some basic questions:

- do i need the xml schema ?
- if not > save it as a blob
- if i do > check the big players possibilities (oracle plugs)
- check the xml dbms (natix)
- if you want to do it on your one > check the techniques ( save a xml
as a ordered tree > search for "xml dbms kossmann")

maybe you you specify what you wanna do. saving xml in a dbms is
possible. Especially if you use a special DBMS like NATIX

Greets,
Chris


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 ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.