The system of identification and control of animal movement (SIKKŽ) throughout the territory of Bosnia and Herzegovina, in accordance with the Law on Veterinary Medicine, identifies every animal (from the population of cattle, pigs and small ruminants) and their movement is recorded. Through this system, registration of all property, slaughterhouses and livestock market is also performed. For the purpose of all this, ASW Engineering defined the requirements and goals of this project: • Every property, slaughterhouse and livestock market must be registered in the State Databases (DBP), in which they will be assigned a special and permanent letter-code code for the purpose of registration and identification. • Every animal must be marked with an individual ear tag, and its owner has the same animal passport, which is also entered into the DBP. • In the end, the movement of each animal can be done only with the possession of appropriate documentation and every movement of the animal must also be registered in the DBP. The system of identification and control of animal movements in BiH is under the direct authority of the BiH Veterinary Office (KZV BiH), and the operational activities of Animal Identification and Control (SIKK) are effectively and effectively performed by the Animal Protection Agency within the KZV BiH. The main goal of the project was the establishment of a unique database of registered animals and animal movements. The system is used by end users from the Agency for marking of animals in Banja Luka and three data offices (Banja Luka, Mostar and Sarajevo). It is envisaged to expand the user circle to all authorized veterinary stations and larger farms and slaughterhouses.
In addition to the basic web-based module for use by end-users, a module for field work using PDAs (Psion Teklogix Ikon) has been developed. Connecting external systems (Register of Agricultural Holdings, Inspectorate) is enabled through the web service. In addition to the development of a new software system and database, the project also included migration of data from two existing data sources. All data on registered holdings, all animals and historical data on animal movements for the last ten years (since the records are kept) have been successfully transferred. The crown of the project is the realization of the business intelligence module that enables advanced reporting on the basis of collected data. Within the BI module, a set of ETL procedures is implemented, which at the daily level transfer the changes from the operational database to the data warehouse (Data Warehouse). The Microstrategy system is used to create and review the analysis.
