Bases de datos : Empresa de selección de personal

Este documento refleja el trabajo realizado durante el diseño e implementación de una base de datos relacional y un almacén de datos para una empresa de gestión de personal.

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

Implementació d'un sistema de base de dades per donar resposta a la necessitat de control energètic plantejada a nivell europeu. La base de dades ha de guardar informació relacionada amb el consum energètic i permetre la generació de dades estadístiques sobre l'ús de l'energia.

A clinical trial for uniform multidrug therapy for leprosy patients in Brazil: rationale and design

Leprosy will continue to be a public health problem for several decades. The World Health Organization (WHO) recommends that, for treatment purposes, leprosy cases be classified as either paucibacillary or multibacillary (MB). A uniform leprosy treatment regimen would simplify treatment and halve the treatment duration for MB patients. The clinical trial for uniform multidrug therapy (U-MDT) for leprosy patients (LPs) in Brazil is a randomised, open-label clinical trial to evaluate if the effectiveness of U-MDT for leprosy equals the regular regimen, to determine the acceptability of the U-MDT regimen and to identify the prognostic factors. This paper details the clinical trial methodology and patient enrolment data. The study enrolled 858 patients at two centres and 78.4% of participants were classified as MB according to the WHO criteria. The main difficulty in evaluating a new leprosy treatment regimen is that no reliable data are available for the current treatment regimen. Relapse, reaction and impaired nerve function rates have never been systematically determined, although reaction and impaired nerve function are the two major causes of nerve damage that lead to impairments and disabilities in LPs. Our study was designed to overcome the need for reliable data about the current treatment and to compare its efficacy with that of a uniform regimen.

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.

Where microbiology meets microengineering: design and applications of reporter bacteria.

Bacteria have long been the targets for genetic manipulation, but more recently they have been synthetically designed to carry out specific tasks. Among the simplest of these tasks is chemical compound and toxicity detection coupled to the production of a quantifiable reporter signal. In this Review, we describe the current design of bacterial bioreporters and their use in a range of assays to measure the presence of harmful chemicals in water, air, soil, food or biological specimens. New trends for integrating synthetic biology and microengineering into the design of bacterial bioreporter platforms are also highlighted.

Rationale and design of a randomized, double-blind, placebo controlled multicenter trial to study efficacy, security, and long term effects of intermittent repeated levosimendan administration in patients with advanced heart failure: LAICA study.

BACKGROUND Advanced heart failure (HF) is associated with high morbidity and mortality; it represents a major burden for the health system. Episodes of acute decompensation requiring frequent and prolonged hospitalizations account for most HF-related expenditure. Inotropic drugs are frequently used during hospitalization, but rarely in out-patients. The LAICA clinical trial aims to evaluate the effectiveness and safety of monthly levosimendan infusion in patients with advanced HF to reduce the incidence of hospital admissions for acute HF decompensation. METHODS The LAICA study is a multicenter, prospective, randomized, double-blind, placebo-controlled, parallel group trial. It aims to recruit 213 out-patients, randomized to receive either a 24-h infusion of levosimendan at 0.1 μg/kg/min dose, without a loading dose, every 30 days, or placebo. RESULTS The main objective is to assess the incidence of admission for acute HF worsening during 12 months. Secondarily, the trial will assess the effect of intermittent levosimendan on other variables, including the time in days from randomization to first admission for acute HF worsening, mortality and serious adverse events. CONCLUSIONS The LAICA trial results could allow confirmation of the usefulness of intermittent levosimendan infusion in reducing the rate of hospitalization for HF worsening in advanced HF outpatients.

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.

Urban design proposes for the norwegian cities

Alta is the biggest city in the country of Finnmark. The area of study, Bossekop, is situated 4km from the city centre. It has some commercial areas, offices, hotels and housing, mostly single family housing. The most important Norwegian road, E6 goes through Bossekop, there for it has a big traffic flow. The concept builds on the idea of two axis, one local leading from the local sports development area into the centre core, and one on a higher level, the E6. In Bodø, after analysing carefully the surroundings we reached the conclusion that it is posssible to conserve a lot of the green as well as offering the municipalities the chance to develop with several housing typologies. Nature should be preserved and with this connect directly the mountain to the sea, using the existing creek to make the water connection. In order to keep a big part of this land untouched, we suggest that the rest of the site can be developed quite densely in one of the areas and then continuously fading out in direction of the mountains. Finnsnes is an important communication point for the region with its good connections. In that way it is becoming a central point for commerce and leisure. The concept is based on the wish from the municipality of Lenvik to look upon the city’s connection to the surrounding sea and green areas, together with the wish to make the pedestrian access better and the car traffic lighter., and in that way improve the conditions in the city

A microRNA Signature Associated with Early Recurrence in Breast Cancer.

Recurrent breast cancer occurring after the initial treatment is associated with poor outcome. A bimodal relapse pattern after surgery for primary tumor has been described with peaks of early and late recurrence occurring at about 2 and 5 years, respectively. Although several clinical and pathological features have been used to discriminate between low- and high-risk patients, the identification of molecular biomarkers with prognostic value remains an unmet need in the current management of breast cancer. Using microarray-based technology, we have performed a microRNA expression analysis in 71 primary breast tumors from patients that either remained disease-free at 5 years post-surgery (group A) or developed early (group B) or late (group C) recurrence. Unsupervised hierarchical clustering of microRNA expression data segregated tumors in two groups, mainly corresponding to patients with early recurrence and those with no recurrence. Microarray data analysis and RT-qPCR validation led to the identification of a set of 5 microRNAs (the 5-miRNA signature) differentially expressed between these two groups: miR-149, miR-10a, miR-20b, miR-30a-3p and miR-342-5p. All five microRNAs were down-regulated in tumors from patients with early recurrence. We show here that the 5-miRNA signature defines a high-risk group of patients with shorter relapse-free survival and has predictive value to discriminate non-relapsing versus early-relapsing patients (AUC = 0.993, p-value<0.05). Network analysis based on miRNA-target interactions curated by public databases suggests that down-regulation of the 5-miRNA signature in the subset of early-relapsing tumors would result in an overall increased proliferative and angiogenic capacity. In summary, we have identified a set of recurrence-related microRNAs with potential prognostic value to identify patients who will likely develop metastasis early after primary breast surgery.

Tuberculosis in migrant populations. A systematic review of the qualitative literature.

BACKGROUND The re-emergence of tuberculosis (TB) in low-incidence countries and its disproportionate burden on immigrants is a public health concern posing specific social and ethical challenges. This review explores perceptions, knowledge, attitudes and treatment adherence behaviour relating to TB and their social implications as reported in the qualitative literature. METHODS Systematic review in four electronic databases. Findings from thirty selected studies extracted, tabulated, compared and synthesized. FINDINGS TB was attributed to many non-exclusive causes including air-born transmission of bacteria, genetics, malnutrition, excessive work, irresponsible lifestyles, casual contact with infected persons or objects; and exposure to low temperatures, dirt, stress and witchcraft. Perceived as curable but potentially lethal and highly contagious, there was confusion around a condition surrounded by fears. A range of economic, legislative, cultural, social and health system barriers could delay treatment seeking. Fears of deportation and having contacts traced could prevent individuals from seeking medical assistance. Once on treatment, family support and "the personal touch" of health providers emerged as key factors facilitating adherence. The concept of latent infection was difficult to comprehend and while TB screening was often seen as a socially responsible act, it could be perceived as discriminatory. Immigration and the infectiousness of TB mutually reinforced each another exacerbating stigma. This was further aggravated by indirect costs such as losing a job, being evicted by a landlord or not being able to attend school. CONCLUSIONS Understanding immigrants' views of TB and the obstacles that they face when accessing the health system and adhering to a treatment programme-taking into consideration their previous experiences at countries of origin as well as the social, economic and legislative context in which they live at host countries- has an important role and should be considered in the design, evaluation and adaptation of programmes.

Structure-based drug design studies of the interactions ofent-kaurane diterpenes derived from Wedelia paludosa with the Plasmodium falciparumsarco/endoplasmic reticulum Ca2+-ATPase PfATP6

Malaria is responsible for more deaths around the world than any other parasitic disease. Due to the emergence of strains that are resistant to the current chemotherapeutic antimalarial arsenal, the search for new antimalarial drugs remains urgent though hampered by a lack of knowledge regarding the molecular mechanisms of artemisinin resistance. Semisynthetic compounds derived from diterpenes from the medicinal plant Wedelia paludosawere tested in silico against the Plasmodium falciparumCa2+-ATPase, PfATP6. This protein was constructed by comparative modelling using the three-dimensional structure of a homologous protein, 1IWO, as a scaffold. Compound 21 showed the best docking scores, indicating a better interaction with PfATP6 than that of thapsigargin, the natural inhibitor. Inhibition of PfATP6 by diterpene compounds could promote a change in calcium homeostasis, leading to parasite death. These data suggest PfATP6 as a potential target for the antimalarial ent-kaurane diterpenes.

Use of Two-Part Regression Calibration Model to Correct for Measurement Error in Episodically Consumed Foods in a Single-Replicate Study Design: EPIC Case Study.

In epidemiologic studies, measurement error in dietary variables often attenuates association between dietary intake and disease occurrence. To adjust for the attenuation caused by error in dietary intake, regression calibration is commonly used. To apply regression calibration, unbiased reference measurements are required. Short-term reference measurements for foods that are not consumed daily contain excess zeroes that pose challenges in the calibration model. We adapted two-part regression calibration model, initially developed for multiple replicates of reference measurements per individual to a single-replicate setting. We showed how to handle excess zero reference measurements by two-step modeling approach, how to explore heteroscedasticity in the consumed amount with variance-mean graph, how to explore nonlinearity with the generalized additive modeling (GAM) and the empirical logit approaches, and how to select covariates in the calibration model. The performance of two-part calibration model was compared with the one-part counterpart. We used vegetable intake and mortality data from European Prospective Investigation on Cancer and Nutrition (EPIC) study. In the EPIC, reference measurements were taken with 24-hour recalls. For each of the three vegetable subgroups assessed separately, correcting for error with an appropriately specified two-part calibration model resulted in about three fold increase in the strength of association with all-cause mortality, as measured by the log hazard ratio. Further found is that the standard way of including covariates in the calibration model can lead to over fitting the two-part calibration model. Moreover, the extent of adjusting for error is influenced by the number and forms of covariates in the calibration model. For episodically consumed foods, we advise researchers to pay special attention to response distribution, nonlinearity, and covariate inclusion in specifying the calibration model.

Computational drug design strategies applied to the modelling of human immunodeficiency virus-1 reverse transcriptase inhibitors

Reverse transcriptase (RT) is a multifunctional enzyme in the human immunodeficiency virus (HIV)-1 life cycle and represents a primary target for drug discovery efforts against HIV-1 infection. Two classes of RT inhibitors, the nucleoside RT inhibitors (NRTIs) and the nonnucleoside transcriptase inhibitors are prominently used in the highly active antiretroviral therapy in combination with other anti-HIV drugs. However, the rapid emergence of drug-resistant viral strains has limited the successful rate of the anti-HIV agents. Computational methods are a significant part of the drug design process and indispensable to study drug resistance. In this review, recent advances in computer-aided drug design for the rational design of new compounds against HIV-1 RT using methods such as molecular docking, molecular dynamics, free energy calculations, quantitative structure-activity relationships, pharmacophore modelling and absorption, distribution, metabolism, excretion and toxicity prediction are discussed. Successful applications of these methodologies are also highlighted.

CATMA, a comprehensive genome-scale resource for silencing and transcript profiling of Arabidopsis genes.

BACKGROUND: The Complete Arabidopsis Transcript MicroArray (CATMA) initiative combines the efforts of laboratories in eight European countries 1 to deliver gene-specific sequence tags (GSTs) for the Arabidopsis research community. The CATMA initiative offers the power and flexibility to regularly update the GST collection according to evolving knowledge about the gene repertoire. These GST amplicons can easily be reamplified and shared, subsets can be picked at will to print dedicated arrays, and the GSTs can be cloned and used for other functional studies. This ongoing initiative has already produced approximately 24,000 GSTs that have been made publicly available for spotted microarray printing and RNA interference. RESULTS: GSTs from the CATMA version 2 repertoire (CATMAv2, created in 2002) were mapped onto the gene models from two independent Arabidopsis nuclear genome annotation efforts, TIGR5 and PSB-EuGène, to consolidate a list of genes that were targeted by previously designed CATMA tags. A total of 9,027 gene models were not tagged by any amplified CATMAv2 GST, and 2,533 amplified GSTs were no longer predicted to tag an updated gene model. To validate the efficacy of GST mapping criteria and design rules, the predicted and experimentally observed hybridization characteristics associated to GST features were correlated in transcript profiling datasets obtained with the CATMAv2 microarray, confirming the reliability of this platform. To complete the CATMA repertoire, all 9,027 gene models for which no GST had yet been designed were processed with an adjusted version of the Specific Primer and Amplicon Design Software (SPADS). A total of 5,756 novel GSTs were designed and amplified by PCR from genomic DNA. Together with the pre-existing GST collection, this new addition constitutes the CATMAv3 repertoire. It comprises 30,343 unique amplified sequences that tag 24,202 and 23,009 protein-encoding nuclear gene models in the TAIR6 and EuGène genome annotations, respectively. To cover the remaining untagged genes, we identified 543 additional GSTs using less stringent design criteria and designed 990 sequence tags matching multiple members of gene families (Gene Family Tags or GFTs) to cover any remaining untagged genes. These latter 1,533 features constitute the CATMAv4 addition. CONCLUSION: To update the CATMA GST repertoire, we designed 7,289 additional sequence tags, bringing the total number of tagged TAIR6-annotated Arabidopsis nuclear protein-coding genes to 26,173. This resource is used both for the production of spotted microarrays and the large-scale cloning of hairpin RNA silencing vectors. All information about the resulting updated CATMA repertoire is available through the CATMA database http://www.catma.org.

Let's talk: how communication affects contract design

We study experimentally how the ability to communicate affects the frequency and effectiveness of flexible and inflexible contracts in a bilateral trade context where sellers can adjust trade quality after observing a post-contractual cost shock and a discretionary buyer transfer. In the absence of communication, we find that rigid contracts are more frequent and lead to higher earnings for both buyer and seller. By contrast, in the presence of communication, flexible contracts are much more frequent and considerably more productive, both for buyers and sellers. Also, both buyer and seller earn considerably more from flexible with communication than rigid without communication. Our results show quite strongly that communication, a normal feature in contracting, can remove the potential cost of flexibility (disagreements caused by conflicting perceptions). We offer an explanation based on social norms.