Re: zusammengesetzter Primary Key mit Deleted-Flag

> (I also hope you are trying to design your DB with Oracle ;)
No.

>
> Alkos

With Oracle Designer you can design DB's.

With Oracle you can implement DB's. (Databasemodel).

But the designing process can be done with a great number of tools (pen and paper for one). Also designing the databasemodel can be done with a great number of tools (pen and paper for one).

The designing process should be at least for a great deal be independend of the database where you implement the database. Because of RDBMS differences and performance one can make different implementations on different RDBMSsen. So although an RDBMS (Oracle) for example can be in the back op your mind during the design fase, it should not have to much influence.

When designing try to make the 'design' as generic as possible. A design which can be implemented in multiple different RDBMSsen is 'stronger' than a dedicated design.
(The world is not completely ideal, so some parts of the design are dependend on the database you are actually going to use. There are differences in concurrency model, in grouping of records (think iot and clustering), in sequencing, some of these should be taken into the designing process at an early stage.
So when possible try to be independend of an RDBMS but when neccesary take the RDBMS into account)

ben brugman Received on Fri Oct 31 2003 - 09:19:11 CST