| Paper Abstract and Keywords |
| Presentation |
2008-09-22 10:15
[Invited Talk]
Towards Flash-based Enterprise Databases Sang-Won Lee (Sungkyunkwan Univ.) DE2008-47 |
| Abstract |
(in Japanese) |
(See Japanese page) |
| (in English) |
Flash memory is being rapidly deployed as data storage for mobile devices such as PDAs, MP3 players, mobile phones and digital cameras, mainly because of its low electronic power, non-volatile storage, high performance, physical stability, and portability. As its capacity increases and prices drop, flash memory will compete more successfully with lower-end, lower-capacity disk drives. It is thus not inconceivable to consider running a full database system on the flash-only computing platforms or an embedded database system on the lightweight computing devices.
One disadvantage of flash memory is that prewritten data cannot be dynamically overwritten. Before overwriting prewritten data, a time-consuming erase operation on the used blocks must precede, which significantly degrades the overall write performance of flash memory. Therefore, it is very important to solve this "erase-before-write" problem. This talk covers three recent results toward flash-based enterprise database applications.
First, we will explain how a software module inside flash controller, called 'flash translation layer(FTL)' can deal with the "erase-before-write" problem. In particular, we describe a log block buffer scheme, called FAST(Full Associative Sector Translation).
Second, we present a new design called in-page logging (IPL) for flash memory based database systems, which can overcome the limitations of flash memory such as high write latency, and exploits unique characteristics of flash memory to achieve the best attainable performance for flash-based database systems.
Third, we will show the applicability and potential impact that flash memory SSD (Solid State Drive) has for certain type of storage spaces of a database server where sequential writes and random reads are prevalent. We show empirically that up to more than an order of magnitude improvement can be achieved in transaction processing by replacing magnetic disk with flash memory SSD for transaction log, rollback segments, and temporary table spaces. |
| Keyword |
(in Japanese) |
(See Japanese page) |
| (in English) |
Flash Memory / Enterprise Databases / / / / / / |
| Reference Info. |
IEICE Tech. Rep., vol. 108, no. 211, DE2008-47, pp. 35-36, Sept. 2008. |
| Paper # |
DE2008-47 |
| 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-47 |
| 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) |
Towards Flash-based Enterprise Databases |
| Sub Title (in English) |
|
| Keyword(1) |
Flash Memory |
| Keyword(2) |
Enterprise Databases |
| Keyword(3) |
|
| Keyword(4) |
|
| Keyword(5) |
|
| Keyword(6) |
|
| Keyword(7) |
|
| Keyword(8) |
|
| 1st Author's Name |
Sang-Won Lee |
| 1st Author's Affiliation |
Sungkyunkwan University, Korea (Sungkyunkwan 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 |
() |
| 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 |
2008-09-22 10:15:00 |
| Presentation Time |
30 minutes |
| Registration for |
DE |
| Paper # |
DE2008-47 |
| Volume (vol) |
vol.108 |
| Number (no) |
no.211 |
| Page |
pp.35-36 |
| #Pages |
2 |
| Date of Issue |
2008-09-14 (DE) |
|