Table 2.
Study #1 | Study #2 | Study #3 | Study #4 | Study #5 | |
---|---|---|---|---|---|
Big data technology | KUDU | Hive | Cassandra | HBase | Elasticsearch |
Big data Interface | Library | JDBC | Library | Library | RapidMQ |
(1) Insert data∗ | |||||
Insert 100 b/100k rows | 1.54 | 13,207.80 | 1.11 | 1.22 | 0.34 |
Insert 1 kb/100k rows | 1.70 | No response | No response | 1.31 | 0.75 |
Insert 10 kb/100k rows | 2.73 | No response | No response | 2.73 | 7.30 |
Insert 100 kb/100k rows | 17.72675 | No response | No response | 23.4235 | 13.33 |
(2) Select data∗ | |||||
Select 1 row | 800.00 | 19,709.20 | No response | 1,000.00 | 230 |
Select 5 rows | 800.00 | 21,882.20 | No response | No response | 450 |
(3) Architecture | Master/slave | Master/slave | Multimaster | Master/slave | Master/slave |
(4) File structure | Distributed DB | Hadoop | Distributed DB | Hadoop | Database |
(5) Storage fault tolerant | Multicopies | Multicopies | Multicopies | Multicopies | Multicopies |
(6) Large volume data access for analytics | Average | Best | Worse | Worse | Average |
(7) Access data by key | No | No | Yes | No | No |
(8) Built-in visualization | No | No | No | No | Best |
(9) Min. server required | 3 | 5 | 3 | 3 | 3 |
(10) Security | |||||
Client-node encryption | TLS/SSL | TLS/SSL | N/A | TLS/SSL | |
Web UI encryption | TLS/SSL | N/A | N/A | ||
Peer node authentication | N/A | N/A | N/A | ||
User authentication | Kerberos | Internal | Kerberos | ||
Authentication tokens | Y | N/A | Kerberos |
∗A unit of measurement is a response time (millisecond) per 1 transaction.