Asterix DB

Question 1

What is a main difference between SparkSQL and AsterixDB

Answer 1

AsterixDB can manipulate data using insert, update, and delete but SparkSQL can only work with static data

Question 2

Traditional B+-tree indexes cannot run in HDFS due to the lack of random file updates.

Answer 2

True

Question 3

LSM is suitable for big-data since it is designed for distributed query processing engines that use functional programming

Answer 3

False

Question 4

Why is Log-structured Merge (LSM) tree a good fit for big-data indexing?

Answer 4

It only uses sequential writes for index maintenance which fits the HDFS limitations