Paper Abstract and Keywords |
Presentation |
2007-07-03 14:25
Database Restructuration Spport Based on Cost Estimation Qiang Ma, Yoshihide Ishiguro (NEC) DE2007-82 |
Abstract |
(in Japanese) |
(See Japanese page) |
(in English) |
Generally, the database schemata of a certain appliaction or service are designed in advance. However, since data increase rapidly and its usage and access pattern change dynamically, the database perfomance will go down in some cases. Dynamic restructing of database schemata is one of the solutions for this issue. However, the conventional methods of database restructing just try to create or modify views based on the access-cost estimation. They do not support advanced database restructing functions, such as schema merger and division, and database restructing based on storage-cost estimation. Hence, database restructing relies on database experts and is a very expensive task yet. In this paper, we propose methods of database cost-estimation and visualization for supporting database restructing. Based on these methods, we can compare the costs of different database schemata without changing the schemata in a RDB system. We also introduce a prototype system under developing and some evaluation results. |
Keyword |
(in Japanese) |
(See Japanese page) |
(in English) |
Database Restructing / Cost Estimation / Access Cost / Storage Cost / / / / |
Reference Info. |
IEICE Tech. Rep., vol. 107, no. 131, DE2007-82, pp. 363-368, July 2007. |
Paper # |
DE2007-82 |
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-82 |
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) |
Database Restructuration Spport Based on Cost Estimation |
Sub Title (in English) |
|
Keyword(1) |
Database Restructing |
Keyword(2) |
Cost Estimation |
Keyword(3) |
Access Cost |
Keyword(4) |
Storage Cost |
Keyword(5) |
|
Keyword(6) |
|
Keyword(7) |
|
Keyword(8) |
|
1st Author's Name |
Qiang Ma |
1st Author's Affiliation |
NEC (NEC) |
2nd Author's Name |
Yoshihide Ishiguro |
2nd Author's Affiliation |
NEC (NEC) |
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 |
2007-07-03 14:25:00 |
Presentation Time |
25 minutes |
Registration for |
DE |
Paper # |
DE2007-82 |
Volume (vol) |
vol.107 |
Number (no) |
no.131 |
Page |
pp.363-368 |
#Pages |
6 |
Date of Issue |
2007-06-25 (DE) |
|