MULTIDIMENSIONAL DATABASES AS A DATA SOURCE OF BUSINESS INTELLIGENCE SYSTEMS

Oleg Sabinin, Ekaterina Sheikina
2017 Theoretical & Applied Science  
Impact Factor: ISRA (India) = 1.344 ISI (Dubai, UAE) = 0.829 GIF (Australia) = 0.564 JIF = 1.500 SIS (USA) = 0.912 РИНЦ (Russia) = 0.207 ESJI (KZ) = 3.860 SJIF (Morocco) = 2.031 ICV (Poland) = 6.630 PIF (India) = 1.940 IBI (India) = 4.260 Abstract: The aim of this paper is to compare a relational database, an optimized relational database, OLAP as a model of multidimensional databases and formulate the prerequisites of the usage of MOLAP, ROLAP and HOLAP on the basis of theoretical facts and an
more » ... implemented experiment in terms of Business Intelligence technologies. The formulated prerequisites refer to data sources' performance, supported amount of data, features of required analysis, available disk space, frequency of reporting and volatility of data. The implemented experiment includes the comparison of average performance of databases, MOLAP, ROLAP and HOLAP with the constant number of rows in a fact table and the increasing complexity of queries, the comparison of average performance of databases and MOLAP with increasing number of rows and observations about average disk space allocated by MOLAP. Furthermore, brief descriptions of Business Intelligence systems, OLAP and its basic forms were given.
doi:10.15863/tas.2017.11.55.21 fatcat:v2xa2no4zvctnkvj7czwjbjbyi