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.

Interfície de control de una línia industrial automatitzada

Estudi seriós sobre les interfícies gràfiques destinades al sector industrial. En aquest sentit, s'analitza el perfil d'usuari o usuaris més freqüent en aquest sector (les seves característiques i les seves necessitats), es presenten i es descriuen diverses pautes de disseny i diversos elements gràfics que compleixen una sèrie de requisits predefinits, es procedeix a fer un muntatge d'exemple presentant una sèrie de pantalles (se n'explica i justifica el funcionament) i, per acabar, es proposa un mètode per a fer la validació del disseny, mètode que pot comportar modificacions sobre el disseny inicial.

Análisis y diseño de una aplicación control de inventarios de una empresa lechera. "Holandesa"

El present treball consisteix en un sistema per a una empresa de producció i distribució de productes làctics basat en l'anàlisi i disseny amb les noves tecnologies. L'aplicació, que es dirà Control d'Inventaris, durà a terme la gestió del procés de revisió d'inventaris en magatzems registrant l'entrada de productes per a l'elaboració i la producció dels diferents productes. També realitzarà la gestió de reserves de comandes per a la seva cartera de clients.

Association between pre-diagnostic circulating vitamin D concentration and risk of colorectal cancer in European populations:a nested case-control study

Objective. To examine the association between pre-diagnostic circulating vitamin D concentration, dietary intake of vitamin D and calcium, and the risk of colorectal cancer in European populations. Design Nested case-control study. Setting. The study was conducted within the EPIC study, a cohort of more than 520 000 participants from 10 western European countries. Participants: 1248 cases of incident colorectal cancer, which developed after enrolment into the cohort, were matched to 1248 controls. Main outcome measures. Circulating vitamin D concentration (25-hydroxy-vitamin-D, 25-(OH)D) was measured by enzyme immunoassay. Dietary and lifestyle data were obtained from questionnaires. Incidence rate ratios and 95% confidence intervals for the risk of colorectal cancer by 25-(OH)D concentration and levels of dietary calcium and vitamin D intake were estimated from multivariate conditional logistic regression models, with adjustment for potential dietary and other confounders. Results. 25-(OH)D concentration showed a strong inverse linear dose-response association with risk of colorectal cancer (P for trend <0.001). Compared with a pre-defined mid-level concentration of 25-(OH)D (50.0-75.0 nmol/l), lower levels were associated with higher colorectal cancer risk (<25.0 nmol/l: incidence rate ratio 1.32 (95% confidence interval 0.87 to 2.01); 25.0-49.9 nmol/l: 1.28 (1.05 to 1.56), and higher concentrations associated with lower risk (75.0-99.9 nmol/l: 0.88 (0.68 to 1.13); ≥100.0 nmol/l: 0.77 (0.56 to 1.06)). In analyses by quintile of 25-(OH)D concentration, patients in the highest quintile had a 40% lower risk of colorectal cancer than did those in the lowest quintile (P<0.001). Subgroup analyses showed a strong association for colon but not rectal cancer (P for heterogeneity=0.048). Greater dietary intake of calcium was associated with a lower colorectal cancer risk. Dietary vitamin D was not associated with disease risk. Findings did not vary by sex and were not altered by corrections for season or month of blood donation. Conclusions The results of this large observational study indicate a strong inverse association between levels of pre-diagnostic 25-(OH)D concentration and risk of colorectal cancer in western European populations. Further randomised trials are needed to assess whether increases in circulating 25-(OH)D concentration can effectively decrease the risk of colorectal cancer.

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

La Comunitat Europea ha encarregat el disseny i implementació d'una base de dades que ajudi a controlar el consum energètic i estudiar les seves característiques. Aquest TFC conté el desenvolupament d'aquest projecte començant des de zero i contempla totes les fases de creació de la base de dades a implementar en Oracle. Les fases del projecte són: anàlisi prèvia, anàlisi de requisits, disseny, implementació, proves i lliurament final.

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.

Long-Term Control of Endemic Hospital-Wide Methicillin-Resistant Staphylococcus aureus (MRSA): The Impact of Targeted Active Surveillance for MRSA in Patients and Healthcare Workers

To evaluate the long-term impact of successive interventions on rates of methicillin-resistant Staphylococcus aureus (MRSA) colonization or infection and MRSA bacteremia in an endemic hospital-wide situation. DESIGN:Quasi-experimental, interrupted time-series analysis. The impact of the interventions was analyzed by use of segmented regression. Representative MRSA isolates were typed by use of pulsed-field gel electrophoresis. SETTING:A 950-bed teaching hospital in Seville, Spain. PATIENTS:All patients admitted to the hospital during the period from 1995 through 2008. METHODS:Three successive interventions were studied: (1) contact precautions, with no active surveillance for MRSA; (2) targeted active surveillance for MRSA in patients and healthcare workers in specific wards, prioritized according to clinical epidemiology data; and (3) targeted active surveillance for MRSA in patients admitted from other medical centers. RESULTS:Neither the preintervention rate of MRSA colonization or infection (0.56 cases per 1,000 patient-days [95% confidence interval {CI}, 0.49-0.62 cases per 1,000 patient-days]) nor the slope for the rate of MRSA colonization or infection changed significantly after the first intervention. The rate decreased significantly to 0.28 cases per 1,000 patient-days (95% CI, 0.17-0.40 cases per 1,000 patient-days) after the second intervention and to 0.07 cases per 1,000 patient-days (95% CI, 0.06-0.08 cases per 1,000 patient-days) after the third intervention, and the rate remained at a similar level for 8 years. The MRSA bacteremia rate decreased by 80%, whereas the rate of bacteremia due to methicillin-susceptible S. aureus did not change. Eighty-three percent of the MRSA isolates identified were clonally related. All MRSA isolates obtained from healthcare workers were clonally related to those recovered from patients who were in their care. CONCLUSION:Our data indicate that long-term control of endemic MRSA is feasible in tertiary care centers. The use of targeted active surveillance for MRSA in patients and healthcare workers in specific wards (identified by means of analysis of clinical epidemiology data) and the use of decolonization were key to the success of the program.

Clinical and molecular epidemiology of extended-spectrum beta-lactamase-producing Escherichia coli as a cause of nosocomial infection or colonization: implications for control.

BACKGROUND: Extended-spectrum beta-lactamase (ESBL)-producing members of the Enterobacteriaceae family are important nosocomial pathogens. Escherichia coli producing a specific family of ESBL (the CTX-M enzymes) are emerging worldwide. The epidemiology of these organisms as causes of nosocomial infection is poorly understood. The aims of this study were to investigate the clinical and molecular epidemiology of nosocomial infection or colonization due to ESBL-producing E. coli in hospitalized patients, consider the specific types of ESBLs produced, and identify the risk factors for infection and colonization with these organisms. METHODS: All patients with nosocomial colonization and/or infection due to ESBL-producing E. coli in 2 centers (a tertiary care hospital and a geriatric care center) identified between January 2001 and May 2002 were included. A double case-control study was performed. The clonal relatedness of the isolates was studied by repetitive extragenic palindromic-polymerase chain reaction and pulsed-field gel electrophoresis. ESBLs were characterized by isoelectric focusing, polymerase chain reaction, and sequencing. RESULTS: Forty-seven case patients were included. CTX-M-producing E. coli were clonally unrelated and more frequently susceptible to nonoxyimino-beta-lactams. Alternately, isolates producing SHV- and TEM-type ESBL were epidemic and multidrug resistant. Urinary catheterization was a risk factor for both CTX-M-producing and SHV-TEM-producing isolates. Previous oxyimino-beta-lactam use, diabetes, and ultimately fatal or nonfatal underlying diseases were independent risk factors for infection or colonization with CTX-M-producing isolates, whereas previous fluoroquinolone use was associated with infection or colonization with SHV-TEM-producing isolates. CONCLUSIONS: The epidemiology of ESBL-producing E. coli as a cause of nosocomial infection is complex. Sporadic CTX-M-producing isolates coexisted with epidemic multidrug-resistant SHV-TEM-producing isolates. These data should be taken into account for the design of control measures.

Prevalence, awareness, treatment and control of high blood pressure in a Swiss city general population: the CoLaus study.

BACKGROUND: This study is aimed to assess the prevalence of awareness, treatment and control of high blood pressure (HBP) and associated factors in a Swiss city. DESIGN: Population-based cross-sectional study of 6182 participants (52.5% women) aged 35-75 years living in Lausanne, Switzerland. METHODS: HBP was defined as blood pressure >/=140/90 mmHg or current antihypertensive medication. RESULTS: The overall prevalence of HBP was 36% (95% confidence interval: 35-38%). Among participants with HBP, 63% were aware of it. Among participants aware of HBP, 78% were treated, and among those treated, 48% were controlled (BP <140/90 mmHg). In multivariate analysis, HBP prevalence was associated with older age, male sex, low educational level, high alcohol intake, awareness of diabetes or dyslipidaemia, obesity and parental history of myocardial infarction. HBP awareness was associated with older age, female sex, awareness of diabetes or dyslipidaemia, obesity and parental history of myocardial infarction. HBP control was associated with younger age, higher educational level and no alcohol intake. Alone or in combination, sartans were the most often prescribed antihypertensive medication category (41%), followed by diuretics, beta-blockers, angiotensin converting enzyme inhibitors and calcium channel blockers. Only 31% of participants treated for HBP were taking >/=2 antihypertensive medications. CONCLUSION: Although more than half of all participants with HBP were aware and more than three-quarters of them received a pharmacological treatment, less than half of those treated were adequately controlled.

Experimental Modeling and Control Strategies on an Open Mobile Robot Platform PRIM

This research work deals with the problem of modeling and design of low level speed controller for the mobile robot PRIM. The main objective is to develop an effective educational tool. On one hand, the interests in using the open mobile platform PRIM consist in integrating several highly related subjects to the automatic control theory in an educational context, by embracing the subjects of communications, signal processing, sensor fusion and hardware design, amongst others. On the other hand, the idea is to implement useful navigation strategies such that the robot can be served as a mobile multimedia information point. It is in this context, when navigation strategies are oriented to goal achievement, that a local model predictive control is attained. Hence, such studies are presented as a very interesting control strategy in order to develop the future capabilities of the system

Mission control system for dam inspection with an AUV

This paper presents a complete control architecture that has been designed to fulfill predefined missions with an autonomous underwater vehicle (AUV). The control architecture has three levels of control: mission level, task level and vehicle level. The novelty of the work resides in the mission level, which is built with a Petri network that defines the sequence of tasks that are executed depending on the unpredictable situations that may occur. The task control system is composed of a set of active behaviours and a coordinator that selects the most appropriate vehicle action at each moment. The paper focuses on the design of the mission controller and its interaction with the task controller. Simulations, inspired on an industrial underwater inspection of a dam grate, show the effectiveness of the control architecture