Storing and Evaluation of the Records of Livestock Enterprises in Database

Authors

DOI:

https://doi.org/10.24925/turjaf.v7i12.2089-2094.2793

Keywords:

Livestock enterprises, Record keeping, Database, DBMS, Pedigree

Abstract

The data stored for a long time in livestock enterprises will play a crucial role in increasing the productivity in animal production, revealing animal breeding values, meeting qualified breeding needs, making effective breeding organizations, obtaining high income, determining the animals to be kept or as a breeder. Among the important technical data kept in livestock enterprises; ram, bull, and goat and their reproduction, growth-development, yield records (animal weight and wool yield in small ruminants, body weight gain, feed consumption, lactation and milk yield), reproductive performance measures, slaughter and carcass dimensions and characteristics records such as meat quality, animal diseases and vaccination practices can be shown as important technical data in livestock enterprises. Issues such as followed animals and storing identifying information of the animals from this data in the database are being made compulsory for conformity program of Turkey with the European Union by the rule number 27137 “Regulation on the identification, registration and monitoring of sheep and goat type of animals” that published in the official newspaper by Agriculture and Forestry Ministry on 10.02.2009. Nowadays, database software such as MySQL, MS SQL, Postrage SQL, Oracle, Firebird, IBM DB2 and MS Access are used in order to obtain healthy data and store the data safely. Knowledge of the use and cost of this database software and Database Management Systems (DBMS) is important for the enterprise. In this study, it is aimed to give information about the software that adds value to the enterprise and their costs of the operations on enterprise.

Published

14.12.2019

How to Cite

Çelikyürek, H., Karakuş, K., & Kara, M. (2019). Storing and Evaluation of the Records of Livestock Enterprises in Database. Turkish Journal of Agriculture - Food Science and Technology, 7(12), 2089–2094. https://doi.org/10.24925/turjaf.v7i12.2089-2094.2793

Issue

Section

Review Articles