Integrating Amazonic Heterogeneous Hydrometeorological Databases

This paper tackles a logical database integration process implemented for existing databases from the Brazilian National Water Agency (ANA). It describes an important part of a Brazilian Project between ANA and Brazilian Aeronautics Institute of Technology (ITA). The integration process started with a detailed analysis of four existing databases, followed by logical modeling elaboration and integration. Its major contributions are the description of main processes, documentations, model auditing, and human resources involved. At the end, the best practices used for applying main data modeling and database design techniques together with a successful use of a modeling tools are also presented.