[Gusdev-gusdev] Re: Re GUS Working Group

[Michael S. <msa...@pc...>]

Copied to the group, and comments inline...

Jinal Jhaveri wrote:
> Mike,
> 
> I would be interested in joining this working group. Extending the idea(s) you 
> have about representing the schema in xml format,  I believe that following 
> will be some immediate questions
> 

Thanks for your interest...

> a) How exactly will the dtd of xml file look like. How will it solve the 
> problems of commonly representing both oracle's and postgresql's data-types
> 

XML won't solve the translation problem alone, but it provides 
programmatic access to the schema and allows for easy access, storage, 
and tracking of the canonical schema.

> b) Will we need to write some of our own tools to convert this xml to pgsql 
> and oracle sql for installing the schema?
> 

I would imagine we will need to write some of our own tools, unless 
someone is aware of an existing tool (commercial or otherwise) that 
meets our needs.

> c) How easy or tough it will be for us to update the xml file whenever any 
> major/minor change is made in the schema
> 

I think that one of the goals of this effort would be to make this task 
easy!

> d) Will we have a consistent documentation system (+ wiki entry) for briefly 
> documenting this changes and announcing it to the newsgroup?
> 

Yes, I think we should!

> 
> 
> Let me know if I understood your suggestion correctly from the above suggested 
> extensions.
> 
> 
> Probably its a good idea to structure this working group before approaching 
> the problem
> 

Yes... we'll see who all is interested and figure out how to proceed.

> ---Jinal