Re: Help with complex db design concepts
Date: 30 May 2002 07:38:45 -0700
> 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.
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.
For fun, the fundamental aspects of the above app were modeled in a simple oodb. See www.xdb1.com/Example/Ex046.asp for results. Received on Thu May 30 2002 - 16:38:45 CEST