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
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.