Transformation Econometric Model to Multidimensional Databases to Support the Analytical Systems in Agriculture

Authors

How to Cite

Transformation Econometric Model to Multidimensional Databases to Support the Analytical Systems in Agriculture. (2015). AGRIS on-Line Papers in Economics and Informatics, 7(3), 71-77. https://aol.cacaotech.eu/subdom/aol/index.php/agris/article/view/252

Abstract

Econometric model application in farms is a very complex process requiring knowledge not only the economy but also statistical and mathematical methods in agriculture workers themselves. The solution may be an application of econometric problems in analytical decision support systems for farms managers. For such a solution is necessary to design a multidimensional database for support online analytical data processing (OLAP). This paper proposes a new method (called TEM-CM) for formal transformation of econometric model to the conceptual data model for creating multidimensional schemes. This new method allows to formalize the process of transferring production function in agriculture to multidimensional data model and thus contribute to a more efficient design of data warehouses and OLAP databases for decision support in the agricultural analytics systems.

References

Abelló, A., Romero, O. Encyclopedia of Database Systems. Ling L., Özsu, T. M. USA: Springer US, On-Line Analytical Processing. 2008, p. 1949-1954. ISBN 978-0-387-35544-3.

Boulil, K., Le Ber, F., Bimonte, S., Grac, C., Cernesson, F. Multidimensional Modeling and Analysis of Large and Complex Watercourse Data: An OLAP-Based Solution. Ecological Informatics. 2014, vol. 24, p. 90-106. ISSN 1574-9541. DOI: https://doi.org/10.1016/j.ecoinf.2014.07.001

Burstein, F., Holsapple, C. Handbook on decision support systems. 2008, Springer. ISBN 978-3-540-48712-8.

García, S. C., Tamayo, J. E. I., Carbonell-Olivares, J., Cabrera, Y. P. Application of the Game Theory with Perfect Information to an Agricultural Company. Agricultural Economics. 2013, Vol. 59, No. 1. ISSN 0139-570X. DOI: https://doi.org/10.17221/1/2012-AGRICECON

Čechura, L. Estimation of Technical Efficiency in Czech Agriculture with Respect to Firm Heterogeneity. Agricultural Economics. 2010, Vol. 56, p. 183-191. ISSN 0139-570X. DOI: https://doi.org/10.17221/23/2010-AGRICECON

Čechura, L., Taussigová, T. Avian Influenza and Structural Change in the Czech Poultry Industry. Agricultural Economics. 2013, Vol. 59, No. 1. ISSN 0139-570X. DOI: https://doi.org/10.17221/63/2012-AGRICECON

Codd, E. F., Codd, S. B., Salley, C. T. Providing OLAP (on-Line Analytical Processing) to UserAnalysts: An IT Mandate. 1993, Codd and Date, Vol. 32.

Datta, A., Thomas, H. The Cube Data Model: A Conceptual Model and Algebra for on-Line Analytical Processing in Data Warehouses. Decision Support Systems. 1999, Vol. 27, No. 3, p. 289-301. ISSN 0975-8887. DOI: https://doi.org/10.1016/S0167-9236(99)00052-4

Fahrner, Ch. Vossen, G. A Survey of Database Design Transformations Based on the EntityRelationship Model. Data & Knowledge Engineering. 1995, Vol. 15, No. 3, p. 213-250. ISSN 0169-023X. DOI: https://doi.org/10.1016/0169-023X(95)00006-E

Felipe, J., Adams, F. G. "A Theory of Production" the Estimation of the Cobb-Douglas Function: A Retrospective View. Eastern Economic Journal. 2005, Vol. 31, No. 3, p. 427-445. ISSN 0094-5056.

Kimball, R. The data warehouse lifecycle toolkit: expert methods for designing, developing, and deploying data warehouses. 1998, John Wiley & Sons. ISBN 978-0-471-25547-5.

Kroupová, Z. Technická efektivnost ekologického zemědělství České republiky. Ekonomická Revue. 2010, Vol. 2, p. 61-73. ISSN 1212-3951. DOI: https://doi.org/10.7327/cerei.2010.06.01

Lips, M., Schmid, D., Jan, P. Labour-use Pattern on Swiss Dairy Farms. Agricultural Economics. 2013, Vol. 59, No. 4. ISSN 0139-570X. DOI: https://doi.org/10.17221/121/2012-AGRICECON

Mylopoulos, J. Database design. 2009, Ling L., Özsu, T. M., Springer US, p. 708-710. ISBN 978-0-387-35544-3.

Novotný, O., Pour, J., Slánský, D. Business Intelligence: Jak využít bohatství ve vašich datech. Prague: Grada Publishing, 2005. ISBN 80-247-1094-3.

Pardillo, J., Mazón, J.-N., Trujillo, J. Extending OCL for OLAP Querying on Conceptual Multidimensional Models of Data Warehouses. Information Sciences. 2010, Vol. 180, No. 5, p. 584-601. ISSN 0020-0255. DOI: https://doi.org/10.1016/j.ins.2009.11.006

Pedersen, T. B. Encyclopedia of Database Systems. Ling L., Özsu, T. M. USA: Springer US, 2009a, Multidimensional Modeling, p. 1777-1784. ISBN 978-0-387-35544-3.

Pedersen, T. B. Encyclopedia of Database Systems. Ling L., Özsu, T. M. USA: Springer US, 2009b, Cube, p. 538-539. ISBN 978-0-387-35544-3.

Pedersen, T. B. Encyclopedia of Database Systems. Ling L., Özsu, T. M. USA: Springer US, 2009c, Dimension, p. 836-836. ISBN 978-0-387-35544-3.

Rai, A., Dubey, V., Chaturvedi, K. K., Malhotra, P. K. Design and Development of Data Mart for Animal Resources. Computers and Electronics in Agriculture. 2008, vol. 64, No. 2, p. 111-119. ISSN 0168-1699. DOI: https://doi.org/10.1016/j.compag.2008.04.009

Schulze, Ch., Spilke, J., Lehner, W. Data Modeling for Precision Dairy Farming within the Competitive Field of Operational and Analytical Tasks. Computers and Electronics in Agriculture. 2007, Vol. 59, No. 1, p. 39-55. ISSN 0168-1699. DOI: https://doi.org/10.1016/j.compag.2007.05.001

Tvrdoň, J. Ekonometrie (Econometric). 2006, Prague. Czech University of Life Sciences Prague. ISBN 80-213-0819-2.

Tyrychtr, J., Ulman, M., Vostrovský, V. Evaluation of the State of the Business Intelligence among Small Czech Farms. Agricultural Economics. 2015, Vol. 61, No. 2, p. 63-71. ISSN 0139-570X. DOI: https://doi.org/10.17221/108/2014-AGRICECON

Vassiliadis, P., Sellis, T. A Survey of Logical Models for OLAP Databases. ACM Sigmod Record. 1999, Vol. 28, No. 4, p. 64-69. ISSN 0163-5808. DOI: https://doi.org/10.1145/344816.344869