山黑猪繁殖数据网络数据库平台的开发

doi:10.3864/j.issn.0578-1752.2013.12.016

中国农业科学 ›› 2013, Vol. 46 ›› Issue (12): 2550-2557.doi: 10.3864/j.issn.0578-1752.2013.12.016

山黑猪繁殖数据网络数据库平台的开发

杨亮, 熊本海, 吕健强, 常乐, 孙秀坤

1.中国农业科学院北京畜牧兽医研究所，北京 100193
2.吉林市精气神有机农业股份有限公司，长春 130052

收稿日期:2012-11-19 出版日期:2013-06-15 发布日期:2013-03-18
通讯作者: 通信作者熊本海，Tel/Fax：010-62811680/5988；E-mail：Bhxiong@iascaas.net.cn
作者简介:杨亮，E-mail：yl@iascaas.net.cn
基金资助:
国家“863”计划项目（2012AA101905）、家养动物数据共享平台研究（2012DAK12111）

Study on Network Database Platform of Hill-Black Swine Breeding Data

YANG Liang, XIONG Ben-Hai, 吕Jian-Qiang , CHANG Le, SUN Xiu-Kun

1.Institute of Animal Science, Chinese Academy of Agricultural Sciences, Beijing 100193
2.Jilin City Jing-qi-shen Organic-Agricultural Ltd. Company, Changchun 130052

Received:2012-11-19 Online:2013-06-15 Published:2013-03-18

摘要/Abstract

摘要： 【目的】满足山黑猪种猪资源数据的保护，提高其繁育效率及遗传进展。【方法】基于北方山黑猪从祖代种猪到父母代种猪及商品猪的生产管理流程，将种猪划分为种公猪、后备公猪，种母猪、后备母猪；育成公猪、育成母猪；育肥公猪、育肥母猪等，在设计种猪基本信息的数据标准规范后，采用.Net及SQL Server 2008网络数据库技术。【结果】研究构建了山黑种猪繁殖数据管理及分析平台，实现了对山黑猪种猪基本繁殖数据的网络远程数据库管理，包括平均胎间距、低产母猪、高产母猪等在线动态分析与数据输出，配种、临产、断奶、转群及淘汰等各类生产事件的智能提醒，以及各种繁殖性能参数，如猪群结构、母猪胎次结构等统计分析及可视化图形分析等。【结论】不管山黑种猪的类型、数量及世代繁衍过程多么繁杂，都可以通过数据库、业务逻辑及相应的模型等形成网络计算系统，进行全方位的数据管理、分析及智能决策。

关键词: 山黑猪 , 繁殖数据 , 网络数据库 , 数据分析 , 图形分析

Abstract: 【Objective】 The aim of the study is to preserve resource data and to increase efficiency of breeding and genetic improvement of Hill-Black breeding pigs. 【Method】 Based on the North Hill Black pigs production process from progenitor to parents and to its commodity pigs, the pigs in breeding farm were divided into breeding boar, mothball boar, breeding sow, mothball sow, grew boar, grew sow, finishing boar, finishing sow and so on, and the standards and specifications of essential information of breeding pigs were designed. 【Result】 The study constructed pig breeding data management and analysis platform by using. Net and SQL Server 2008 network database technology, and realized remote network database management of essential breeding process information or data, and it could analyze some derived indexes including calving interval, low production sow and high production sow so on on-line, and it also realized intelligent alert of various production events such as mating, parturition, weaning, transfer group and culling.【Conclusion】 Regardless of how complicated in types, quantity and generation reproduction of the Hill-Black breeding pigs, it is possible to do a integrated data management, analysis and intelligent decision-making by developing a network computing system in terms of a series of databases, business logics and corresponding models.

Key words: Hill-Black swine , breeding data , network database , data analysis , graphical analysis

杨亮, 熊本海, 吕健强, 常乐, 孙秀坤. 山黑猪繁殖数据网络数据库平台的开发[J]. 中国农业科学, 2013, 46(12): 2550-2557.

YANG Liang, XIONG Ben-Hai, 吕Jian-Qiang , CHANG Le, SUN Xiu-Kun. Study on Network Database Platform of Hill-Black Swine Breeding Data[J]. Scientia Agricultura Sinica, 2013, 46(12): 2550-2557.

0
/ / 推荐

导出引用管理器 EndNote|Reference Manager|ProCite|BibTeX|RefWorks

链接本文: https://www.chinaagrisci.com/CN/10.3864/j.issn.0578-1752.2013.12.016

https://www.chinaagrisci.com/CN/Y2013/V46/I12/2550

参考文献

[1]徐树利, 敖文利. 我国地方猪种的优良特性. 科技传播, 2010(4): 100-101.

Xu S L, Ao W L. The superior characteristics of Chinese local pig species. Science and Technology Communication, 2010(4): 100-101. (in Chinese)

[2]乔绍权. 四川省地方猪种的生产性能及利用前景初探. 四川畜牧兽医, 1994(2): 2-4.

Qiao S Q. Prospect of production performance and utilization on local pig breeds of Sichuan province. Sichuan Animal Science and Veterinary, 1994(2): 2-4. (in Chinese)

[3]International Livestock Research Institute. http://dagris.ilri.cgiar.org/, 2012.

[4]Food and Agriculture Organization of the United Nations. http://www.fao.org/ag/againfo/themes/en/poultry/AnGR.html, 2012.

[5]Agritec. http://www.agritecsoft.com/en/porcitec/reports/, 2012.

[6]Agrovision B V. http://www.pigwin.com/productline/, 2012.

[7]熊本海, 马月辉, 罗清尧, 庞之洪. 中国畜禽品种资源网络数据库系统的构建. 畜牧兽医学报, 2005, 36(1): 43-47.

Xiong B H, Ma Y H, Luo Q Y, Pang Z H. Construction of network database on animal genetic resources in China. Acta Veterinaria et Zootechnica Sinica, 2005, 36(1): 43-47. (in Chinese)

[8]孙德林. 工厂化养猪计算机管理系统. 北京: 中国农业大学出版社, 1998.

Sun D L. Computer Management System on Factory Swine Farming. Beijing: China Agriculture University Press, 1998. (in Chinese)

[9]熊本海. 种猪场精细饲养综合技术平台. 北京: 中国农业科学技术出版社, 2005.

Xiong B H. Comprehensive Technology Platform on Breeding Swine Precision Farming. Beijing: China Agriculture Science and Technology Press, 2005. (in Chinese)

[10]周海深, 齐志明. 工厂化养猪生产猪群管理参数的确定. 养猪, 2000(1): 36-37.

Zhou H S, Qi Z M. Determination of management parameters of production swine herd based on factory method. Swine Farming, 2000(1): 36-37. (in Chinese)

[11]王楚端, 王新谋. 规模化猪场各类猪群存栏及占栏头数的计算. 现代畜牧兽医, 2005(1): 8-9.

Wang C D, Wang X M. All kinds swine groups stocks and their computation of pened amount. Modern Animal Science and Veterinary, 2005(1): 8-9. (in Chinese)

[12]刘庭科, 黄学斌. 现代规模猪场管理要点浅析. 中国猪业, 2012(3): 14-15.

Liu T K, Huang X B. Analysis of management key-points on modern large-size swine farm. China Swine Industry, 2012(3): 14-15. ( in Chinese)

[13]吕健强, 杨亮. 利用工厂化养猪理论参数动态监测猪群生产. 农业网络信息, 2006(8): 23-24.

Lü J Q, Yang L. Dynamic supervision of a swine herd production with the factory farming theory parameters. Agriculture Network Information, 2006(8): 23-24. (in Chinese)

[14]吴常信, 阎汉平. 英汉畜牧词典. 北京: 中国农业出版社, 2006.

Wu C X, Yan H P. English-Chinese Dictionary of Animal Husbandary. Beijing: China Agriculture Press, 2006. (in Chinese)

[15]Richter J. 李建忠译. Microsoft.NET框架程序设计. 北京: 清华大学出版社, 2003.

Richter J. Translated by Li J Z. Microsoft.NET Framework Program Design. Beijing: Tsinghua University Press, 2003. (in Chinese)

[16]FusionCharts Technologies LLP. http://www.fusioncharts.com/, 2012.

[17]http://ftp1.businessobjects.com/webprod/crxi/14-50079-085.zip.

[18]Mertens K, Decuypere E, de Baerdemaeker J, de Ketelaere B. Statistical control charts as a support tool for the management of livestock production. Journal of Agricultural Science, 2011, 149: 369-384.

[19]梁晓辉, 王正来. 规模化种猪场母猪高效生产综合技术. 畜禽业, 2007(219): 22-23.

Liang X H, Wang Z L. The comprehensive technology of high efficiency production on large-scale breeding swine farm. Livestock and Poultry Industry, 2007(219): 22-23. (in Chinese)

[20]滕小华. 猪繁育体系的经济效益及其模拟分析. 养猪研究, 1994(94): 56-59.

Teng X H. Economic efficiency and model analysis. Study of Swine Farming, 1994(94): 56-59. (in Chinese)

[21]Huirne R B M, Dijkhuizen A A, Renkema J A. Economic optimization of sow replacement decision on the personal computer by method of stochastic dynamic programming. Livestock Production Science, 1991, 28(4): 331-347.

[22]Kristemen A R, Søllested T A. A sow replacement model using bayesian updating in a three hierarchic markov process．I．biological model．Livestock Production Science, 2004, 87(1): 13-24.

[23]陈元琳. 基于人工神经网络的动态系统仿真模型和算法研究[D]. 大庆: 大庆石油学院, 2006.

Chen Y L. Study on models and algorithms of artificial neural networks used in dynamic system simulation[D]. Daqing: Daqing Petroleum College, 2006. (in Chinese)

[24]柴琦丽. 种猪场生产系统动态仿真模型的研究[D]. 哈尔滨: 东北农业大学, 2006.

Chai Q L. The study on the dynamic emulation model of the pig breeding farm prodution system[D]. Harbin: North-East Agriculture University, 2006. (in Chinese)

山黑猪繁殖数据网络数据库平台的开发

Study on Network Database Platform of Hill-Black Swine Breeding Data

PDF

赞

可视化

被引次数

摘要/Abstract

引用本文

使用本文

参考文献

相关文章 2

Metrics

本文评价

推荐阅读 0

[1]	岳慧丽,张昭,张蕙杰,刘升平,张杰. 中国农业科技水平的时空演变、区域关联及其经济协同发展效应——以省域公立农业科研机构为例[J]. 中国农业科学, 2021, 54(24): 5251-5265.
[2]	曾大力,滕胜,钱前,国广泰史. 视频显微扫描技术在稻米垩白研究中的应用[J]. 中国农业科学, 2001, 34(4): 451-453 .