| 行列混合存储数据库系统的研究 |
| |
| 引用本文： | 孙林超,陈 群,肖玉泽,白 松.行列混合存储数据库系统的研究[J].计算机应用研究,2013,30(2):480-482. |
| |
| 作者姓名： | 孙林超 陈 群 肖玉泽 白 松 |
| |
| 作者单位： | 西北工业大学计算机学院,西安,710072 |
| |
| 基金项目： | 国家自然科学基金重点资助项目（61033007）; 华为创新研究计划资助项目（IRP-2011-02-03） |
| |
| 摘 要： | 通过研究列存储技术的特点,提出了一种行列混合存储数据库系统的设计方案.该方案在存储层设立独立的行存储引擎和列存储引擎,采用早物化技术在数据读出之后将列表转换成行表,然后以行的形式完成后续处理.因此,该方法既获得了列存储的读优势又复用了行数据库系统的成熟部件,降低了开发的风险和复杂度.基于PostgreSQL的原型开发与测试证明了该方案的可行性和有效性.
|
| 关 键 词： | 数据库管理系统 行列混合存储 存储引擎 |
Research of row-column mixed storage DBMS |
| |
| SUN Lin-chao,CHEN Qun,XIAO Yu-ze,BAI Song.Research of row-column mixed storage DBMS[J].Application Research of Computers,2013,30(2):480-482. |
| |
| Authors: | SUN Lin-chao CHEN Qun XIAO Yu-ze BAI Song |
| |
| Affiliation: | School of Computer Science, Northwestern Polytechnical University, Xi'an 710072, China |
| |
| Abstract: | By analyzing the technical features of column store, this paper proposed a design of mixed storage DBMS. On the storage level, both row engine and column engine were built. After the column table was read, it was transformed to row table, so that subsequent processing could be done. Therefore, the design gets the advantages of column store as well as reuses the mature parts of row DBMS, reducing the risk and complexity of the development. PostgreSQL-based prototype and testing prove the feasibility and effectiveness of the proposed design. |
| |
| Keywords: | DBMS row-column mixed storage storage engine |
| 本文献已被 CNKI 万方数据 等数据库收录！ |
| 点击此处可从《计算机应用研究》浏览原始摘要信息 |
|
点击此处可从《计算机应用研究》下载全文 |
|
