4 ms·
"OrientDB does away with the concept of a join table, one of the most significant bottle necks in relational databases." join table? Does he mean that you are
by bni 13y ago
"OrientDB does away with the concept of a join table, one of the most significant bottle necks in relational databases."
join table? Does he mean that you are able to join tables in queries? This is awesome! It might be a bottleneck but its also on of RDBMS best features. I also would revisit the bottleneck claim with todays SSDs and fast CPUs.
"...support for inheritance in OrientDB is useful ... to avoid joining tables to mimic class inheritance."
I have never used joins to "mimic class inheritance" and dont understand why you would ever want to do such a thing. Can someone enlighten me?
- nsxwolf 13y agoI think they are talking about a junction table. I also think they're talking about a class table inheritance pattern, where you have a base table that stores the data for the base/abstract class, then more tables to store the data for classes that extend the base class. You could use junction tables to model that relationship. http://en.wikipedia.org/wiki/Junction_table http://en.wikipedia.org/wiki/Junction_table