dbTalk Databases Forums  

Object-relational impedence

comp.databases.theory comp.databases.theory


Discuss Object-relational impedence in the comp.databases.theory forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
JOG
 
Posts: n/a

Default Object-relational impedence - 03-03-2008 , 10:52 AM






On Mar 3, 2:07 pm, Thomas Gagne <tga... (AT) wide-open-west (DOT) com> wrote:
Quote:
All attempts by applications to access a DB's tables and columns
directly violates design principles that guard against close-coupling.
This is a basic design tenet for OO. Violating it when jumping from OO
to RDB is, I think, the source of problem that are collectively and
popularly referred to as the object-relational impedance mismatch.
I wondered if we might be able to come up with some agreement on what
object-relational impedence mismatch actually means. I always thought
the mismatch was centred on the issue that a single object != single
tuple, but it appears there may be more to it than that.

I was hoping perhaps people might be able to offer perspectives on the
issues that they have encountered. One thing I would like to avoid
(outside of almost flames of course), is the notion that database
technology is merely a persistence layer (do people still actually
think that?) - I wonder if the 'mismatch' stems from such a
perspective.


Reply With Quote
  #2  
Old   
Thomas Gagne
 
Posts: n/a

Default Re: Object-relational impedence - 03-03-2008 , 11:07 AM






JOG wrote:
Quote:
I wondered if we might be able to come up with some agreement on what
object-relational impedence mismatch actually means. I always thought
the mismatch was centred on the issue that a single object != single
tuple, but it appears there may be more to it than that.

The issue as I've discovered it has to do with the fact OO systems are
composed of graphs of data and RDBs are two-dimensional.

What defines an account in an RDB may be composed of multiple tables.
An RDB might express multiple account types through multiple tables
where OO may reflect it as multiple classes. Attempts to make RDBs
function as graphs through mapping tools results in disappointing
performance and, in my experience, too much mapping, too much
infrastructure, and too much language/paradigm-specific layers. In
short, way more code, way more maintenance, and way more job-security
for consultants, pundits, and tool providers.


--
Visit <http://blogs.instreamco.com/anything.php> to read
my rants on technology and the finance industry. Visit
<http://tggagne.blogspot.com/> for politics, society and culture.


Reply With Quote
  #3  
Old   
Thomas Gagne
 
Posts: n/a

Default Re: Object-relational impedence - 03-03-2008 , 11:07 AM



JOG wrote:
Quote:
I wondered if we might be able to come up with some agreement on what
object-relational impedence mismatch actually means. I always thought
the mismatch was centred on the issue that a single object != single
tuple, but it appears there may be more to it than that.

The issue as I've discovered it has to do with the fact OO systems are
composed of graphs of data and RDBs are two-dimensional.

What defines an account in an RDB may be composed of multiple tables.
An RDB might express multiple account types through multiple tables
where OO may reflect it as multiple classes. Attempts to make RDBs
function as graphs through mapping tools results in disappointing
performance and, in my experience, too much mapping, too much
infrastructure, and too much language/paradigm-specific layers. In
short, way more code, way more maintenance, and way more job-security
for consultants, pundits, and tool providers.


--
Visit <http://blogs.instreamco.com/anything.php> to read
my rants on technology and the finance industry. Visit
<http://tggagne.blogspot.com/> for politics, society and culture.


Reply With Quote
  #4  
Old   
Thomas Gagne
 
Posts: n/a

Default Re: Object-relational impedence - 03-03-2008 , 11:07 AM



JOG wrote:
Quote:
I wondered if we might be able to come up with some agreement on what
object-relational impedence mismatch actually means. I always thought
the mismatch was centred on the issue that a single object != single
tuple, but it appears there may be more to it than that.

The issue as I've discovered it has to do with the fact OO systems are
composed of graphs of data and RDBs are two-dimensional.

What defines an account in an RDB may be composed of multiple tables.
An RDB might express multiple account types through multiple tables
where OO may reflect it as multiple classes. Attempts to make RDBs
function as graphs through mapping tools results in disappointing
performance and, in my experience, too much mapping, too much
infrastructure, and too much language/paradigm-specific layers. In
short, way more code, way more maintenance, and way more job-security
for consultants, pundits, and tool providers.


--
Visit <http://blogs.instreamco.com/anything.php> to read
my rants on technology and the finance industry. Visit
<http://tggagne.blogspot.com/> for politics, society and culture.


Reply With Quote
  #5  
Old   
Thomas Gagne
 
Posts: n/a

Default Re: Object-relational impedence - 03-03-2008 , 11:07 AM



JOG wrote:
Quote:
I wondered if we might be able to come up with some agreement on what
object-relational impedence mismatch actually means. I always thought
the mismatch was centred on the issue that a single object != single
tuple, but it appears there may be more to it than that.

The issue as I've discovered it has to do with the fact OO systems are
composed of graphs of data and RDBs are two-dimensional.

What defines an account in an RDB may be composed of multiple tables.
An RDB might express multiple account types through multiple tables
where OO may reflect it as multiple classes. Attempts to make RDBs
function as graphs through mapping tools results in disappointing
performance and, in my experience, too much mapping, too much
infrastructure, and too much language/paradigm-specific layers. In
short, way more code, way more maintenance, and way more job-security
for consultants, pundits, and tool providers.


--
Visit <http://blogs.instreamco.com/anything.php> to read
my rants on technology and the finance industry. Visit
<http://tggagne.blogspot.com/> for politics, society and culture.


Reply With Quote
  #6  
Old   
Thomas Gagne
 
Posts: n/a

Default Re: Object-relational impedence - 03-03-2008 , 11:07 AM



JOG wrote:
Quote:
I wondered if we might be able to come up with some agreement on what
object-relational impedence mismatch actually means. I always thought
the mismatch was centred on the issue that a single object != single
tuple, but it appears there may be more to it than that.

The issue as I've discovered it has to do with the fact OO systems are
composed of graphs of data and RDBs are two-dimensional.

What defines an account in an RDB may be composed of multiple tables.
An RDB might express multiple account types through multiple tables
where OO may reflect it as multiple classes. Attempts to make RDBs
function as graphs through mapping tools results in disappointing
performance and, in my experience, too much mapping, too much
infrastructure, and too much language/paradigm-specific layers. In
short, way more code, way more maintenance, and way more job-security
for consultants, pundits, and tool providers.


--
Visit <http://blogs.instreamco.com/anything.php> to read
my rants on technology and the finance industry. Visit
<http://tggagne.blogspot.com/> for politics, society and culture.


Reply With Quote
  #7  
Old   
Thomas Gagne
 
Posts: n/a

Default Re: Object-relational impedence - 03-03-2008 , 11:07 AM



JOG wrote:
Quote:
I wondered if we might be able to come up with some agreement on what
object-relational impedence mismatch actually means. I always thought
the mismatch was centred on the issue that a single object != single
tuple, but it appears there may be more to it than that.

The issue as I've discovered it has to do with the fact OO systems are
composed of graphs of data and RDBs are two-dimensional.

What defines an account in an RDB may be composed of multiple tables.
An RDB might express multiple account types through multiple tables
where OO may reflect it as multiple classes. Attempts to make RDBs
function as graphs through mapping tools results in disappointing
performance and, in my experience, too much mapping, too much
infrastructure, and too much language/paradigm-specific layers. In
short, way more code, way more maintenance, and way more job-security
for consultants, pundits, and tool providers.


--
Visit <http://blogs.instreamco.com/anything.php> to read
my rants on technology and the finance industry. Visit
<http://tggagne.blogspot.com/> for politics, society and culture.


Reply With Quote
  #8  
Old   
Thomas Gagne
 
Posts: n/a

Default Re: Object-relational impedence - 03-03-2008 , 11:07 AM



JOG wrote:
Quote:
I wondered if we might be able to come up with some agreement on what
object-relational impedence mismatch actually means. I always thought
the mismatch was centred on the issue that a single object != single
tuple, but it appears there may be more to it than that.

The issue as I've discovered it has to do with the fact OO systems are
composed of graphs of data and RDBs are two-dimensional.

What defines an account in an RDB may be composed of multiple tables.
An RDB might express multiple account types through multiple tables
where OO may reflect it as multiple classes. Attempts to make RDBs
function as graphs through mapping tools results in disappointing
performance and, in my experience, too much mapping, too much
infrastructure, and too much language/paradigm-specific layers. In
short, way more code, way more maintenance, and way more job-security
for consultants, pundits, and tool providers.


--
Visit <http://blogs.instreamco.com/anything.php> to read
my rants on technology and the finance industry. Visit
<http://tggagne.blogspot.com/> for politics, society and culture.


Reply With Quote
  #9  
Old   
Thomas Gagne
 
Posts: n/a

Default Re: Object-relational impedence - 03-03-2008 , 11:07 AM



JOG wrote:
Quote:
I wondered if we might be able to come up with some agreement on what
object-relational impedence mismatch actually means. I always thought
the mismatch was centred on the issue that a single object != single
tuple, but it appears there may be more to it than that.

The issue as I've discovered it has to do with the fact OO systems are
composed of graphs of data and RDBs are two-dimensional.

What defines an account in an RDB may be composed of multiple tables.
An RDB might express multiple account types through multiple tables
where OO may reflect it as multiple classes. Attempts to make RDBs
function as graphs through mapping tools results in disappointing
performance and, in my experience, too much mapping, too much
infrastructure, and too much language/paradigm-specific layers. In
short, way more code, way more maintenance, and way more job-security
for consultants, pundits, and tool providers.


--
Visit <http://blogs.instreamco.com/anything.php> to read
my rants on technology and the finance industry. Visit
<http://tggagne.blogspot.com/> for politics, society and culture.


Reply With Quote
  #10  
Old   
Thomas Gagne
 
Posts: n/a

Default Re: Object-relational impedence - 03-03-2008 , 11:07 AM



JOG wrote:
Quote:
I wondered if we might be able to come up with some agreement on what
object-relational impedence mismatch actually means. I always thought
the mismatch was centred on the issue that a single object != single
tuple, but it appears there may be more to it than that.

The issue as I've discovered it has to do with the fact OO systems are
composed of graphs of data and RDBs are two-dimensional.

What defines an account in an RDB may be composed of multiple tables.
An RDB might express multiple account types through multiple tables
where OO may reflect it as multiple classes. Attempts to make RDBs
function as graphs through mapping tools results in disappointing
performance and, in my experience, too much mapping, too much
infrastructure, and too much language/paradigm-specific layers. In
short, way more code, way more maintenance, and way more job-security
for consultants, pundits, and tool providers.


--
Visit <http://blogs.instreamco.com/anything.php> to read
my rants on technology and the finance industry. Visit
<http://tggagne.blogspot.com/> for politics, society and culture.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.