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

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

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

【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.