Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: DB Design Dilemma!! One DB or Many DBs??

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@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...

> 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
>
>
Received on Wed Feb 13 2002 - 16:06:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US