Object Relational Feature

[MG]

Hi,
I am interested to know if there are any features in Oracle that would
allow a design similar to the "design by contract" methodology that
exists in the OO world. I read about the Object Relational Feature,
and it seems to be pretty creative, but it's also very limited towards
any change. What I'm after is something similar to an interface in
Java, but for tables in Oracle. Can you abstract out the interface to
a table, i.e. what the client/user can see, from it's actual
implementation. If such mechanism is in place, are there any
performance costs that would make it not viable. I'm looking at
applying this in a data warehouse project. I'd appreciate any
pointers towards where I can find such information.

Thanks,
Mohsen

[Ron]

Re: Object Relational Feature

Hello MG,

Based on what you are describing views is the one way to do it.

You can customize output of the table data using functions, create a view
and let user access it.

Regards,

Ron
DBA Infopower

http://www.dbainfopower.com

Standard disclaimer:

http://www.dbainfopower.com/dbaip_advice_disclaimer.html

"MG" <deeplfo@yahoo. comwrote in message
news:c8e3e11c.0 402051701.78813 58e@posting.goo gle.com...

Hi,
I am interested to know if there are any features in Oracle that would
allow a design similar to the "design by contract" methodology that
exists in the OO world. I read about the Object Relational Feature,
and it seems to be pretty creative, but it's also very limited towards
any change. What I'm after is something similar to an interface in
Java, but for tables in Oracle. Can you abstract out the interface to
a table, i.e. what the client/user can see, from it's actual
implementation. If such mechanism is in place, are there any
performance costs that would make it not viable. I'm looking at
applying this in a data warehouse project. I'd appreciate any
pointers towards where I can find such information.
>
Thanks,
Mohsen

[MG]

Re: Object Relational Feature

Based on what you are describing views is the one way to do it.

>
You can customize output of the table data using functions, create a view
and let user access it.
>
Regards,
>
Ron
DBA Infopower

Thanks, I'll consider that.

mohsen