Developing scalable management information system with big financial data using data mart and mining architecture

Abstract

The traditional Management Information System (MIS) with Big Financial Data (BFD) for corporate financial diagnosis has many limitations such as the data is not summarized thus these causing increases in query times, and also the complexity in analysis. The creation of a Data Mart (DM) leads to a great summarization of data, such that contains only essential business information. And by using data mining techniques we can be extracting unknown useful information from DM and apply it to make important decisions for the business. Thus, in this paper we are adopting an architecture of six layers; interface layer, analysis layer, extract transformation load layer, data mart layer, data mining layer, and evaluating layer, MIS with BFD using DM and Mining (MIS-BFD-DMM) is proposed, which is not only permits the use of DM and mining technologies in decision support, but also the full utilization of non-financial/financial info held by businesses. This paper offers the benefits of building and integrating DM with mining. Also determines the distinction between DM and a relational database for decision-makers to get information. The test and analysis are achieved in the terms of useful metrics (accuracy, balance accuracy, F-measure, precision, recall, and time). As a result, Data returned from arranged star schema is far faster than ERD. In conclusion, the SVM is best than other algorithms in terms of the parameters of the confusion matrix.