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...

Descripción completa

Guardado en:
Detalles Bibliográficos
Autor principal: Gorla, Narasimhaiah
Formato: Articulo
Lenguaje:Inglés
Publicado: 2007
Materias:
Ciencias Informáticas
Constraints
Base de Datos
partitioning schemes
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:
SEDICI (UNLP) de Universidad Nacional de La Plata
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

Ejemplares similares