Abstract
The in-field econometric analysis with specific OLAP technology is of benefit to non-econometric analysts for efficient analysis. Integration of the transformation of the econometric model (TEM) method with the software tool is useful for designing a multidimensional database. This research presents the design prototype of such software and its integration with an in-field TEM method to implement database specific for OLAP by a star schema. The prototype of the EM-OLAP Tool software was designed by a simple click-and-play menu using a graphical user interface and optimized to adapt the database design requirements. An algorithm for transformation of econometric models was developed to design a multidimensional schema of database according the TEM method.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Similar content being viewed by others
References
Abelló, A., Romero, O.: On-line analytical processing. In: Liu, L., Özsu, M.T. (eds.) Encyclopedia of database systems, pp. 1949–1954. Springer, Heidelberg (2009)
Berson, A., Smith, S.J.: Data Warehousing, Data Mining, and OLAP. McGraw-Hill Inc., New York (1997)
Celko, J.: Joe Celko’s Analytics and OLAP in SQL. Elsevier, San Francisco (2010)
Erciyes, K.: Guide to Graph Algorithms: Sequential, Parallel and Distributed. Springer (2018)
Han, J., Pei, J., Kamber, M.: Data Mining: Concepts and Techniques. Elsevier, Waltham (2011)
Chapin, N.: Flowchart, pp. 714–716. Wiley, Chichester (2003)
Kopriva, D.A.: Implementing Spectral Methods for Partial Differential Equations: Algorithms for Scientists and Engineers. Springer, Dordrecht (2009)
Robertson, L.A.: Pseudocode, Encyclopedia of Information Systems. Elsevier (2003)
Tyrychtr, J., Pelikán, M., Štiková, H., Vrana, I.: EM-OLAP framework. Bus. Inf. Syst. Eng. 60(6), 543–562 (2018)
Acknowledgements
This work was conducted within the project Ambient intelligence in decision-making problems in uncertainty conditions (2019B0008) funded through the IGA foundation of the Faculty of Economics and Management, Czech University of Life Sciences in Prague.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2019 Springer Nature Switzerland AG
About this paper
Cite this paper
Tyrychtr, J., Pelikán, M., Vrana, I. (2019). Software Algorithm of EM-OLAP Tool: Design of OLAP Database for Econometric Application. In: Silhavy, R. (eds) Software Engineering Methods in Intelligent Algorithms. CSOC 2019. Advances in Intelligent Systems and Computing, vol 984. Springer, Cham. https://doi.org/10.1007/978-3-030-19807-7_34
Download citation
DOI: https://doi.org/10.1007/978-3-030-19807-7_34
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-030-19806-0
Online ISBN: 978-3-030-19807-7
eBook Packages: Intelligent Technologies and RoboticsIntelligent Technologies and Robotics (R0)