MULTIDIMENSIONAL DATABASES IN INFORMATION SYSTEMS OF UNIVERSITIES

A. Mukasheva, D. Yedilkhan, M. Aldiyar

Аннотация


The article is devoted to the description of the method of multidimensional database, which is an effective method of data storage, which allows analyzing data qualitatively, and most importantly in a short time. The article discusses the capabilities of multidimensional databases, in particular, multidimensional OLAP (On-Line Analytical Processing) cubes when analyzing large amounts of data. Provides an overview and features of a multidimensional database and discusses the steps you need to take with a multidimensional database to understand the structure and capabilities of an OLAP cube. To create a knowledge base, it describes the steps you can take to create and execute a multidimensional database that you can collect from various sources, save to a database, and then prepare a report using OLAP analysis. Various information system data processing technologies such as OLTP and OLAP were considered. The algorithm of the data storage process for analysis purposes was studied. A model of a multidimensional database in the form of a three-dimensional cube was presented. Examples of analysis and ways of obtaining information from the data cube were also given. The use of a multidimensional database in higher education institutions as a simple and effective method of data storage is considered. There are also illustrations of the structure of a higher educational institution to see the bulkiness of information, and what kind of information database operates in the educational institution.

Ключевые слова


Information system, Database, OLAP, OLTP, three-dimensional, one-dimensional, data analysis

Полный текст:

PDF (English)

Литература


Karpova I.P. (2009) Osnovy bazy dannyh. Uchebnoe posobie. Moskva: Moscow State Institute of Electronics and Mathematics (Technical University).

Palominos F. E., Córdova, F., Durán, C., & Nuñez, B. (2020). A simpler and semantic multidimensional database query language to facilitate access to information in decision-making. International journal of computers communications and control. 15(4). https://doi.org/10.15837/ijccc.2020.4.3900

Orlova M.A. (2021). Konceptual’noe proektirovanie mnogomernoj bazy dannyh importera produkcii. E-Scio, 11 (62), 99–105.

Blagodatskiy G.A. (2020). Multidimensional database analysis. Izhevsk, Russia: Izhevsk State Technical University named after M. T. Kalashnikov.

Cabibbo, L., & Torlone, R. (1998). A logical approach to multidimensional databases. Lecture Notes in Computer Science, 183–197. https://doi.org/10.1007/bfb0100985

Cabibbo, L., & Torlone, R. (1998). Querying multidimensional databases. Database Programming Languages, 319–335. https://doi.org/10.1007/3-540-64823-2_18

Shahi, C., & Sinha, M. (2020). Digital Transformation: Challenges faced by organizations and their potential solutions. International Journal of Innovation Science, 13(1), 17–33. https://doi.org/10.1108/ijis-09-2020-0157

Iyengar, S. S., Rao, N. S. V., Kashyap, R. L., & Vaishnavi, V. K. (1988). Multidimensional Data Structures: Review and outlook. Advances in Computers, 69–119. https://doi.org/10.1016/s0065-2458(08)60257-0

Khatwani, G., & Kar, A. K. (2017). Improving the cosine consistency index for the analytic hierarchy process for solving multi-criteria decision making problems. Applied Computing and Informatics, 13(2), 118–129. https://doi.org/10.1016/j.aci.2016.05.001

Petersen, A. H., & Ekstrøm, C. T. (2019). Your assistant for documenting supervised data quality screening in R. Journal of Statistical Software, 90(6). https://doi.org/10.18637/jss.v090.i06

Liu Y.A., Stoller S.D. Knowledge of Uncertain Worlds: Programming with Logical Constraints. - Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics) 11972, (pp.111-127).

Jennex, M. E. (2017). Big Data, the internet of things, and the revised knowledge pyramid. ACM SIGMIS Database: the DATABASE for Advances in Information Systems, 48(4), 69–79. https://doi.org/10.1145/3158421.3158427

Zhang, Y., Lin, G., Gu, H., Zhuang, F., & Wei, G. (2020). Multi-copy dynamic cloud data auditing model based on IMB Tree. Enterprise Information Systems, 15(2), 248–269. https://doi.org/10.1080/17517575.2020.1812004

Arnas, D., & Rodríguez, M. (2020). Range searching in multidimensional databases using navigation metadata. Applied Mathematics and Computation, 386, 125510. https://doi.org/10.1016/j.amc.2020.125510

Anshari, M., Almunawar, M. N., Lim, S. A., & Al-Mudimigh, A. (2019). Customer relationship management and Big Data enabled: Personalization & Customization Of Services. Applied Computing and Informatics, 15(2), 94–101. https://doi.org/10.1016/j.aci.2018.05.004

Vial, G. (2019). Understanding digital transformation: A review and a research agenda. The Journal of Strategic Information Systems, 28(2), 118–144. https://doi.org/10.1016/j.jsis.2019.01.003

Roberts, N., Qahri-Saremi, H., & Vijayasarathy, L. R. (2021). Understanding IT value at the managerial level: Managerial ambidexterity, seizing opportunities, and the moderating role of information systems use. ACM SIGMIS Database: the DATABASE for Advances in Information Systems, 52(3), 39–55. https://doi.org/10.1145/3481629.3481633




DOI: http://dx.doi.org/10.37943/AITU.2022.53.85.008

Ссылки

  • Ссылки не определены.


(P): 2707-9031
(E): 2707-904X


Нур-Султан
Бизнес-центр EXPO, блок C.1.
Казахстан, 010000

sjaitu@astanait.edu.kz