Which is better homogeneous and heterogeneous database?
Answers
Answered by
0
If you use a single Database technology (e.g. all your nodes are Cassandra nodes or all are MySQL nodes or all are Oracle nodes) in a distributed fashion (e.g. 20 Cassandra nodes as part of a single cluster or 20 Oracle nodes as part of a single cluster), then you have a homogenous distributed database system.
An example of a heterogenous database system is to use multiple technologies in a combination to achieve your database needs. For example, we know Cassandra is good at storing/accessing data by primary key, but not so good for secondary-key-wise look up. Lucene or MongoDB have been used by many companies (e.g. Netflix) to store the secondary indexes for the primary data stored in Cassandra. In order to further speed up point-secondary index look-ups, Memcached can be layered on top of Lucene or MySQL.
An example of a heterogenous database system is to use multiple technologies in a combination to achieve your database needs. For example, we know Cassandra is good at storing/accessing data by primary key, but not so good for secondary-key-wise look up. Lucene or MongoDB have been used by many companies (e.g. Netflix) to store the secondary indexes for the primary data stored in Cassandra. In order to further speed up point-secondary index look-ups, Memcached can be layered on top of Lucene or MySQL.
Similar questions