Paper Abstract and Keywords |
Presentation |
2016-01-19 16:55
Cost Estimation Method based on CPU Architecture for Relational Database Query Optimization Tsuyoshi Tanaka (Tokyo Metropolitan Univ./Hitachi), Hiroshi Ishikawa (Tokyo Metropolitan Univ.) VLD2015-84 CPSY2015-116 RECONF2015-66 |
Abstract |
(in Japanese) |
(See Japanese page) |
(in English) |
Performance improvement and capacity enlargement of semiconductor record medium make the disk IO cost decrease and CPU cost increase relatively for cost calculation to search the most suitable access path of database query. Therefore a high precision cost calculation method of query execution will be required more in future. Accordingly, we propose a database join operation cost model based on CPU architecture and accuracy improving method by using statistics information measured by performance counter embedded in CPU. |
Keyword |
(in Japanese) |
(See Japanese page) |
(in English) |
Database / Optimization / CPU Cost / TPC-H / / / / |
Reference Info. |
IEICE Tech. Rep., vol. 115, no. 399, CPSY2015-116, pp. 67-72, Jan. 2016. |
Paper # |
CPSY2015-116 |
Date of Issue |
2016-01-12 (VLD, CPSY, RECONF) |
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 |
VLD2015-84 CPSY2015-116 RECONF2015-66 |
Conference Information |
Committee |
VLD CPSY RECONF IPSJ-SLDM IPSJ-ARC |
Conference Date |
2016-01-19 - 2016-01-21 |
Place (in Japanese) |
(See Japanese page) |
Place (in English) |
Hiyoshi Campus, Keio University |
Topics (in Japanese) |
(See Japanese page) |
Topics (in English) |
FPGA Applications, etc |
Paper Information |
Registration To |
CPSY |
Conference Code |
2016-01-VLD-CPSY-RECONF-SLDM-ARC |
Language |
Japanese |
Title (in Japanese) |
(See Japanese page) |
Sub Title (in Japanese) |
(See Japanese page) |
Title (in English) |
Cost Estimation Method based on CPU Architecture for Relational Database Query Optimization |
Sub Title (in English) |
|
Keyword(1) |
Database |
Keyword(2) |
Optimization |
Keyword(3) |
CPU Cost |
Keyword(4) |
TPC-H |
Keyword(5) |
|
Keyword(6) |
|
Keyword(7) |
|
Keyword(8) |
|
1st Author's Name |
Tsuyoshi Tanaka |
1st Author's Affiliation |
Tokyo Metropolitan University/Hitachi,Ltd. (Tokyo Metropolitan Univ./Hitachi) |
2nd Author's Name |
Hiroshi Ishikawa |
2nd Author's Affiliation |
Tokyo Metropolitan University (Tokyo Metropolitan Univ.) |
3rd Author's Name |
|
3rd Author's Affiliation |
() |
4th Author's Name |
|
4th Author's Affiliation |
() |
5th Author's Name |
|
5th Author's Affiliation |
() |
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 |
() |
Speaker |
Author-1 |
Date Time |
2016-01-19 16:55:00 |
Presentation Time |
25 minutes |
Registration for |
CPSY |
Paper # |
VLD2015-84, CPSY2015-116, RECONF2015-66 |
Volume (vol) |
vol.115 |
Number (no) |
no.398(VLD), no.399(CPSY), no.400(RECONF) |
Page |
pp.67-72 |
#Pages |
6 |
Date of Issue |
2016-01-12 (VLD, CPSY, RECONF) |
|