Paper Abstract and Keywords |
Presentation |
2008-09-21 13:00
[Invited Talk]
Advanced Query Optimization Techniques in a Parallel Computing Environment Wook-Shin Han (Kyungpook National Univ.) DE2008-30 |
Abstract |
(in Japanese) |
(See Japanese page) |
(in English) |
We introduce two query optimization techniques that we recently developed, which can be employed in a parallel computing environment. The first technique is called "progressive optimization in a parallel database"; the second one "parallelizing query optimization." Progressive optimization (POP) is a technique to detect cardinality estimation errors by monitoring actual cardinalities at runtime and to recover by triggering re-optimization with the actual cardinalities measured. In order to apply POP to a parallel environment, 1) rigorous voting schemes are used to make a global decision of whether re-optimization should be triggered; 2) a mechanism that re-uses a distributed temporary table is used. To reduce optimization time in multi-core processor architectures, a novel framework for parallelizing query optimization is introduced. This framework permits for the first time exploiting dynamic programming to find optimal plans for some complex OLAP ad-hoc queries referencing more than about 12 tables. |
Keyword |
(in Japanese) |
(See Japanese page) |
(in English) |
query optimization / progressive optimization / parallel databases / / / / / |
Reference Info. |
IEICE Tech. Rep., vol. 108, no. 211, DE2008-30, pp. 1-2, Sept. 2008. |
Paper # |
DE2008-30 |
Date of Issue |
2008-09-14 (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 |
DE2008-30 |
Conference Information |
Committee |
DE |
Conference Date |
2008-09-21 - 2008-09-22 |
Place (in Japanese) |
(See Japanese page) |
Place (in English) |
|
Topics (in Japanese) |
(See Japanese page) |
Topics (in English) |
|
Paper Information |
Registration To |
DE |
Conference Code |
2008-09-DE |
Language |
English |
Title (in Japanese) |
(See Japanese page) |
Sub Title (in Japanese) |
(See Japanese page) |
Title (in English) |
Advanced Query Optimization Techniques in a Parallel Computing Environment |
Sub Title (in English) |
|
Keyword(1) |
query optimization |
Keyword(2) |
progressive optimization |
Keyword(3) |
parallel databases |
Keyword(4) |
|
Keyword(5) |
|
Keyword(6) |
|
Keyword(7) |
|
Keyword(8) |
|
1st Author's Name |
Wook-Shin Han |
1st Author's Affiliation |
Kyungpook National University (Kyungpook National Univ.) |
2nd Author's Name |
|
2nd Author's Affiliation |
() |
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 |
2008-09-21 13:00:00 |
Presentation Time |
30 minutes |
Registration for |
DE |
Paper # |
DE2008-30 |
Volume (vol) |
vol.108 |
Number (no) |
no.211 |
Page |
pp.1-2 |
#Pages |
2 |
Date of Issue |
2008-09-14 (DE) |