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