Home // DBKDA 2015, The Seventh International Conference on Advances in Databases, Knowledge, and Data Applications // View article

Extending PostgreSQL with Column Store Indexes

Authors:
Minoru Nakamura
Tsugichika Tabaru
Yoshifumi Ujibashi
Takushi Hashida
Motoyuki Kawaba
Lilian Harada

Keywords: PostgreSQL; columnar data; OLTP; OLAP; OLXP.

Abstract:
Abstract — The importance of database systems to support mixed online transaction processing (OLTP) and online analytical processing (OLAP) workloads, the so-called OLXP workloads, has attracted much attention recently. Some research projects and also commercial database systems with focus on OLXP have appeared in the last few years. In this paper, we present our work aiming at extending the PostgreSQL OSS database system to efficiently handle OLXP workloads. Besides PostgreSQL’s traditional OLTP-oriented row data store, a new OLAP-oriented column data store is added in the form of a new index. Unlike previous works focusing on OLXP, our column store index has no restrictions concerning data size and/or updatability. Therefore, transactional data inserted to PostgreSQL row data store become immediately available for efficient query processing using this new column store index.

Pages: 51 to 52

Copyright: Copyright (c) IARIA, 2015

Publication date: May 24, 2015

Published in: conference

ISSN: 2308-4332

ISBN: 978-1-61208-408-4

Location: Rome, Italy

Dates: from May 24, 2015 to May 29, 2015