Plataforma de Dados de Saúde - Portal Institucional

O presente documento de dissertação retrata o desenvolvimento do projeto PDS-Portal Institucional cujo cerne é um sistema para recolha, armazenamento e análise de dados (plataforma de Business Intelligence). Este portal está enquadrado na área da saúde e é uma peça fundamental no sistema da Plataforma de dados da Saúde, que é constituído por quatro portais distintos. Esta plataforma tem como base um sistema totalmente centrado no utente, que agrega dados de saúde dos utentes e distribui pelos diversos intervenientes: utente, profissionais de saúde nacionais e internacionais e organizações de saúde. O objetivo principal deste projeto é o desenvolvimento do PDS-Portal Institucional, recorrendo a uma plataforma de Business Intelligence, com o intuito de potenciar os utilizadores de uma ferramenta analítica para análise de dados. Estando a informação armazenada em dois dos portais da Plataforma de dados da Saúde (PDS-Portal Utente e PDS-Portal Profissional), é necessário modular um armazém de dados que agregue a informação de ambos e, através do PDS-PI, distribua um conjunto de análises ao utilizador final. Para tal este sistema comtempla um mecanismo totalmente automatizado para extração, tratamento e carregamento de dados para o armazém central, assim como uma plataforma de BI que disponibiliza os dados armazenados sobre a forma de análises específicas. Esta plataforma permite uma evolução constante e é extremamente flexível, pois fornece um mecanismo de gestão de utilizadores e perfis, assim como capacita o utilizador de um ambiente Web para análise de dados, permitindo a partilha e acesso a partir de dispositivos móveis. Após a implementação deste sistema foi possível explorar os dados e tirar diversas conclusões que são de extrema importância tanto para a evolução da PDS como para os métodos de praticar os cuidados de saúde em Portugal. Por fim são identificados alguns pontos de melhoria do sistema atual e delineada uma perspetiva de evolução futura. É certo que a partir do momento que este projeto seja lançado para produção, novas oportunidades surgirão e o contributo dos utilizadores será útil para evoluir o sistema progressivamente.

Sistema para a monitorização ativa com recurso ao cloud computing

O desenvolvimento de aplicações para dispositivos móveis já não é uma área recente, contudo continua a crescer a um ritmo veloz. É notório o avanço tecnológico dos últimos anos e a crescente popularidade destes dispositivos. Este avanço deve-se não só à grande evolução no que diz respeito às características destes dispositivos, mas também à possibilidade de criar aplicações inovadoras, práticas e passíveis de solucionar os problemas dos utilizadores em geral. Nesse sentido, as necessidades do quotidiano obrigam à implementação de soluções que satisfaçam os utilizadores, e nos dias de hoje, essa satisfação muitas vezes passa pelos dispositivos móveis, que já tem um papel fundamental na vida das pessoas. Atendendo ao aumento do número de raptos de crianças e à insegurança que se verifica nos dias de hoje, as quais dificultam a tarefa de todos os pais/cuidadores que procuraram manter as suas crianças a salvo, é relevante criar uma nova ferramenta capaz de os auxiliar nesta árdua tarefa. A partir desta realidade, e com vista a cumprir os aspetos acima mencionados, surge assim esta dissertação de mestrado. Esta aborda o estudo e implementação efetuados no sentido de desenvolver um sistema de monitorização de crianças. Assim, o objetivo deste projeto passa por desenvolver uma aplicação nativa para Android e um back-end, utilizando um servidor de base de dados NoSQL para o armazenamento da informação, aplicando os conceitos estudados e as tecnologias existentes. A solução tem como principais premissas: ser o mais user-friendly possível, a otimização, a escalabilidade para outras situações (outros tipos de monitorizações) e a aplicação das mais recentes tecnologias. Assim sendo, um dos estudos mais aprofundados nesta dissertação de mestrado está relacionado com as bases de dados NoSQL, dada a sua importância no projeto.

Farm 2.0 Using Wordpress to Manage Geocontent and Promote Regional Food Products

Dissertation submitted in partial fulfilment of the requirements for the Degree of Master of Science in Geospatial Technologies.

Estudo de vulnerabilidades em aplicações web e o seu reflexo em domínios Portugueses

Muito se tem falado sobre revolução tecnológica e do aparecimento constante de novas aplicações Web, com novas funcionalidades que visam facilitar o trabalho dos utilizadores. Mas será que estas aplicações garantem que os dados transmitidos são tratados e enviados por canais seguros (protocolos)? Que garantias é que o utilizador tem que mesmo que a aplicação utilize um canal, que prevê a privacidade e integridade de dados, esta não apresente alguma vulnerabilidade pondo em causa a informação sensível do utilizador? Software que não foi devidamente testado, aliado à falta de sensibilização por parte dos responsáveis pelo desenvolvimento de software para questões de segurança, levam ao aumento de vulnerabilidades e assim exponenciam o número de potenciais vítimas. Isto aliado ao efeito de desinibição que o sentimento de invisibilidade pode provocar, conduz ao facilitismo e consequentemente ao aumento do número de vítimas alvos de ataques informáticos. O utilizador, por vezes, não sabe muito bem do que se deve proteger, pois a confiança que depõem no software não pressupõem que os seus dados estejam em risco. Neste contexto foram recolhidos dados históricos relativos a vulnerabilidades nos protocolos SSL/TLS, para perceber o impacto que as mesmas apresentam e avaliar o grau de risco. Para além disso, foram avaliados um número significativo de domínios portugueses para perceber se os mesmos têm uma vulnerabilidade específica do protocolo SSL/TLS.

Dynamic adaptation of interaction models for stateful web services

Dissertação para obtenção do Grau de Mestre em Engenharia Informática

An investigation into system security requirements and implementation in an Application Service Provider (ASP) environment

Although the ASP model has been around for over a decade, it has not achieved the expected high level of market uptake. This research project examines the past and present state of ASP adoption and identifies security as a primary factor influencing the uptake of the model. The early chapters of this document examine the ASP model and ASP security in particular. Specifically, the literature and technology review chapter analyses ASP literature, security technologies and best practices with respect to system security in general. Based on this investigation, a prototype to illustrate the range and types of technologies that encompass a security framework was developed and is described in detail. The latter chapters of this document evaluate the practical implementation of system security in an ASP environment. Finally, this document outlines the research outputs, including the conclusions drawn and recommendations with respect to system security in an ASP environment. The primary research output is the recommendation that by following best practices with respect to security, an ASP application can provide the same level of security one would expect from any other n-tier client-server application. In addition, a security evaluation matrix, which could be used to evaluate not only the security of ASP applications but the security of any n-tier application, was developed by the author. This thesis shows that perceptions with regard to fears of inadequate security of ASP solutions and solution data are misguided. Finally, based on the research conducted, the author recommends that ASP solutions should be developed and deployed on tried, tested and trusted infrastructure. Existing Application Programming Interfaces (APIs) should be used where possible and security best practices should be adhered to where feasible.

Gestión de centros deportivos: Virtual Trainer Web Ed.

Virtual Trainer Web Edition proporciona un sistema de gestión, planificación y control de un centro deportivo, ofreciendo interactividad entre técnicos, socios y personal de gerencia y facilitando todo el trabajo de un mantenimiento de información tradicional. A través de cualquier PC con conexión a Internet y sin instalación de software adicional, se accede a una completa aplicación con contenidos multimedia.

Photodynamic therapy : a pathway for enhanced delivery of liposomal doxorubicin to tumors

Abstract Part I : Background : Isolated lung perfusion (ILP) was designed for the treatment of loco-regional malignancies of the lung. In contrast to intravenous (IV) drug application, ILP allows for a selective administration of cytostatic agents such as doxorubicin to the lung while sparing non-affected tissues. However, the clinical results with ILP were disappointing. Doxorubicinbased ILP on sarcoma rodent lungs suggested high overall doxorubicin concentrations within the perfused lung but a poor penetration of the cytostatic agent into tumors. The same holds true for liposomal-encapsulated macromolecular doxorubicin (LiporubicinTM) In specific conditions, low-dose photodynamic therapy (PDT) can enhance the distribution of macromolecules across the endothelial bamer in solid tumors. It was recently postulated that tumor neovessels were more responsive to PDT than the normal vasculature. We therefore hypothesized that Visudyne®-mediated PDT could selectively increase liposomal doxorubicin (LiporubicinTM) uptake in sarcoma tumors to rodent lungs during intravenous (IV) drug administration and isolated lung perfusion (ILP). Material and Methods : A sarcoma tumor was generated in the left lung of Fisher rats by subpleural injection of a sarcoma cell ,suspension via thoracotomy. Ten days later, LiporubicinTM is administered IV or by single pass antegrade ILP, with or without Visudyne® -mediated low-dose PDT pre-treatment of the sarcoma bearing lung. The drug concentration and distribution were assessed separately in tumors and lung tissues by high pressure liquid chromatography (HPLC) and fluorescence microscopy (FNI~, respectively. Results : PDT pretreatment before IV LiporubicinTM administration resulted in a significantly higher tumor drug uptake and tumor to lung drug ratio compared to IV drug injection alone without affecting the blood flow and drug distribution in the lung. PDT pre-treatment before LiporubicinTM-based ILP also resulted in a higher tumor drug uptake and a higher tumor to lung drug ratio compared to ILP alone, however, these differences were not significant due to a heterogeneous blood flow drug distribution during ILP which was further accentuated by PDT. Conclusions : Low-dose Visudyne®-mediated PDT pre-treatment has the potential to selectively enhance liposomal encapsulated doxorubicin uptake in tumors but not in normal lung tissue after IV drug application in a rat model of sarcoma tumors to the lung which opens new perspectives for the treatment of superficially spreading chemoresistant tumors of the chest cavity such as mesothelioma or malignant effusion. However, the impact of PDT on macromolecular drug uptake during ILP is limited since its therapeutic advantage is circumvented by ILP-induced heterogeneicity of blood flow and drug distribution Abstract Part II Background : Photodynamic therapy (PDT) with Visudyne® acts by direct cellular phototoxicity and/or by an indirect vascular-mediated effect. Here, we demonstrate that the vessel integrity interruption by PDT can promote the extravasation of a macromolecular agent in normal tissue. To obtain extravasation in normal tissue PDT conditions were one order of magnitude more intensive than the ones in tissue containing neovessels reported in the literature. Material and Methods : Fluorescein isothiocyanate dextran (FITC-D, 2000kDa), a macromolecular agent, was intravenously injected 10 minutes before (LKO group, n=14) or 2 hours (LK2 group, n=16) after Visudyne® mediated PDT in nude mice bearing a dorsal skin fold chamber. Control animals had no PDT (CTRL group, n=8). The extravasation of FITC-D from blood vessels in striated muscle tissue was observed in both groups in real-time for up to 2500 seconds after injection. We also monitored PDT-induced leukocyte rolling in-vivo and assessed, by histology, the corresponding inflammatory reaction score in the dorsal skin fold chambers. Results : In all animals, at the applied PDT conditions, FITC-D extravasation was significantly enhanced in the PDT treated areas as compared to the surrounding non-treated areas (p<0.0001). There was no FITC-D leakage in the control animals. Animals from the LKO group had significantly less FITC-D extravasation than those from the LK2 group (p = 0.0002). In the LKO group FITC-D leakage correlated significantly with the inflammation (p < 0.001). Conclusions: At the selected conditions, Visudyne-mediated PDT promotes vascular leakage and FITC-D extravasation into the interstitial space of normal tissue. The intensity of vascular leakage depends on the time interval between PDT and FITC-D injection. This concept could be used to locally modulate the delivery of macromolecules in vivo. Résumé : La perfusion cytostatique isolée du poumon permet une administration sélective des agents cytostatiques sans implication de la circulation systémique avec une forte accumulation au niveau du poumon mais une faible pénétration dans les tumeurs. La thérapie photodynamique (PDT) qui consiste en l'application d'un sensibilisateur activé par lumière laser non- thermique d'une longueur d'onde définie permet dans certaines conditions, une augmentation de la pénétration des agents cytostatiques macromoléculaires à travers la barrière endothéliale tumorale. Nous avons exploré cet avantage thérapeutique de la PDT dans un modèle expérimental afin d'augmenter d'une manière sélective la pénétration tumorale de la doxorubicin pegylée, liposomal- encapsulée macromoléculaire (Liporubicin). Une tumeur sarcomateuse a été générée au niveau du poumon de rongeur suivie d'administration de Liporubicin, soit par voie intraveineuse soit par perfusion isolée du poumon (ILP). Une partie des animaux ont reçus un prétraitement de la tumeur et du poumon sous jacent par PDT avec Visudyne comme photosensibilisateur. Les résultats ont démontrés que la PDT permet, sous certaines conditions, une augmentation sélective de Liporubicin dans les tumeurs mais pas dans le parenchyme pulmonaire sous jacent. Après administration intraveineuse de Liporubicin et prétraitement par PDT, l'accumulation dans les tumeurs était significative par rapport au poumon, et aux tumeurs sans PDT. Le même phénomène est observé après ILP du poumon. Cependant, les différences avec ou sans PDT n'étaient pas significatives lié à und distribution hétérogène de Liporubicin dans le poumon perfusé après ILP. Dans une deuxième partie de l'expérimentation, nous avons exploré la microscopie intra-vitale pour déterminer l'extravasion des substances macromoléculaires (FITS) à travers la barrière endothéliale avec ou sans Visudyne-PDT au niveau des chambres dorsales des souris nues. Les résultats montrent qu'après PDT, l'extravasion de FITS a été augmentée de manière significative par rapport au tissu non traité. L'intensité de l'extravasion de FITS dépendait également de l'intervalle entre PDT et injection de FITS. En conclusion, les expérimentations montrent que la PDT est capable, sous certaines conditions, d'augmenter de manière significative l'extravasion des macromolécules à travers la barrière endothéliale et leur accumulation dans des tumeurs mais pas dans le parenchyme pulmonaire. Ces résultats permettent une nouvelle perspective de traitement pour des tumeurs superficielles intrathoraciques chimio-résistent comme l'épanchement pleural malin ou le mésothéliome pleural.

Desenvolupament d'un servidor d'informació geogràfica

L'explosió d'aplicacions a Internet basades en oferir serveis de localització, com són portals web de mobilitat o aplicacions de seguiment de vehicles en línia han motivat aquest projecte. Google Maps ens permet afegir mapes fàcilment en un lloc web amb la seva API, però OpenLayers, una llibreria JavaScript lliure ens dóna l'opció de carregar cobertures de mapa i marcadors des de qualsevol font. OpenStreetMap proporciona dades geogràfiques de manera lliure, com per exemple mapes de carrers i carreteres. Un estudi acurat de l'estructura i agrupació de les dades en el format OSM i el desenvolupament d'un servidor basat en el model de tessel·les, són els principals elements de partida per crear la nostra pròpia font de dades cartogràfiques. En aquest projecte s'analitza i processa DXF Drawing eXchange Format passant al format OSM. Un fitxer OSM conté la informació geogràfica necessària per a la base de dades espaial a partir de la qual, entre d'altres aplicacions, es podran visualitzar els mapes propis en una aplicació de seguiment de vehicles o en un portal web.

Estudio sobre la información de texto contenida en imágenes web

La indexació i la recerca de pàgines web es basa en l’anàlisi de text. La tecnologia actual encara no pot processar d’una manera eficient i suficientment ràpida el text contingut a les imatges de les pàgines web. Aquest fet planteja un problema important d’indexació però també d’inaccessibilitat. Per poder quantificar aquest problema hem desenvolupat una aplicació software que ens permet realitzar un estudi sobre aquesta situació. Hem utilitzat aquest software per analitzar un conjunt de pàgines web representatives de la situació actual a Internet. Aquests resultats obtinguts s’han analitzat i comparat amb estudis anteriors.

Protocol de comerç electrònic basat en serveis web

Protocol per autenticar a persones que sol·liciten un servei o producte en un web mitjançant un proveïdor d'identitats amb el DNI-E. El proveïdor d'identitats garanteix als proveïdors de serveis que les persones amb qui tracten són qui diuen ser i proporciona a més una reputació associada a cada persona. Aquesta comunicació es fa amb un servei web que prèvia autenticació del proveïdor de servei podrà realitzar les diferents peticions d'autenticitat i de reputació dels seus clients. Donat que es tracten amb dades personals, durant el protocol es protegeix en tot moment l'autèntica identitat de cada persona per tal de que pugui mantenir el seu anonimat.

Desarrollo de una aplicación web para representación de datos de posicionamiento

En aquesta memòria s’explica el desenvolupament d’una eina útil que permet a l’usuari visualitzar en l’aplicació Google Maps les dades de posicionament captats en una sessió GPS. En aquest projecte, hem dissenyat una aplicació Web en la qual recollim les dades ingressades per l’usuari mitjançant un formulari. Un cop emmagatzemades aquestes dades en el servidor, la nostra eina hi executa l’aplicació encarregada del càlcul de les posicions. Aquesta és un script desenvolupat en MATLAB, que s’encarrega d’interpretar les dades subministrades per l’usuari, amb les quals es poden calcular les coordenades captades pel receptor GPS. Una vegada calculades, el software les emmagatzema en el servidor, en un arxiu .xml, que serà el que posteriorment interpretarà Google Maps gràcies al seu API. D’aquesta manera, l’usuari obtindrà el resultat visual de la sessió GPS que hagi decidit carregar sense necessitat des disposar de cap software específic per a la interpretació i el càlcul de les dades que hi ha capturat.

Surgery for aortic coarctation: a 30 years experience.

OBJECTIVE: A retrospective study to review the experience of a single center with surgery for aortic coarctation over a period of 30 years (1970-1999). METHODS: Criteria for inclusion: (a) aortic coarctation, isolated or associated with congenital heart defect; (b) surgery between 1970 and 1999. Data recorded: (1) date of surgery; (2) age at surgery; (3) associated lesions; (4) surgical technique; (5) simultaneous surgical procedures; (6) early and late surgical results in term of: (a) deaths; (b) need for reoperation because of re-coarctation or other cardiac lesion; (c) residual/recurrent pressure gradient, evaluated at cuff/Doppler at rest; (d) systemic hypertension, requiring medical treatment. RESULTS: One hundred and forty-one patients underwent surgery for aortic coarctation: 30 neonates, 29 infants, 45 children and 37 adults. Associated lesions were found in 8/37 (=21.6%) adults and in 73/104 (=70.1%) pediatric patients. There were no hospital deaths. During the follow-up there were one late death in the adults group (1/37=2.7%) and three late deaths in the pediatric group (3/104=2.9%), all unrelated with aortic coarctation. Re-operation because of re-coarctation occurred only in ten late survivors of the pediatric group (10/101=9.9%), 9/10 operated on before 1980 (P<0.00001). End-to-end anastomosis, enlarged to the aortic arch in neonates, was associated with the lowest incidence of re-coarctation (P<0.005). A significant (>20 mmHg at rest) pressure gradient was found in none of the adults, and in seven of the 91 pediatric patients (7/91=7.7%) late survivors. Three adults (3/36=8.3%) late survivors are on medical treatment to control systemic hypertension. CONCLUSIONS: The long-term results of our retrospective study confirm that surgery has to be considered the gold standard for the treatment of aortic coarctation. The interventional angioplasty techniques have to provide long-term outcome at least similar to the results obtained with surgery.

PHA supports World No Tobacco Day

The Public Health Agency is taking the opportunity to highlight this year's World No Tobacco Day which takes place on Tuesday 31 May.In Northern Ireland, around 340,000 people aged 16 and over smoke. Smoking contributes not only to many cancers, heart disease, bronchitis and asthma, but to other illnesses, including stroke. In fact, smoking causes around 2,700 deaths per year here, all of them avoidable.The PHA is committed to saving lives by reducing the percentage of people who smoke. The PHA:works with councils to ensure smoking-related laws are enforced; funds a range of support to smokers who want to quit; educates young people to not start smoking, through programmes like 'Teenage Kicks' and 'Smokebusters'. In January this year, the PHA also launched its smoking campaign 'Things to do before you die' to encourage smokers, particularly those aged 20-49, to stop smoking.Health Minister Edwin Poots said:"Smoking is the greatest cause of preventable illness and premature death in Northern Ireland. While good progress has been made in the last number of years to reduce the number of people who smoke, more needs to be done."I would appeal to all smokers to use the wide range of support services available to make every effort to stop smoking - it is the single best step you can take to improve your health and quality of life."Mark Mc Bride, Health Improvement Manager, PHA, said "Smoking is the single greatest preventable cause of death in the world today. Across Northern Ireland there are over 600 support services for people who wish to stop smoking. These are based in GP surgeries, community pharmacies, hospitals, community centres and workplaces."From April 2010 to end March 2011 more than 1 in 10 of all adult smokers sought help from the support services and approximately half had quit after four weeks. This is a substantial - roughly 50% increase - on previous years and shows the benefit of the PHA campaigns and the dedication of the many specialists who help smokers quit."I would encourage everyone who is either thinking about quitting or ready to log on to our Want 2 Stop website www.want2stop.info or to contacting the Smokers' Helpline on 0808 812 8008 a Quit Kit free of charge."

Risky single occasion drinking frequency and alcohol-related consequences: can abstinence during early adulthood lead to alcohol problems?

QUESTIONS UNDER STUDY: the main purpose of this longitudinal study was to determine the impact of risky single occasion drinking (RSOD) frequency on alcohol dependence and drinking consequences reported 15 months later. METHODS: As a baseline sample, 5,990 young men were assessed on their drinking habits including the frequency of RSOD. Of them, 5,196 were reassessed at follow-up 15 months later on RSOD frequency, alcohol dependence and alcohol related consequences in thze interceding year. Drop out biases were investigated. RESULTS: Around 45% of the baseline participants reported regular RSOD (every month or more frequently). Despite the fact that RSOD distribution was generally stable during the initial sample, 47.4% reported a variation of their RSOD frequency 15 months later. Around 25% of the sample reported reduced RSOD frequency. Nonetheless, occasional RS drinkers were more likely to become regular (monthly) RSO drinkers at follow up. Daily and weekly RSOD were associated with high proportions of alcohol dependence and detrimental consequences of drinking. Surprisingly, abstainers at baseline were more likely to be at risk of alcohol dependence and consequences at follow up than non-RSO drinkers. CONCLUSIONS: Despite the fact that alcohol abstinence is logically the best way to avoid the detrimental consequences of alcohol drinking, abstainers at baseline reported as many problems due to alcohol use at follow up as occasional or monthly RSO drinkers. The few participants who had become RSO drinkers during the follow up period were indeed likely to engage in detrimental behaviour. Non-RSO drinkers had the fewest problems due to alcohol use. This substantiates the early occurrence of drinking consequences among inexperienced RSO drinkers.