dbTalk Databases Forums  

Importing data to a database from XML

comp.databases comp.databases


Discuss Importing data to a database from XML in the comp.databases forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Michael CATANZARITI
 
Posts: n/a

Default Importing data to a database from XML - 10-01-2006 , 05:19 AM






Hello,

I would like to start a new open source project for importing data to
any relational database (MySql, Oracle, SqlServer) by providing an XSD
and several XSL.

The XSD schema will be used to format data to import.
Each XSL will be associated with a relational database engine and will
generate a SQL script from the data stored in an XML document respecting
the XSD.

Do you know if such a project exists ?
Do you know if OASIS or ISO/ANSI have published a standard XSD for
importing/exporting data from a relational database ?

Thank you

Michael

Reply With Quote
  #2  
Old   
AMO
 
Posts: n/a

Default Re: Importing data to a database from XML - 10-09-2006 , 04:40 PM






"Michael CATANZARITI" <catanzariti (AT) yahoo (DOT) com> wrote

Quote:
Hello,

I would like to start a new open source project for importing data to any
relational database (MySql, Oracle, SqlServer) by providing an XSD and
several XSL.

The XSD schema will be used to format data to import.
Each XSL will be associated with a relational database engine and will
generate a SQL script from the data stored in an XML document respecting
the XSD.

Do you know if such a project exists ?
Do you know if OASIS or ISO/ANSI have published a standard XSD for
importing/exporting data from a relational database ?

Thank you

Michael
Most organisations send XML via web services and such like where the WSDL
holds the information regarding the structure of the file. Most database
languages can then create a temporary table to import that information. It
might not be parsed against the XSD, but the idea is that because the
parsing of the data into the temporary table is performed internally, it is
a lot faster.

AMO




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.