XML To Database

[Konstantina Stamopoulou]

Hello everyone,
I have the following problem. I need for my application to use a database which is in 
form of .xml.
I want  to convert this database to a real database such us ORACLE.
 I have a .dtd but I cannot find a way to do this transformation automatically. 
Can anyone help by giving me some reference docs?
I couldn't find anything in the archives.

Thank you in advance
Konstantina

RE: XML To Database

[Navjot Singh]

hi,

this is off struts but anyway...

It's simple. Most of the recent developments in databases now supports
XML-DB table mapping. So, it can be transformed automatically.
For more details, search for xmldb on otn.oracle.com

I have not done this before but as you are working can i expect words on
implementation when you will be through?

regards
Navjot Singh




|-Original Message-
|From: Konstantina Stamopoulou [mailto:[EMAIL PROTECTED]
|Sent: Monday, July 21, 2003 4:45 PM
|To: Struts Users Mailing List
|Subject: XML To Database
|
|
|Hello everyone,
|I have the following problem. I need for my application to use a
|database which is in form of .xml.
|I want  to convert this database to a real database such us ORACLE.
| I have a .dtd but I cannot find a way to do this transformation
|automatically.
|Can anyone help by giving me some reference docs?
|I couldn't find anything in the archives.
|
|Thank you in advance
|Konstantina
|
|
|


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: Xml to database

[Brandon Goodin]

You need to read the article that explains the whole object relational
mapping paradigm that is used in xmldbms. It is quite ingenious. This will
explain why there are so many fields created to reperesent the xml data in a
relational database. The link to the article is:
http://www.xml.com/pub/a/2001/05/09/dtdtodbs.html

Hope that clears it up for you,
Brandon Goodin
Phase Communications
P (406)862-2245
F (406)862-0354
http://www.phase.ws


-Original Message-
From: ALAMI Ahmed - BOR [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 12, 2001 3:25 AM
To: 'Struts Users Mailing List'
Subject: RE: Xml to database


Hello everyone

i'm using xml-dbms framework, and i have a problem, if i give to the
map generator this XML file:
?xml version=1.0?
!DOCTYPE note [
  !ELEMENT note(to,from,heading,body)
  !ELEMENT to  (#PCDATA)
  !ELEMENT from(#PCDATA)
  !ELEMENT heading (#PCDATA)
  !ELEMENT body(#PCDATA)
]
note
toTove/to
fromJani/from
headingReminder/heading
bodyDon't forget me this weekend!/body
/note
I get this SQL file:
CREATE TABLE  note  ( toOrder  INTEGER,  headingOrder  INTEGER,  fromOrder
INTEGER,  noteOrder  INTEGER,  body  VARCHAR(255),  notePK  INTEGER,  from
VARCHAR(255),  to  VARCHAR(255),  bodyOrder  INTEGER,  heading
VARCHAR(255))

wich is not very representative of the XMl file:

So my question is: can I avoid this problem to get only;
CREATE TABLE  note  ( to VARCHAR(), from VARCHAR())

Thanks to everyone.

-Message d'origine-
De : Brandon Goodin [mailto:[EMAIL PROTECTED]]
Envoyé : jeudi 8 novembre 2001 14:41
À : 'Struts Users Mailing List'
Objet : RE: Xml to database


XMLDBMS - http://www.rpbourret.com/xmldbms/index.htm

This is an object relational mapping of an xml file to a database/a database
to an xml file. This might work for what you are looking for. I have used it
to extract data from a database and convert it to xml and then import the
xml into another database. It has support for multiple databases.

Hope it works,
Brandon Goodin
Phase Communications
P (406)862-2245
F (406)862-0354
http://www.phase.ws


-Original Message-
From: ALAMI Ahmed - BOR [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 08, 2001 3:53 AM
To: 'Struts Users Mailing List'
Subject: Xml to database



Hello everybody
Does anyone knows how to export an XML file to a database.
That means generating tables of a database knowing the XMl file describing
this database
Thanks to everyone

--
To unsubscribe, e-mail:
mailto:[EMAIL PROTECTED]
For additional commands, e-mail:
mailto:[EMAIL PROTECTED]




--
To unsubscribe, e-mail:
mailto:[EMAIL PROTECTED]
For additional commands, e-mail:
mailto:[EMAIL PROTECTED]

--
To unsubscribe, e-mail:
mailto:[EMAIL PROTECTED]
For additional commands, e-mail:
mailto:[EMAIL PROTECTED]




--
To unsubscribe, e-mail:   mailto:[EMAIL PROTECTED]
For additional commands, e-mail: mailto:[EMAIL PROTECTED]