Disseny i implementació d'un sistema per a gestionar la postvenda d'electrodomèstics

Treball centrat en el disseny i implementació d'una base de dades relacional (BD) per a la gestió d'incidències d'electrodomèstics, atenent als requeriments inicialment establerts. Inclou els procediments emmagatzemats, els sistema de diari (log). També es crea un magatzem de dades (DWH) i el procés d'extracció, transformació i càrrega (ETL) entre la BD i el DWH. Finalment es creen unes consultes específiques del DWH i una interfície HTML per a realitzar-les des d'un navegador i un servidor web.

Comparison of 2 frailty indexes for prediction of falls, disability, fractures, and death in older women.

BACKGROUND: Frailty, as defined by the index derived from the Cardiovascular Health Study (CHS index), predicts risk of adverse outcomes in older adults. Use of this index, however, is impractical in clinical practice. METHODS: We conducted a prospective cohort study in 6701 women 69 years or older to compare the predictive validity of a simple frailty index with the components of weight loss, inability to rise from a chair 5 times without using arms, and reduced energy level (Study of Osteoporotic Fractures [SOF index]) with that of the CHS index with the components of unintentional weight loss, poor grip strength, reduced energy level, slow walking speed, and low level of physical activity. Women were classified as robust, of intermediate status, or frail using each index. Falls were reported every 4 months for 1 year. Disability (> or =1 new impairment in performing instrumental activities of daily living) was ascertained at 4(1/2) years, and fractures and deaths were ascertained during 9 years of follow-up. Area under the curve (AUC) statistics from receiver operating characteristic curve analysis and -2 log likelihood statistics were compared for models containing the CHS index vs the SOF index. RESULTS: Increasing evidence of frailty as defined by either the CHS index or the SOF index was similarly associated with an increased risk of adverse outcomes. Frail women had a higher age-adjusted risk of recurrent falls (odds ratio, 2.4), disability (odds ratio, 2.2-2.8), nonspine fracture (hazard ratio, 1.4-1.5), hip fracture (hazard ratio, 1.7-1.8), and death (hazard ratio, 2.4-2.7) (P < .001 for all models). The AUC comparisons revealed no differences between models with the CHS index vs the SOF index in discriminating falls (AUC = 0.61 for both models; P = .66), disability (AUC = 0.64; P = .23), nonspine fracture (AUC = 0.55; P = .80), hip fracture (AUC = 0.63; P = .64), or death (AUC = 0.72; P = .10). Results were similar when -2 log likelihood statistics were compared. CONCLUSION: The simple SOF index predicts risk of falls, disability, fracture, and death as well as the more complex CHS index and may provide a useful definition of frailty to identify older women at risk of adverse health outcomes in clinical practice.

Selecció i implementació d'un motor de cerca a la Biblioteca Virtual de la UOC

A partir de diferents enquestes de satisfacció institucional i de l'anàlisi de l'arxiu 'log' del servidor de la biblioteca respecte a l'ús i al comportament dels usuaris, es va detectar que cada cop era més complex accedir als continguts i serveis de manera proporcional al creixement d'aquests darrers i de l'augment del nombre d'usuaris. El creixement dels recursos i de les diferents aplicacions desenvolupats a la Biblioteca Virtual de la UOC (BUOC) va fer necessari la selecció i la implementació d'un motor de cerca que facilités de manera global l'accés als recursos d'informació i als serveis oferts a la comunitat virtual de la UOC d'acord amb la tipologia d'usuari, l'idioma i el seu entorn d'aprenentatge. En aquest article s'exposa el procés d'anàlisi de diferents productes i la implementació de Verity a la BUOC amb els desenvolupaments realitzats en les diferents aplicacions perquè el motor de cerca pugui fer la seva funció.

Effectiveness of a nurse-led case management home care model in Primary Health Care. A quasi-experimental, controlled, multi-centre study

Background Demand for home care services has increased considerably, along with the growing complexity of cases and variability among resources and providers. Designing services that guarantee co-ordination and integration for providers and levels of care is of paramount importance. The aim of this study is to determine the effectiveness of a new case-management based, home care delivery model which has been implemented in Andalusia (Spain). Methods Quasi-experimental, controlled, non-randomised, multi-centre study on the population receiving home care services comparing the outcomes of the new model, which included nurse-led case management, versus the conventional one. Primary endpoints: functional status, satisfaction and use of healthcare resources. Secondary endpoints: recruitment and caregiver burden, mortality, institutionalisation, quality of life and family function. Analyses were performed at base-line, and at two, six and twelve months. A bivariate analysis was conducted with the Student's t-test, Mann-Whitney's U, and the chi squared test. Kaplan-Meier and log-rank tests were performed to compare survival and institutionalisation. A multivariate analysis was performed to pinpoint factors that impact on improvement of functional ability. Results Base-line differences in functional capacity – significantly lower in the intervention group (RR: 1.52 95%CI: 1.05–2.21; p = 0.0016) – disappeared at six months (RR: 1.31 95%CI: 0.87–1.98; p = 0.178). At six months, caregiver burden showed a slight reduction in the intervention group, whereas it increased notably in the control group (base-line Zarit Test: 57.06 95%CI: 54.77–59.34 vs. 60.50 95%CI: 53.63–67.37; p = 0.264), (Zarit Test at six months: 53.79 95%CI: 49.67–57.92 vs. 66.26 95%CI: 60.66–71.86 p = 0.002). Patients in the intervention group received more physiotherapy (7.92 CI95%: 5.22–10.62 vs. 3.24 95%CI: 1.37–5.310; p = 0.0001) and, on average, required fewer home care visits (9.40 95%CI: 7.89–10.92 vs.11.30 95%CI: 9.10–14.54). No differences were found in terms of frequency of visits to A&E or hospital re-admissions. Furthermore, patients in the control group perceived higher levels of satisfaction (16.88; 95%CI: 16.32–17.43; range: 0–21, vs. 14.65 95%CI: 13.61–15.68; p = 0,001). Conclusion A home care service model that includes nurse-led case management streamlines access to healthcare services and resources, while impacting positively on patients' functional ability and caregiver burden, with increased levels of satisfaction.

Estudio y construcción de herramientas de validación HTML

The Final Year Project consists of two essentially different parts, which share acommon theme: HTML code validation. The first of these two parts focuses on the study of the validation process. It supplies a brief introduction to the evolution of HTML and XHTML, the new tags introduced in HTML5 and the most common errors found in today's websites. Already developed HTML validation tools are analyzed and examined in detail in order to compare their features and evaluate their performances. Lastly, a comparison of the parsing process in the most common browsers found nowadays is provided. In the second part of the project the focus of the project is shifted towards the development of a XHTML5 validation tool. The input is a XHTML5 file whose content may or may not comply with the W3C specification, and therefore, may or may not be a valid XHTML5 document. The output provided by this tool will be a fixed XHTML5 document and an error log returned in the form of a XML file. Information as to the course of action pursued to fix the error and its location will also be included.

Oxidative stress response to menadione and cumene hydroperoxide in the opportunistic fungal pathogen Candida glabrata

Candida glabrata is an opportunistic fungal pathogen that can cause severe invasive infections and can evade phagocytic cell clearance. We are interested in understanding the virulence of this fungal pathogen, in particular its oxidative stress response. Here we investigated C. glabrata, Saccharomyces cerevisiae and Candida albicans responses to two different oxidants: menadione and cumene hydroperoxide (CHP). In log-phase, in the presence of menadione, C. glabrata requires Cta1p (catalase), while in a stationary phase (SP), Cta1p is dispensable. In addition, C. glabrata is less resistant to menadione than C. albicans in SP. The S. cerevisiae laboratory reference strain is less resistant to menadione than C. glabrata and C. albicans; however S. cerevisiaeclinical isolates (CIs) are more resistant than the lab reference strain. Furthermore, S. cerevisiae CIs showed an increased catalase activity. Interestingly, in SP C. glabrata and S. cerevisiae are more resistant to CHP than C. albicans and Cta1p plays no apparent role in detoxifying this oxidant.

Latitude gradients in melanoma incidence and mortality in the non-Maori population of New Zealand

The variation with latitude of incidence and mortality for cutaneous malignant melanoma (CMM) in the non-Maori population of New Zealand was assessed. For those aged 20 to 74 years, the effects of age, time period, birth-cohort, gender, and region (latitude), and some interactions between them were evaluated by log-linear regression methods. Increasing age-standardized incidence and mortality rates with increasing proximity to the equator were found for men and women. These latitude gradients were greater for males than females. The relative risk of melanoma in the most southern part of New Zealand (latitude 44 degrees S) compared with the most northern region (latitude 36 degrees S) was 0.63 (95 percent confidence interval [CI] = 0.60-0.67) for incidence and 0.76 (CI = 0.68-0.86) for mortality, both genders combined. The mean percentage change in CMM rates per degree of latitude for males was greater than those reported in other published studies. Differences between men and women in melanoma risk with latitude suggest that regional sun-behavior patterns or other risk factors may contribute to the latitude gradient observed.

Coherent forecasting of multiple-decrement life tables: a test using Japanese cause of death data

Planners in public and private institutions would like coherent forecasts of the components of age-specic mortality, such as causes of death. This has been di cult toachieve because the relative values of the forecast components often fail to behave ina way that is coherent with historical experience. In addition, when the group forecasts are combined the result is often incompatible with an all-groups forecast. It hasbeen shown that cause-specic mortality forecasts are pessimistic when compared withall-cause forecasts (Wilmoth, 1995). This paper abandons the conventional approachof using log mortality rates and forecasts the density of deaths in the life table. Sincethese values obey a unit sum constraint for both conventional single-decrement life tables (only one absorbing state) and multiple-decrement tables (more than one absorbingstate), they are intrinsically relative rather than absolute values across decrements aswell as ages. Using the methods of Compositional Data Analysis pioneered by Aitchison(1986), death densities are transformed into the real space so that the full range of multivariate statistics can be applied, then back-transformed to positive values so that theunit sum constraint is honoured. The structure of the best-known, single-decrementmortality-rate forecasting model, devised by Lee and Carter (1992), is expressed incompositional form and the results from the two models are compared. The compositional model is extended to a multiple-decrement form and used to forecast mortalityby cause of death for Japan

Ki-67 MIB1 labelling index and the prognosis of primary TaT1 urothelial cell carcinoma of the bladder.

Aims: To evaluate whether ki-67 labelling index (LI) has independent prognostic value for survival of patients with bladder urothelial tumours graded according to the 2004 World Health Organisation classification. Methods: Ki-67 LI was evaluated in 164 cases using the grid counting method. Non-invasive (stage Ta) tumours were: papilloma (n = 5), papillary urothelial neoplasia of low malignant potential (PUNLMP; n = 26), and low (LG; n = 34) or high grade (HG; n = 15) papillary urothelial carcinoma. Early invasive (stage T1) tumours were: LG (n = 58) and HG (n = 26) carcinoma. Statistical analysis included Fisher and x2 tests, and mean comparisons by ANOVA and t test. Univariate and multivariate survival analyses were performed according to the Kaplan–Meier method with log rank test and Cox’s proportional hazard method. Results: Mean ki-67 LI increased from papilloma to PUNLMP, LG, and HG in stage Ta (p,0.0001) and from LG to HG in stage T1 (p = 0.013) tumours. High tumour proliferation (.13%) was related to greater tumour size (p = 0.036), recurrence (p = 0.036), progression (p = 0.035), survival (p = 0.054), and high p53 accumulation (p = 0.015). Ki-67 LI and tumour size were independent predictors of disease free survival (DFS), but only ki-67 LI was related to progression free survival (PFS). Cancer specific overall survival (OS) was related to ki-67 LI, tumour size, and p27kip1 downregulation. Ki-67 LI was the main independent predictor of DFS (p = 0.0005), PFS (p = 0.0162), and cancer specific OS (p = 00195). Conclusion: Tumour proliferation measured by Ki-67 LI is related to tumour recurrence, stage progression, and is an independent predictor of DFS, PFS, and cancer specific OS in TaT1 bladder urothelial cell carcinoma.

Use of high-resolution geophysical data to characterize heterogeneous aquifers: influence of data integration method on hydrological predictions

The integration of geophysical data into the subsurface characterization problem has been shown in many cases to significantly improve hydrological knowledge by providing information at spatial scales and locations that is unattainable using conventional hydrological measurement techniques. The investigation of exactly how much benefit can be brought by geophysical data in terms of its effect on hydrological predictions, however, has received considerably less attention in the literature. Here, we examine the potential hydrological benefits brought by a recently introduced simulated annealing (SA) conditional stochastic simulation method designed for the assimilation of diverse hydrogeophysical data sets. We consider the specific case of integrating crosshole ground-penetrating radar (GPR) and borehole porosity log data to characterize the porosity distribution in saturated heterogeneous aquifers. In many cases, porosity is linked to hydraulic conductivity and thus to flow and transport behavior. To perform our evaluation, we first generate a number of synthetic porosity fields exhibiting varying degrees of spatial continuity and structural complexity. Next, we simulate the collection of crosshole GPR data between several boreholes in these fields, and the collection of porosity log data at the borehole locations. The inverted GPR data, together with the porosity logs, are then used to reconstruct the porosity field using the SA-based method, along with a number of other more elementary approaches. Assuming that the grid-cell-scale relationship between porosity and hydraulic conductivity is unique and known, the porosity realizations are then used in groundwater flow and contaminant transport simulations to assess the benefits and limitations of the different approaches.

Linezolid alone or combined with rifampin against methicillin-resistant Staphylococcus aureus in experimental foreign-body infection.

We investigated the activity of linezolid, alone and in combination with rifampin (rifampicin), against a methicillin-resistant Staphylococcus aureus (MRSA) strain in vitro and in a guinea pig model of foreign-body infection. The MIC, minimal bactericidal concentration (MBC) in logarithmic phase, and MBC in stationary growth phase were 2.5, >20, and >20 microg/ml, respectively, for linezolid; 0.01, 0.08, and 2.5 microg/ml, respectively, for rifampin; and 0.16, 0.63, >20 microg/ml, respectively, for levofloxacin. In time-kill studies, bacterial regrowth and the development of rifampin resistance were observed after 24 h with rifampin alone at 1x or 4x the MIC and were prevented by the addition of linezolid. After the administration of single intraperitoneal doses of 25, 50, and 75 mg/kg of body weight, linezolid peak concentrations of 6.8, 12.7, and 18.1 microg/ml, respectively, were achieved in sterile cage fluid at approximately 3 h. The linezolid concentration remained above the MIC of the test organism for 12 h with all doses. Antimicrobial treatments of animals with cage implant infections were given twice daily for 4 days. Linezolid alone at 25, 50, and 75 mg/kg reduced the planktonic bacteria in cage fluid during treatment by 1.2 to 1.7 log(10) CFU/ml; only linezolid at 75 mg/kg prevented bacterial regrowth 5 days after the end of treatment. Linezolid used in combination with rifampin (12.5 mg/kg) was more effective than linezolid used as monotherapy, reducing the planktonic bacteria by >or=3 log(10) CFU (P < 0.05). Efficacy in the eradication of cage-associated infection was achieved only when linezolid was combined with rifampin, with cure rates being between 50% and 60%, whereas the levofloxacin-rifampin combination demonstrated the highest cure rate (91%) against the strain tested. The linezolid-rifampin combination is a treatment option for implant-associated infections caused by quinolone-resistant MRSA.

Mandibular osteoradionecrosis in squamous cell carcinoma of the oral cavity and oropharynx: incidence and risk factors.

Objective. Mandibular osteoradionecrosis (ORN) is a serious complication of radiotherapy (RT) in head and neck cancer patients. The aim of this study was to analyze the incidence of and risk factors for mandibular ORN in squamous cell carcinoma (SCC) of the oral cavity and oropharynx.Study Design. Case series with chart review.Setting. University tertiary care center for head and neck oncology.Subjects and Methods. Seventy-three patients treated for stage I to IV SCC of the oral cavity and oropharynx between 2000 and 2007, with a minimum follow-up of 2 years, were included in the study. Treatment modalities included both RT with curative intent and adjuvant RT following tumor surgery. The log-rank test and Cox model were used for univariate and multivariate analyses.Results. The incidence of mandibular ORN was 40% at 5 years. Using univariate analysis, the following risk factors were identified: oral cavity tumors (P < .01), bone invasion (P < .02), any surgery prior to RT (P < .04), and bone surgery (P < .0001). By multivariate analysis, mandibular surgery proved to be the most important risk factor and the only one reaching statistical significance (P < .0002).Conclusion. Mandibular ORN is a frequent long-term complication of RT for oral cavity and oropharynx cancers. Mandibular surgery before irradiation is the only independent risk factor. These aspects must be considered when planning treatment for these tumors.

A tale of two logits, compositional data analysis and zero observations

The application of compositional data analysis through log ratio trans-formations corresponds to a multinomial logit model for the shares themselves.This model is characterized by the property of Independence of Irrelevant Alter-natives (IIA). IIA states that the odds ratio in this case the ratio of shares is invariant to the addition or deletion of outcomes to the problem. It is exactlythis invariance of the ratio that underlies the commonly used zero replacementprocedure in compositional data analysis. In this paper we investigate using thenested logit model that does not embody IIA and an associated zero replacementprocedure and compare its performance with that of the more usual approach ofusing the multinomial logit model. Our comparisons exploit a data set that com-bines voting data by electoral division with corresponding census data for eachdivision for the 2001 Federal election in Australia

An R Library for Compositional Data Analysis in Archaeometry

Compositional data naturally arises from the scientific analysis of the chemicalcomposition of archaeological material such as ceramic and glass artefacts. Data of thistype can be explored using a variety of techniques, from standard multivariate methodssuch as principal components analysis and cluster analysis, to methods based upon theuse of log-ratios. The general aim is to identify groups of chemically similar artefactsthat could potentially be used to answer questions of provenance.This paper will demonstrate work in progress on the development of a documentedlibrary of methods, implemented using the statistical package R, for the analysis ofcompositional data. R is an open source package that makes available very powerfulstatistical facilities at no cost. We aim to show how, with the aid of statistical softwaresuch as R, traditional exploratory multivariate analysis can easily be used alongside, orin combination with, specialist techniques of compositional data analysis.The library has been developed from a core of basic R functionality, together withpurpose-written routines arising from our own research (for example that reported atCoDaWork'03). In addition, we have included other appropriate publicly availabletechniques and libraries that have been implemented in R by other authors. Availablefunctions range from standard multivariate techniques through to various approaches tolog-ratio analysis and zero replacement. We also discuss and demonstrate a smallselection of relatively new techniques that have hitherto been little-used inarchaeometric applications involving compositional data. The application of the libraryto the analysis of data arising in archaeometry will be demonstrated; results fromdifferent analyses will be compared; and the utility of the various methods discussed

Compositional analysis of archaeological glasses

At CoDaWork'03 we presented work on the analysis of archaeological glass composi-tional data. Such data typically consist of geochemical compositions involving 10-12variables and approximates completely compositional data if the main component, sil-ica, is included. We suggested that what has been termed `crude' principal componentanalysis (PCA) of standardized data often identi ed interpretable pattern in the datamore readily than analyses based on log-ratio transformed data (LRA). The funda-mental problem is that, in LRA, minor oxides with high relative variation, that maynot be structure carrying, can dominate an analysis and obscure pattern associatedwith variables present at higher absolute levels. We investigate this further using sub-compositional data relating to archaeological glasses found on Israeli sites. A simplemodel for glass-making is that it is based on a `recipe' consisting of two `ingredients',sand and a source of soda. Our analysis focuses on the sub-composition of componentsassociated with the sand source. A `crude' PCA of standardized data shows two clearcompositional groups that can be interpreted in terms of di erent recipes being used atdi erent periods, reected in absolute di erences in the composition. LRA analysis canbe undertaken either by normalizing the data or de ning a `residual'. In either case,after some `tuning', these groups are recovered. The results from the normalized LRAare di erently interpreted as showing that the source of sand used to make the glassdi ered. These results are complementary. One relates to the recipe used. The otherrelates to the composition (and presumed sources) of one of the ingredients. It seemsto be axiomatic in some expositions of LRA that statistical analysis of compositionaldata should focus on relative variation via the use of ratios. Our analysis suggests thatabsolute di erences can also be informative