Disseny i implementació d'una base de dades relacional per a una empresa de selecció de personal

Anàlisi, disseny i implementació d'una base de dades relacional i un magatzem de dades per a una empresa de selecció de personal.

Selecció de personal : Borsa de treball i magatzem de dades

L'objectiu d'aquest projecte és desenvolupar una aplicació per donar suport en les activitats de negoci d'una empresa de selecció de personal. Per fer-ho s'hauran de desenvolupar un sistema relacional i un magatzem de dades.

Disseny i implementació de la base de dades d'un sistema de control energètic

Aquest treball de fi de carrera consisteix en la realització d'una base de dades per a la gestió de recursos energètics i el seu control de distribució i consum.

Disseny i implementació de la base de dades d'un sistema de control energètic

Donada la necessitat a nivell europeu d'aconseguir un control energètic, la Comunitat Europea vol implementar una aplicació que permeti la generació de dades estadístiques de l'ús de l'energia. El projecte consisteix en desenvolupar la primera fase d'aquesta aplicació: una base de dades que permeti emmagatzemar tota la informació necessària per la generació de dades estadístiques sobre l'ús de l'energia. A nivell general, la funció de la Base de Dades ha de ser la de guardar tota la informació necessària per entendre i fer actuacions per millorar el consum energètic, així com per a guardar l'històric del mateix. De la mateixa manera, ha de permetre guardar la informació dels clients, comptadors, centraletes de distribució, centrals de producció, etc., permitint realitzar amb aquesta informació diferents consultes habituals com el consum mig de tots els clients, la línia que ha estat més carregada a nivell d'energia consumida, etc.

Disseny i implementació de la base de dades d'un sistema de control energètic

El treball proposat consisteix en implementar un sistema de base de dades per donar resposta a una necessitat de control energètic que s'ha plantejat a nivell europeu. Inclou fase de plantejament, disseny, implementació i proves.

Disseny i implementació de la base de dades d'un sistema de control energètic

Proyecto de base de datos para un sistema de control energético para la Comunidad Europea que incluye la gestión de centrales, contadores y consumos.

Disseny i implementació de la base de dades d'un sistema de control energètic

Disseny d'un model de base de dades relacional, juntament amb els procediments i disparadors necessaris per controlar un sistema energètic.

Consensus statement of the European guidelines on clinical management of HIV-1 tropism testing

Introduction: Testing for HIV tropism is recommended before prescribing a chemokine receptor blocker. To date, in most European countries HIV tropism is determined using a phenotypic test. Recently, new data have emerged supporting the use of a genotypic HIV V3-loop sequence analysis as the basis for tropism determination. The European guidelines group on clinical management of HIV-1 tropism testing was established to make recommendations to clinicians and virologists. Methods: We searched online databases for articles from Jan 2006 until March 2010 with the terms: tropism or CCR5-antagonist or CCR5 antagonist or maraviroc or vicriviroc. Additional articles and/or conference abstracts were identified by hand searching. This strategy identified 712 potential articles and 1240 abstracts. All were reviewed and finally 57 papers and 42 abstracts were included and used by the panel to reach a consensus statement. Results: The panel recommends HIV-tropism testing for the following indications: i) drug-naïve patients in whom toxicity or limited therapeutic options are foreseen; ii) patients experiencing therapy failure whenever a treatment change is considered. Both the phenotypic Enhanced Trofile assay (ESTA) and genotypic population sequencing of the V3-loop are recommended for use in clinical practice. Although the panel does not recommend one methodology over another it is anticipated that genotypic testing will be used more frequently because of its greater accessibility, lower cost and shorter turnaround time. The panel also provides guidance on technical aspects and interpretation issues. If using genotypic methods, triplicate PCR amplification and sequencing testing is advised using the G2P interpretation tool (clonal model) with an FPR of 10%. If the viral load is below the level of reliable amplification, proviral DNA can be used, and the panel recommends performing triplicate testing and use of an FPR of 10%. If genotypic DNA testing is not performed in triplicate the FPR should be increased to 20%. Conclusions: The European guidelines on clinical management of HIV-1 tropism testing provide an overview of current literature, evidence-based recommendations for the clinical use of tropism testing and expert guidance on unresolved issues and current developments. Current data support both the use of genotypic population sequencing and ESTA for co-receptor tropism determination. For practical reasons genotypic population sequencing is the preferred method in Europe.

Continuous monitoring of cerebrovascular pressure reactivity in patients with head injury.

OBJECT: Cerebrovascular pressure reactivity is the ability of cerebral vessels to respond to changes in transmural pressure. A cerebrovascular pressure reactivity index (PRx) can be determined as the moving correlation coefficient between mean intracranial pressure (ICP) and mean arterial blood pressure. METHODS: The authors analyzed a database consisting of 398 patients with head injuries who underwent continuous monitoring of cerebrovascular pressure reactivity. In 298 patients, the PRx was compared with a transcranial Doppler ultrasonography assessment of cerebrovascular autoregulation (the mean index [Mx]), in 17 patients with the PET-assessed static rate of autoregulation, and in 22 patients with the cerebral metabolic rate for O(2). Patient outcome was assessed 6 months after injury. RESULTS: There was a positive and significant association between the PRx and Mx (R(2) = 0.36, p < 0.001) and with the static rate of autoregulation (R(2) = 0.31, p = 0.02). A PRx > 0.35 was associated with a high mortality rate (> 50%). The PRx showed significant deterioration in refractory intracranial hypertension, was correlated with outcome, and was able to differentiate patients with good outcome, moderate disability, severe disability, and death. The graph of PRx compared with cerebral perfusion pressure (CPP) indicated a U-shaped curve, suggesting that too low and too high CPP was associated with a disturbance in pressure reactivity. Such an optimal CPP was confirmed in individual cases and a greater difference between current and optimal CPP was associated with worse outcome (for patients who, on average, were treated below optimal CPP [R(2) = 0.53, p < 0.001] and for patients whose mean CPP was above optimal CPP [R(2) = -0.40, p < 0.05]). Following decompressive craniectomy, pressure reactivity initially worsened (median -0.03 [interquartile range -0.13 to 0.06] to 0.14 [interquartile range 0.12-0.22]; p < 0.01) and improved in the later postoperative course. After therapeutic hypothermia, in 17 (70.8%) of 24 patients in whom rewarming exceeded the brain temperature threshold of 37 degrees C, ICP remained stable, but the average PRx increased to 0.32 (p < 0.0001), indicating significant derangement in cerebrovascular reactivity. CONCLUSIONS: The PRx is a secondary index derived from changes in ICP and arterial blood pressure and can be used as a surrogate marker of cerebrovascular impairment. In view of an autoregulation-guided CPP therapy, a continuous determination of a PRx is feasible, but its value has to be evaluated in a prospective controlled trial.

La palce de la spiritualité dans les soins infirmiers: une revue de littérature [The role of spirituality in nursing care: a literature review].

Spirituality addresses the need to give meaning to life events and is characterized by the relationship with oneself, others and the universe. This article aims to provide an overview of the empirical knowledge, and the prevailing thoughts about spirituality in nursing and suggest perspectives for future directions. The literature review was conducted using the main databases; 36 articles, published between 2008-2013, were selected. The themes covered include the definitions of the spirituality, the spiritual care and the spiritual well-being. Spirituality differs from, yet is not opposed to religion and takes different forms in multicultural and secular societies. Cancer incites existential questions and impacts quality of life, and spiritual well-being is recognized as a good indicator of quality of life for people living with cancer. Professional caregivers are concerned about the needs and spiritual well-being of their patients and often consider interventions to address them. This article reflects the depth of thought and research in nursing and touches on both discipline-specific and interdisciplinary issues.

A review of malaria vaccine clinical projects based on the WHO rainbow table.

Development and Phase 3 testing of the most advanced malaria vaccine, RTS,S/AS01, indicates that malaria vaccine R&D is moving into a new phase. Field trials of several research malaria vaccines have also confirmed that it is possible to impact the host-parasite relationship through vaccine-induced immune responses to multiple antigenic targets using different platforms. Other approaches have been appropriately tested but turned out to be disappointing after clinical evaluation. As the malaria community considers the potential role of a first-generation malaria vaccine in malaria control efforts, it is an apposite time to carefully document terminated and ongoing malaria vaccine research projects so that lessons learned can be applied to increase the chances of success for second-generation malaria vaccines over the next 10 years. The most comprehensive resource of malaria vaccine projects is a spreadsheet compiled by WHO thanks to the input from funding agencies, sponsors and investigators worldwide. This spreadsheet, available from WHO's website, is known as "the rainbow table". By summarizing the published and some unpublished information available for each project on the rainbow table, the most comprehensive review of malaria vaccine projects to be published in the last several years is provided below.

DAS-28-based EULAR response and HAQ improvement in rheumatoid arthritis patients switching between TNF antagonists

INTRODUCTION No definitive data are available regarding the value of switching to an alternative TNF antagonist in rheumatoid arthritis patients who fail to respond to the first one. The aim of this study was to evaluate treatment response in a clinical setting based on HAQ improvement and EULAR response criteria in RA patients who were switched to a second or a third TNF antagonist due to failure with the first one. METHODS This was an observational, prospective study of a cohort of 417 RA patients treated with TNF antagonists in three university hospitals in Spain between January 1999 and December 2005. A database was created at the participating centres, with well-defined operational instructions. The main outcome variables were analyzed using parametric or non-parametric tests depending on the level of measurement and distribution of each variable. RESULTS Mean (+/- SD) DAS-28 on starting the first, second and third TNF antagonist was 5.9 (+/- 2.0), 5.1 (+/- 1.5) and 6.1 (+/- 1.1). At the end of follow-up, it decreased to 3.3 (+/- 1.6; Delta = -2.6; p > 0.0001), 4.2 (+/- 1.5; Delta = -1.1; p = 0.0001) and 5.4 (+/- 1.7; Delta = -0.7; p = 0.06). For the first TNF antagonist, DAS-28-based EULAR response level was good in 42% and moderate in 33% of patients. The second TNF antagonist yielded a good response in 20% and no response in 53% of patients, while the third one yielded a good response in 28% and no response in 72%. Mean baseline HAQ on starting the first, second and third TNF antagonist was 1.61, 1.52 and 1.87, respectively. At the end of follow-up, it decreased to 1.12 (Delta = -0.49; p < 0.0001), 1.31 (Delta = -0.21, p = 0.004) and 1.75 (Delta = -0.12; p = 0.1), respectively. Sixty four percent of patients had a clinically important improvement in HAQ (defined as > or = -0.22) with the first TNF antagonist and 46% with the second. CONCLUSION A clinically significant effect size was seen in less than half of RA patients cycling to a second TNF antagonist.

Homology modeling and metabolism prediction of human carboxylesterase-2 using docking analyses by GriDock: a parallelized tool based on AutoDock 4.0.

Metabolic problems lead to numerous failures during clinical trials, and much effort is now devoted to developing in silico models predicting metabolic stability and metabolites. Such models are well known for cytochromes P450 and some transferases, whereas less has been done to predict the activity of human hydrolases. The present study was undertaken to develop a computational approach able to predict the hydrolysis of novel esters by human carboxylesterase hCES2. The study involved first a homology modeling of the hCES2 protein based on the model of hCES1 since the two proteins share a high degree of homology (congruent with 73%). A set of 40 known substrates of hCES2 was taken from the literature; the ligands were docked in both their neutral and ionized forms using GriDock, a parallel tool based on the AutoDock4.0 engine which can perform efficient and easy virtual screening analyses of large molecular databases exploiting multi-core architectures. Useful statistical models (e.g., r (2) = 0.91 for substrates in their unprotonated state) were calculated by correlating experimental pK(m) values with distance between the carbon atom of the substrate's ester group and the hydroxy function of Ser228. Additional parameters in the equations accounted for hydrophobic and electrostatic interactions between substrates and contributing residues. The negatively charged residues in the hCES2 cavity explained the preference of the enzyme for neutral substrates and, more generally, suggested that ligands which interact too strongly by ionic bonds (e.g., ACE inhibitors) cannot be good CES2 substrates because they are trapped in the cavity in unproductive modes and behave as inhibitors. The effects of protonation on substrate recognition and the contrasting behavior of substrates and products were finally investigated by MD simulations of some CES2 complexes.

N-3 fatty acids, cancer and cachexia: a systematic review of the literature.

Use of n-3 fatty acids (FA) has been reported to be beneficial for cancer patients. We performed a systematic review of the literature in order to issue recommendations on the clinical use of n-3 FA in the cancer setting. A systematic search was performed in MEDLINE, EMBASE, Cochrane and Healthstar databases. We selected clinical trials or prospective observational studies including patients with cancer and life expectancy >2 months, in which enteral supplements with n-3 FA were administered. Parameters evaluated individually were clinical (nutritional status, tolerance, survival and hospital stays), biochemical (inflammatory mediators), and functional (functional status, appetite and quality of life (QoL)). Seventeen studies met the inclusion criteria; eight were of high quality. The panel of experts established the following evidence: (1) oral supplements with n-3 FA benefit patients with advanced cancer and weight loss, and are indicated in tumours of the upper digestive tract and pancreas; (2) the advantages observed were: increased weight and appetite, improved QoL, and reduced post-surgical morbidity; (3) there is no defined pattern for combining different n-3 FA, and it is recommended to administer > 1.5 g/day; and (4) better tolerance is obtained administering low-fat formulas for a period of at least 8 weeks. All the evidences were grade B but for 'length of treatment' and 'advantage of survival' it was grade C. Our findings suggest that administration of n-3 FA (EPA and DHA) in doses of at least 1.5 g/day for a prolonged period of time to patients with advanced cancer is associated with an improvement in clinical, biological and QoL parameters.

Emerging pharmacotherapies for alcohol dependence: a systematic review focusing on reduction in consumption.

BACKGROUND: European Medicines Agency guidelines recognize two different treatment goals for alcohol dependence: abstinence and reduction in alcohol consumption. All currently approved agents are indicated for abstinence. This systematic review aimed to identify drugs in development for alcohol dependence treatment and to establish, based upon trial design, if any are seeking market authorization for reduction in consumption. METHODS: We searched PubMed and Embase (December 2001-November 2011) to identify agents in development for alcohol dependence treatment. Additional studies were identified by searching ClinicalTrials.gov and the R&D Insight and Clinical Trials Insight databases. Studies in which the primary focus was treatment of comorbidity, or n≤20, were excluded. Studies were then classified as 'abstinence' if they: described a detoxification/alcohol withdrawal period; enrolled patients who had undergone detoxification previously; or presented relapse/abstinence rates as the primary outcome. Studies in patients actively drinking at baseline were classified as 'reduction in consumption'. RESULTS: Of 602 abstracts identified, 45 full-text articles were eligible. Five monotherapies were in development for alcohol dependence treatment: topiramate, fluvoxamine, aripiprazole, flupenthixol and nalmefene. Nalmefene was the only agent whose sponsor was clearly seeking definitive approval for reduction in consumption. Development status was unclear for topiramate, fluvoxamine, aripiprazole and flupenthixol. Fifteen agents were examined in published exploratory investigator-initiated trials; the majority focused on abstinence. Ongoing (unpublished) trials tended to focus on reduction in consumption. CONCLUSIONS: While published studies generally focused on abstinence, ongoing trials focused on reduction in consumption, suggesting a change in emphasis in the approach to treating alcohol dependence.