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

Theory!!

P: n/a
hi,

can anyone give me some info on the caracteristics of object relational databases and their advantages as well as disdvantages!
thanx in advance.

Nov 23 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Mayra wrote:
hi,

can anyone give me some info on the caracteristics of object relational
databases and their advantages as well as disdvantages!
thanx in advance.


http://facinf.uho.edu.cu/

This isn't homework by any chance is it?
Nov 23 '05 #2

P: n/a
Mayra wrote:
hi,

can anyone give me some info on the caracteristics of object
relational databases and their advantages as well as disdvantages!


I'm not sure that there is any standard definition of "object relational
databases". You also don't say what you want to compare them to. Could
you provide more detail - what precisely are you trying to find out?

--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 23 '05 #3

P: n/a
> can anyone give me some info on the caracteristics of object
relational databases and their advantages as well as disdvantages!


First, it's best to understand the real concepts behind relational
databases. I read two great books that taught me a lot about the theory
of RDBMSs, and why they were developed (and why RDBMSs have been so
successful).

(1) "An Introduction to Database Systems", by C.J. Date -- A great book
about the theory that's very precisely written. The book leaves no
ambiguity in it's explanations, and covers a lot of ground.

(2) "Foundation for Future Database Systems", The Third Manifesto, by
Date and Darwen -- An explanation of what features should be part of a
complete RDBMS, and which should be left out, and why. Again, this
author is very good. If you've read the first book, and you're still
lured by the buzzwords in the database world, this second book will cure
you :)

Object oriented development is the way you structure your application,
and more important, the way you understand your application. You don't
need object oriented syntax to develop an object ordiented application.

PostgreSQL does, however, provide some object oriented syntax: for
example, inheritence. In some cases, using inheritence (versus a similar
solution without) can affect the way data is stored physically, which is
helpful to some (even in non-object-oriented contexts). However, the
inheritance doesn't add much to the relational model from a theory
perspective (according to Date, who gives a thorough explanation of his
reasoning).

So, in short, learn how to program object-orientedly with an RDBMS
first, then later check its feature list to see how extra object
oriented syntax might make things easier for you. Fundamentally, RDBMSs
and ORDBMSs have the same capabilities.

Regards,
Jeff Davis
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 23 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.