ISJ Theoretical & Applied Science

 

 

Information about the scientific conferences and journal

Schedule of conferences

Submit a report to the conference

Requirements to the article

Section

Indexing

Journal archive

Tracing of postal items

The organizing Committee of Conference

Editorial Board

 

 

www.T-Science.org       p-ISSN 2308-4944 (print)       e-ISSN 2409-0085 (online)
SOI: 1.1/TAS         DOI: 10.15863/TAS

Journal Archive

ISJ Theoretical & Applied Science 11(55) 2017

ISPC Technological development, Philadelphia, USA

* Scientific Article * Impact Factor 6.630


Sabinin O, Sheikina E

MULTIDIMENSIONAL DATABASES AS A DATA SOURCE OF BUSINESS INTELLIGENCE SYSTEMS.

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.


 

 

 

 

 

 

E-mail:         T-Science@mail.ru

© «Theoretical &Applied Science»                      2013 г.