On Sun, 16 Jul 2000, Frank Conradie wrote:
>
> ----- Original Message -----
> From: Regis Koenig <[EMAIL PROTECTED]>
> To: Turbine <[EMAIL PROTECTED]>
> Sent: Sunday, July 16, 2000 3:50 PM
> Subject: Re: XMLDatabaseMapBuilder & Co
>
>
> > As far as i can see, the current way sql -> MapBuilder is short but is
> > not very clean. SQL is a command language and _not_ a description
> > language. So, using sql files to describe a database structure may
> > hardly be appropriate. Actually, your .sql generator tool has probably
> > an internal format for describing the database structure, and outputs
> > .sql files that create this stucture into a specific sgbd (say MySQL).
> > Of course, as long as you do not have access to this descriptor you have
> > to play with the sql files which is easier for you :-) You are probably
> > not alone and that is why the current schema has to stay there. It is
> > simple and efficient.
>
> Leon is writing a JDBCSchemaToDatabaseMap class for use in the
> GenerateMapBuilderTask that will use an already created database, via the
> JDBC metadata methods, to gather info about the db structure. This way you
> will not be bound to a specific db's SQL schema.
>
I agree that the XMLDataBaseMapBuilder is the best way to start
a new project. With the description in XML you could easily
use the XML directly in a diagramming tool. I think the XML
description just makes the information more usable. And for
someone who doesn't know many databases they can just switch
the target DB and look at the output.
I think the JDBCSchemaToDatabaseMap would be the best way
to generate what you need from an existing project. But I
think it would be cool if there was a utility that would
look at the metadata and create XML, so again you could
look at the model in some sort of tool.
jvz.
>
>
> ------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
> Problems?: [EMAIL PROTECTED]
>
>
--
Jason van Zyl
[EMAIL PROTECTED]
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
