loading
Papers

Research.Publish.Connect.

Paper

Paper Unlock

Authors: Fang Xi 1 ; Takeshi Mishima 2 and Haruo Yokota 1

Affiliations: 1 Tokyo institute of technology, Japan ; 2 NTT Japan, Japan

ISBN: 978-989-758-096-3

Keyword(s): DBMS, Multicore, Middleware, TPC-W.

Related Ontology Subjects/Areas/Topics: Databases and Information Systems Integration ; e-Business ; Enterprise Information Systems ; Middleware Integration ; Middleware Platforms ; Query Languages and Query Processing ; Technology Platforms

Abstract: The continued evolution of modern hardware has brought several new challenges to database management systems (DBMSs). Multicore CPUs are now mainstream, while the future lies in massively parallel computing performed on many-core processors. However, because they were developed originally for single-core processors, DBMSs cannot take full advantage of the parallel computing that uses so many cores. Several components in the traditional database engines become new bottlenecks on multicore platforms. In this paper, we analyze the bottlenecks in existing database engines on a modern multicore platform using the mixed workload of the TPC-W benchmark and describe strategies for higher scalability and throughput for existing DBMSs on multicore platforms. First, we show how to overcome the limitations of the database engine by introducing a partition-based multi-instance database system on a single multicore platform without any modification of existing DBMSs. Second, we analyze the possibil ity of further improving the performance by optimizing the cache performance of concurrent queries. Implemented by middleware, our proposed PM-DB can avoid the challenging work of modifying existing database engines. Performance evaluation using the TPC-W benchmark revealed that our proposal can achieve at most 2.5 times higher throughput than the existing engine of PostgreSQL. (More)

PDF ImageFull Text

Download
CC BY-NC-ND 4.0

Sign In Guest: Register as new SciTePress user now for free.

Sign In SciTePress user: please login.

PDF ImageMy Papers

You are not signed in, therefore limits apply to your IP address 34.239.160.113

In the current month:
Recent papers: 100 available of 100 total
2+ years older papers: 200 available of 200 total

Paper citation in several formats:
Xi, F.; Mishima, T. and Yokota, H. (2015). PM-DB: Partition-based Multi-instance Database System for Multicore Platforms.In Proceedings of the 17th International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-989-758-096-3, pages 128-138. DOI: 10.5220/0005370901280138

@conference{iceis15,
author={Fang Xi. and Takeshi Mishima. and Haruo Yokota.},
title={PM-DB: Partition-based Multi-instance Database System for Multicore Platforms},
booktitle={Proceedings of the 17th International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2015},
pages={128-138},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0005370901280138},
isbn={978-989-758-096-3},
}

TY - CONF

JO - Proceedings of the 17th International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - PM-DB: Partition-based Multi-instance Database System for Multicore Platforms
SN - 978-989-758-096-3
AU - Xi, F.
AU - Mishima, T.
AU - Yokota, H.
PY - 2015
SP - 128
EP - 138
DO - 10.5220/0005370901280138

Login or register to post comments.

Comments on this Paper: Be the first to review this paper.