Development of a Decision Support System with the use of OLAP-Technologies in the National Terminological Information Environment

Full Text (PDF, 1043KB), PP.43-52

Views: 0 Downloads: 0

Author(s)

Rasim M. Alguliyev 1,* Gulnara Ch. Nabibayova 1 Afruz M. Gurbanova 1

1. Institute of Information Technology, Azerbaijan National Academy of Sciences

* Corresponding author.

DOI: https://doi.org/10.5815/ijmecs.2019.06.05

Received: 8 Apr. 2019 / Revised: 18 Apr. 2019 / Accepted: 26 Apr. 2019 / Published: 8 Jun. 2019

Index Terms

Decision support system, data warehouse, OLAP, terminology information system, data marts, OLTP, hypercube, cube measurement, term

Abstract

In order to improve analytical activities and providing support to decision makers in the field of terminology, the article proposes a decision support system developed based on the data warehouse technologies and online analytical processing OLAP. The architectural and technological model of the system, its integration with the terminological information system is presented. The role of this system in the National Terminology Information System is shown. The article also presents the structure of the data warehouse and the OLAP-cube developed on its basis.

Cite This Paper

Rasim M. Alguliyev, Gulnara Ch. Nabibayova, Afruz M. Gurbanova, "Development of a Decision Support System with the use of OLAP-Technologies in the National Terminological Information Environment", International Journal of Modern Education and Computer Science(IJMECS), Vol.11, No.6, pp. 43-52, 2019.DOI: 10.5815/ijmecs.2019.06.05

Reference

[1]Rasim M. Alguliyev, Afruz M. Gurbanova. The Conceptual Foundations of National Terminological Information System // I. J. of Education and Management Engineering, Vol. 8, No. 4, Jul. 2018, pp.19-30.
[2]Aris Tsois, Nikos Karayannidis , Timos Sellis. MAC: Conceptual Data Modeling for OLAP. Proceedings of the International Workshop on Design and Management of Data Warehouses (DMDW'2001) Interlaken, Switzerland, June 4, 2001, V.5, p. 1-11. http://ceur-ws.org/Vol-39/paper5.pdf
[3]Korobko A.V., Penkova T.G. Conceptual OLAP-modeling method based on formal conceptual analysis. Bulletin of the Siberian State Aerospace University after Academician M.F. Reshetneva, Russia, 2010, No 4 (30), pp. 74-79
[4]Kulagin V.P., Matchin V.T. Mathematical modeling of OLAP-cube in the context of aggregation of simple and hierarchical dimensions. News of the Tomsk Polytechnic University, 2010, Vol. 316, No 5, pp. 72-75.
[5]Thanh Binh Nguyen, A. Min Tjoa, and Roland Wagner. Conceptual Multidimensional Data Model Based on MetaCube, International Conference on Advances in Information Systems ADVIS 2000, LNCS 1909, 2000, pp. 24-33,
[6]Biryukov A.S. Decision Making and Data Warehouse // DBMS, 1997, No4, pp. 37-41.
[7]Berner Eta, S. Clinical Decision Support Systems. Theory and Practice / S. Berner Eta. Springer, 2007, 274 p.].
[8]Inmon W. Building the Data Warehouse (4th Edition), 2005, 543 p.
[9]Kudryavtsev Yu. OLAP-technologies: a review of tasks and studies // Business Informatics, 2008, No1, pp. 66-70,
[10]Pedersen T., Jensen K., Technology of multidimensional databases // Open Systems, 2002, No1, http://www.osp.ru/os/2002/01/180958/
[11]Fedorov A., Elmanova N. Introduction to Microsoft OLAP-technology. Moscow: Dialog-MEPI, 2002, 268 p.
[12]Shavelyev L.V. Operational analytical data processing: concepts and technologies, http://www.olap.ru/basic/olap_and_ida.asp
[13]Zabotnev M.S. Methods of presenting information in sparse data hypercubes, http://www.olap.ru/basic/theory.asp
[14]Kashirin I.Yu., Semchenkov S.Yu. Interactive analytical data processing in modern OLAP-systems // Business Informatics, 2009, No2, pp. 12-19.
[15]Kupriyanov M.S., Stepanenko V.V., Kholod I.I. Data analysis technologies: Data Mining, Visual Mining, Text Mining, OLAP. Spb .: BHV-Petersburg, 2007, 384 p.
[16]Nekrasov V. Mobile OLAP//Open Systems, 2003, No5.
[17]Nozhenkova L.F. OLAP-modeling tools and their use in health care problems // Mathematical methods of pattern recognition, M, 2007, vol.13, No1, pp. 609-612.
[18]Alguliyev R., Aliguliyev R., Nabibayova G. The Method of Measuring the Integration Degree of Countries on the Basis of International Relations // I.J. Intelligent Systems and Applications, 2015, no. 11, pp. 10-18.
[19]Spirley E. Corporate Data Warehouse. Planning, development and implementation. 2001, vol. 1, 400 p.
[20]Imhoff C. Understanding the Three E's of Integration EAI, EII and ETL. Management Magazine, April 2005, http://www.information-management.com/issues/20050401/1023893-1.htm
[21]E.M. Forster, G. Wallas, A. Gide. Data Visualization, https://apandre.wordpress.com/data/datacube/
[22]Mironov A.A., Mordvinov V.A., Skuratov A.K. Semantic-entropic management of OLAP and xOLAP integration models in SemanticNET (ONTONET) // Informatization of education and science, 2009, No2, pp. 21-30.