PowerHouse and RDBMS issues

[Louis BROUILLETTE]

At 14:06 99-05-14 -0400, you wrote:
>G'day all
>
>I am writing a paper on the issues concerning migrating and PowerHouse app
>from one RDBMS to another, e.g. Oracle Rdb to Oracle 7 or Allbase to
>Interbase, etc.
>
>I have personal experience with Oracle Rdb to Oracle 7 but I would like to
>hear from the list about other people's experiences.  So I ask, please share
>your woes and joys of such an adventure.  I will REALLY appreciate it.
>
>TIA
>
>Blue
>= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
>Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
>powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
>This list is closed, thus to post to the list, you must be a subscriber.
>
We migrated from Interbase 3.3 to Oracle 7.3.  Problems were:

1) There is no "computed fields" in Oracle 7 ( or 8 either).  So, we had to
convert all computed fields to functions and create a view on each table
which had a computed field and then, in all PH programs, we had to add a
link to the view when the program was using a "computed field".

2) The logic of some triggers had to be modified because of "mutating
table" problem in Oracle.  Triggers were easier in Interbase.

3) We had to add "commit at update" in some QTPs.  As far as I can
remember, it is because Interbase has "optimistic" locking and Oracle don't.

Having said that, we are now very happy with Oracle.  It is much more
complicated to work with (at a dba standpoint) but you have more control on
every aspects of the database.  I see Interbase as a black box.  When
performance was degrading, we didn't know what to do.  When it was freezing
(and it happened pretty often), I had a procedure to apply and we were back
on track but didn't know what happened.  Now, with Oracle, when we have a
problem, I know what to do to correct the problem and never had an
interruption of services.

Also, there is a lot resources on the Web concerning Oracle (lots of tools,
scripts, tips, ...).

Hope that helps.

Louis Brouillette
Analyste en informatique (DBA)
Universite du Quebec a Trois-Rivieres
Tel: (819) 376-5011 ext. 2435
Email: Louis_Brouillette@uqtr.uquebec.ca
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.