Conceptual design of a temporal data warehouse

Autores
Neil, Carlos Gerardo; Ale, Juan María
Año de publicación
2002
Idioma
inglés
Tipo de recurso
documento de conferencia
Estado
versión publicada
Descripción
In a data warehouse, time is one of the dimensions for the analysis, but it refers to the moment in which the transaction was made, it does not explain in detail how the attributes or relationship involved in the transactions change. We are proposing a multidimensional schema that includes not only the main fact of analysis but also the temporal schemas, which did not belong to a hierarchy within the dimensions, but will register the variation of certain attributes and relationships. To build this schema, we are proposing an expansion of the algorithm that will allow to build the conceptual design of a data warehouse semi-automatically from a temporal entity-relationship model. We will unite in one model the multidimensional schema and the temporal schema to allow the registration and analysis of temporal variations and queries about the multidimensional structure.
Sociedad Argentina de Informática e Investigación Operativa
Materia
Ciencias Informáticas
Data warehouse
Conceptual models
Multidimensional data model
Entity-relationship model
Nivel de accesibilidad
acceso abierto
Condiciones de uso
http://creativecommons.org/licenses/by-nc-sa/4.0/
Repositorio
SEDICI (UNLP)
Institución
Universidad Nacional de La Plata
OAI Identificador
oai:sedici.unlp.edu.ar:10915/183096
Acceder
id SEDICI_0e25cb170a8a26b52e5bcbeb20804b9b
oai_identifier_str oai:sedici.unlp.edu.ar:10915/183096
network_acronym_str SEDICI
repository_id_str 1329
network_name_str SEDICI (UNLP)
spelling Conceptual design of a temporal data warehouseNeil, Carlos GerardoAle, Juan MaríaCiencias InformáticasData warehouseConceptual modelsMultidimensional data modelEntity-relationship modelIn a data warehouse, time is one of the dimensions for the analysis, but it refers to the moment in which the transaction was made, it does not explain in detail how the attributes or relationship involved in the transactions change. We are proposing a multidimensional schema that includes not only the main fact of analysis but also the temporal schemas, which did not belong to a hierarchy within the dimensions, but will register the variation of certain attributes and relationships. To build this schema, we are proposing an expansion of the algorithm that will allow to build the conceptual design of a data warehouse semi-automatically from a temporal entity-relationship model. We will unite in one model the multidimensional schema and the temporal schema to allow the registration and analysis of temporal variations and queries about the multidimensional structure.Sociedad Argentina de Informática e Investigación Operativa2002-09info:eu-repo/semantics/conferenceObjectinfo:eu-repo/semantics/publishedVersionObjeto de conferenciahttp://purl.org/coar/resource_type/c_5794info:ar-repo/semantics/documentoDeConferenciaapplication/pdf143-156http://sedici.unlp.edu.ar/handle/10915/183096enginfo:eu-repo/semantics/altIdentifier/issn/1666-1087info:eu-repo/semantics/openAccesshttp://creativecommons.org/licenses/by-nc-sa/4.0/Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0)reponame:SEDICI (UNLP)instname:Universidad Nacional de La Platainstacron:UNLP2025-09-29T11:50:03Zoai:sedici.unlp.edu.ar:10915/183096Institucionalhttp://sedici.unlp.edu.ar/Universidad públicaNo correspondehttp://sedici.unlp.edu.ar/oai/snrdalira@sedici.unlp.edu.arArgentinaNo correspondeNo correspondeNo correspondeopendoar:13292025-09-29 11:50:03.813SEDICI (UNLP) - Universidad Nacional de La Platafalse
dc.title.none.fl_str_mv Conceptual design of a temporal data warehouse
title Conceptual design of a temporal data warehouse
spellingShingle Conceptual design of a temporal data warehouse
Neil, Carlos Gerardo
Ciencias Informáticas
Data warehouse
Conceptual models
Multidimensional data model
Entity-relationship model
title_short Conceptual design of a temporal data warehouse
title_full Conceptual design of a temporal data warehouse
title_fullStr Conceptual design of a temporal data warehouse
title_full_unstemmed Conceptual design of a temporal data warehouse
title_sort Conceptual design of a temporal data warehouse
dc.creator.none.fl_str_mv Neil, Carlos Gerardo
Ale, Juan María
author Neil, Carlos Gerardo
author_facet Neil, Carlos Gerardo
Ale, Juan María
author_role author
author2 Ale, Juan María
author2_role author
dc.subject.none.fl_str_mv Ciencias Informáticas
Data warehouse
Conceptual models
Multidimensional data model
Entity-relationship model
topic Ciencias Informáticas
Data warehouse
Conceptual models
Multidimensional data model
Entity-relationship model
dc.description.none.fl_txt_mv In a data warehouse, time is one of the dimensions for the analysis, but it refers to the moment in which the transaction was made, it does not explain in detail how the attributes or relationship involved in the transactions change. We are proposing a multidimensional schema that includes not only the main fact of analysis but also the temporal schemas, which did not belong to a hierarchy within the dimensions, but will register the variation of certain attributes and relationships. To build this schema, we are proposing an expansion of the algorithm that will allow to build the conceptual design of a data warehouse semi-automatically from a temporal entity-relationship model. We will unite in one model the multidimensional schema and the temporal schema to allow the registration and analysis of temporal variations and queries about the multidimensional structure.
Sociedad Argentina de Informática e Investigación Operativa
description In a data warehouse, time is one of the dimensions for the analysis, but it refers to the moment in which the transaction was made, it does not explain in detail how the attributes or relationship involved in the transactions change. We are proposing a multidimensional schema that includes not only the main fact of analysis but also the temporal schemas, which did not belong to a hierarchy within the dimensions, but will register the variation of certain attributes and relationships. To build this schema, we are proposing an expansion of the algorithm that will allow to build the conceptual design of a data warehouse semi-automatically from a temporal entity-relationship model. We will unite in one model the multidimensional schema and the temporal schema to allow the registration and analysis of temporal variations and queries about the multidimensional structure.
publishDate 2002
dc.date.none.fl_str_mv 2002-09
dc.type.none.fl_str_mv info:eu-repo/semantics/conferenceObject
info:eu-repo/semantics/publishedVersion
Objeto de conferencia
http://purl.org/coar/resource_type/c_5794
info:ar-repo/semantics/documentoDeConferencia
format conferenceObject
status_str publishedVersion
dc.identifier.none.fl_str_mv http://sedici.unlp.edu.ar/handle/10915/183096
url http://sedici.unlp.edu.ar/handle/10915/183096
dc.language.none.fl_str_mv eng
language eng
dc.relation.none.fl_str_mv info:eu-repo/semantics/altIdentifier/issn/1666-1087
dc.rights.none.fl_str_mv info:eu-repo/semantics/openAccess
http://creativecommons.org/licenses/by-nc-sa/4.0/
Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0)
eu_rights_str_mv openAccess
rights_invalid_str_mv http://creativecommons.org/licenses/by-nc-sa/4.0/
Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0)
dc.format.none.fl_str_mv application/pdf
143-156
dc.source.none.fl_str_mv reponame:SEDICI (UNLP)
instname:Universidad Nacional de La Plata
instacron:UNLP
reponame_str SEDICI (UNLP)
collection SEDICI (UNLP)
instname_str Universidad Nacional de La Plata
instacron_str UNLP
institution UNLP
repository.name.fl_str_mv SEDICI (UNLP) - Universidad Nacional de La Plata
repository.mail.fl_str_mv alira@sedici.unlp.edu.ar
_version_ 1844616360128151552
score 13.069144

Publicaciones similares