By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,502 Members | 1,878 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,502 IT Pros & Developers. It's quick & easy.

Object Relational Feature

P: n/a
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
Jul 19 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Ron
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_ad...isclaimer.html

"MG" <de*****@yahoo.com> wrote in message
news:c8**************************@posting.google.c om...
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

Jul 19 '05 #2

P: n/a
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

Thanks, I'll consider that.

mohsen
Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.