Re: EJB w/ different DB's

[Magnus Rydin]

Foreign keys are good for making sure your data is consistant, for example you
cant reference a bank account that does not exist.
They are also good for defining delete rules, such as if this order is deleted,
make sure all orderrows are deleted too.
Correctly defined, they also speed up searching over multiple tables (if
needed).

But if your system does not need this (now or in the future), Databasesystems
like MySQL is excellent.

WR

"Kucera, Rich" wrote:

> MySQL also contains some pretty practical advice regarding the
> indiscriminate use of foriegn keys
> (it even says they're only useful for visual design tools so designers can
> more easily generate excess complexity
> or something to that effect)
>