EM-OLAP Framework

Econometrics is currently one of the most popular approaches to economic analysis. To better support advances in these areas as much as possible, it is necessary to apply econometric problems to econometric intelligent systems. The article describes an econometric OLAP framework that supports the design of a multidimensional database to secure econometric analyses to increase the effectiveness of the development of econometric intelligent systems. The first part of the article consists of the creation of formal rules for the new transformation of the econometric model (TEM) method for the econometric model transformation of multidimensional schema through the use of mathematical notation. In the proposed TEM method, the authors pay attention to the measurement of quality and understandability of the multidimensional schema, and compare the proposed method with the original TEM-CM method. In the second part of the article, the authors create a multidimensional database prototype according to the new TEM method and design an OLAP application for econometric analysis.

[1]  Ahsan Abdullah.  Analysis of mealybug incidence on the cotton crop using ADSS-OLAP (Online Analytical Processing) tool , 2009 .

[2]  Jan Tyrychtr,et al.  Transformation Econometric Model to Multidimensional Databases to Support the Analytical Systems in Agriculture , 2015 .

[3]  P. K. Malhotra,et al.  Original papers: Design and development of data mart for animal resources , 2008 .

[4]  Alejandro P. Buchmann,et al.  Research Issues in Data Warehousing , 1997, BTW.

[5]  Mario Piattini,et al.  Empirical studies to assess the understandability of data warehouse schemas using structural metrics , 2008, Software Quality Journal.

[6]  Chuck Ballard,et al.  Data Modeling Techniques for Data Warehousing , 1999 .

[7]  Kin Keung Lai,et al.  Forecasting China’s Foreign Trade Volume with a Kernel-Based Hybrid Econometric-Ai Ensemble Learning Approach , 2008, J. Syst. Sci. Complex..

[8]  Erricos John Kontoghiorghes,et al.  Handbook of Computational Econometrics , 2009 .

[9]  T. Assaf,et al.  Decision Automation for Predictive Analysis Models , 2007, 2007 Annual Reliability and Maintainability Symposium.

[10]  Timos K. Sellis,et al.  A survey of logical models for OLAP databases , 1999, SGMD.

[11]  Spyros Fountas,et al.  Farm management information systems: Current situation and future perspectives , 2015, Comput. Electron. Agric..

[12]  D. Solís,et al.  Technical efficiency in farming: a meta-regression analysis , 2007 .

[13]  Don E. Ethridge,et al.  An Automated Econometric Approach for Estimating and Reporting Daily Cotton Market Prices , 1995, Journal of Agricultural and Applied Economics.

[14]  H. Landry,et al.  Review: Integrated decision support system (DSS) for manure management: A review and perspective , 2007 .

[15]  B. Recio,et al.  An econometric system to assess the economic impact of water restriction policies in Spain , 2010 .

[16]  Lukas Cechura.  Analysis of the Technical and Scale Efficiency of Farms Operating in LFA , 2014 .

[17]  Anjana Gosain,et al.  Analysis of Data Warehouse Quality Metrics Using LR , 2010, ICT.

[18]  Daniel R. Dolk,et al.  An active modeling system for econometric analysis , 1991, Decis. Support Syst..

[19]  Tomasz Kijek,et al.  Technical efficiency and its determinants in the European Union agriculture. , 2016 .

[20]  Chunhua Ju,et al.  Research and Application on OLAP-based Farm Products Examination Model , 2008, 2008 International Symposium on Electronic Commerce and Security.

[21]  Charles G. Renfro.  A compendium of existing econometric software packages , 2004 .

[22]  Sandro Bimonte,et al.  A New Sensor-Based Spatial OLAP Architecture Centered on an Agricultural Farm Energy-Use Diagnosis Tool , 2013, Int. J. Decis. Support Syst. Technol..

[23]  Alberto Abelló,et al.  On-Line Analytical Processing , 2009, Encyclopedia of Database Systems.

[24]  Mark Levene,et al.  Why is the snowflake schema a good data warehouse design? , 2003, Inf. Syst..

[25]  Tayfun Cay,et al.  A Spatial Decision Support System design for land reallocation: A case study in Turkey , 2013 .

[26]  Surajit Chaudhuri,et al.  An overview of data warehousing and OLAP technology , 1997, SGMD.

[27]  Ulrich Küsters,et al.  Forecasting software: Past, present and future , 2006 .

[28]  Wolfgang Lehner,et al.  Data modeling for Precision Dairy Farming within the competitive field of operational and analytical tasks , 2007 .

[29]  Kevin P. Scheibe,et al.  Dimensional issues in agricultural data warehouse designs , 2008 .

[30]  Alberto Abelló,et al.  Research in data warehouse modeling and design: dead or alive? , 2006, DOLAP '06.

[31]  Bernd Brandl,et al.  An automated econometric decision support system: forecasts for foreign exchange trades , 2006, Central Eur. J. Oper. Res..

[32]  Michael Böhnlein,et al.  Deriving initial data warehouse structures from the conceptual data models of the underlying operational information systems , 1999, DOLAP '99.

[33]  Jesus Felipe,et al.  "A Theory of Production" The Estimation of the Cobb-Douglas Function: A Retrospective View , 2005 .

[34]  Zdeňka Kroupová.  Technická efektivnost ekologického zemědělství České republiky , 2011 .