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. 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.
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.
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.
4) What kind of support do you get when the archiving
process dies?
