Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: DB Design Dilemma!! One DB or Many DBs??
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 - 16:06:36 CST
> 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
>
>