Is there really Object-relational impedance mismatch?

Posted by user52763 on Programmers See other posts from Programmers or by user52763
Published on 2012-04-26T08:44:48Z Indexed on 2012/08/28 15:50 UTC
Read the original article Hit count: 323

It is always stated that it is hard to store applications objects in relational databases - the object-relational impedance mismatch - and that is why Document databases are better.

However, is there really an impedance mismatch? And object has a key (albeit it may be hidden away by the runtime as a pointer to memory), a set of values, and foreign keys to other objects. Objects are as much made up of tables as it is a document. Neither really fit.

I can see a use for databases to model the data into specific shapes for scenarios in the application - e.g. to speed up database lookup and avoid joins, etc., but won't it be better to keep the data as normalized as possible at the core, and transform as required?

© Programmers or respective owner

Related posts about object-oriented

Related posts about orm