MODELING OF AN ANALYTICAL DATABASE SYSTEM

Alex Sandro Romeu de Souza Poletto, Jorge Rady Almeida Junior

2007

Abstract

This paper describes a modeling for constructing an analytical database, with the objective to store historical values and also the most recent values starting from operational databases. The first function of this modeling is to map operational database into analytical database, using their E-R diagrams. For that, we created ten steps, which will support the mapping. The second function is to make available mechanisms for generation, transport and storage of these historic data. For that, we specified triggers and procedures for each step.

References

  1. Corey, Michael; Abbey, Michael; Abramson, Ian; Taub, Ben. Oracle 8i Data Warehouse. Editora Campus, Date, C J.; Introdução a Sistemas de Banco de Dados. 8ª edição - Rio de Janeiro: Elsevier, 2003.
  2. Gonçalves, Márcio. Extração de Dados para Data Warehouse. Editora: Axcel Bookes do Brasil, 2003.
  3. Inmon, W. H.; Terdeman R. H.; Imhoff, Claudia. Data Warehousing - Como transformar informações em oportunidades de negócios.São Paulo: Berkeley, 2001.
  4. Kimball, Ralph. Data Warehouse Toolkit; o guia completo para modelagem dimensional. Editora: Campus, 2002.
  5. Kochhar, Neena; Gravina, Ellen; Nathan, Priya. Introdução ao Oracle: SQL e PL/SQL. Volume 1 e 2. Editora: Oracle Education, 2000.
  6. Silberschatz, Abraham; Korth, Henry F.; Sudarschan, S. Sistemas de Bancos de Dados. 3ª edição - São Paulo. Editora: Makron Books, 1999.
  7. Vassiliadis, Panos; Simitsis, Alkis; Skiadopoulos, Spiros. Conceptual Modeling for ETL Processes. National Technical University of Athens. McLean, Virginia, USA, 2002.
Download


Paper Citation


in Harvard Style

Sandro Romeu de Souza Poletto A. and Rady Almeida Junior J. (2007). MODELING OF AN ANALYTICAL DATABASE SYSTEM . In Proceedings of the Ninth International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-972-8865-88-7, pages 477-481. DOI: 10.5220/0002362804770481


in Bibtex Style

@conference{iceis07,
author={Alex Sandro Romeu de Souza Poletto and Jorge Rady Almeida Junior},
title={MODELING OF AN ANALYTICAL DATABASE SYSTEM},
booktitle={Proceedings of the Ninth International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2007},
pages={477-481},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002362804770481},
isbn={978-972-8865-88-7},
}


in EndNote Style

TY - CONF
JO - Proceedings of the Ninth International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - MODELING OF AN ANALYTICAL DATABASE SYSTEM
SN - 978-972-8865-88-7
AU - Sandro Romeu de Souza Poletto A.
AU - Rady Almeida Junior J.
PY - 2007
SP - 477
EP - 481
DO - 10.5220/0002362804770481