规模化种猪场繁育管理数据库的设计

发布时间：2018-12-09 10:26

【摘要】：随着近年来生猪养殖业的快速发展,计算机技术在规模化猪场中的应用也得以广泛传播。传统的手工记录和简单的办公软件只能记录基本报表数据,当数据量增大和一些复杂查询时,这些软件会明显力不从心,不能满足大型规模化种猪场的管理需求,迫切需要现代化、信息化、流程化的管理模式,猪场信息化管理系统是解决此问题的关键,而数据库是管理系统的核心部分。因此,本研究通过使用SQL Server关系型数据库管理系统实现猪场数据数字化、信息化管理,从而提高种猪场的生产管理水平和生产信息记录的规范化水平。本研究分为三个阶段,数据采集、数据库基本建立和管理功能实现。在一个千头种猪规模的种猪场现场收集数据三个月,收集了产房舍112头能繁母猪基本信息、繁殖性能及生产信息、1086头仔猪的出生、断奶信息,配种舍的18头种公猪基本信息和生产区的7名技术人员基本信息。数据库设计包括关系型数据库管理系统的安装、数据库关系设计、具体表格设计:采精明细表、断奶窝登记表、断奶仔猪表、母猪发情记录、母猪生产记录表、能繁母猪基本信息、配种记录、人员信息表、种公猪基本信息、仔猪登记表。管理功能的实现的方法是利用SQL语言编程,储存进程,实现对采精量、精子活力、断奶窝重、出生重、胎次、产仔数、死胎数等的基本查询,进一步开发复杂的查询管理功能,如:返情管理。通过测试,本研究设计的关系型数据库管理系统实现了对规模化种猪场基本信息的管理与查询和返情管理功能,通过使用储存进程简化操作,经现场测试,可提高规模化种猪场的信息化管理程度,配种率、生产水平以及猪场员工的工作效率,进而提升猪场的经济效益。
[Abstract]:With the rapid development of pig breeding in recent years, the application of computer technology in large-scale pig farms has been widely spread. Traditional manual recording and simple office software can only record basic report data. When the amount of data increases and some complex queries, these software will obviously be unable to meet the management needs of large-scale pig farms. There is an urgent need for a modern, information-based and process-oriented management model. The information management system of pig farm is the key to solve this problem, and the database is the core part of the management system. Therefore, this study uses SQL Server relational database management system to realize the data digitization and information management of pig farm, so as to improve the production management level and the standardized level of production information record. This research is divided into three stages, data acquisition, database establishment and management function. The data were collected in a 1000 pig scale pig farm for three months. The basic information, reproductive performance and production information, birth and weaning information of 1086 piglets were collected in the labor room. Basic information of 18 boars in breeding house and 7 technicians in production area. Database design includes installation of relational database management system, database relational design, specific table design: sperm collection schedule, weaning litter registration form, weaning piglet table, sows estrus record, sows production record table, Basic information of sow breeding, breeding record, personnel information table, basic information of breeding boar, registration form of piglets. The method of realizing the management function is to use SQL language programming, storage process, to realize the basic query of the collection quantity, sperm motility, weaning litter weight, birth order, litter size, stillbirth number and so on, and to further develop the complex query management function. Such as: return to the situation management. Through testing, the relational database management system designed in this paper has realized the functions of managing and querying the basic information of the large-scale pig farm, simplifying the operation by using the storage process, and testing on the spot. It can improve the information management degree, breeding rate, production level and the working efficiency of the staff of the large-scale pig farm, and then improve the economic benefit of the pig farm.
【学位授予单位】：东北农业大学
【学位级别】：硕士
【学位授予年份】：2015
【分类号】：S828;S818.9

【相似文献】