On Tue, 01 May 2001 08:28:17 Wayne Wilson wrote:
>Andrew po-jung Ho wrote:
>
>> Since SAP-DB is open source, it will not have the proprietary trigger problems like
>Oracle.
>
> >
>Don't think that will be the issue. Exactly how triggers
>are implemented (open source or not) is the issue.
Hi Wayne,
Good point! I have avoided using triggers in the OIO system for that reason, but
triggers do have performance advantages. Since SAP-DB is now open source, perhaps it
is more likely to extend its trigger-"compatibility" from Oracle 7 to other databases.
If nothing else, it may be preferable to be locked into an open source DBMS than a
proprietary one :-).
>Each
>database that we have seen does it differently, makes no
>matter if open source as long as it's different. Given the
>impending collapse of the relational database industry (IBM
>just bought Informix) in just a small number of vendors,
>unless they can all agree, it remains an issue. Most of
>them won't agree because they already have an installed base.
I see. Since SAP-DB is open source, wouldn't also be easier for others to implement
triggers so that they are compatible with SAP-DB? For example, IBM can incorporate
SAP-DB code within their next version of DB2 to make DB2 capable of running SAP-DB
triggers.
>Even using java inside the DBMS execution space is no answer
>as exactly how that java is hooked up to the DB varies from
>implementation to implementation. For example, Oracle uses
>PL/SQl to activate java.
Right.
>Can't comment on SAP-DB for you, the real test is under
>heavy use over extended periods of time.
>
>1) How stable is it.
>2) How fast is it.
>3) How manageable while running.
Got to try it to know.
>4) What kind of support do you get when the archiving
>process dies?
How do I test this last one?
Best regards,
Andrew
---
Andrew P. Ho, M.D.
OIO: Open Infrastructure for Outcomes
TxOutcome.Org (hosting OIO Library #1)
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
