Re: Model-driven architecture outside of the enterprise?

From: Richard Grossman (rgrossmanDELETE-THIS-PART_at_techIII.com)
Date: 12/31/03 

Date: Tue, 30 Dec 2003 23:36:51 -0800

Brion L. Webster wrote:

> The second is the database maintenance. Most of my applications
> revolve around databases - either consolidating from multiple
> databases or persisting ancillary information into a database. ECO
> offers scripts to evolve an existing database into a version n+1
> database. Those scrips can be saved in a VCS and built into the
> install package, so you don't have to manually figure out how to
> transform the production database into whatever the test database
> wound up looking like.

Interesting. I wrote this for myself several years ago.

When I distribute updates, the users download them and run the
installer, which runs the DMM (Database Maintenance Module), which
compares the new schema (database definition) with the one on their
computer, and updates their existing database to match the new schema.

Without this, I'd have to manually update all those databases myself.

Relevant Pages

  • Re: how to move location of default database???? plz!
    ... fine, cool about the database, it probably amounts to how much tagging one ... updates - i woulda rolled them all back. ... No recent version of Windows does ... well when you have less than about 50MB to 100MB of free space. ...
    (microsoft.public.windowsmedia.player)
  • Re: Update Sql Server 2000 database from the HP3000
    ... collects those updates via ODBC every 10 or so seconds. ... essentially update the SQL database at the same time as the main ... Authorised and regulated by the Financial Services Authority. ...
    (comp.sys.hp.mpe)
  • Re: The right database for the job?
    ... Note that "many updates ... > the programmer that have to fix somebody elses code and/or database ... > devices under its control, it connects to a central "DB server" program ...
    (comp.databases)
  • Re: Disk transfers
    ... database software rather than in the application itself) is to capture the change in a relatively small update record in a log - which can be supported effectively in a relatively small amount of NVRAM if performance is important, rather than throwing GB of NVRAM at a generic disk write-back cache, and which in any event can effectively batch many such updates into a single log write if they occur very close to each other - and then later perform the eventual on-disk structural updates lazily, in the background, and possibly in bulk. ... though I'm not sure how the latter would vary all that much (unless you're just referring to the difference between disk and NVRAM performance). ...
    (comp.arch)
  • Re: A different definition of MINUS, Part 3
    ... can actually be the value of the database at any set point in time. ... updates, on the other hand, assert which possible value for the ... neither the algebra nor the calculus are sufficient when it comes to ... To extend the analogy to view updates, we also have an input delta ...
    (comp.databases.theory)