Skip to main content

Software Algorithm of EM-OLAP Tool: Design of OLAP Database for Econometric Application

  • Conference paper
  • First Online:
Software Engineering Methods in Intelligent Algorithms (CSOC 2019)

Part of the book series: Advances in Intelligent Systems and Computing ((AISC,volume 984))

Included in the following conference series:

  • 648 Accesses

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.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Subscribe and save

Springer+ Basic
$34.99 /Month
  • Get 10 units per month
  • Download Article/Chapter or eBook
  • 1 Unit = 1 Article or 1 Chapter
  • Cancel anytime
Subscribe now

Buy Now

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Similar content being viewed by others

References

  1. 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)

    Google Scholar 

  2. Berson, A., Smith, S.J.: Data Warehousing, Data Mining, and OLAP. McGraw-Hill Inc., New York (1997)

    Google Scholar 

  3. Celko, J.: Joe Celko’s Analytics and OLAP in SQL. Elsevier, San Francisco (2010)

    Google Scholar 

  4. Erciyes, K.: Guide to Graph Algorithms: Sequential, Parallel and Distributed. Springer (2018)

    Google Scholar 

  5. Han, J., Pei, J., Kamber, M.: Data Mining: Concepts and Techniques. Elsevier, Waltham (2011)

    MATH  Google Scholar 

  6. Chapin, N.: Flowchart, pp. 714–716. Wiley, Chichester (2003)

    Google Scholar 

  7. Kopriva, D.A.: Implementing Spectral Methods for Partial Differential Equations: Algorithms for Scientists and Engineers. Springer, Dordrecht (2009)

    Book  Google Scholar 

  8. Robertson, L.A.: Pseudocode, Encyclopedia of Information Systems. Elsevier (2003)

    Google Scholar 

  9. Tyrychtr, J., Pelikán, M., Štiková, H., Vrana, I.: EM-OLAP framework. Bus. Inf. Syst. Eng. 60(6), 543–562 (2018)

    Article  Google Scholar 

Download references

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

Authors

Corresponding author

Correspondence to Jan Tyrychtr .

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2019 Springer Nature Switzerland AG

About this paper

Check for updates. Verify currency and authenticity via CrossMark

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

Publish with us

Policies and ethics