ImpactU Versión 3.11.2 Última actualización: Interfaz de Usuario: 16/10/2025 Base de Datos: 29/08/2025 Hecho en Colombia
Construcción y poblamiento de un datawarehouse basado en el paradigma de bases de datos objeto relacional Construction and population of a datawarehouse based on the paradigm Of databases relational object
The present article present the construction of an administrative system of information developed under the technology Data Warehousing directed to the business Intelligence. It is implementing a methodology of design of Data warehouse named dimention fact model, which allows to adapt the functionality of a multidimensional Data Base of support for uses of control, independent of the data sources which give the historical information. From the shaped one of the data warehouse it is still a boss to give the information of the system by means of the application of the processes ETL, implemented by means of the tool of graphical design of transformations known as Kettle. However, we use three different engines (Access, PostgreSQL, MySQL) named sources isolated of data origin that will be an object of integration and Extraction for our warehouse developed in a different engine (Oracle 10g Express) under the Object-Relational paradigm. The results exposed will serve as foundations for entrusted to administer systems of information, as well as for high managers and clerical that they wish implement strategies on new technologies with the aim to achieve major efficiency of agreement to the managerial decisions that go to the obtaining of ideal results for the organizations.