Full Article: PDF
Scientific Object Identifier: http://s-o-i.org/1.1/TAS-11-55-21
DOI: https://dx.doi.org/10.15863/TAS.2017.11.55.21
Language: English
Citation: Sabinin O, Sheikina E (2017) MULTIDIMENSIONAL DATABASES AS A DATA SOURCE OF BUSINESS INTELLIGENCE SYSTEMS. ISJ Theoretical & Applied Science, 11 (55): 175-180. Soi: http://s-o-i.org/1.1/TAS-11-55-21 Doi: https://dx.doi.org/10.15863/TAS.2017.11.55.21 |
Pages: 175-180
Published: 30.11.2017
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 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.
Key words: Business Intelligence, databases, MOLAP, ROLAP, HOLAP.
|
