SQL Server In Farming{4}


by Jorge R
The main purpose of the article is to explain how SQL Server can be implemented into the farming business. In the dairy business, milk is the banner child for their main product. Over the years the demand for dairy products have skyrocketed, which led researchers to find new innovative ways to improve farming techniques. In order to produce the best cows, researchers needed to look at the family tree, they need to pinpoint the cows with the best genes by using genetic evaluation, “…in the animal breeding and genetics depth analysis of the theory based on the use of advanced computer object-oriented programming ideas…”.The first step is to perform Test Day Model (TDM),”is a series of test day records for genetic evaluation of the object as a treatment mode”. The second step is to design a create a system structure of dairy cow genetic evaluation performance. Upon collecting a variety of data from multiple cows, the data can be organized into data tables. The implementation of cow genetic performance evaluation needs to include data such as pedigree, descent, condition growth, development and childbirth. The article also explains the basics on how to update, delete, and insert data into SQL Server.

This article is interesting, in the fact that I would have never guessed that farmers would be using SQL Server to help them analyze data. Now after reading the article it makes perfect sense for them to be using the software.  It is essential for them to use SQL Server in order to organize and simplify the massive amounts of data. This relates to our class because it shows us an alternative way to use SQL Server. I can relate to this article because we used the same statements in our second class project. This article makes me wonder, what other ways SQL Server helps businesses.

Reference
Qian Zhao; He Huang; , “Research on dairy cow genetic evaluation system based on SQL Server,” Electronic Computer Technology (ICECT), 2010 International Conference on , vol., no., pp.193-196, 7-10 May 2010
doi: 10.1109/ICECTECH.2010.5479959
URL: http://0-ieeexplore.ieee.org.opac.library.csupomona.edu/stamp/stamp.jsp?tp=&arnumber=5479959&isnumber=5479932