A temporal study of data sources to load a corporate data warehouse

  • Martín C
  • Abelló A
  • 7

    Readers

    Mendeley users who have this article in their library.
  • 4

    Citations

    Citations of this article.

Abstract

. The input data of the corporate data warehouse is provided by the data sources, that are integrated. In the temporal database research area, a bitemporal database is a database supporting valid time and transaction time. Valid time is the time when the fact is true in the modeled reality, while transaction time is the time when the fact is stored in the database. Defining a data warehouse as a bitemporal database containing integrated and subjectoriented data in support of the decision making process, transaction time in the data warehouse can always be obtained, because it is internal to a given storage system. When an event is loaded into the data warehouse, its valid time is transformed into a bitemporal element, adding transaction time, generated by the database management system of the data warehouse. However, depending on whether the data sources manage transaction time and valid time or not, we could obtain the valid time for the data warehouse or not. The aim of this paper is to present a temporal study of the different kinds of data sources to load a corporate data warehouse, using a bitemporal storage structure. 1

Author-supplied keywords

  • abelló
  • carme martín and alberto
  • departament de llenguatges i
  • emporal study of data
  • load a corporate data
  • sistemes informàtics
  • sources to
  • warehouse

Get free article suggestions today

Mendeley saves you time finding and organizing research

Sign up here
Already have an account ?Sign in

Find this document

  • SCOPUS: 2-s2.0-35248864934
  • ISSN: 03029743
  • PUI: 137635468
  • SGR: 35248864934

Authors

  • Carme Martín

  • Alberto Abelló

Cite this document

Choose a citation style from the tabs below

Save time finding and organizing research with Mendeley

Sign up for free