Development of query language for retrieval, integration and presentation of data

The aim of this work was to improve the system Algator in the part, which deals with the analysis and presentation of data. First, we compared some query languages to find the most suitable for use in the system Algator. Algator stores data in a specific format, and the data are always combined in the same fashion. Therefore, special query language is more suitable because it can take advantage of these properties. We determined the simplified syntax of SQL and used in the system Algator. User interface and converter from JSON format to a simplified SQL and vice versa has been developed. Execution of queries has been optimized because some inquiries run too long. Functionality of calculated fields has been added, which allows to add additional fields that are calculated from other fields

Development of query language for retrieval, integration and presentation of data

Cilj diplomske naloge je bil izboljšanje sistema Algator v delu, ki se ukvarja z analizo in predstavitvijo podatkov. Najprej smo primerjali nekaj poizvedovalnih jezikov, da bi našli čim bolj primernega za uporabo v sistemu Algator. Algator shranjuje podatke v točno določeno obliko, podatki pa se združujejo vedno na enak način, zato je lasten poizvedovalni jezik bolj primeren, ker lahko upošteva te lastnosti. Določili smo poenostavljeno sintakso SQL in jo uporabili v sistemu Algator. Za pisanje poizvedb je bil razvit uporabniški vmesnik in pretvornik poizvedb iz formata JSON v poenostavljen SQL ter obratno. Izvedba poizvedb je bila optimizirana, ker so nekatere poizvedbe trajale predolgo. Dodana je bila funkcionalnost izračunanih polj, ki omogočajo, da v rezultat poizvedb dodamo še polja, ki so izračunana iz ostalih polj.The aim of this work was to improve the system Algator in the part, which deals with the analysis and presentation of data. First, we compared some query languages to find the most suitable for use in the system Algator. Algator stores data in a specific format, and the data are always combined in the same fashion. Therefore, special query language is more suitable because it can take advantage of these properties. We determined the simplified syntax of SQL and used in the system Algator. User interface and converter from JSON format to a simplified SQL and vice versa has been developed. Execution of queries has been optimized because some inquiries run too long. Functionality of calculated fields has been added, which allows to add additional fields that are calculated from other fields

Image-Based Investigation : Biorelevant Solubility of α and γ Indomethacin

Solubility is a physicochemical property highly dependent on the solid-state form of a compound. Thus, alteration of a compound’s solid-state form can be undertaken to enhance the solubility of poorly soluble drug compounds. In the Biopharmaceutics Classification System (BCS), drugs are classified on the basis of their aqueous solubility and permeability. However, aqueous solubility does not always correlate best with in vivo solubility and consequently bioavailability. Therefore, the use of biorelevant media is a more suitable approach for mimicking in vivo conditions. Here, assessed with a novel image-based single-particle-analysis (SPA) method, we report a constant ratio of solubility increase of 3.3 ± 0.5 between the α and γ solid-state forms of indomethacin in biorelevant media. The ratio was independent of pH, ionic strength, and surfactant concentration, which all change as the drug passes through the gastrointestinal tract. On the basis of the solubility ratio, a free-energy difference between the two polymorphic forms of 2.9 kJ/mol was estimated. Lastly, the use of the SPA approach to assess solubility has proven to be simple, fast, and both solvent- and sample-sparing, making it an attractive tool for drug development.Peer reviewe

Uticaj različitih uslova uzgoja na pojavu patoloških promena na organima zaklanih svinja

Introduction. This study assessed the effect of farming system, feeding system, floor type, housing density and gender on the occurrence of pathological lesions in slaughtered pigs. Materials and Methods. The study was conducted on 400 pigs from four farms with different housing conditions. The plucks of 100 slaughtered pigs from each farm were examined for pneumonia, pleurisy, pericarditis and milk spots. Results and Conclusions. Pigs housed in a large-scale indoor farm had the lowest incidence of pneumonia. The highest occurrence of pneumonia was recorded in pigs fattened in a small-scale farm in pens with outdoor access. Pigs reared on farms in pens with outdoor access had the highest incidence of milk spots. Pigs from farms using pellet feeding systems had higher incidences of pneumonia, pleurisy and milk spots than those from a farm using a liquid feeding system. A rearing system comprising concrete floors without bedding resulted in the highest incidence of pneumonia in pigs. Pigs from a farm using a concrete floor with bedding had the highest occurrence of milk spots. The lowest incidence of milk spots was recorded in pigs from farms using fully-slatted floors. Compared to low housing density, high housing density resulted in higher incidences of pneumonia, pericarditis and milk spots in pigs. A higher prevalence of lung lesions was detected in barrows than in gilts. This study showed the most significant risk factors for the occurrence of pathological lesions in slaughtered pigs are pens with outdoor access, pellet feeding system, concrete floor, high housing density and gender.Uvod. Cilj ovog istraživanja bio je da se utvrdi uticaj tipa farme, način ishrane, tipa poda, dostupne podne površine u boksovima i pola na pojavu patoloških promena na organima zaklanih svinja. Materijal i metode. Ispitivanje je sprovedeno na 400 svinja koje su poticale sa četiri komercijalne farme sa različitim uslovima uzgoja. U cilju utvrđivanja prisustva patoloških promena na unutrašnjim organima svinja, kompleti organa (pluća, srce i jetra) od 100 svinja sa svake farme su pregledani adspekcijom i palpacijom na liniji klanja na prisustvo pneumonija, pleuritisa, perikarditisa i mlečnih pega na jetri. Rezultati i zaključak. Svinje uzgajane na farmi velikog kapaciteta u boksovima bez ispusta su imale najmanju učestalost pneumonija, dok je najveća prevalencija patoloških promena na plućima zabeležena kod svinja sa farme malog kapaciteta koje su uzgajane u boksovima sa ispustom. Kod životinja koje su uzgajane na farmama u boksovima sa ispustom utvrđena je najveća učestalost mlečnih pega na jetri. Ishrana svinja peletiranom hranom rezultirala je većom pojavom pneumonija, pleuritisa i mlečnih pega na jetri u poređenju sa ishranom svinja kašastom hranom. Uzgoj svinja na betonskom podu bez prostirke rezultirao je najvećom pojavom pneumonija. Najveća učestalost mlečnih pega na jetri zabeležena je kod svinja koje su uzgajane na betonskom podu sa prostirkom, a najmanja pojava mlečnih pega na jetri je utvrđena kod svinja koje su držane na celorešetkastom podu. U poređenju sa malom dostupnom podnom površinom u boksovima, velika dostupna podna površina u boksovima imala je za posledicu veću učestalost pojave pneumonija, perikarditisa i mlečnih pega. Kod kastrata je utvrđena veća učestalost patoloških promena na plućima u poređenju sa nazimicama. Na osnovu rezultata ovog istraživanja može se zaključiti da su boksovi sa ispustom, ishrana peletiranom hranom, uzgoj na betonskom podu, mala dostupna podna površina u boksovima i pol najznačajni faktori rizika za pojavu patoloških promena na organima svinja

Variations in the detection of anti-PEDV antibodies in serum samples using three diagnostic tests – short communication

Over the last few years several porcine epidemic diarrhoea (PED) outbreaks have been discovered in Europe including the first PED case in Slovenia in January 2015. The aim of this study was to determine when PED virus (PEDV) infection started in Slovenia. Serum samples collected between 2012 and 2016 were tested. Three hundred and seventy-five serum samples were collected from 132 Slovenian small, one-site pig farms. Samples were tested for PEDV antibodies utilising three different serological methods: commercially-available indirect ELISA, in-house blocking ELISA test and Immunoperoxidase Monolayer Assay (IPMA) test. One hundred and seventy (45.33%) tested samples were found positive by the commercially-available ELISA test kit, and 10 (5.68%) of these 170 samples found positive were positive by the in-house blocking ELISA. Only these 10 samples were collected from a farm where clinical signs of PED infection had been observed and PEDV was confirmed by RT-PCR methodology; the other 160 samples were collected randomly. Thirty-two samples with the highest S/P value obtained with the commercial ELISA were all negative with IPMA. Reasons for the high variance in the results obtained remain unclear; more research is required to ensure higher sensitivity and specificity in terms of PEDV antibody tests and other PED diagnostic methods