Re: DTD: Possible missing attributes/entities - Was: revised gda-xml-query.dtd

[Rodrigo Moya <rodrigo linuxave net>]

"David T. Bath" wrote:
> 
> Rodrigo Moya wrote:
> > I'll make an initial DTD during the weekend, and then we'll comment on
> > it. Although David, you can prepare one proposal as well if you want.
> > Although, as I said in a previous mail, I would start just defining the
> > stuff for the TABLES (and maybe VIEWS) and then we'll extend it, all
> > right?
> I just wanted the owner/schema to be an entity in its own right,
> not just an attribute of a table/view.  Hmmm.  What are the possible
> attributes of a schema entity?  Something like a privilege summary?
> Membership of various roles/groups? (Ouch, another entity?)
> 
yes, I think the schema should go in the DTD. So what I really meant was
that I'm going to start the DTD with TABLES and VIEWS, but all under a
specific schema.

> Hmmm.  Pity I haven't pulled apart the system catalogs for Oracle 8i
> yet.  I knew them pretty well inside out for versions 4 through 7.
> Maybe thats something we can do - systematically hack the current
> catalogs from the various vendors as a guide to the MINIMUM we need
> to handle.
>
yes, we should support all the basic stuff common to all the providers,
and allow for extensions also, so that any vendor can be supported.
  
> > most importantly, gnome-db is not yet in
> > a state where we can say it's the premier open source interface.
> That's why I said it that way instead of "gda".
> Anyway, from 0.95 (which took a bit of makefile hacking to get to
> work with Oracle8i), I was really impressed as a user with gdafe.
>
glad to hear this!

>         ksqlplus (1 session)
>                 Because of its history and for SQL*Plus scripts
>
you mean command history? this is already implemented in gdafe, but do
you have any suggestions to improve it?
And about scripts, support is also there, but I don't like it too much,
so more suggestions?

> Oh, but for grunt database work? DBI/DBD.  Perhaps this is
> something that needs to be addressed by gdafe, a GUI-less
> implementation for cron jobs, middleware server daemons, etc.
> --
there is a command-line app (gda-run) which could be used to execute
cron jobs. Is that what you mean?

and about the middleware, this is one of the ideas I've got for the
gda-builder app: the possibility to create DB services (as CORBA
objects). That is, you could for example create services such as
update_employee_salary, buy_stocks... This would be something like
stored procedures, but with the advantage of being distributed thanks to
CORBA as well as DB-independent.