Search research reports:
Regional Animal Health Data Warehousing and Data Mining System
C.N. Carter, W. Northington, J. Smith
Livestock Disease Diagnostic Center
The Livestock Disease Diagnostic Center at the University of Kentucky and the Breathitt Veterinary Center at Murray State University have animal health archives dating back to 1993. These collections represent over one million clinical cases that were processed through these two laboratories. A state-of-the-art, fully graphical case accessioning system has been developed and tested in a previous project that will capture all diagnostic medicine findings for current and future cases.
The intent here is to build a data warehouse that will combine the legacy case findings and the findings that will be captured by the new laboratory information management system (LIMS). The legacy data are currently residing in a proprietary, custom developed format that is not ODBC compliant. An inventory of each data element and data class must be taken for both the legacy and the new LIMS system. A new data base must then be designed that will accommodate the data elements from both systems. Finally, a means of importing the archived and current data elements into a reasonably flat, un-normalized data warehouse structure must be developed.