2. Column VS Row oriented database(列式与行式数据库)
-
Row
-
Row-oriented systems are designed to efficiently return data for an entire row, or record, in as few operations as possible.
-
row-oriented systems are not efficient at performing set-wide operations on the whole table, as opposed to a small number of specific records. For instance, in order to find all records in the example table with salaries between 40,000 and 50,000, the DBMS would have to fully scan through the entire table looking for matching records.
-
database indexes
-
Column
Faster when only a limited subset of data is retrieved.
