Geek Answers Handbook

The best data warehouse for huge data with a lot of reads and records

I need to store about 100 million records in a database. About 60-70% of them will be deleted daily, and the same number of entries are made daily. I feel like a document database like Hbase, Big Table. There are many other data stores, such as Cassandra, MongoDb, etc. What kind of data warehouse would be useful for such problems, since a huge number of read / write operations (about 10 million) will be received daily.

+5
source share
1 answer

Depending on the characteristics you mentioned (JSON Documents, key access, 100 million records, balanced read / write) I would say CouchDB or Membase are good candidates (here's a quick comparison )

Both HBase and Cassandra may also work, but for HBase you will need to install many components (Hadoop, ZooKeeper, etc.) that you will not use only d, and Cassandra is better if you have more entries, than read it (at least the last time I used it).

The large table, unfortunately, is internal to google :)

+3
source

More articles:


All Articles