Paper Abstract and Keywords |
Presentation |
2007-07-04 08:25
An approach of using a parallel B-tree structure, Fat-Btree, in PostgreSQL for distributed retrieval Yuta Namiki (Tokyo Tech), Kota Kanbe (Future Architect), Dai Kobayashi (Tokyo Tech./JSPS), Haruo Yokota (Tokyo Tech) DE2007-101 |
Abstract |
(in Japanese) |
(See Japanese page) |
(in English) |
Parallel database systems have been developed to support the performance demands on large databases. To enable distributed retrieval on multiple PostgreSQL servers with the current technology, data are distributed into PEs based on statically settled values. There has been no challenges using any distributed index which can dynamically change data distribution for retrieving data using index. We consider a retrieving function for data distributed on multiple PEs using a Fat-Btree, a parallel B-tree structure. We implement a part of it and perform experiments. The experimental result shows that data retrieval using the Fat-Btree provide higher throughput than using the non-distributed B-tree on a PE, for frequent retrieval requests. |
Keyword |
(in Japanese) |
(See Japanese page) |
(in English) |
Parallel B-Tree / Fat-Btree / PostgreSQL / Distributed Retrieval / / / / |
Reference Info. |
IEICE Tech. Rep., vol. 107, no. 131, DE2007-101, pp. 473-478, July 2007. |
Paper # |
DE2007-101 |
Date of Issue |
2007-06-25 (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 |
DE2007-101 |
Conference Information |
Committee |
DE |
Conference Date |
2007-07-02 - 2007-07-04 |
Place (in Japanese) |
(See Japanese page) |
Place (in English) |
Akiu hot springs (Sendai) |
Topics (in Japanese) |
(See Japanese page) |
Topics (in English) |
Summer Database Workshop 2007 (Data engineering, etc.) |
Paper Information |
Registration To |
DE |
Conference Code |
2007-07-DE |
Language |
Japanese |
Title (in Japanese) |
(See Japanese page) |
Sub Title (in Japanese) |
(See Japanese page) |
Title (in English) |
An approach of using a parallel B-tree structure, Fat-Btree, in PostgreSQL for distributed retrieval |
Sub Title (in English) |
|
Keyword(1) |
Parallel B-Tree |
Keyword(2) |
Fat-Btree |
Keyword(3) |
PostgreSQL |
Keyword(4) |
Distributed Retrieval |
Keyword(5) |
|
Keyword(6) |
|
Keyword(7) |
|
Keyword(8) |
|
1st Author's Name |
Yuta Namiki |
1st Author's Affiliation |
Tokyo Institute of Technology (Tokyo Tech) |
2nd Author's Name |
Kota Kanbe |
2nd Author's Affiliation |
Future Architect, Inc. (Future Architect) |
3rd Author's Name |
Dai Kobayashi |
3rd Author's Affiliation |
Tokyo Institute of Technology/JSPS (Tokyo Tech./JSPS) |
4th Author's Name |
Haruo Yokota |
4th Author's Affiliation |
Tokyo Institute of Technology (Tokyo Tech) |
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 |
2007-07-04 08:25:00 |
Presentation Time |
25 minutes |
Registration for |
DE |
Paper # |
DE2007-101 |
Volume (vol) |
vol.107 |
Number (no) |
no.131 |
Page |
pp.473-478 |
#Pages |
6 |
Date of Issue |
2007-06-25 (DE) |
|