Estudi per la implantació d'un ERP en una oficina de farmàcia

En aquest projecte es realitza l'estudi previ de la implantació d'un Planificador de Recursos Empresarials (ERP) en una oficina de farmàcia. Es pretenen analitzar els diferents punts a tenir en compte, tant de l'empresa com del ERP, a l'hora d'escollir el millor sistema per implantar a la farmàcia. Primerament hi ha una part teòrica on es defineix el concepte de ERP, donant una visió del mercat actual i del què suposa implantar un ERP en una empresa. El segon pas és el més rellevant, es tracta de l'anàlisi dels requeriments funcionals i tècnics de la farmàcia. Finalment, es proposen els 3 sistemes més ben col·locats per a una possible implantació i s'escull el que millor s'adapta a les necessitats especificades.

Anàlisi sòcio-demogràfica del reagrupament familiar a Catalunya 2004-2010

Aquest treball parteix de l’anàlisi de les dades sobre informes d’adequació de l’habitatge per a l’obtenció d’una autorització de reagrupament familiar realitzats per l’Ajuntament de Barcelona des de 2005 fins 2009, i del registre administratiu de les sol•licituds de reagrupament familiar presentades a les quatre subdelegacions del Govern a Catalunya des de 2004 fins 2010. Per a procedir a la seva anàlisi s’ha hagut de fer un important treball de depuració, harmonització i anonimització d’unes dades procedents de registres administratius no pensades per la seva explotació estadística. L’anàlisi demogràfica ha posat en relleu la importància dels rols de gènere en les estratègies familiars que acabaran conformant el perfil sociodemogràfic tant de les persones reagrupades com de les reagrupadores. També s’ha pogut veure com no hi ha una relació directa entre les persones estrangeres residents en cada municipi i les pautes de reagrupament familiar. La davallada del reagrupament familiar és deguda en bona part a la crisi econòmica, no obstant per a entendre la seva evolució en conjunt cal tenir en compte a més els factors legislatius (la Normalització del 2005 que explica el creixement de 2006 i 2007, però també l’entrada dels romanesos a la UE en 2007), així com la pròpia dinàmica familiar de la població immigrada, amb un esgotament del potencial reagrupadors per a les nacionalitats que precisament protagonitzaren el boom migratori (llatinoamericans). La legislació en matèria de reagrupament familiar s’ha basat en tres principis que han tingut un efecte indubtable i de vegades contrari a l’esperat: 1) la discriminació entre raons econòmiques i familiars en les migracions; 2) La restricció del dret de reagrupar a la definició nuclear de la família; i, 3) L’assumpció de la formació pre-migratòria de la família a reagrupar. Els resultats d’aquest informe aporten indicis que aquesta aproximació apriorística ha tingut efectes perversos, començant pel volum considerable de reagrupacions de facto.

Assembling genes from predicted exons in linear time with dynamic programming

In a number of programs for gene structure prediction in higher eukaryotic genomic sequences, exon prediction is decoupled from gene assembly: a large pool of candidate exons is predicted and scored from features located in the query DNA sequence, and candidate genes are assembled from such a pool as sequences of nonoverlapping frame-compatible exons. Genes are scored as a function of the scores of the assembled exons, and the highest scoring candidate gene is assumed to be the most likely gene encoded by the query DNA sequence. Considering additive gene scoring functions, currently available algorithms to determine such a highest scoring candidate gene run in time proportional to the square of the number of predicted exons. Here, we present an algorithm whose running time grows only linearly with the size of the set of predicted exons. Polynomial algorithms rely on the fact that, while scanning the set of predicted exons, the highest scoring gene ending in a given exon can be obtained by appending the exon to the highest scoring among the highest scoring genes ending at each compatible preceding exon. The algorithm here relies on the simple fact that such highest scoring gene can be stored and updated. This requires scanning the set of predicted exons simultaneously by increasing acceptor and donor position. On the other hand, the algorithm described here does not assume an underlying gene structure model. Indeed, the definition of valid gene structures is externally defined in the so-called Gene Model. The Gene Model specifies simply which gene features are allowed immediately upstream which other gene features in valid gene structures. This allows for great flexibility in formulating the gene identification problem. In particular it allows for multiple-gene two-strand predictions and for considering gene features other than coding exons (such as promoter elements) in valid gene structures.

Comparative gene prediction in human and mouse

The completion of the sequencing of the mouse genome promises to help predict human genes with greater accuracy. While current ab initio gene prediction programs are remarkably sensitive (i.e., they predict at least a fragment of most genes), their specificity is often low, predicting a large number of false-positive genes in the human genome. Sequence conservation at the protein level with the mouse genome can help eliminate some of those false positives. Here we describe SGP2, a gene prediction program that combines ab initio gene prediction with TBLASTX searches between two genome sequences to provide both sensitive and specific gene predictions. The accuracy of SGP2 when used to predict genes by comparing the human and mouse genomes is assessed on a number of data sets, including single-gene data sets, the highly curated human chromosome 22 predictions, and entire genome predictions from ENSEMBL. Results indicate that SGP2 outperforms purely ab initio gene prediction methods. Results also indicate that SGP2 works about as well with 3x shotgun data as it does with fully assembled genomes. SGP2 provides a high enough specificity that its predictions can be experimentally verified at a reasonable cost. SGP2 was used to generate a complete set of gene predictions on both the human and mouse by comparing the genomes of these two species. Our results suggest that another few thousand human and mouse genes currently not in ENSEMBL are worth verifying experimentally.

Decay of linkage disequilibrium within genes across HGDP-CEPH human samples: most population isolates do not show increased LD

Background: It is well known that the pattern of linkage disequilibrium varies between human populations, with remarkable geographical stratification. Indirect association studies routinely exploit linkage disequilibrium around genes, particularly in isolated populations where it is assumed to be higher. Here, we explore both the amount and the decay of linkage disequilibrium with physical distance along 211 gene regions, most of them related to complex diseases, across 39 HGDP-CEPH population samples, focusing particularly on the populations defined as isolates. Within each gene region and population we use r2 between all possible single nucleotide polymorphism (SNP) pairs as a measure of linkage disequilibrium and focus on the proportion of SNP pairs with r2 greater than 0.8.Results: Although the average r2 was found to be significantly different both between and within continental regions, a much higher proportion of r2 variance could be attributed to differences between continental regions (2.8% vs. 0.5%, respectively). Similarly, while the proportion of SNP pairs with r2 > 0.8 was significantly different across continents for all distance classes, it was generally much more homogenous within continents, except in the case of Africa and the Americas. The only isolated populations with consistently higher LD in all distance classes with respect to their continent are the Kalash (Central South Asia) and the Surui (America). Moreover, isolated populations showed only slightly higher proportions of SNP pairs with r2 > 0.8 per gene region than non-isolated populations in the same continent. Thus, the number of SNPs in isolated populations that need to be genotyped may be only slightly less than in non-isolates. Conclusion: The "isolated population" label by itself does not guarantee a greater genotyping efficiency in association studies, and properties other than increased linkage disequilibrium may make these populations interesting in genetic epidemiology.

Proteomic analysis of peach fruit mesocarp softening and chilling injury using difference gel electrophoresis (DIGE)

Background: Peach fruit undergoes a rapid softening process that involves a number of metabolic changes. Storing fruit at low temperatures has been widely used to extend its postharvest life. However, this leads to undesired changes, such as mealiness and browning, which affect the quality of the fruit. In this study, a 2-D DIGE approach was designed to screen for differentially accumulated proteins in peach fruit during normal softening as well as under conditions that led to fruit chilling injury. Results:The analysis allowed us to identify 43 spots -representing about 18% of the total number analyzed- that show statistically significant changes. Thirty-nine of the proteins could be identified by mass spectrometry. Some of the proteins that changed during postharvest had been related to peach fruit ripening and cold stress in the past. However, we identified other proteins that had not been linked to these processes. A graphical display of the relationship between the differentially accumulated proteins was obtained using pairwise average-linkage cluster analysis and principal component analysis. Proteins such as endopolygalacturonase, catalase, NADP-dependent isocitrate dehydrogenase, pectin methylesterase and dehydrins were found to be very important for distinguishing between healthy and chill injured fruit. A categorization of the differentially accumulated proteins was performed using Gene Ontology annotation. The results showed that the 'response to stress', 'cellular homeostasis', 'metabolism of carbohydrates' and 'amino acid metabolism' biological processes were affected the most during the postharvest. Conclusions: Using a comparative proteomic approach with 2-D DIGE allowed us to identify proteins that showed stage-specific changes in their accumulation pattern. Several proteins that are related to response to stress, cellular homeostasis, cellular component organization and carbohydrate metabolism were detected as being differentially accumulated. Finally, a significant proportion of the proteins identified had not been associated with softening, cold storage or chilling injury-altered fruit before; thus, comparative proteomics has proven to be a valuable tool for understanding fruit softening and postharvest.

Reliable detection of directional couplings using rank statistics

To detect directional couplings from time series various measures based on distances in reconstructed state spaces were introduced. These measures can, however, be biased by asymmetries in the dynamics' structure, noise color, or noise level, which are ubiquitous in experimental signals. Using theoretical reasoning and results from model systems we identify the various sources of bias and show that most of them can be eliminated by an appropriate normalization. We furthermore diminish the remaining biases by introducing a measure based on ranks of distances. This rank-based measure outperforms existing distance-based measures concerning both sensitivity and specificity for directional couplings. Therefore, our findings are relevant for a reliable detection of directional couplings from experimental signals.

Taking care of the most vulnerable : a descriptive study of patients with 12 attendances or more at a Swiss university hospital emergency department in 2009

Introduction: Patients who repeatedly attend the Emergency Department (ED) often have a distinct and complex vulnerability profile that includes poor somatic, psychological, and social indicators. This profile has an impact on the patients' well-being as well as on hospital costs. The objective of the study was to specify the characteristics of hyper users (HU) and explore the connection with ED care and hospital costs. Methods: The study sample comprised all adult patients with 12 or more attendances at the ED of the Lausanne University Hospital in 2009. The data were collected by retrospectively searching internal databases to identify the patients concerned and then analysing the profiles of these patients. Information gathered included demographic, somatic, psychological, at-risk behaviour, and social indicators, and health system consumption including costs. Results: In 2009, 23 patients (0.1%) attended 12 times or more (425 attendances, 0.8%). The average age was about 43 years, 60.9% were female, and 47.8% single. Of these 95.7% had basic insurance, 87.0% had a general practitioner, and 30.4% were under legal guardianship. The majority attended in the evening or at night (67.1%), and almost one quarter of these attendances resulted in inpatient treatment (24.0%). Most HU had attended the ED in previous years too (95.7% in 2008). The most prevalent diagnoses concerned 'mental disorders' (87.0%). About 30.4% of patients had attempted suicide (all were female patients). Other frequent diagnoses concerned 'trauma' (65.2%), and the 'digestive' and the 'nervous system' (each 56.5%). At-risk behaviour such as severe alcohol consumption (34.8%), or excessive use of medicines (26.1%) was very frequent, and some patients used illicit drugs (21.7%). There was only a weak association between the number of ED attendances and the resulting costs. However, a reduction of one outpatient visit per patient would have decreased ED outpatient costs by 8.5%. Conclusions: HU often have a particularly vulnerable profile. Mental problems are prevalent among them, as are at-risk behaviour and severe somatic conditions. The complexity of the patients' profiles demands specific care that cannot be guaranteed within an everyday ED routine. The use of an interdisciplinary case management team might be a promising approach in diminishing the number of attendances and the associated costs, although the profiles of HU are such that they probably cannot completely give up ED attendance.

Anàlisi contrastiva de la innovació lèxica en català i en castellà

Sovint s’ha afirmat que els mecanismes de creació lèxica en català són en gran part deutors de les innovacions lèxiques de la llengua castellana. Els objectius d’aquest article són, d’una banda, descriure i analitzar els diferents mecanismes d’innovació lèxica i el grau de coincidència entre el català i el castellà i, de l’altra, hipotetitzar una interpretació a propòsit de la influència que el català rep tant del castellà com d’altres llengües.

Interobserver and intraobserver variability of the apparent diffusion coefficient in treated malignant hepatic lesions on a 3.0T machine: measurements in the whole lesion versus in the area with the most restricted diffusion.

PURPOSE: To assess the inter/intraobserver variability of apparent diffusion coefficient (ADC) measurements in treated hepatic lesions and to compare ADC measurements in the whole lesion and in the area with the most restricted diffusion (MRDA). MATERIALS AND METHODS: Twenty-five patients with treated malignant liver lesions were examined on a 3.0T machine. After agreeing on the best ADC image, two readers independently measured the ADC values in the whole lesion and in the MRDA. These measurements were repeated 1 month later. The Bland-Altman method, Spearman correlation coefficients, and the Wilcoxon signed-rank test were used to evaluate the measurements. RESULTS: Interobserver variability for ADC measurements in the whole lesion and in the MRDA was 0.17 x 10(-3) mm(2)/s [-0.17, +0.17] and 0.43 x 10(-3) mm(2)/s [-0.45, +0.41], respectively. Intraobserver limits of agreement could be as low as [-0.10, +0.12] 10(-3) mm(2)/s and [-0.20, +0.33] 10(-3) mm(2)/s for measurements in the whole lesion and in the MRDA, respectively. CONCLUSION: A limited variability in ADC measurements does exist, and it should be considered when interpreting ADC values of hepatic malignancies. This is especially true for the measurements of the minimal ADC.