行式数据库 和 列式数据库

来源:互联网 发布:淘宝买手机被骗怎么办 编辑:程序博客网 时间:2024/05/04 01:27

seek time is incredibly long compared to the other delays in computers. Sometimes, reading a megabyte of sequentially stored data takes no more time than one random access.
因为列式数据库的rowid都挨在一起所以Row-based systems are not efficient at performing operations that apply to the entire data set, as opposed to a specific record. For instance, in order to find all the records in the example table that have salaries between 40,000 and 50,000, the DBMS would have to seek through the entire data set looking for matching records.

0 0
原创粉丝点击