Disseny i implementació d'un sistema de votació ciutadana a nivell Europeu a través d'Internet

Aquest treball consisteix en el desenvolupament d'un projecte de base de dades relacional implementat en Oracle que dóna resposta a la necessitat d'un sistema de votació ciutadana a nivell europeu a través d'Internet.

Disseny i implementació de la base de dades d'un sistema de votació ciutadana a nivell europeu a través d'Internet

Disseny i implementació d'una base de dades per a la realització de votacions a travès d'internet a l'ambit de la Comunitat Europea.

Disseny i implementació d'una base de dades relacional per al manteniment d'aparells d'una empresa

Una empresa ens contracta ja que té la necessitat de controlar la gestió del manteniment de tots els aparells que té instal·lats en els 32 centres de treball de que disposa (com poden ser extintors, calderes, aire condicionat, fotocopiadores, escàners, impressores, plotters, etc.), i el manteniment el porten a terme diferents empreses de serveis especialitzades. Aquesta gestió i l'accés a tota la informació necessària es realitzarà mitjançant procediments de Base de Dades.La Base de Dades que es crearà ha de ser capaç de portar a terme la gestió de manteniment de tot el maquinari existent en cadascun dels centres de l'empresa, i ha de disposar d'eines que permetin, per una banda, tractar correctament la informació referent als diferents tipus de manteniment (preventiu, correctiu, adaptatiu) que es pot aplicar als diferents equips, i per l'altra, que li permetin incorporar a la Base de Dades aquelles necessites futures, és a dir, que li permetin ser escalable.Aquesta Base de Dades també disposarà de mecanismes que li permetin tractar possibles problemes d'integració amb la resta del sistema, com per exemple, la creació d'un log de les diferents accions fetes amb la Base de Dades, o diferents mecanismes per fer diversos tests de les funcionalitats del sistema.A part de la gestió de manteniment, es disposarà també un magatzem de dades (DataWarehouse) per tal de poder analitzar la informació que conté la Base de Dades anteriorment esmentada, amb l'objectiu d'ajudar a prendre decisions sobre les dades existents en un moment donat.El projecte està dividit en dos blocs principals, on el primer es dissenyarà i s'implementarà una Base de Dades relacional, amb la seva definició de requeriments, l'anàlisi i disseny, desenvolupament de procediments de base de dades i proves per testejar el correcte funcionament, mentre que el segon es dissenyarà i s'implementarà un magatzem de dades (DataWarehouse) per explotar les dades existents en la base de dades relacional.

Sistema de votación ciudadana a nivel europeo

Diseño e implementación mediante Oracle de una base de datos relacional de un sistema de votación ciudadana a nivel europeo.

Diseño e implementación de la base de datos de un sistema de votaciones ciudadano a través de internet

Memoria, presentación y producto de una base de datos para realizar votaciones ciudadanas a través de internet.

Immune monitoring design within the developmental pipeline for an immunotherapeutic or preventive vaccine

Immunotherapy is defined as the treatment of disease by inducing, enhancing, or suppressing an immune response, whereas preventive vaccination is intended to prevent the development of diseases in healthy subjects. Most successful prophylactic vaccines rely on the induction of high titers of neutralizing antibodies. It is generally thought that therapeutic vaccination requires induction of robust T-cell mediated immunity. The diverse array of potential or already in use immunotherapeutic and preventive agents all share the commonality of stimulating the immune system. Hence, measuring those vaccination-induced immune responses gives the earliest indication of vaccine take and its immune modulating effects.

On ubiquitin ligases and cancer.

Protein kinase genes account for almost 10% of all currently known cancer genes, highlighting the role of signal transduction in oncogenesis. A reexamination of the literature and available databases shows that E3 ubiquitin ligases are also key mediators of tumorigenesis. Altogether kinase and E3 genes represent more than 15% of the known cancer genes, underlining the importance of phosphorylation and ubiquitylation signaling pathways in cancer formation. Considering the recent literature reporting correlations between alterations in ubiquitylation processes and oncogenesis, this percentage is likely to increase even further in the future. Finally, E3 genes could serve as baits for the identification of additional cancer genes (e.g. their interacting partners). In contrast, deubiquitinases, like phosphatases, are not overrepresented among cancer genes. The same holds for E1 and E2 genes. Thus, kinase and E3 genes represent primary targets as cancer susceptibility genes for mutation screening and for the design of novel therapies.

Detection rate of FNA cytology in medullary thyroid carcinoma: a meta-analysis.

BACKGROUND: The early detection of medullary thyroid carcinoma (MTC) can improve patient prognosis, because histological stage and patient age at diagnosis are highly relevant prognostic factors. As a consequence, delay in the diagnosis and/or incomplete surgical treatment should correlate with a poorer prognosis for patients. Few papers have evaluated the specific capability of fine-needle aspiration cytology (FNAC) to detect MTC, and small series have been reported. This study conducts a meta-analysis of published data on the diagnostic performance of FNAC in MTC to provide more robust estimates. RESEARCH DESIGN AND METHODS: A comprehensive computer literature search of the PubMed/MEDLINE, Embase and Scopus databases was conducted by searching for the terms 'medullary thyroid' AND 'cytology', 'FNA', 'FNAB', 'FNAC', 'fine needle' or 'fine-needle'. The search was updated until 21 March 2014, and no language restrictions were used. RESULTS: Fifteen relevant studies and 641 MTC lesions that had undergone FNAC were included. The detection rate (DR) of FNAC in patients with MTC (diagnosed as 'MTC' or 'suspicious for MTC') on a per lesion-based analysis ranged from 12·5% to 88·2%, with a pooled estimate of 56·4% (95% CI: 52·6-60·1%). The included studies were statistically heterogeneous in their estimates of DR (I-square >50%). Egger's regression intercept for DR pooling was 0·03 (95% CI: -3·1 to 3·2, P = 0·9). The study that reported the largest MTC series had a DR of 45%. Data on immunohistochemistry for calcitonin in diagnosing MTC were inconsistent for the meta-analysis. CONCLUSIONS: The presented meta-analysis demonstrates that FNAC is able to detect approximately one-half of MTC lesions. These findings suggest that other techniques may be needed in combination with FNAC to diagnose MTC and avoid false negative results.

Current genetic data do not improve the prediction of type 2 diabetes mellitus: the CoLaus study.

CONTEXT: Several genetic risk scores to identify asymptomatic subjects at high risk of developing type 2 diabetes mellitus (T2DM) have been proposed, but it is unclear whether they add extra information to risk scores based on clinical and biological data. OBJECTIVE: The objective of the study was to assess the extra clinical value of genetic risk scores in predicting the occurrence of T2DM. DESIGN: This was a prospective study, with a mean follow-up time of 5 yr. SETTING AND SUBJECTS: The study included 2824 nondiabetic participants (1548 women, 52 ± 10 yr). MAIN OUTCOME MEASURE: Six genetic risk scores for T2DM were tested. Four were derived from the literature and two were created combining all (n = 24) or shared (n = 9) single-nucleotide polymorphisms of the previous scores. A previously validated clinic + biological risk score for T2DM was used as reference. RESULTS: Two hundred seven participants (7.3%) developed T2DM during follow-up. On bivariate analysis, no differences were found for all but one genetic score between nondiabetic and diabetic participants. After adjusting for the validated clinic + biological risk score, none of the genetic scores improved discrimination, as assessed by changes in the area under the receiver-operating characteristic curve (range -0.4 to -0.1%), sensitivity (-2.9 to -1.0%), specificity (0.0-0.1%), and positive (-6.6 to +0.7%) and negative (-0.2 to 0.0%) predictive values. Similarly, no improvement in T2DM risk prediction was found: net reclassification index ranging from -5.3 to -1.6% and nonsignificant (P ≥ 0.49) integrated discrimination improvement. CONCLUSIONS: In this study, adding genetic information to a previously validated clinic + biological score does not seem to improve the prediction of T2DM.

The Impact of CAROtid plaque Screening on Smoking (CAROSS) cessation and control of other cardiovascular risk factors: rationale and design of a randomized controlled trial

BACKGROUND: Screening tests for subclinical cardiovascular disease, such as markers of atherosclerosis, are increasingly used in clinical prevention to identify individuals at high cardiovascular risk. Being aware of these test results might also enhance patient motivation to change unhealthy behaviors but the effectiveness of such a screening strategy has been poorly studied. METHODS: The CAROtid plaque Screening trial on Smoking cessation (CAROSS) is a randomized controlled trial in 530 regular smokers aged 40-70 years to test the hypothesis that carotid plaque screening will influence smokers' behavior with an increased rate of smoking cessation (primary outcome) and an improved control of other cardiovascular risk factors (secondary outcomes) after 1-year follow-up. All smokers will receive a brief advice for smoking cessation,and will subsequently be randomly assigned to either the intervention group (with plaques screening) or the control group (without plaque screening). Carotid ultrasound will be conducted with a standard protocol. Smokers with at least one carotid plaque will receive pictures of their own plaques with a structured explanation on the general significance of plaques. To ensure equal contact conditions, smokers not undergoing ultrasound and those without plaque will receive a relevant explanation on the risks associated with tobacco smoking. Study outcomes will be compared between smokers randomized to plaque screening and smokers not submitted to plaque screening. SUMMARY: This will be the first trial to assess the impact of carotid plaque screening on 1-year smoking cessation rates and levels of control of other cardiovascular risk factors.

Interventions to achieve long-term weight loss in obese older people: A systematic review and meta-analysis

Purpose: the prevalence of obesity is rapidly increasing in older adults. Information is required about what interventions are effective in reducing obesity and influencing health outcomes in this age group. Design: systematic review and meta-analysis. Data sources: thirteen databases were searched, earliest date 1966 to December 2008, including Medline, CINAHL, PsycINFO, the Cochrane database and EMBASE. Study selection: we included studies with participants�۪ mean age 60 years and mean body mass index 30 kg/m2, with outcomes at a minimum of 1 year. Data were independently extracted by two reviewers and differences resolved by consensus. Data extraction: nine eligible trials were included. Study interventions targeted diet, physical activity and mixed approaches. Populations included patients with coronary artery disease, diabetes mellitus and osteoarthritis. Results: meta-analysis (seven studies) demonstrated a modest but significant weight loss of 3.0 kg [95% confidence interval (CI) 5.1���0.9] at 1 year. Total cholesterol (four studies) did not show a significant change: ���0.36 mmol/l (95% CI ���0.75 to 0.04). There was no significant change in high-density lipoprotein, low-density lipoprotein or triglycerides. In one study, recurrence of hypertension or cardiovascular events was significantly reduced (hazard ratio 0.65, 95% CI 0.50���0.85). Six-minute walk test did not significantly change in one study. Health-related quality of life significantly improved in one study but did not improve in a second study. Conclusions: although modest weight reductions were observed, there is a lack of high-quality evidence to support the efficacy of weight loss programmes in older people. ��Keywords: obesity, older, weight loss, meta-analysis, elderly, systematic review

Interventions to achieve long-term weight loss in obese older people

Purpose: the prevalence of obesity is rapidly increasing in older adults. Information is required about what interventions are effective in reducing obesity and influencing health outcomes in this age group. Design: systematic review and meta-analysis. Data sources: thirteen databases were searched, earliest date 1966 to December 2008, including Medline, CINAHL, PsycINFO, the Cochrane database and EMBASE. Study selection: we included studies with participants�۪ mean age 60 years and mean body mass index 30 kg/m2, with outcomes at a minimum of 1 year. Data were independently extracted by two reviewers and differences resolved by consensus. Data extraction: nine eligible trials were included. Study interventions targeted diet, physical activity and mixed approaches. Populations included patients with coronary artery disease, diabetes mellitus and osteoarthritis. Results: meta-analysis (seven studies) demonstrated a modest but significant weight loss of 3.0 kg [95% confidence interval (CI) 5.1���0.9] at 1 year. Total cholesterol (four studies) did not show a significant change: ���0.36 mmol/l (95% CI ���0.75 to 0.04). There was no significant change in high-density lipoprotein, low-density lipoprotein or triglycerides. In one study, recurrence of hypertension or cardiovascular events was significantly reduced (hazard ratio 0.65, 95% CI 0.50���0.85). Six-minute walk test did not significantly change in one study. Health-related quality of life significantly improved in one study but did not improve in a second study. Conclusions: although modest weight reductions were observed, there is a lack of high-quality evidence to support the efficacy of weight loss programmes in older people. ��Keywords: obesity, older, weight loss, meta-analysis, elderly, systematic review��

Aplicació web per a la gestió de comandes amb J2EE

La present memòria descriu els passos necessaris per fer l'anàlisi, el disseny i la implementació de un gestor de comandes per un empresa mitjançant l'entorn web. El projecte ha estat realitzat en llenguatge Java, ja que és un llenguatge orientat a l'objecte molt reutilitzable i que té una plataforma que és la J2EE, que la fa ideal per l'unió de pàgines web amb bases de dades.

Construcció i explotació d'un magatzem de dades corporatiu

Treball de disseny i implementació d'una solució de consulta de dades sobre un magatzem de dades corporatiu creat i nodrit a partir de diverses bases de dades ja existents en una empresa. El projecte s'ha desenvolupat amb el gestor de bases de dades Oracle 10g i amb l'eina de consulta Oracle Discoverer. Les bases de dades on es trobaven les dades originals es trobaven en MS Access, i en aquest entorn s'ha desenvolupat el procés de tractament de les dades.

Disseny i implementació d'un sistema de control de projectes

L'àmbit d'aquest treball de final de carrera és el camp del disseny de les bases de dades relacionals, per la qual cosa aquest treball s'ha enfocat des de diversos punts de vista: a) Acadèmic. Es descriurà la teoria del disseny de bases de dades relacionals. b) Pràctic. Es posarà en pràctica tot el model teòric desenvolupant un cas concret (producte) que s'anirà intercalant amb el desenvolupament teòric del punt anterior. c) Tecnològic. El desplegament del producte es farà a l'SGBD Oracle 9i (s'hi porta a terme una introducció), on s'implementarà tota la interfície a la BD amb la tecnologia PL/SQL d'Oracle.