User Defined Types and Nested Tables in Object Relational Databases

Bernadette Byrne, Mary Garvey, ‘User Defined Types and Nested Tables in Object Relational Databases’, paper presented at the United Kingdom Academy for Information Systems 2006: Putting Theory into Practice, Cheltenham, UK, 5-7 June, 2006.There has been much research and work into incorporating objects into databases with a number of object databases being developed in the 1980s and 1990s. During the 1990s the concept of object relational databases became popular, with object extensions to the relational model. As a result, several relational databases have added such extensions. There has been little in the way of formal evaluation of object relational extensions to commercial database systems. In this work an airline flight logging system, a real-world database application, was taken and a database developed using a regular relational database and again using object relational extensions, allowing the evaluation of the relational extensions.Peer reviewe

Screening commercial teat disinfectants against bacteria isolated from bovine milk using disk diffusion

peer-reviewedBackground and Aim: Teat disinfection is an important tool in reducing the incidence of bovine mastitis. Identifying the potential mastitis-causing bacterial species in milk can be the first step in choosing the correct teat disinfectant product. The objective of this study was to screen commercial teat disinfectants for inhibition against mastitis-associated bacteria isolated from various types of milk samples. Materials and Methods: Twelve commercially available teat disinfectant products were tested, against 12 mastitis-associated bacteria strains isolated from bulk tank milk samples and bacterial strains isolated from clinical (n=2) and subclinical (n=3) quarter foremilk samples using the disk diffusion method. Results: There was a significant variation (7-30 mm) in bacterial inhibition between teat disinfection products, with products containing a lactic acid combination (with chlorhexidine or salicylic acid) resulting in the greatest levels of bacterial inhibition against all tested bacteria (p<0.05). Conclusion: In this study, combined ingredients in teat disinfection products had greater levels of bacterial inhibition than when the ingredients were used individually. The disk diffusion assay is a suitable screening method to effectively differentiate the bacterial inhibition of different teat disinfectant products

The effect of disinfectant ingredients on teat skin bacteria associated with mastitis in Irish dairy herds

peer-reviewedBackground Teat disinfection is an important step in the control of mastitis within a dairy herd. The objective of this study was to evaluate the effectiveness of 96 commercially available teat disinfectant products in Ireland against bacterial isolates on teat skin. Teat disinfection products were applied to the teats of seventeen Holstein–Friesian cows. A split-udder model was used where one cow received two different teat disinfection products on each day. A composite swab sample was taken of the left teats and the right teats before and after teat disinfectant application. Swab samples were plated onto 3 different selective agars to enumerate bacterial counts of streptococcal, staphylococcal and coliform isolates. Results Streptococcal isolates were the most prominent bacterial group recovered on teat swabs taken before the application of a teat disinfection product (55.0%), followed by staphylococcal isolates (41.3%) and coliform isolates (3.7%). Products were reclassified by active ingredients (n = 9) for analysis. These ingredient groups included; chlorhexidine, chlorine dioxide, diamine, iodine, iodine and lactic acid, lactic acid, lactic acid and chlorhexidine, lactic acid and hydrogen peroxide, and lactic acid and salicylic acid. The ingredient group, chlorine dioxide, resulted in comparable reductions to the iodine group for streptococcal isolates. The ingredient group, iodine combined with lactic acid, resulted in the greatest reduction of staphylococcal isolates. When observing products individually, a product containing 1.6% w/w lactic acid combined with hydrogen peroxide was the most effective at reducing streptococcal isolates on the teat skin, whereas a product containing lactic acid combined with 0.6% w/w chlorhexidine was the most effective against staphylococcal isolates. Minor differences were observed regarding the relationship between effectiveness and active ingredient concentration between products. Conclusions This study suggests that some teat disinfectant products achieve a higher reduction in bacterial levels against different specific bacterial groups on teat skin than other products. Therefore, when choosing a teat disinfectant product, the bacteria in the dairy herds’ environment should be considered. Further studies are necessary to evaluate products efficacy against new IMIs and any possible effects on teat skin condition

The SPRY domain–containing SOCS box protein SPSB2 targets iNOS for proteasomal degradation

Macrophages lacking SPSB2 have increased NO production and enhanced pathogen-killing capabilities due to decreased ubiquitin-mediated destruction of iNOS

Evaluating the effectiveness of commercial teat disinfectant products sold in Ireland using the disc diffusion method

peer-reviewedEvaluation of teat disinfectant products for their effectiveness against the most prevalent mastitis-causing bacteria is important to identify the most effective ingredients against specific bacterial strains. Ninety-six commercially available teat disinfectant products were tested against three bacterial strains associated with mastitis in Ireland (Staphylococcus aureus, Streptococcus uberis and Escherichia coli) using the disc diffusion method. Products were reclassified by active ingredients (n = 9) for analysis. These ingredient groups included: chlorhexidine (n = 25), chlorine dioxide (n = 5), diamine (n = 1), iodine (n = 13), iodine combined with lactic acid (n = 5), lactic acid (n = 15), lactic acid combined with chlorhexidine (n = 21), lactic acid combined with hydrogen peroxide (n = 1) and lactic acid combined with salicylic acid (n = 10). The ingredient group chlorine dioxide resulted in the greatest zones of inhibition for all three bacterial strains. An individual product containing a combination of lactic acid and hydrogen peroxide resulted in the greatest zone of inhibition for Sta. aureus and Str. uberis, whereas a specific product within the chlorine dioxide group resulted in the greatest zones of inhibition for E. coli. High concentrations of active ingredient did not necessarily increase the effectiveness for the majority of teat disinfectant products. It is possible to use the disc diffusion method to evaluate/screen a large number of teat disinfectant products prior to conducting field trials to establish the products’ ability to reduce intramammary infections (IMI)

Effect of Pre-Milking Teat Foam Disinfection on the Prevention of New Mastitis Rates in Early Lactation

The objective of this study was to determine the benefit of pre-milking teat foam disinfection on the prevention of new infections by contagious and environmental bacteria in two spring calving herds managed outdoors (Herd 1 [H1]; 331 cows and Herd 2 [H2]; 142 cows). Four pre-milking teat preparation treatments were applied post calving; with each herd receiving two treatments; using a split udder design (for approx. 15 weeks). These treatments included; (1) ‘water wash, foam application and dry wipe (WFD) in H1′; (2) ‘water wash and dry wipe (WD)’ in H1; (3) ‘foam application and dry wipe (FD)’ in H2; (4) ‘no teat cleaning preparation (NP)’ in H2. Individual quarter foremilk samples were collected on four occasions and all clinical and sub-clinical cases were recorded. The mean SCC of quarter foremilk samples was 134 × 103 cells/mL and 127 × 103 cells/mL for WD and WFD, respectively, and 109 × 103 cells/mL and 89 × 103 cells/mL for NP and FD, respectively (p &gt; 0.05). Lower bacterial counts were observed on teat skin that received a foaming treatment. Pre-milking teat disinfection using a foaming product may be of little benefit, in early lactation, for a pasture-based dairy herd