loading
Papers Papers/2020

Research.Publish.Connect.

Paper

Paper Unlock

Authors: Alex Sandro Romeu de Souza Poletto and Jorge Rady Almeida Junior

Affiliation: Fundação Educacional do Município de Assis (FEMA); Escola Politécnica-Universidade de São Paulo, Brazil

ISBN: 978-972-8865-88-7

ISSN: 2184-4992

Keyword(s): Analytical database, trigger, procedure, operational database, decision taking, SQL.

Related Ontology Subjects/Areas/Topics: Coupling and Integrating Heterogeneous Data Sources ; Data Warehouses and OLAP ; Databases and Information Systems Integration ; Enterprise Information Systems ; Enterprise Resource Planning ; Enterprise Software Technologies ; Simulation and Modeling ; Simulation Tools and Platforms ; Software Engineering

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.

CC BY-NC-ND 4.0

Sign In Guest: Register as new SciTePress user now for free.

Sign In SciTePress user: please login.

PDF ImageMy Papers

You are not signed in, therefore limits apply to your IP address 3.239.33.139

In the current month:
Recent papers: 100 available of 100 total
2+ years older papers: 200 available of 200 total

Paper citation in several formats:
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 3: ICEIS, ISBN 978-972-8865-88-7, pages 477-481. DOI: 10.5220/0002362804770481

@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 3: ICEIS,},
year={2007},
pages={477-481},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002362804770481},
isbn={978-972-8865-88-7},
}

TY - CONF

JO - Proceedings of the Ninth International Conference on Enterprise Information Systems - Volume 3: 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

Login or register to post comments.

Comments on this Paper: Be the first to review this paper.