[Ilugc] Help needed
- From: solar345@xxxxxxxxx (Antano Solar)
- Date: Sat Nov 3 23:16:50 2007
On Nov 2, 2007 2:03 PM, ?????????? <citizenofgnu@xxxxxxxxx> wrote:
Dear Friends,
I have an xml file and my requirement is to build a mysql table and
push the value of the xml file into the table.
I would request a pointer on how to build a table at run time after
look the xsd file. Is there any straight way tool for solving the
problem, I heard xmlspy solves the problem. Any pointer is much
appreciated.
1. There is a berkley xml embedded database (opensource) by oracle . Needs
no setup , has binding in most language. DB is stores in flat file similar
to sqlite.Very efficient and fast.Supports xpath and xquery.
2.You can try the traditional method of having something map the xml to
conventional DB. as usual you have 101 ways to do this in perl . One of
which would be . DBIx::DBStag ->
http://search.cpan.org/~cmungall/DBIx-DBStag-0.09/DBIx/DBStag.pm<
http://search.cpan.org/%7Ecmungall/DBIx-DBStag-0.09/DBIx/DBStag.pm>
.
By the DBIx in the above module is a database abstraction layer which
supports any database type.So you can theoritically take the xml file and
store it as tables in conventional DB or to ldap or to xml file system or
even to facebook.
Besides that , even a perl paranoid programmer can use it , as like almost
all perl modules on cpan , there is working code in the synopsis section of
the documentation . You will have to just take the code change 1 line - the
db connection string. Then you can use it as a stand alone program which you
can invoke from other programs.
Antano Solar John
Other related posts:
