Desarrollo de un sistema de control financiero para la empresa CBM utilizando el gestor de base de datos Apache Cassandra.

Abstract

The objective of this research work was to automate the process of credit control of the CBM company for the reduction of time in the reports generation. A comparison was made between the times generated by the administrators with the system and manually, for the realization of this statistical analysis a survey was carried out to the administrators of the buildings to obtain the preparation time of reports. The time in the generation of reports with and without the use of the computer system was compared, descriptive statistics were used to compare the elapsed times. In the development of the application, the agile development methodology SCRUM was used together with Model-View-Controller architecture structured in several layers, and the technologies Java Server Face (JSF) and as database engine the NoSQL Apache Cassandra was chosen as the database which works oriented to columns; Thanks to this, the creation, deletion and modification can be done at run time without blocking updates or queries. It was obtained as a result that the use of the computer system allowed the reduction of the generation time of the credit reports by 99.78%. So, it is concluded that the system had a positive impact on the time of the credit control process of the company and it is recommended the use of column-oriented databases because can be reached to analyze the information to a high degree of detail.