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

La Comunitat Econòmica Europea ha plantejat la necessitat d'assolir un control exhaustiu de la gestió i el consum que a la comunitat es fa de l'energia, sigui quina sigui la seva naturalesa. És per això que requereix el disseny d'una base de dades que proporcioni la capacitat d'emmagatzemar tota la informació necessària, i que faciliti l'obtenció de llistats i dades estadístiques referents a aquest ús de l'energia. Aquest treball pretén implementar la base de dades que donarà resposta a aquestes necessitats, un cop valorats els requeriments i la viabilitat del projecte.

Subclinical hypothyroidism and the risk of coronary heart disease and mortality.

CONTEXT: Data regarding the association between subclinical hypothyroidism and cardiovascular disease outcomes are conflicting among large prospective cohort studies. This might reflect differences in participants' age, sex, thyroid-stimulating hormone (TSH) levels, or preexisting cardiovascular disease. OBJECTIVE: To assess the risks of coronary heart disease (CHD) and total mortality for adults with subclinical hypothyroidism. DATA SOURCES AND STUDY SELECTION: The databases of MEDLINE and EMBASE (1950 to May 31, 2010) were searched without language restrictions for prospective cohort studies with baseline thyroid function and subsequent CHD events, CHD mortality, and total mortality. The reference lists of retrieved articles also were searched. DATA EXTRACTION: Individual data on 55,287 participants with 542,494 person-years of follow-up between 1972 and 2007 were supplied from 11 prospective cohorts in the United States, Europe, Australia, Brazil, and Japan. The risk of CHD events was examined in 25,977 participants from 7 cohorts with available data. Euthyroidism was defined as a TSH level of 0.50 to 4.49 mIU/L. Subclinical hypothyroidism was defined as a TSH level of 4.5 to 19.9 mIU/L with normal thyroxine concentrations. RESULTS: Among 55,287 adults, 3450 had subclinical hypothyroidism (6.2%) and 51,837 had euthyroidism. During follow-up, 9664 participants died (2168 of CHD), and 4470 participants had CHD events (among 7 studies). The risk of CHD events and CHD mortality increased with higher TSH concentrations. In age- and sex-adjusted analyses, the hazard ratio (HR) for CHD events was 1.00 (95% confidence interval [CI], 0.86-1.18) for a TSH level of 4.5 to 6.9 mIU/L (20.3 vs 20.3/1000 person-years for participants with euthyroidism), 1.17 (95% CI, 0.96-1.43) for a TSH level of 7.0 to 9.9 mIU/L (23.8/1000 person-years), and 1.89 (95% CI, 1.28-2.80) for a TSH level of 10 to 19.9 mIU/L (n = 70 events/235; 38.4/1000 person-years; P <.001 for trend). The corresponding HRs for CHD mortality were 1.09 (95% CI, 0.91-1.30; 5.3 vs 4.9/1000 person-years for participants with euthyroidism), 1.42 (95% CI, 1.03-1.95; 6.9/1000 person-years), and 1.58 (95% CI, 1.10-2.27, n = 28 deaths/333; 7.7/1000 person-years; P = .005 for trend). Total mortality was not increased among participants with subclinical hypothyroidism. Results were similar after further adjustment for traditional cardiovascular risk factors. Risks did not significantly differ by age, sex, or preexisting cardiovascular disease. CONCLUSIONS: Subclinical hypothyroidism is associated with an increased risk of CHD events and CHD mortality in those with higher TSH levels, particularly in those with a TSH concentration of 10 mIU/L or greater.

Evolutionary simulations to detect functional lineage-specific genes.

MOTIVATION: Supporting the functionality of recent duplicate gene copies is usually difficult, owing to high sequence similarity between duplicate counterparts and shallow phylogenies, which hamper both the statistical and experimental inference. RESULTS: We developed an integrated evolutionary approach to identify functional duplicate gene copies and other lineage-specific genes. By repeatedly simulating neutral evolution, our method estimates the probability that an ORF was selectively conserved and is therefore likely to represent a bona fide coding region. In parallel, our method tests whether the accumulation of non-synonymous substitutions reveals signatures of selective constraint. We show that our approach has high power to identify functional lineage-specific genes using simulated and real data. For example, a coding region of average length (approximately 1400 bp), restricted to hominoids, can be predicted to be functional in approximately 94-100% of cases. Notably, the method may support functionality for instances where classical selection tests based on the ratio of non-synonymous to synonymous substitutions fail to reveal signatures of selection. Our method is available as an automated tool, ReEVOLVER, which will also be useful to systematically detect functional lineage-specific genes of closely related species on a large scale. AVAILABILITY: ReEVOLVER is available at http://www.unil.ch/cig/page7858.html.

Magatzems de dades en el context de la web semàntica

L'objecte del projecte és estudiar en profunditat els sistemes gestors de bases de dates en l'àmbit de la web semàntica. Aquests sistemes són gestors de bases de dades especialitzats en l'emmagatzematge i tractament de dades semàntiques, tot tenint en compte les peculiaritats d'aquestes. Per tal d'aprofundir en la matèria, el projecte es divideix en dues parts principals. En la primera es recerca l'estat de l'art, fent un estudi comparatiu entre els magatzems semàntics més coneguts en l'actualitat. En la segona part s'estudia en profunditat un d'aquests magatzems (Virtuoso Universal Server).

XML y web semántica : Bases de datos en el contexto de la web semántica

Este trabajo define qué es una base de datos semántica, qué ventajas ofrece, cómo se utiliza y en qué tipo de proyectos o sistemas tiene sentido usarla. Además, en él se estudia en detalle una de ellas, OWLIM 1, de la empresa Ontotext, para evaluar la dificultad de usarla, su rendimiento y sus capacidades específicas.

Sistema de control energètic

La Comunitat Europea, dins de la partida pressupostària destinada a controlar l'ús de la energia, ha decidit obrir un concurs públic per a rebre propostes sobre el disseny d'una base de dades. Aquesta els hi servirà de magatzem de la informació per a la futura aplicació que volem implementar per permetre la generació de dades estadístiques sobre l'ús de l'energia.