Sistema de reservas hoteleras RESHOTEL

XXXTOUR és una empresa que té com a principal negoci fer d'intermediari per a les agències de viatge i els particulars que vulguin reservar places hoteleres, d'una banda, i per als establiments hotelers, de l'altra. Així, doncs, contracta aquestes places a uns proveïdors i les ven a aquests clients. En l'actualitat, els proveïdors comuniquen a XXXTOUR totes les dades referents a les places mitjançant documents impresos i per telèfon, i els treballadors de l'empresa les han d'introduir al sistema d'informació de l'empresa. Per mitjà del nou sistema, els proveïdors, a més de poder emprar la funcionalitat actual, podran accedir al portal d'XXXTOUR i introduir les seves pròpies dades. I quan rebin una petició de places les podran confirmar accedint al portal, de manera que el client tindrà les places sol·licitades molt més aviat, cosa que millora el servei.

Análisis, diseño e implementación de un mini gestor de contenidos en un Framework Spring

Memoria del trabajo de fin de carrera donde se detalla la implementación de un mini gestor de contenidos utilizando el framework Spring.

Construcció i explotació d'un magatzem de dades de planificació hidrològica

Memòria del treball de fi de carrera on s'ha construït i explotat un magatzem de dades, partint d'unes dades en un sistema OLTP a un sistema multidimensional OLAP, tot això sobre amb les eines Oracle Express Edition 10v i Oracle Discoverer.

Reconocimiento de puntos de interés en rostros

Aplicación que realiza un entrenamiento de puntos de interés en rostros a partir de una colección de imágenes, posteriormente se puede verificar el resultado. Dada una imagen se comprueba el porcentaje de aciertos.

Disseny d'un sistema de gestió per a una cambra de congelació robotitzada de masses congelades.

Alguns dels grans fabricants del sector de les masses congelades fan servir robots per a l'emmagatzematge, servei i gestió dels productes de les cambres de congelació. Aquests robots només emmagatzemen i serveixen palets de caixes d'un mateix tipus de producte; així, doncs, només són útils quan el client és un gran consumidor, com un distribuïdor o una delegació, però no un petit comerç, com un restaurant o una fleca, els quals també són clients potencials del fabricant. Per tant, el problema es planteja en el moment de servir els clients que tenen problemes d'emmagatzematge, els quals es veuen obligats a fer comandes de diversos productes, que, a més, en total no fan ni de bon tros un palet sencer. A partir d'aquí la idea és dissenyar un sistema, emprant la tècnica de l'orientació a objectes (O-O), que gestioni un conjunt de robots que, a més d'emmagatzemar i gestionar una cambra de congelació, siguin capaços de servir les comandes fent una selecció de caixes de productes concrets, és a dir, les que sol·licita el client que ha fet la comanda per caixes i no per palets. Per qüestions d'organització i d'estocs, aquests robots han de ser independents dels altres, és a dir, han de treballar en una cambra independent de la dels robots que treballen per palets (actualment aquesta feina la fan treballadors dins una cambra independent de la dels robots).

Control de accesos mediante reconocimiento facial

En esta memoria expone el trabajo que se ha llevado a cabo para intentar crear un sistema de reconocimiento facial.

Regulation of gammadelta versus alphabeta T lymphocyte differentiation by the transcription factor SOX13.

alphabeta and gammadelta T cells originate from a common, multipotential precursor population in the thymus, but the molecular mechanisms regulating this lineage-fate decision are unknown. We have identified Sox13 as a gammadelta-specific gene in the immune system. Using Sox13 transgenic mice, we showed that this transcription factor promotes gammadelta T cell development while opposing alphabeta T cell differentiation. Conversely, mice deficient in Sox13 expression exhibited impaired development of gammadelta T cells but not alphabeta T cells. One mechanism of SOX13 function is the inhibition of signaling by the developmentally important Wnt/T cell factor (TCF) pathway. Our data thus reveal a dominant pathway regulating the developmental fate of these two lineages of T lymphocytes.

Spatial distribution of Schistosoma mansoni infection before and after chemotherapy with two praziquantel doses in a community of Pernambuco, Brazil

Praziquantel chemotherapy has been the focus of the Schistosomiasis Control Program in Brazil for the past two decades. Nevertheless, information on the impact of selective chemotherapy against Schistosoma mansoni infection under the conditions confronted by the health teams in endemic municipalities remains scarce. This paper compares the spatial pattern of infection before and after treatment with either a 40 mg/kg or 60 mg/kg dose of praziquantel by determining the intensity of spatial cluster among patients at 180 and 360 days after treatment. The spatial-temporal distribution of egg-positive patients was analysed in a Geographic Information System using the kernel smoothing technique. While all patients became egg-negative after 21 days, 17.9% and 30.9% reverted to an egg-positive condition after 180 and 360 days, respectively. Both the prevalence and intensity of infection after treatment were significantly lower in the 60 mg/kg than in the 40 mg/kg treatment group. The higher intensity of the kernel in the 40 mg/kg group compared to the 60 mg/kg group, at both 180 and 360 days, reflects the higher number of reverted cases in the lower dose group. Auxiliary, preventive measures to control transmission should be integrated with chemotherapy to achieve a more enduring impact.

An image quality comparison of standard and dual-side read CR systems for pediatric radiology.

An objective analysis of image quality parameters was performed for a computed radiography (CR) system using both standard single-side and prototype dual-side read plates. The pre-sampled modulation transfer function (MTF), noise power spectrum (NPS), and detective quantum efficiency (DQE) for the systems were determined at three different beam qualities representative of pediatric chest radiography, at an entrance detector air kerma of 5 microGy. The NPS and DQE measurements were realized under clinically relevant x-ray spectra for pediatric radiology, including x-ray scatter radiations. Compared to the standard single-side read system, the MTF for the dual-side read system is reduced, but this is offset by a significant decrease in image noise, resulting in a marked increase in DQE (+40%) in the low spatial frequency range. Thus, for the same image quality, the new technology permits the CR system to be used at a reduced dose level.

NUTRISOL: un programa informático para la evaluación nutricional comunitaria y hospitalaria de acceso libre.

We have developed the computer programme NUTRISOL, a nutritional programme destined to analysis of dietary intake by means of the food transformation to nutrient. It has been performed under Windows operative system, using Visual Basic 6.0. It is presented in a CD-Rom. We have used the Spanish CSIC Food Composition Table and domestic food measures commonly used in Spain which could be modified and updated. Diverse kind of diets and reference anthropometric data are also presented. The results may be treated using various statistical programmes. The programme contains three modules: 1) Nutritional epidemiology, which allows to create or open a data base, sample management, analyse food intake, consultation of nutrient content and exportation of data to statistical programmes. 2) Analyses of diets and recipes, creation or modification of new ones. 3) To ask different diets for prevalent pathologies. Independent tools for modifying the original tables, calculate energetic needs, recommend nutrient intake and anthropometric indexes are also offered. In conclusion, NUTRISOL Programme is an application which runs in PC computers with minimal equipment in a friendly interface, of easy use, freeware, which may be adapted to each country, and has demonstrated its usefulness and reliability in different epidemiologic studies. Furthermore, it may become an efficient instrument for clinical nutrition and health promotion.

Impactia: automating the study of the scientific production

Introduction The Andalusian Public Health System Virtual Library (Biblioteca Virtual del Sistema Sanitario Público de Andalucía, BV-SSPA) was set up in June 2006. It consists of a regional government action with the aim of democratizing the health professional access to quality scientific information, regardless of the professional workplace. Andalusia is a region with more than 8 million inhabitants, with 100,000 health professionals for 41 hospitals, 1,500 primary healthcare centres, and 28 centres for non-medical attention purposes (research, management, and educational centres). Objectives The Department of Development, Research and Investigation (R+D+i) of the Andalusian Regional Government has, among its duties, the task of evaluating the hospitals and centres of the Andalusian Public Health System (SSPA) in order to distribute its funding. Among the criteria used is the evaluation of the scientific output, which is measured using bibliometry. It is well-known that the bibliometry has a series of limitations and problems that should be taken into account, especially when it is used for non-information sciences, such us career, funding, etc. A few years ago, the bibliometric reports were done separately in each centre, but without using preset and well-defined criteria, elements which are basic when we need to compare the results of the reports. It was possible to find some hospitals which were including Meeting Abstracts in their figures, while others do not, and the same was happening with Erratum and many other differences. Therefore, the main problem that the Department of R+D+i had to deal with, when they were evaluating the health system, was that bibliometric data was not accurate and reports were not comparable. With the aim of having an unified criteria for the whole system, the Department of R+D+i ordered the BV-SSPA to do the year analysis of the scientific output of the system, using some well defined criteria and indicators, among whichstands out the Impact Factor. Materials and Methods As the Impact Factor is the bibliometric indicator that the virtual library is asked to consider, it is necessary to use the database Web of Science (WoS), since it is its owner and editor. The WoS includes the databases Science Citation Index (SCI), Social Sciences Citation Index (SSCI) and Arts & Humanities Citation Index. To gather all the documents, SCI and SSCI are used; to obtain the Impact Factor and quartils, it is used the Journal Citation Reports, JCR. Unlike other bibliographic databases, such us MEDLINE, the bibliometric database WoS includes the address of all the authors. In order to retrieve all the scientific output of the SSPA, we have done general searches, which are afterwards processed by a tool developed by our library. We have done nine different searches using the field ‘address’; eight of them including ‘Spain’ and each one of the eight Andalusian Regions, and the other one combining ‘Spain’ with all those cities where there are health centres, since we have detected that there are some authors that do not use the region in their signatures. These are some of the search strategies: AD=Malaga and AD=Spain AD=Sevill* and AD=Spain AD=SPAIN AND (AD=GUADIX OR AD=BAZA OR AD=MOTRIL) Further more, the field ‘year’ is used to determine the period. To exploit the data, the BV-SSPA has developed a tool called Impactia. It is a web application which uses a database to store the information of the documents generated by the SSPA. Impactia allows the user to automatically process the retrieved documents, assigning them to their correspondent centres. In order to do the classification of documents automaticaly, it was necessary to detect the huge variability of names of the centres that the authors use in their signatures. Therefore, Impactia knows that if an author signs as “Hospital Universitario Virgen Macarena”, “HVM” or “Hosp. Virgin Macarena”, he belongs to the same centre. The figure attached shows the variability found for the Empresa Publica Hospital de Poniente. Besides the documents from WoS, Impactia includes the documents indexed in Scopus and in other databases, where we do bibliographic searches using similar strategies to the later ones. Aware that in the health centres and hospitals there is a lot of grey literature that is not gathered in databases, Impactia allows the centres to feed the application with these documents, so that all the SSPA scientific output is gathered and organised in a centralized place. The ones responsible of localizing this gray literature are the librarians of each one of the centres. They can also do statements to the documents and indicators that are collected and calculated by Impactia. The bulk upload of documents from WoS and Scopus into Impactia is monthly done. One of the main issues that we found during the development of Impactia was the need of dealing with duplicated documents obtained from different sources. Taking into account that sometimes titles might be written differently, with slashes, comas, and so on, Impactia detects the duplicates using the field ‘DOI’ if it is available or comparing the fields: page start, page end and ISSN. Therefore it is possible to guarantee the absence of duplicates. Results The data gathered in Impactia becomes available to the administrative teams and hospitals managers, through an easy web page that allows them to know at any moment, and with just one click, the detailed information of the scientific output of their hospitals, including useful graphs such as percentage of document types, journals where their scientists usually publish, annual comparatives, bibliometric indicators and so on. They can also compare the different centres of the SSPA. Impactia allows the user to download the data from the application, so that he can work with this information or include them in their centres’ reports. This application saves the health system many working hours. It was previously done manually by forty one librarians, while now it is done by only one person in the BV-SSPA during two days a month. To sum up, the benefits of Impactia are: It has shown its effectiveness in the automatic classification, treatment and analysis of the data. It has become an essential tool for all managers to evaluate quickly and easily the scientific production of their centers. It optimizes the human resources of the SSPA, saving time and money. It is the reference point for the Department of R+D+i to do the scientific health staff evaluation.

Growth and characterization of CoO ultra thin films

In this report we present the growth process of the cobalt oxide system using reactive electron beam deposition. In that technique, a target of metallic cobalt is evaporated and its atoms are in-flight oxidized in an oxygen rich reactive atmosphere before reaching the surface of the substrate. With a trial and error procedure the deposition parameters have been optimized to obtain the correct stoichiometry and crystalline phase. The evaporation conditions to achieve the correct cobalt oxide salt rock structure, when evaporating over amorphous silicon nitride, are: 525 K of substrate temperature, 2.5·10-4 mbar of oxygen partial pressure and 1 Å/s of evaporation rate. Once the parameters were optimized a set of ultra thin film ranging from samples of 1 nm of nominal thickness to 20nm thick and bulk samples were grown. With the aim to characterize the samples and study their microstructure and morphology, X-ray diffraction, transmission electron microscopy, electron diffraction, energy dispersive X-ray spectroscopy and quasi-adiabatic nanocalorimetry techniques are utilised. The final results show a size dependent effect of the antiferromagnetic transition. Its Néel temperature becomes depressed as the size of the grains forming the layer decreases.

Telemedicine influence on the follow-up of type 2 diabetes patients.

OBJECTIVE This study was designed to evaluate the impact of a teleassistance system on the metabolic control of type 2 diabetes patients. RESEARCH DESIGN AND METHODS We conducted a 1-year controlled parallel-group trial comparing patients randomized (1) to an intervention group, assigned to a teleassistance system using real-time transmission of blood glucose results, with immediate reply when necessary, and telephone consultations, or (2) to a control group, being regularly followed-up at their healthcare center. Study subjects were type 2 diabetes patients >30 years of age followed in the primary care setting. RESULTS A total of 328 type 2 diabetes patients were recruited from 35 family practices in the province of Málaga, Spain. There was a reduction in hemoglobin A1c after 12 months from 7.62 +/- 1.60% to 7.40 +/- 1.43% (P = 0.027) in the intervention group and from 7.44 +/- 1.31% to 7.35 +/- 1.38% (P = 0.303) in the control group. The difference in the change between groups was not statistically significant. There was also a significant decrease in systolic and diastolic blood pressure, total cholesterol, low-density lipoprotein cholesterol, and body mass index in the intervention group. In the control group, the only significant decline was in low-density lipoprotein cholesterol. CONCLUSIONS A teleassistance system using real-time transmission of blood glucose results with an option to make telephone consultations is feasible in the primary care setting as a support tool for family physicians in their follow-up of type 2 diabetes patients.

Substrate specificity of human kallikrein 2 (hK2) as determined by phage display technology.

Human glandular kallikrein 2 (hK2) is a trypsin-like serine protease expressed predominantly in the prostate epithelium. Recently, hK2 has proven to be a useful marker that can be used in combination with prostate specific antigen for screening and diagnosis of prostate cancer. The cleavage by hK2 of certain substrates in the proteolytic cascade suggest that the kallikrein may be involved in prostate cancer development; however, there has been very little other progress toward its biochemical characterization or elucidation of its true physiological role. In the present work, we adapt phage substrate technology to study the substrate specificity of hK2. A phage-displayed random pentapeptide library with exhaustive diversity was generated and then screened with purified hK2. Phages displaying peptides susceptible to hK2 cleavage were amplified in eight rounds of selection and genes encoding substrates were transferred from the phage to a fluorescent system using cyan fluorescent protein (derived from green fluorescent protein) that enables rapid determination of specificity constants. This study shows that hK2 has a strict preference for Arg in the P1 position, which is further enhanced by a Ser in P'1 position. The scissile bonds identified by phage display substrate selection correspond to those of the natural biological substrates of hK2, which include protein C inhibitor, semenogelins, and fibronectin. Moreover, three new putative hK2 protein substrates, shown elsewhere to be involved in the biology of the cancer, have been identified thus reinforcing the importance of hK2 in prostate cancer development.

Transformació de dades pel comerç electrònic de Tous

Aquest projecte es tracta de la creació d'una aplicació que ens ajudarà a establir comunicació entre la web de comerç on-line de l'empresa “Joieria Tous”, que estarà administrat per “GSI Commerce” i el sistema informàtic de la nostra central logística. Observarem que el sistema actual és totalment propietari i fet a mida, llavors per poder tenir una comunicació amb les noves botigues on-line s'ha de crear una plataforma que transformi les dades d'entrada al sistema informàtic de la nostra empresa i les dades de sortida al sistema informàtic de la empresa externa que gestionarà el comerç on-line: “GSI Commerce”.