| Paper Abstract and Keywords |
| Presentation |
2013-07-23 11:10
Performance Characteristics of Large Analytical Query Processing on Relational Database with SSDs Keisuke Suzuki, Yuto Hayamizu, Daisaku Yokoyama, Miyuki Nakano, Masaru Kitsuregawa (Univ. of Tokyo) DE2013-24 |
| Abstract |
(in Japanese) |
(See Japanese page) |
| (in English) |
The SSDs are expected new storage devices whose transfer rate are thousands faster than that of HDDs.
By employing SSDs on behalf of HDDs, performance of data intensive applications is likely to be improved drasti-
cally since I/O cost of HDDs is dominant in execution time of data intensive applications. Then, different behavior
of data intensive application may be observed in case of SSDs, since SSD's I/O cost is relatively small in total
execution time. In this report, we analyze the difference in behaviors of hash join operation on a relational database
with both HDD and SSD environment, and clarify that it is necessary to consider the cost model by taking into
account characteristics of SSDs. |
| Keyword |
(in Japanese) |
(See Japanese page) |
| (in English) |
DBMS / SSD / OLAP / Join / / / / |
| Reference Info. |
IEICE Tech. Rep., vol. 113, no. 150, DE2013-24, pp. 117-122, July 2013. |
| Paper # |
DE2013-24 |
| Date of Issue |
2013-07-15 (DE) |
| ISSN |
Print edition: ISSN 0913-5685 Online edition: ISSN 2432-6380 |
Copyright and reproduction |
All rights are reserved and no part of this publication may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopy, recording, or any information storage and retrieval system, without permission in writing from the publisher. Notwithstanding, instructors are permitted to photocopy isolated articles for noncommercial classroom use without fee. (License No.: 10GA0019/12GB0052/13GB0056/17GB0034/18GB0034) |
| Download PDF |
DE2013-24 |
| Conference Information |
| Committee |
DE IPSJ-DBS IPSJ-IFAT |
| Conference Date |
2013-07-22 - 2013-07-23 |
| Place (in Japanese) |
(See Japanese page) |
| Place (in English) |
Hokkaido University |
| Topics (in Japanese) |
(See Japanese page) |
| Topics (in English) |
Data Management, Information Search and Knowledge Retrieval for Big Data, etc. |
| Paper Information |
| Registration To |
DE |
| Conference Code |
2013-07-DE-DBS-IFAT |
| Language |
Japanese |
| Title (in Japanese) |
(See Japanese page) |
| Sub Title (in Japanese) |
(See Japanese page) |
| Title (in English) |
Performance Characteristics of Large Analytical Query Processing on Relational Database with SSDs |
| Sub Title (in English) |
|
| Keyword(1) |
DBMS |
| Keyword(2) |
SSD |
| Keyword(3) |
OLAP |
| Keyword(4) |
Join |
| Keyword(5) |
|
| Keyword(6) |
|
| Keyword(7) |
|
| Keyword(8) |
|
| 1st Author's Name |
Keisuke Suzuki |
| 1st Author's Affiliation |
University of Tokyo (Univ. of Tokyo) |
| 2nd Author's Name |
Yuto Hayamizu |
| 2nd Author's Affiliation |
University of Tokyo (Univ. of Tokyo) |
| 3rd Author's Name |
Daisaku Yokoyama |
| 3rd Author's Affiliation |
University of Tokyo (Univ. of Tokyo) |
| 4th Author's Name |
Miyuki Nakano |
| 4th Author's Affiliation |
University of Tokyo (Univ. of Tokyo) |
| 5th Author's Name |
Masaru Kitsuregawa |
| 5th Author's Affiliation |
University of Tokyo (Univ. of Tokyo) |
| 6th Author's Name |
|
| 6th Author's Affiliation |
() |
| 7th Author's Name |
|
| 7th Author's Affiliation |
() |
| 8th Author's Name |
|
| 8th Author's Affiliation |
() |
| 9th Author's Name |
|
| 9th Author's Affiliation |
() |
| 10th Author's Name |
|
| 10th Author's Affiliation |
() |
| 11th Author's Name |
|
| 11th Author's Affiliation |
() |
| 12th Author's Name |
|
| 12th Author's Affiliation |
() |
| 13th Author's Name |
|
| 13th Author's Affiliation |
() |
| 14th Author's Name |
|
| 14th Author's Affiliation |
() |
| 15th Author's Name |
|
| 15th Author's Affiliation |
() |
| 16th Author's Name |
|
| 16th Author's Affiliation |
() |
| 17th Author's Name |
|
| 17th Author's Affiliation |
() |
| 18th Author's Name |
|
| 18th Author's Affiliation |
() |
| 19th Author's Name |
|
| 19th Author's Affiliation |
() |
| 20th Author's Name |
|
| 20th Author's Affiliation |
() |
| 21st Author's Name |
|
| 21st Author's Affiliation |
() |
| 22nd Author's Name |
|
| 22nd Author's Affiliation |
() |
| 23rd Author's Name |
|
| 23rd Author's Affiliation |
() |
| 24th Author's Name |
|
| 24th Author's Affiliation |
() |
| 25th Author's Name |
|
| 25th Author's Affiliation |
() |
| 26th Author's Name |
/ / |
| 26th Author's Affiliation |
()
() |
| 27th Author's Name |
/ / |
| 27th Author's Affiliation |
()
() |
| 28th Author's Name |
/ / |
| 28th Author's Affiliation |
()
() |
| 29th Author's Name |
/ / |
| 29th Author's Affiliation |
()
() |
| 30th Author's Name |
/ / |
| 30th Author's Affiliation |
()
() |
| 31st Author's Name |
/ / |
| 31st Author's Affiliation |
()
() |
| 32nd Author's Name |
/ / |
| 32nd Author's Affiliation |
()
() |
| 33rd Author's Name |
/ / |
| 33rd Author's Affiliation |
()
() |
| 34th Author's Name |
/ / |
| 34th Author's Affiliation |
()
() |
| 35th Author's Name |
/ / |
| 35th Author's Affiliation |
()
() |
| 36th Author's Name |
/ / |
| 36th Author's Affiliation |
()
() |
| Speaker |
Author-1 |
| Date Time |
2013-07-23 11:10:00 |
| Presentation Time |
40 minutes |
| Registration for |
DE |
| Paper # |
DE2013-24 |
| Volume (vol) |
vol.113 |
| Number (no) |
no.150 |
| Page |
pp.117-122 |
| #Pages |
6 |
| Date of Issue |
2013-07-15 (DE) |