Design method for a Historical Data Warehouse, explicit valid time in multidimensional models
Fuente:
Redalyc
Saved in:
| Main Author: | |
|---|---|
| Format: | Artículo científico |
| Language: | en |
| Published: |
Universidad de Tarapacá
2014
|
| Subjects: | |
| Online Access: | |
| Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
| _version_ | 1876453757513891840 |
|---|---|
| author | Carlos G. Neil |
| author_facet | Carlos G. Neil |
| contents | Design method for a Historical Data Warehouse, explicit valid time in multidimensional models Carlos G. Neil Marcelo E. De Vincenzi Claudia F. Pons Ingeniería valid time Design method data warehouse historical data base model driven software development 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). 2014 artículo científico 0718-3291 https://www.redalyc.org/articulo.oa?id=77231016008 en http://www.redalyc.org/revista.oa?id=772 Ingeniare. Revista Chilena de Ingeniería application/pdf Universidad de Tarapacá Ingeniare. Revista Chilena de Ingeniería (Chile) Num.2 Vol.22 |
| format | Artículo científico |
| id | redalyc_77231016008 |
| institution | Redalyc |
| language | en |
| publishDate | 2014 |
| publisher | Universidad de Tarapacá |
| spellingShingle | Design method for a Historical Data Warehouse, explicit valid time in multidimensional models Carlos G. Neil Ingeniería valid time Design method data warehouse historical data base model driven software development Design method for a Historical Data Warehouse, explicit valid time in multidimensional models Carlos G. Neil Marcelo E. De Vincenzi Claudia F. Pons Ingeniería valid time Design method data warehouse historical data base model driven software development 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). 2014 artículo científico 0718-3291 https://www.redalyc.org/articulo.oa?id=77231016008 en http://www.redalyc.org/revista.oa?id=772 Ingeniare. Revista Chilena de Ingeniería application/pdf Universidad de Tarapacá Ingeniare. Revista Chilena de Ingeniería (Chile) Num.2 Vol.22 |
| title | Design method for a Historical Data Warehouse, explicit valid time in multidimensional models |
| topic | Ingeniería valid time Design method data warehouse historical data base model driven software development |
| url | https://www.redalyc.org/articulo.oa?id=77231016008 |