Statement 1: Row-oriented storage is optimal for transaction processing applications.
Statement 2: Column-oriented storage is efficient for data-warehouse workloads.
Which of the following is correct?
Answers
I think both statement 1 and statement 2 are correct.
Row-oriented storage has the ability to write data very quickly and in transaction processing applications, speed is one of the major features to have. Hence, statement 1 is correct.
Whereas, column-oriented storage is best-in-class for aggregating big amount of data. In data-warehouse workloads, large volumes of data are required to be stored thus, supporting statement 2.
The answer is both.
Both the given statements are correct.
Row oriented storage and column oriented storage have their own distinct applications. However, the column oriented storage has a distinct advantage over its row counterpart. They have very fast query speeds. What takes minutes or even hours to accomplish with row oriented storage is likely to get accomplished in seconds with column oriented storage.