{"title":"列存储数据库优化技术研究","authors":"Wu Qiyue","doi":"10.1109/LISS.2015.7369708","DOIUrl":null,"url":null,"abstract":"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.","PeriodicalId":124091,"journal":{"name":"2015 International Conference on Logistics, Informatics and Service Sciences (LISS)","volume":"448 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2015-07-27","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"1","resultStr":"{\"title\":\"Research on column-store databases optimization techniques\",\"authors\":\"Wu Qiyue\",\"doi\":\"10.1109/LISS.2015.7369708\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"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.\",\"PeriodicalId\":124091,\"journal\":{\"name\":\"2015 International Conference on Logistics, Informatics and Service Sciences (LISS)\",\"volume\":\"448 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2015-07-27\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"1\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"2015 International Conference on Logistics, Informatics and Service Sciences (LISS)\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1109/LISS.2015.7369708\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"2015 International Conference on Logistics, Informatics and Service Sciences (LISS)","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/LISS.2015.7369708","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
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.