On Wed, 11 Apr 2001 13:02:24 Wayne Wilson wrote:
>pschloeffel wrote:
>> Database bindings are another big area of work. The only binding at present
>> is to the ODB Matisse which was really done as a demonstration and because
>> Thomas had previously used this database in a commercial (non-health)
>> project. Anyone volunteering to write bindings for PostGresSQL, Oracle,
>> DB2, Sybase, SQL Server etc will be welcomed with open arms.
I raised this issue at the AMIA 2000 meeting and I raise the same issue again. I must
be missing something since I still don't know why the GEHR project continues to be
stuck on the database issue.
Why do you have to re-implement database binding for the GEHR project? Are there no
existing Oracle, PostgreSQL, SQL Server, DB2 etc database "binders" that you can use?
By using Zope, the OIO system enjoys database adaptors that include Oracle,
PostgreSQL, etc. We use SQL within OIO to communicate with the database. When the
database adaptors are improved, the OIO system becomes a better system without having
to waste time writing and maintaining our own database adaptor.
Is it a good idea to rely on GEHR-specific and Brand-specific database routines?
Why not re-use existing routines?
>These are the kinds of things that could be added as other tasks to the
>one's I
> suggested earlier be done by the Internet2
>consortium that Mary Kratz has formed.
I am not sure throwing more resources on this problem is the best solution. First of
all, it may be a good idea to understand the development strategy that you are
proposing.
Are you suggesting that we need to write an "binder" for each database that GEHR talks
to? Could we possibly use a generic SQL gateway to solve the problem?
Please ignore me if I am not making sense,
Andrew
---
Andrew P. Ho, M.D.
OIO: Open Infrastructure for Outcomes
www.TxOutcome.Org
Assistant Clinical Professor
Department of Psychiatry, Harbor-UCLA Medical Center
University of California, Los Angeles
Join 18 million Eudora users by signing up for a free Eudora Web-Mail account at
http://www.eudoramail.com
