Paper Abstract and Keywords |
Presentation |
2023-09-22 10:55
A Preliminary Study of Dynamic Query Optimization Using MLIR Genki Kimura, Kazuo Goda (UT) DE2023-23 |
Abstract |
(in Japanese) |
(See Japanese page) |
(in English) |
Query optimizer generates execution plans from input queries and has a significant impact on database performance. Traditional query optimizer estimates execution costs based on statistics and approximate cost models and constructs the most efficient plan, but the potential for inefficiencies comes from errors in these estimates. On the other hand, dynamic query optimization achieves efficient execution using runtime feedback on query processing. This paper explores dynamic optimization techniques considering operators at the implementation levels, and the configuration of this approach using MLIR, which is the recent major compiler infrastructure. Additionally, the potential for performance improvements is examined through preliminary experiments. |
Keyword |
(in Japanese) |
(See Japanese page) |
(in English) |
dynamic query optimization / multi query optimization / MLIR / / / / / |
Reference Info. |
IEICE Tech. Rep., vol. 123, no. 192, DE2023-23, pp. 72-77, Sept. 2023. |
Paper # |
DE2023-23 |
Date of Issue |
2023-09-14 (DE) |
ISSN |
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 |
DE2023-23 |
Conference Information |
Committee |
DE IPSJ-DBS IPSJ-IFAT |
Conference Date |
2023-09-21 - 2023-09-22 |
Place (in Japanese) |
(See Japanese page) |
Place (in English) |
Kitakyushu International Conference Center |
Topics (in Japanese) |
(See Japanese page) |
Topics (in English) |
Bigdata management, information retrieval, knowledge discovery, etc. |
Paper Information |
Registration To |
DE |
Conference Code |
2023-09-DE-DBS-IFAT |
Language |
Japanese |
Title (in Japanese) |
(See Japanese page) |
Sub Title (in Japanese) |
(See Japanese page) |
Title (in English) |
A Preliminary Study of Dynamic Query Optimization Using MLIR |
Sub Title (in English) |
|
Keyword(1) |
dynamic query optimization |
Keyword(2) |
multi query optimization |
Keyword(3) |
MLIR |
Keyword(4) |
|
Keyword(5) |
|
Keyword(6) |
|
Keyword(7) |
|
Keyword(8) |
|
1st Author's Name |
Genki Kimura |
1st Author's Affiliation |
The University of Tokyo (UT) |
2nd Author's Name |
Kazuo Goda |
2nd Author's Affiliation |
The University of Tokyo (UT) |
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 |
() |
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 |
2023-09-22 10:55:00 |
Presentation Time |
25 minutes |
Registration for |
DE |
Paper # |
DE2023-23 |
Volume (vol) |
vol.123 |
Number (no) |
no.192 |
Page |
pp.72-77 |
#Pages |
6 |
Date of Issue |
2023-09-14 (DE) |