MODELING OF AN ANALYTICAL DATABASE SYSTEM
Alex Sandro Romeu de Souza Poletto, Jorge Rady de Almeida · 2007
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