Re: Help with complex db design concepts

From: James <>
Date: 30 May 2002 07:38:45 -0700
Message-ID: <>

> Has anyone had experience with turning one approach into another on
> production databases? Did anyone run both approaches succesfully?

Below are some observations based on a Utility Modelling System for Semiconductor Fabrication Plants.

Traditional approach in rdb (65 tables)

  Fuller utilization of SQL.
  Less coding.

  App was less flexible. Required rigid data structures     but real world data was not.
  App was less resilient to changes, ie addition of new data structures,...
  Evolving the schema was difficult.

Meta-data approach in rdb (5 tables)

  App was more flexible. Allowed us to model variable data structures.   Evolving the schema was easier.

  Had to rely more on coding.
  Could only use simple subset of SQL.
  Much slower.

For fun, the fundamental aspects of the above app were modeled in a simple oodb. See for results. Received on Thu May 30 2002 - 16:38:45 CEST

Original text of this message