Modeling for liming and fertilization recommendation for the main grain producing regions of Brazil in the SQL language
DOI:
https://doi.org/10.5902/2179460X35510Keywords:
Conceptual Modeling, SQL, RecommendationAbstract
The agribusiness has a significant importance to the Brazilian economy. In this case, technologies are needed to increase the efficiency of the productive system, but there are few technological tools that perform interpretations of soil analysis and fertilizer recommendations efficiently and comprehensively. In this context, the AgroFert system proposes to make corrective and fertilizer recommendations based on soil analyzes for several regions and grain crops of Brazil, through two systems: web and mobile, which uses a knowledge base in liming and fertilization. Therefore, this work aims at presenting the conceptual and logical modeling process of a database that have rules of information management to interpret the results of soil analysis reports and to recommend soil correctives and fertilizers. Rules were created that use comparisons, filtering, mathematical operations and logical operations, modeled in the SQL language, and when executed, generate interpretations of soil analysis and recommendations for correctives and fertilizers. The AgroFert covers the states of Rio Grande do Sul, Santa Catarina, Paraná, Minas Gerais and São Paulo and the biome of Cerrado. In addition to the conceptual modeling, 22 operations were created, totaling approximately 400 lines of code, and it was possible to recommend fertilizers for 13 grain crops. The results of the tests showed that the computerization of the data present in the RS / SC and Paraná manuals facilitated the interpretation of the data present in soil analysis reports, besides increasing the precision and agility in the recommendations of corrective and fertilizer producers.Downloads
References
BROCH L D, SIDNEI K R. Fertilidade do solo, adubação e nutrição da cultura do Milho. 2011-2012; Tecnologia e produção: Soja e Milho.
CAHN M, HARTZ T, SMITH R, NOEL B, JOHNSON L, MELTON F. [CropManage: an online decision support tool for irrigation and nutrient management]. Proceedings of the Western Nutrient Management Conference. Rev. Eletr. Enf. [Internet] 2015 March [cited 2018 feb 17]. Aviable from: http://www.ipni.net/ipniweb/conference/wnmc.nsf/e0f 085ed5f091b1b852579000057902e/4be3031d1d87927a85257e37004fa7a8/$FILE/WNMC2015%20Cahn%20pg9.pdf.
CARMONA F C, ANGHINONI I, MARTINS A P, BOENI M. ADUBARROZ: uma experiência brasileira em recomendações de adubação e calagem para o arroz irrigado via sistema computacional. Rev. Eletr. Enf. [Internet] 2016 [cited 2018 feb 03]; 46(11):1959-1962. Aviable from: http://revistas.bvs-vet.org.br/crural/article/view/33353.
COSTA M M. Recomendação de adubação em agricultura de precisão com base no modelo CERES-Maize. 2015.
DA SILVA S V, TUCCI C A F, SANTOS J Z L. Calagem e adubação com potássio, boro e cobre em laranjeira ‘pêra’ em Manaus-AM. 2015.
DE OLIVEIRA F H T, NOVAIS R F. Desenvolvimento de um sistema para recomendação de adubação para a cultura da bananeira. Revista Brasileira de Ciência do Solo. 2005;29(1):131-143.
FERREIRA JUNIOR L D, PINHEIRO M C. Desenvolvimento de software de gestão da produção cafeeira: módulo de prescrição e planejamento da adubação. 2015.
INSTITUTO BRASILEIRO DE GEOGRAFIA E ESTATÍSTICA [Internet]. Brasília: Ministério da Agricultura, Pecuária e Abastecimento (BR) [cited 2018 aug 27]. Aviable from: http://www.agricultura.gov.br /noticias/agropecuaria-puxa-o-pib-de-2017.
LU J, WU D, MAO M, WANG W, ZHANG G. [Recommender system application developments: a survey]. Decision Support Systems. 2015;74:12-32.
MINISTÉRIO DA AGRICULTURA, PECUÁRIA E ABASTECIMENTO. Ministro da agricultura fala sobre a forca do agronegócio em seminário em brasilia; 2017 Mai 08 [cited 2018 aug 27]. Aviable from: http://www.agricultura.gov.br/noticias/ministro-da-agricultura-fala-sobre-a-forca-do-agronegocio-em-seminario-em-brasilia.
OLEGO M A, Paz J M, Visconti F, Garzón J E. [Predictive modelling of soil aluminium saturation as a basis for liming recommendations in vineyard acid soils under Mediterranean conditions]. Soil science and plant nutrition. 2014;60(5):695-707.
PAIVA DA SILVA A, Alvarez V H V, Souza A P, Neves J C L, Novais R F, Dantas J P. Sistema para recomendação de fertilizantes e corretivos para a cultura do abacaxi – FERTICALC-ABACAXI. Revista Brasileira de Ciência do Solo. 2009;33:1269-1280.
SANTOS F C, NEVES J C L, NOVAIS R F, ALAREZ V H V, SEDIYAMA C S. Modelagem da recomendação de corretivos e fertilizantes para a cultura da soja. Revista Brasileira de Ciência do Solo. 2008;32:1661-1674.
SILVA T M D. Software for recommendation of liming and fertilization of tomato plants in the state of minas gerais. [dissertation]. Alfenas: Mestrado em Ciência Agrárias/Universidade Jose do Rosario Vellano; 2012.
WENDLING A, ELTS F L F, CUBILLA M M, AMADO T J C, MIELNICZUK J, LOVATO T. Recomendação de adubação nitrogenada para trigo em sucessão ao milho e soja sob sistema plantio direto no Paraguai. Revista Brasileira de Ciência do Solo. 2007;31(5): 985-994.
Downloads
Published
How to Cite
Issue
Section
License
To access the DECLARATION AND TRANSFER OF COPYRIGHT AUTHOR’S DECLARATION AND COPYRIGHT LICENSE click here.
Ethical Guidelines for Journal Publication
The Ciência e Natura journal is committed to ensuring ethics in publication and quality of articles.
Conformance to standards of ethical behavior is therefore expected of all parties involved: Authors, Editors, Reviewers, and the Publisher.
In particular,
Authors: Authors should present an objective discussion of the significance of research work as well as sufficient detail and references to permit others to replicate the experiments. Fraudulent or knowingly inaccurate statements constitute unethical behavior and are unacceptable. Review Articles should also be objective, comprehensive, and accurate accounts of the state of the art. The Authors should ensure that their work is entirely original works, and if the work and/or words of others have been used, this has been appropriately acknowledged. Plagiarism in all its forms constitutes unethical publishing behavior and is unacceptable. Submitting the same manuscript to more than one journal concurrently constitutes unethical publishing behavior and is unacceptable. Authors should not submit articles describing essentially the same research to more than one journal. The corresponding Author should ensure that there is a full consensus of all Co-authors in approving the final version of the paper and its submission for publication.
Editors: Editors should evaluate manuscripts exclusively on the basis of their academic merit. An Editor must not use unpublished information in the editor's own research without the express written consent of the Author. Editors should take reasonable responsive measures when ethical complaints have been presented concerning a submitted manuscript or published paper.
Reviewers: Any manuscripts received for review must be treated as confidential documents. Privileged information or ideas obtained through peer review must be kept confidential and not used for personal advantage. Reviewers should be conducted objectively, and observations should be formulated clearly with supporting arguments, so that Authors can use them for improving the paper. Any selected Reviewer who feels unqualified to review the research reported in a manuscript or knows that its prompt review will be impossible should notify the Editor and excuse himself from the review process. Reviewers should not consider manuscripts in which they have conflicts of interest resulting from competitive, collaborative, or other relationships or connections with any of the authors, companies, or institutions connected to the papers.
