Re: Reuse Database Design with Object Relational Feature ?

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Wed, 11 May 2005 08:12:03 -0700
Message-ID: <1115824072.99463@yasure>

Tony Andrews wrote:

> xta..._at_hotmail.com wrote:
>

>>I read about Object Relational feature in Oracle 8i and later.
>>IS the "database/table Inheritance" is (one of) the objective of

>
> Object
>

>>Relational usage in Oracle ?
>>
>>OR what are the cases where Object Relational is appropriate to use ?

>
>
> There are no known cases when it is appropriate to use Object
> Relational features in database design! I give my reasons for saying
> this here: http://www.dbforums.com/t1154228.html
>
> So far, no one has disagreed...

I will disagree with what you've written here but not with what you wrote originally in the referenced link.

I agree that OR tables are a bad idea ... but using OR features to create views are an entirely different matter and there are places where they make sense.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Wed May 11 2005 - 10:12:03 CDT