• Journals
  • Discipline
  • Indexed
  • Institutions
  • About
JavaScript is disabled for your browser. Some features of this site may not work without it.
View Item 
  •   Home
  • Universidad de Tarapacá
  • Ingeniare: Revista Chilena de Ingeniería
  • View Item
  •   Home
  • Universidad de Tarapacá
  • Ingeniare: Revista Chilena de Ingeniería
  • View Item

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

Author
Neil,Carlos G

De Vincenzi,Marcelo E

Pons,Claudia F

Full text
https://scielo.conicyt.cl/scielo.php?script=sci_arttext&pid=S0718-33052014000200008
Abstract
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).
Metadata
Show full item record
Discipline
Artes, Arquitectura y UrbanismoCiencias Agrarias, Forestales y VeterinariasCiencias Exactas y NaturalesCiencias SocialesDerechoEconomía y AdministraciónFilosofía y HumanidadesIngenieríaMedicinaMultidisciplinarias
Institutions
Universidad de ChileUniversidad Católica de ChileUniversidad de Santiago de ChileUniversidad de ConcepciónUniversidad Austral de ChileUniversidad Católica de ValparaísoUniversidad del Bio BioUniversidad de ValparaísoUniversidad Católica del Nortemore

Browse

All of DSpaceCommunities & CollectionsBy Issue DateAuthorsTitlesSubjectsThis CollectionBy Issue DateAuthorsTitlesSubjects

My Account

LoginRegister
Dirección de Servicios de Información y Bibliotecas (SISIB) - Universidad de Chile
© 2019 Dspace - Modificado por SISIB