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 statements 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.
In the given question, both the options are correct.
Row oriented or column oriented storage are part of the database management system, and they are used to deal and manage with the data.
In a row oriented storage accessing the data is quicker and easy whereas in column oriented it is little slow.
The row oriented storage system is not efficient in operations of all data but the column oriented is more efficient.