A Methodology for Vertically Partitioning in a Multi-Relation Database Environment
Vertical partitioning, in which attributes of a relation are assigned to partitions, is aimed at improving database performance. We extend previous research that is based on a single relation to multi-relation database environment, by including referential integrity constraints, access time based he...
Guardado en:
Autor principal: | |
---|---|
Formato: | Articulo |
Lenguaje: | Inglés |
Publicado: |
2007
|
Materias: | |
Acceso en línea: | http://sedici.unlp.edu.ar/handle/10915/9560 http://journal.info.unlp.edu.ar/wp-content/uploads/JCST-Oct07-5.pdf |
Aporte de: |
id |
I19-R120-10915-9560 |
---|---|
record_format |
dspace |
institution |
Universidad Nacional de La Plata |
institution_str |
I-19 |
repository_str |
R-120 |
collection |
SEDICI (UNLP) |
language |
Inglés |
topic |
Ciencias Informáticas Constraints Base de Datos partitioning schemes |
spellingShingle |
Ciencias Informáticas Constraints Base de Datos partitioning schemes Gorla, Narasimhaiah A Methodology for Vertically Partitioning in a Multi-Relation Database Environment |
topic_facet |
Ciencias Informáticas Constraints Base de Datos partitioning schemes |
description |
Vertical partitioning, in which attributes of a relation are assigned to partitions, is aimed at improving database performance. We extend previous research that is based on a single relation to multi-relation database environment, by including referential integrity constraints, access time based heuristic, and a comprehensive cost model that considers most transaction types including updates and joins. The algorithm was applied to a real-world insurance CLAIMS database. Simulation experiments were conducted and the results show a performance improvement of 36% to 65% over unpartitioned case.
Application of our method for small databases resulted in partitioning schemes that are comparable to optimal. |
format |
Articulo Articulo |
author |
Gorla, Narasimhaiah |
author_facet |
Gorla, Narasimhaiah |
author_sort |
Gorla, Narasimhaiah |
title |
A Methodology for Vertically Partitioning in a Multi-Relation Database Environment |
title_short |
A Methodology for Vertically Partitioning in a Multi-Relation Database Environment |
title_full |
A Methodology for Vertically Partitioning in a Multi-Relation Database Environment |
title_fullStr |
A Methodology for Vertically Partitioning in a Multi-Relation Database Environment |
title_full_unstemmed |
A Methodology for Vertically Partitioning in a Multi-Relation Database Environment |
title_sort |
methodology for vertically partitioning in a multi-relation database environment |
publishDate |
2007 |
url |
http://sedici.unlp.edu.ar/handle/10915/9560 http://journal.info.unlp.edu.ar/wp-content/uploads/JCST-Oct07-5.pdf |
work_keys_str_mv |
AT gorlanarasimhaiah amethodologyforverticallypartitioninginamultirelationdatabaseenvironment AT gorlanarasimhaiah methodologyforverticallypartitioninginamultirelationdatabaseenvironment |
bdutipo_str |
Repositorios |
_version_ |
1764820492137529346 |