A Simpler and Semantic Multidimensional Database Query Language to Facilitate Access to Information in Decision-making

  • Fredi Edgardo Palominos Universidad de Santiago de Chile https://orcid.org/0000-0002-6119-4991
  • Felisa Córdova School of Engineering FinisTerrae University, Santiago, Chile Av. Pedro de Valdivia 1509, Providencia, Región Metropolitana, Chile
  • Claudia Durán Faculty of Engineering Universidad Tecnológica Metropolitana, Santiago, Chile Dieciocho 161, Santiago, Chile
  • Bryan Nuñez Mathematics and Computer Science Department University of Santiago de Chile, Chile Avda. Libertador B. O’Higgins 3363, Estación Central, Santiago, Chile

Abstract

OLAP and multidimensional database technology have contributed significantly to speed up and build confidence in the effectiveness of methodologies based on the use of management indicators in decision-making, industry, production, and services. Although there are a wide variety of tools related to the OLAP approach, many implementations are performed in relational database systems (R-OLAP). So, all interrogation actions are performed through queries that must be reinterpreted in the SQL language. This translation has several consequences because SQL language is based on a mixture of relational algebra and tuple relational calculus, which conceptually responds to the logic of the relational data model, very different from the needs of the multidimensional databases. This paper presents a multidimensional query language that allows expressing multidimensional queries directly over ROLAP databases. The implementation of the multidimensional query language will be done through a middleware that is responsible for mapping the queries, hiding the translation to a layer of software not noticeable to the end-user. Currently, progress has been made in the definition of a language where through a key statement, called aggregate, it is possible to execute the typical multidimensional operators which represent an important part of the most frequent operations in this type of database.

Author Biography

Fredi Edgardo Palominos, Universidad de Santiago de Chile
Department of Mathematics and Computer Science, tenured professor

References

[1] Bojicic, I.; Marjanovic, Z.; Turajlic, N.; Petrovic, M.; Vuckovic, M.; Jovanovic (2016). A comparative analysis of data warehouse data models, In 2016 6th International Conference on Computers Communications and Control (ICCCC), Proceedings of, IEEE, 151-159, 2016.
https://doi.org/10.1109/ICCCC.2016.7496754

[2] Bojicic, I.; Marjanovic, Z.; Turajlic, N.; Petrovic, M.; Vuckovic, M.; Jovanovic, V.(2017). Domain/ Mapping Model: A Novel DataWarehouse Data Mode, International Journal of Computers Communications & Control, 12(2), 166-182, 2017.
https://doi.org/10.15837/ijccc.2017.2.2876

[3] Bouaziz, S.; Nabli, A.; Gargouri, F. (2019). Design a Data Warehouse Schema from Document Oriented database, Procedia Computer Science, 159, 221-230, 2019.
https://doi.org/10.1016/j.procs.2019.09.177

[4] Boukra, D.; Boussaïd, O.; Bentayeb, F. (2010). OLAP operators for complex object data cubes, Lecture Notes in Computer Science (Including Subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics), 6295 LNCS, 103-116, 2010.
https://doi.org/10.1007/978-3-642-15576-5_10

[5] Codd, E. F. (1970). A relational model of data for large shared data banks, Communications of the ACM, 13(6), 377-387, 1970.
https://doi.org/10.1145/362384.362685

[6] Colomo-Palacios, R.; Fernandes, E.; Soto-Acosta, P.; Larrucea, X. (2018). A case analysis of enabling continuous software deployment through knowledge management, International Journal of Information Management, 36(1), 142-154, 2016.

[7] Cuzzocrea, A.; Moussa, R. (2017). Multidimensional database modeling: Literature survey and research agenda in the big data era, 2017 International Symposium on Networks, Computers and Communications (ISNCC), 1-6, 2017.
https://doi.org/10.1109/ISNCC.2017.8072024

[8] Eroshkin, S. Y.; Kameneva, N.; Kovkov, D.; Sukhorukov, A(2017). Conceptual system in the modern information management, Procedia Computer Science, 103(C), 609-612, 2017.
https://doi.org/10.1016/j.procs.2017.01.079

[9] Golfarelli, M.; Rizzi, S. (1999). Designing the Data Warehouse: Key Steps and Crucial Issues, Journal of Computer Science and Information Management, 2(3), 1-14, 1999.

[10] Hümmer, W.; Lehner, W.; Bauer, A.; Schlesinger, L. (2002). A Decathlon in Multidimensional Modeling: Open Issues and Some Solutions, Proceedings of the 4th International Conference on Data Warehousing and Knowledge Discovery, 275-285, 2002.
https://doi.org/10.1007/3-540-46145-0_27

[11] Jaroli, P.; Masson, P. (2012). Data Warehousing and OLAP Technology (Data warehousing), International Journal of Engineering Trends and Technology, 2, 955-960, 2012.

[12] Moole, B. R. (2003). A Probabilistic Multidimensional Data Model and Algebra for OLAP in Decision Support Systems, Conf. Proceedings - IEEE SOUTHEASTCON, 18-30, 2003.
https://doi.org/10.1109/SECON.2003.1268426

[13] Pablo, P. V. (2016). Business intelligence applied to monitoring and meta-monitoring scenarios, In 2016 11th Iberian Conference on Information Systems and Technologies (CISTI), 1-6, 2016.
https://doi.org/10.1109/CISTI.2016.7521536

[14] Palominos, F. E.; Duran, C. A.; Córdova, F. M. (2018). Multidimensional data model for the analysis of information of productive, scientific or service processes, In 7th International Conference on Computers Communications and Control, IEEE, 17-22, 2018.
https://doi.org/10.1109/ICCCC.2018.8390431

[15] Palominos, F. E.; Duran, C. A.; Córdova, F. M. (2019). Improve efficiency in multidimensional database queries through the use of additives aggregation functions, Procedia Computer Science, 162, 754-761, 2019.
https://doi.org/10.1016/j.procs.2019.12.047

[16] Piasevoli, T.; Li, S. (2016). MDX with Microsoft SQL Server 2016 Analysis Services cookbook, 2016.

[17] Rahimi, F.; Møller, C.; Hvam, L (2016). Business process management and IT management: The missing integration, International Journal of Information Management, 40, 186-189, 2018.

[18] Taleb, A.; Eavis, T.; Tabbara, H. (2011). The NOX OLAP query model: From algebra to execution, Lecture Notes in Computer Science, 6862 LNCS, 167-183, 2011.
https://doi.org/10.1007/978-3-642-23544-3_13

[19] Zhang, X. (2018). Design of Intelligent Management Decision Support System for Retailing Chains, In 2018 International Conference on Virtual Reality and Intelligent Systems (ICVRIS), Proceedings of, 485-489, 2018.
https://doi.org/10.1109/ICVRIS.2018.00125

[20] Zykin, S. V.; Mosin S. V.; Poluyanov A. N. (2019). Technology of Multidimensional Data Formation Using Caching, 13th International IEEE Scientific and Technical Conference Dynamics of Systems, Mechanisms and Machines, Dynamics 2019 - Proceedings, 1-10, 2019.
https://doi.org/10.1109/Dynamics47113.2019.8944579
Published
2020-06-08
How to Cite
PALOMINOS, Fredi Edgardo et al. A Simpler and Semantic Multidimensional Database Query Language to Facilitate Access to Information in Decision-making. INTERNATIONAL JOURNAL OF COMPUTERS COMMUNICATIONS & CONTROL, [S.l.], v. 15, n. 4, june 2020. ISSN 1841-9844. Available at: <http://univagora.ro/jour/index.php/ijccc/article/view/3900>. Date accessed: 12 july 2020. doi: https://doi.org/10.15837/ijccc.2020.4.3900.

Keywords

data models, multidimensional model, OLAP, decision making, query languages