Research On Column-Store Databases Optimization Techniques

摘要

Column-stores, store each database table column separately, with attribute values belonging to the same column stored contiguously, compressed, and densely packed, as opposed to traditional database systems that store entire records (rows) one after the other. The main features of it are good query efficiency, less disk access, less storage, and significant improvement of database performance. This paper gives an overview of key optimization techniques used in column-oriented database system.