Design method for a Historical Data Warehouse, explicit valid time in multidimensional models

We present a new storage structure that contains the explicit valid time called Historical DW. This proposal combines a Historical Data Base and a DW in one integrated model. The objective of this model is to solve the temporal limitations of the traditional multidimensional structures. Although the...

Descripción completa

Guardado en:

Detalles Bibliográficos
Autores principales:	Neil,Carlos G, De Vincenzi,Marcelo E, Pons,Claudia F
Lenguaje:	English
Publicado:	Universidad de Tarapacá. 2014
Materias:	Design method model driven software development data warehouse historical data base valid time
Acceso en línea:	http://www.scielo.cl/scielo.php?script=sci_arttext&pid=S0718-33052014000200008
Etiquetas:	Agregar Etiqueta Sin Etiquetas, Sea el primero en etiquetar este registro!

id	oai:scielo:S0718-33052014000200008
record_format	dspace
spelling	oai:scielo:S0718-330520140002000082014-09-02Design method for a Historical Data Warehouse, explicit valid time in multidimensional modelsNeil,Carlos GDe Vincenzi,Marcelo EPons,Claudia F Design method model driven software development data warehouse historical data base valid time We present a new storage structure that contains the explicit valid time called Historical DW. This proposal combines a Historical Data Base and a DW in one integrated model. The objective of this model is to solve the temporal limitations of the traditional multidimensional structures. Although the Temporal DW considers, besides the temporal dimension, other aspects related to time, this model only takes into account the changes that occur in the DW schema, both in dimensions and in hierarchies. Therefore, considering the need for registering values that allow to evaluate trends, variations, maximum and minimum values, a problem to be solved is how to shape the values of entities, attributes or relationships that may vary in time, in the design of the structure. The fact that the needed data was stored is already known, but the temporal search mechanisms would be complex. The Historical DW design is framed in the MDD approach, a strategy that allows, through successive automatic transformations, to obtain one of the implementations of the model in a Relational Data Base Management System (RDBMS).info:eu-repo/semantics/openAccessUniversidad de Tarapacá.Ingeniare. Revista chilena de ingeniería v.22 n.2 20142014-04-01text/htmlhttp://www.scielo.cl/scielo.php?script=sci_arttext&pid=S0718-33052014000200008en10.4067/S0718-33052014000200008
institution	Scielo Chile
collection	Scielo Chile
language	English
topic	Design method model driven software development data warehouse historical data base valid time
spellingShingle	Design method model driven software development data warehouse historical data base valid time Neil,Carlos G De Vincenzi,Marcelo E Pons,Claudia F Design method for a Historical Data Warehouse, explicit valid time in multidimensional models
description	We present a new storage structure that contains the explicit valid time called Historical DW. This proposal combines a Historical Data Base and a DW in one integrated model. The objective of this model is to solve the temporal limitations of the traditional multidimensional structures. Although the Temporal DW considers, besides the temporal dimension, other aspects related to time, this model only takes into account the changes that occur in the DW schema, both in dimensions and in hierarchies. Therefore, considering the need for registering values that allow to evaluate trends, variations, maximum and minimum values, a problem to be solved is how to shape the values of entities, attributes or relationships that may vary in time, in the design of the structure. The fact that the needed data was stored is already known, but the temporal search mechanisms would be complex. The Historical DW design is framed in the MDD approach, a strategy that allows, through successive automatic transformations, to obtain one of the implementations of the model in a Relational Data Base Management System (RDBMS).
author	Neil,Carlos G De Vincenzi,Marcelo E Pons,Claudia F
author_facet	Neil,Carlos G De Vincenzi,Marcelo E Pons,Claudia F
author_sort	Neil,Carlos G
title	Design method for a Historical Data Warehouse, explicit valid time in multidimensional models
title_short	Design method for a Historical Data Warehouse, explicit valid time in multidimensional models
title_full	Design method for a Historical Data Warehouse, explicit valid time in multidimensional models
title_fullStr	Design method for a Historical Data Warehouse, explicit valid time in multidimensional models
title_full_unstemmed	Design method for a Historical Data Warehouse, explicit valid time in multidimensional models
title_sort	design method for a historical data warehouse, explicit valid time in multidimensional models
publisher	Universidad de Tarapacá.
publishDate	2014
url	http://www.scielo.cl/scielo.php?script=sci_arttext&pid=S0718-33052014000200008
work_keys_str_mv	AT neilcarlosg designmethodforahistoricaldatawarehouseexplicitvalidtimeinmultidimensionalmodels AT devincenzimarceloe designmethodforahistoricaldatawarehouseexplicitvalidtimeinmultidimensionalmodels AT ponsclaudiaf designmethodforahistoricaldatawarehouseexplicitvalidtimeinmultidimensionalmodels
_version_	1714203412752498688

Design method for a Historical Data Warehouse, explicit valid time in multidimensional models

Ejemplares similares