Re: DB Design Dilemma!! One DB or Many DBs??
From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 13 Feb 2002 22:06:36 +0000 (UTC)
Message-ID: <a4eo1b$65q$1_at_helle.btinternet.com>
Date: Wed, 13 Feb 2002 22:06:36 +0000 (UTC)
Message-ID: <a4eo1b$65q$1_at_helle.btinternet.com>
I don't think we entirely disagree! In principal at least a good logical design should be platfrom neutral. Its the actual implementation which is db dependent. For example many apps that work on sqlserver and oracle insist on creating temporary tables in user sessions. this is in general bad on oracle and (AIUI) reasonable on sql. sure the logical app design might say use a temporary storage area for this data object, that shouldn't be translated into temp tables per session unless necessary. the desin in question to me sounded like something that would perform best when implemented using platform specific features.
-- Niall Litchfield Oracle DBA Audit Commission UK "David Cressey" <david_at_dcressey.com> wrote in message news:vZaa8.83675$Nq6.15981_at_petpeeve.ziplink.net...Received on Wed Feb 13 2002 - 23:06:36 CET
> I think one should never say 'never'. ;)
>
> I've had quite a bit of success with generic logical designs, that just
get
> the tables, views and keys right, and maybe the indexes.
>
> But the output of a logical design is not used to construct a database.
> It's one of the inputs to physical design. Another input to physical
design
> is the specific database platform.
>
>
> --
> Regards,
> David Cressey
> www.dcressey.com
>
>