I want to move data from a SQL server database to Hbase / Cassandra etc. How to decide which bigdata database to use?

Do I need to develop a plan for moving data from an SQL server database to any of the bigdata databases? Some of the questions I was thinking about are the following:

  • How big is the data?
  • What is the expected growth rate for this data?
  • What queries will be executed frequently? for example: search, range scan, full scan, etc.
  • How often do data move from source to destination?

Can someone help add to this profile?

+4
source share
2 answers

-, How big is the data ! , NoSQL , NoSQL . , , , - , , . (, , , NoSQL DB) Why NoSQL? RDBMS ?

, , NOSQL DB ( - ).

- What kind of queries will be run?

, tuples, . * ( ). NoSQL, columnar - .

: , , , . rowids empid.

, : , , , ..

, , , , .

How frequently the data will be moved/accessed? , , NoSQL DB (: Hive).

, ,:

  • ( )? ( Hew , )

  • ? (, ..) ?   ? Facebook Db (Presto)   ?   ? (, )

  • , , HDFS ( Hadoop) DB - ? , , , , ..

+3

  • sql, . .. , , .
  • CAP, , , .
0

All Articles