Re: Upgrade as Change in Meta-state
Date: 21 Oct 2004 05:32:16 -0700
Message-ID: <1098361936.285750.291180_at_c13g2000cwb.googlegroups.com>
Kenneth Downs wrote:
> Here is something I do not see discussed often, or else I have missed
it.
>
> Is there much interest in discussing the upgrade operation on an RDB?
<SNIP>
Sounds rather like a case for CASE to me. The project I currently work
on (maintaining a complex product that is used by many customers) uses
the Oracle CASE tool called Designer to define the database and rules,
with much of the code (data entry screens) being generated directly
from the CASE tool.
> Consider point #3. Consider a system under active development, with
a dozen
> or so programmers pushing changes through. Some of them are steadily
> altering several large tables.
That wouldn't happen here. Programmers don't push database changes through: database changes have to be routed via the database designers - there is a formal process. The changes are made in the CASE system, which can then generate the "alter table" DDL by comparing the new definition with the old. Received on Thu Oct 21 2004 - 14:32:16 CEST