Chemical profiling: a tool to decipher the structure and organisation of illicit drugs markets: an 8-year study in Western Switzerland

Illicit drug analyses usually focus on the identification and quantitation of questioned material to support the judicial process. In parallel, more and more laboratories develop physical and chemical profiling methods in a forensic intelligence perspective. The analysis of large databases resulting from this approach enables not only to draw tactical and operational intelligence, but may also contribute to the strategic overview of drugs markets. In Western Switzerland, the chemical analysis of illicit drug seizures is centralised in a laboratory hosted by the University of Lausanne. For over 8 years, this laboratory has analysed 5875 cocaine and 2728 heroin specimens, coming from respectively 1138 and 614 seizures operated by police and border guards or customs. Chemical (major and minor alkaloids, purity, cutting agents, chemical class), physical (packaging and appearance) as well as circumstantial (criminal case number, mass of drug seized, date and place of seizure) information are collated in a dedicated database for each specimen. The study capitalises on this extended database and defines several indicators to characterise the structure of drugs markets, to follow-up on their evolution and to compare cocaine and heroin markets. Relational, spatial, temporal and quantitative analyses of data reveal the emergence and importance of distribution networks. They enable to evaluate the cross-jurisdictional character of drug trafficking and the observation time of drug batches, as well as the quantity of drugs entering the market every year. Results highlight the stable nature of drugs markets over the years despite the very dynamic flows of distribution and consumption. This research work illustrates how the systematic analysis of forensic data may elicit knowledge on criminal activities at a strategic level. In combination with information from other sources, such knowledge can help to devise intelligence-based preventive and repressive measures and to discuss the impact of countermeasures.

Audit management

El present document recull la memòria que descriu el meu treball de final de grau d'enginyeria informàtica del àrea de bases de dades. Aquest projecte es centra en la realització del disseny, implementació i validació d'una base de dades relacional que donarà resposta a la necessitat de les empreses certificades amb l'ISO 9001, 13485 o que treballin sota la regulació GxP, de portar una gestió i control de les accions correctives i accions preventives, des d'ara anomenades CAPA, resultats d'observacions detectades en auditories de qualitat tant internes com externes. La validació d'aquesta base de dades s'ha realitzat sota l'estàndard quemarquen les GAMP5.

Diseño e implementación de una base de datos para recogida y análisis de datos de actividad física provenientes de dispositivos wearables

Este proyecto consiste en diseñar e implementar un sistema de información alojado en una base de datos Oracle, con el fin de dar respuesta al proyecto Big Data, cuyo objetivo es cruzar los datos de salud y los datos de actividad física de los ciudadanos europeos.

Disseny BD : Activitat física i història mèdica dels ciutadans de la CEE

Treball de fi de carrera dins de l'àrea de bases de dades relacionals. Es tracta del desenvolupament d'un projecte informàtic consistent en el disseny i implementació d'una base de dades, que en l'àmbit de la Comunitat Europea, permeti emmagatzemar i consultar informació sobre l'activitat física i certes dades de salut dels seus ciutadans.

Construction and validation of a scoring system for the selection of high-quality data in a Spanish population primary care database (SIDIAP)

Background Computerised databases of primary care clinical records are widely used for epidemiological research. In Catalonia, the InformationSystem for the Development of Research in Primary Care (SIDIAP) aims to promote the development of research based on high-quality validated data from primary care electronic medical records. Objective The purpose of this study is to create and validate a scoring system (Registry Quality Score, RQS) that will enable all primary care practices (PCPs) to be selected as providers of researchusable data based on the completeness of their registers. Methods Diseases that were likely to be representative of common diagnoses seen in primary care were selected for RQS calculations. The observed/ expected cases ratio was calculated for each disease. Once we had obtained an estimated value for this ratio for each of the selected conditions we added up the ratios calculated for each condition to obtain a final RQS. Rate comparisons between observed and published prevalences of diseases not included in the RQS calculations (atrial fibrillation, diabetes, obesity, schizophrenia, stroke, urinary incontinenceand Crohn’s disease) were used to set the RQS cutoff which will enable researchers to select PCPs with research-usable data. Results Apart from Crohn’s disease, all prevalences were the same as those published from the RQS fourth quintile (60th percentile) onwards. This RQS cut-off provided a total population of 1 936 443 (39.6% of the total SIDIAP population). Conclusions SIDIAP is highly representative of the population of Catalonia in terms of geographical, age and sex distributions. We report the usefulness of rate comparison as a valid method to establish research-usable data within primary care electronic medical records

Identification of acetates in elasmopalpulus lignosellus pheromone glands using a newly created mass spectral database and kóvats retention indices

Based on a specially created mass spectral database utilizing 23 tetradecenyl and 22 hexadecenyl acetate standards along with Kóvats retention indices obtained on a very polar stationary phase [poly (biscyanopropyl siloxane)] (SP 2340), (Z)-9-hexadecenyl acetate, (Z)-11-hexadecenyl acetate and (E)-8-hexadecenyl acetate were identified in active pheromone extracts of Elasmopalpus lignosellus. This identification was more efficient than our previous study using gas chromatography/mass spectrometry with a dimethyl disulfide derivative where we could only identify the first two acetates. The acetate composition of the pheromone gland differed from region to region in Brazil and from that from the Tifton (GA, USA) population, suggesting polymorphism or a different sub-species.

Diseño e implementación de la base de datos para la gestión de regalos grupales de una red social

El presente trabajo consiste en la creación de una base de datos para generar una aplicación que permita la gestión de un regalo grupal.

Database of the Amazon aromatic plants and their essential oils

The aromatic flora of the Amazon has been inventoried for 30 years. In this sense, were made over 500 field trips to collect over 2500 plants and to obtain more than 2000 essential oils and aroma concentrates, all of them submitted to GC and GC-MS. This work led to the creation of a database for the aromatic plants of the Amazon, which catalogs general information about 1250 specimens. The database has allowed the publication of the chemical composition of the oils and aromas of more than 350 species, associated with a larger number of chemical types. The essential oils of many species offer optimum conditions for economic exploitation and use in national and international market of fragrances, cosmetics, agricultural and household pesticides.

Georeferenced database generation with the purpose of hydrologic molding in reservoirs of the hydrographic basin of Jaguaribe river in the state of Ceará, Brazil

The edafoclimatic conditions of the Brazilian semiarid region favor the water loss by surface runoff. The state of Ceará, almost completely covered by semiarid, has developed public policies for the construction of dams in order to attend the varied water demand. Several hydrological models were developed to support decisive processes in the complex management of reservoirs. This study aimed to establish a methodology for obtaining a georeferenced database suitable for use as input data in hydrological modeling in the semiarid of Ceará. It was used images of Landsat satellite and SRTM Mission, and soil maps of the state of Ceará. The Landsat images allowed the determination of the land cover and the SRTM Mission images, the automatic delineation of hydrographic basins. The soil type was obtained through the soil map. The database was obtained for Jaguaribe River hydrographic basin, in the state of Ceará, and is applicable to hydrological modeling based on the Curve Number method for estimating the surface runoff.

Primary and Revision Hip Replacement. A University Hospital Database and Registry Study

Large-headed total hip arthroplasty (THA) and hip resurfacing arthroplasty (HRA) with metal-on-metal (MoM) bearings became popular during the last decade. Recently, it has become evident that the large-head MoM hip implants are associated with increased revision rates despite their theoretical advantages. The purpose of this study was to evaluate the early results of primary MoM hip replacements and of acetabular revisions. I analyzed retrospectively the results of four MoM implant designs and the survival rate of acetabular revisions with impaction bone grafting, as documented in the Turku University Hospital database. Further, I evaluated the correlation between femoral head size and dislocation rate, and used the Finnish Arthroplasty Register data to compare the survival of three large-head MoM THAs to analogous HRAs. The early results for the Magnum M2A–ReCap THA were good. A larger head size decreased the risk of dislocation. Articular surface replacement (ASR) THA yielded inferior results compared to analogous HRA. For two other designs the results were similar. The R3–Synergy THA yielded inferior results compared to the reference implants. The survival of acetabular reconstructions with impaction bone grafting was inferior compared to previous reports. In conclusion, the early results of the Biomet ReCap–Magnum design were promising, and large head sizes decreased the dislocation rate. The survival of different MoM hip implant designs varied. The survival of new designs and techniques may be inferior to those reported by the clinics where implants are developed. An important caveat is that early promising results of new devices may rapidly worsen. New implants need to be introduced in a controlled fashion to the market; here, arthroplasty registers are a valuable tool that needs to be used.

Effect of lipoarabinomannan from Mycobacterium avium subsp avium in Freund’s incomplete adjuvant on the immune response of cattle

The aim of the present study was to determine whether lipoarabinomannan (LAM), in combination with Freund’s incomplete adjuvant (FIA), was able to improve cell-mediated and antibody-mediated immune responses against ovalbumin (OVA) in cattle. Twenty-three calves were assigned to four treatment groups, which were subcutaneously immunized with either OVA plus FIA, OVA plus FIA and LAM from Mycobacterium avium subsp avium, FIA plus LAM, or FIA alone. Lymphoproliferation, IFN-γ production and cell subpopulations on peripheral blood mononuclear cells before and 15 days after treatment were evaluated. Delayed hypersensitivity was evaluated on day 57. Specific humoral immune response was measured by ELISA. Inoculation with LAM induced higher levels of lymphoproliferation and IFN-γ production in response to ConA and OVA (P < 0.05). Specific antibody titers were similar in both OVA-immunized groups. Interestingly, our results showed that the use of LAM in vaccine preparations improved specific cell immune response evaluated by lymphoproliferation and IFN-γ production by at least 50 and 25%, respectively, in cattle without interfering with tuberculosis and paratuberculosis diagnosis.