China Dairy ›› 2024, Vol. 0 ›› Issue (11): 50-56.doi: 10.12377/1671-4393.24.11.08

• SMART FARMING • Previous Articles     Next Articles

Farm-to-table Science: Dairy Data Mining for Future Resilience

WANG Lei, GUO Kaijun*   

  1. Beijing University of Agriculture, Beijing 100096
  • Online:2024-11-25 Published:2024-12-10

Abstract: Adoption of automated milking systems (AMS) and other precision livestock farming (PLF) systems offers access to large,multidimensional data that allow exploration of resilience traits and sustainable farming strategies in real-world scenarios. Since their inception in the Netherlands in the 1990s,AMS have seen increased adoption Adoption of automated milking systems (AMS) and other precision livestock farming (PLF) systems offers access to large,multidimensional data that allow exploration of resilience traits and sustainable farming strategies in real-world scenarios.Since their inception in the Netherlands in the 1990s,AMS have seen increased adoption in the Nordic countries,with around a third of the total milk production collected by robots. The major brands of farm management systems(FMS)in the Nordic region are only configured to report data as a current overview,discarding older information that is vital to studies of the herd’s genetics,behaviour,and environment.In this work,we present the infrastructure for dairy cattle data at the Swedish University of Agricultural Sciences,Gigacow(SLU Gigacow)that collects data from a set of Swedish dairy farms. Each farm’s FMS sends nightly reports to SLU Gigacow,where records are harmonised and collected in a central database. Collected records include milking statistics,health events,traffic data,and SNP genotypes for thousands of cows,and are made accessible to researchers through SQL or R queries. SLU Gigacow also integrates data from the Swedish national cow registry,including pedigrees and herd transfers for cows resident at participating farms.SLU Gigacow’s longitudinal observations (first data collected in 2020) link genotype to phenotype and animal welfare with the goal of accelerating pilot studies in dairy science,as well as providing a big dataset from cows in active,commercial settings. The data collection software written in Python 3 (Beaverton,USA) has modules that enable collection from several versions of DeLaval DelPro (Tumba,Sweden), and can be extended to any FMS with a graphical user interface running on most consumer operating systems. After harmonisation to resolve differences in language and FMS versions,data are stored in a database maintained at SLU with SQL Server Integration Services (SSIS) (Microsoft, Redmond,USA). By agreement with Växa Sverige AB (Uppsala, Sweden),participating farmers also get a large number of animals genotyped using the 45k EuroG MD beadchip (Amsterdam, The Netherlands). Currently,the database includes information on over 17 000 cattle,over 3 000 000 milkings,and 2 969 SNP genotypes. The cross-referenced data can be mined for various purposes,including stress responses and resilience traits.While SLU Gigacow is intended to collect from Swedish farms and support Swedish researchers,it serves as a proof-of-concept that data from diverse sources and systems at dairy farms can be automatically gathered and collated in a researcherfriendly format. We believe that this shows the great utility of farm-to-table statistics and increased FMS interoperability. SLU Gigacow was constructed essentially without standardised interfaces for dairy data communication. Establishment of such data standards is ongoing within the industry but the development and adoption of standards take time and rely on active participation of multiple actors. The researchdriven approach of SLU Gigacow enables more rapidand integrated measurements of many facets of the dairy farm environment,creates new niches for PLF equipment,and opens great new vistas of information to explore for adaptation to changing climates.

Key words: dairy science, big data, resilience

[1] Bengtsson C,Thomasen J R,Kargo M,et al.Emphasis on resilience in dairy cattle breeding: Possibilities and consequences[J].Journal of Dairy Science,2022,105(9):7588-7599.
[2] Kašná E,Zavadilová L.General resilience in dairy cows: A review[J].Czech Journal of Animal Science,2022,67(12):475-482.
[3] Carabaño M J,Ramón M,Díaz C,et al.BREEDING AND GENETICS SYMPOSIUM: Breeding for resilience to heat stress effects in dairy ruminants. A comprehensive review[J].Journal of Animal Science,2017,95(4):1813-1826.
[4] Chen S Y,Boerman J P,Gloria L S,et al.Genomic-based genetic parameters for resilience across lactations in North American Holstein cattle based on variability in daily milk yield records[J].Journal of Dairy Science,2023,106(6):4133-4146.
[5] Lokhorst C,de Mol R M,Kamphuis C. Invited review:Big Data in precision dairy farming[J].Animal (Cambridge, England),2019,13((7):1519-1528.
[6] Velayudhan S M,Sven K,Veerasamy S,et al.Climate-resilient dairy cattle production:Applications of genomic tools and statistical models[J].Frontiers in Veterinary Science,2021,8:625189-625189.
[7] CRAN.DB:R Database Interface. R package version 1.1.3[EB/OL].https://CRAN.R-project.org/package=DBI,2022.
[8] CRAN.Odbc:Connect to ODBC Compatible Databases(using the DBI Interface).R package version 1.3.5[EB/OL].https://CRAN.R-project.org/package=odbc,2023.
[9] Hermans K,Waegeman W,Opsomer G,et al.Novel approaches to assess the quality of fertility data stored in dairy herd management software[J].Journal of Dairy Science,2017,100(5):4078-4089.
[10] CRAN.Dplyr:A grammar of data manipulation.R package version 1.1.2[EB/OL].https://CRAN.R-project.org/package=dplyr,2023.
[1] LI Jiechao, SHI Ji, LIU Duncheng, FENG Xiaoyu, PANG Shuyue, MA Chong. Application of Cow Intelligent Health Management System in Early Diagnosis of Individual Cases [J]. China Dairy, 2024, 0(11): 22-28.
[2] LIU Wenhua, ZHANG Yixue, HAN Chengbo, HE Hong, PENG Xiayu, WEI Yong. The Application of Big Data Cloud Platform Management to Improve the Safety and Efficiency of Fresh Milk Transportation [J]. China Dairy, 2022, 0(8): 51-55.
[3] HU Tingting, ZHANG Jinmeng, WANG Yichong, GUO Kaijun, HANG Renlong. Application of Big Data and IoT in Dairy Farming* [J]. China Dairy, 2021, 0(5): 29-33.
Viewed
Full text


Abstract

Cited

  Shared   
  Discussed   
No Suggested Reading articles found!