|
|
|
|
|
|
| Author |
Message |
DA Morgan
*nix forums Guru
Joined: 06 Mar 2005
Posts: 1042
|
 Posted: Fri Feb 04, 2005 6:28 pm Post subject:
Re: Trends in Using Oracle 10g Object Extensions
|
|
|
Mark C. Stock wrote:
| Quote: | "DA Morgan" <damorgan@x.washington.edu> wrote in message
news:1107486745.51433@yasure...
Lee Chalupa via OracleMonster.com wrote:
I realize that most of the installed databases in organizations are
relational databases versus some kind of object oriented persistence.
Being a Java Developer and working with objects, I'm interested in
learning the object extensions in 10g such as object types,
object tables, nested tables, varrays, etc. I've read some of the
database-guy blogs and most of them are not too excited about these
object extensions and recommend avoiding them. After playing with some of
the syntax for nested tables, I can see why.
I'd like to know if there are any apps out there that are using these
extensions, what you have learned from the experience, and what you would
recommend to a future application.
Thanks
Lee
They are problematic when used in tables but are very very useful when
defining object-views based on relational tables and essential when
working with many of Oracle's built-in packages.
Most of those that refuse to use them ... also refuse to write any
code or learn anything newer than Oracle 8.0.6.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)
"They are problematic when used in tables " --- could you elaborate?
++ mcs
|
Tom Kyte has elaborated on this quite a bit and with great hesitancy
I will too.
The problem I see is that the object tables don't have any real
referential integrity. A REF is just that a reference. One can
pretty much violate it at will. Delete the object refered to and
nothing happens. Not something you can do with a Foreign Key
constraint.
Here are Tom's comments from "Expert one-on-one Oracle."
Now for an opinion. The object relational components (nested tables,
object tables) are primary what I call 'syntactic sugar'. They are
always translated into 'good old' relational rows and columns. I
prefer not to use them as physical storae mechanisms personally. There
are too many bits of 'magic' happening - side effects that are not
clear. You get hidden columns, extra indexes, surprise pseudo columns,
and so on.
He writes much more on the subject but that should give you a sense
of his thinking. Mine, more simply put, is that I want a referential
constraint that is as tough as gorilla glue.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond) |
|
| Back to top |
|
 |
Mark C. Stock
*nix forums Guru
Joined: 05 May 2005
Posts: 730
|
| Posted: Fri Feb 04, 2005 10:35 am Post subject:
Re: Trends in Using Oracle 10g Object Extensions
|
|
|
"DA Morgan" <damorgan@x.washington.edu> wrote in message
news:1107486745.51433@yasure...
| Quote: | Lee Chalupa via OracleMonster.com wrote:
I realize that most of the installed databases in organizations are
relational databases versus some kind of object oriented persistence.
Being a Java Developer and working with objects, I'm interested in
learning the object extensions in 10g such as object types,
object tables, nested tables, varrays, etc. I've read some of the
database-guy blogs and most of them are not too excited about these
object extensions and recommend avoiding them. After playing with some of
the syntax for nested tables, I can see why.
I'd like to know if there are any apps out there that are using these
extensions, what you have learned from the experience, and what you would
recommend to a future application.
Thanks
Lee
They are problematic when used in tables but are very very useful when
defining object-views based on relational tables and essential when
working with many of Oracle's built-in packages.
Most of those that refuse to use them ... also refuse to write any
code or learn anything newer than Oracle 8.0.6.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)
|
"They are problematic when used in tables " --- could you elaborate?
++ mcs |
|
| Back to top |
|
|
DA Morgan
*nix forums Guru
Joined: 06 Mar 2005
Posts: 1042
|
| Posted: Fri Feb 04, 2005 2:15 am Post subject:
Re: Trends in Using Oracle 10g Object Extensions
|
|
|
Lee Chalupa via OracleMonster.com wrote:
| Quote: | I realize that most of the installed databases in organizations are relational databases versus some kind of object oriented persistence.
Being a Java Developer and working with objects, I'm interested in learning the object extensions in 10g such as object types,
object tables, nested tables, varrays, etc.
I've read some of the database-guy blogs and most of them are not too excited about these object extensions and recommend avoiding them. After playing with some of the syntax for nested tables, I can see why.
I'd like to know if there are any apps out there that are using these extensions, what you have learned from the experience, and what you would recommend to a future application.
Thanks
Lee
|
They are problematic when used in tables but are very very useful when
defining object-views based on relational tables and essential when
working with many of Oracle's built-in packages.
Most of those that refuse to use them ... also refuse to write any
code or learn anything newer than Oracle 8.0.6.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond) |
|
| Back to top |
|
|
Jim Kennedy
*nix forums Guru
Joined: 30 Apr 2005
Posts: 367
|
| Posted: Fri Feb 04, 2005 1:28 am Post subject:
Re: Trends in Using Oracle 10g Object Extensions
|
|
|
"Lee Chalupa via OracleMonster.com" <forum@OracleMonster.com> wrote in
message news:75c9af47abaf4ca8911297273b0bea9a@OracleMonster.com...
| Quote: | I realize that most of the installed databases in organizations are
relational databases versus some kind of object oriented persistence.
Being a Java Developer and working with objects, I'm interested in
learning the object extensions in 10g such as object types,
object tables, nested tables, varrays, etc.
I've read some of the database-guy blogs and most of them are not too
excited about these object extensions and recommend avoiding them. After |
playing with some of the syntax for nested tables, I can see why.
| Quote: |
I'd like to know if there are any apps out there that are using these
extensions, what you have learned from the experience, and what you would |
recommend to a future application.
They are handy in pl/sql programming.
Jim |
|
| Back to top |
|
|
AYEB Mounir via OracleMon
*nix forums beginner
Joined: 17 Feb 2005
Posts: 7
|
| Posted: Thu Feb 03, 2005 12:55 pm Post subject:
Trends in Using Oracle 10g Object Extensions
|
|
|
I realize that most of the installed databases in organizations are relational databases versus some kind of object oriented persistence.
Being a Java Developer and working with objects, I'm interested in learning the object extensions in 10g such as object types,
object tables, nested tables, varrays, etc.
I've read some of the database-guy blogs and most of them are not too excited about these object extensions and recommend avoiding them. After playing with some of the syntax for nested tables, I can see why.
I'd like to know if there are any apps out there that are using these extensions, what you have learned from the experience, and what you would recommend to a future application.
Thanks
Lee
--
Message posted via http://www.oraclemonster.com |
|
| Back to top |
|
|
Google
|
|
| Back to top |
|
|
|
|
The time now is Thu Jan 08, 2009 2:50 am | All times are GMT
|
|
Bankruptcy | Fish Tank Help | Bankruptcy | Bankruptcy | Photography
|
|
Copyright © 2004-2005 DeniX Solutions SRL
|
|
|
|
Other DeniX Solutions sites:
Unix/Linux blog |
electronics forum |
medicine forum |
science forum |
|
|
Privacy Policy
|
Powered by phpBB © 2001, 2005 phpBB Group
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
Forum index
»
Databases
»
Oracle
