MODELING OF AN INFORMATION SYSTEM FOR WINE TRACEABILITY BASED ON A SERVICE ORIENTED ARCHITECTURE

The purpose is to present a scientific research that led to the modeling of an information system which aimed at the maintenance of traceability data in the Brazilian wine industry, according to the principles of a service-oriented architecture (SOA). Since 2005, traceability data maintenance is an obligation for all producers that intend to export to any European Union country. Also, final customers, including the Brazilian ones, have been asking for information about food products. A solution that collectively contemplated the industry was sought in order to permit that producer consortiums of associations could share the costs and benefits of such a solution. Following an extensive bibliographic review, a series of interviews conducted with Brazilian researchers and wine producers in Bento Goncalves - RS, Brazil, elucidated many aspects associated with the wine production process. Information technology issues related to the theme were also researched. The software was modeled with the Unified Modeling Language (UML) and uses web services for data exchange. A model for the wine production process was also proposed. A functional prototype showed that the adopted model is able to fulfill the demands of wine producers. The good results obtained lead us to consider the use of this model in other domains.

Thermodynamic information system for diagnosis and prognosis of power plant operation condition

A thermodynamic information system for diagnosis and prognosis of an existing power plant was developed. The system is based on an analytic approach that informs the current thermodynamic condition of all cycle components, as well as the improvement that can be obtained in the cycle performance by the elimination of the discovered anomalies. The effects induced by components anomalies and repairs in other components efficiency, which have proven to be one of the main drawbacks in the diagnosis and prognosis analyses, are taken into consideration owing to the use of performance curves and corrected performance curves together with the thermodynamic data collected from the distributed control system. The approach used to develop the system is explained, the system implementation in a real gas turbine cogeneration combined cycle is described and the results are discussed. (C) 2011 Elsevier Ltd. All rights reserved.

A spatial approach for the epidemiology of antibiotic use and resistance in community-based studies: the emergence of urban clusters of Escherichia coli quinolone resistance in Sao Paulo, Brasil

Background: Population antimicrobial use may influence resistance emergence. Resistance is an ecological phenomenon due to potential transmissibility. We investigated spatial and temporal patterns of ciprofloxacin (CIP) population consumption related to E. coli resistance emergence and dissemination in a major Brazilian city. A total of 4,372 urinary tract infection E. coli cases, with 723 CIP resistant, were identified in 2002 from two outpatient centres. Cases were address geocoded in a digital map. Raw CIP consumption data was transformed into usage density in DDDs by CIP selling points influence zones determination. A stochastic model coupled with a Geographical Information System was applied for relating resistance and usage density and for detecting city areas of high/low resistance risk. Results: E. coli CIP resistant cluster emergence was detected and significantly related to usage density at a level of 5 to 9 CIP DDDs. There were clustered hot-spots and a significant global spatial variation in the residual resistance risk after allowing for usage density. Conclusions: There were clustered hot-spots and a significant global spatial variation in the residual resistance risk after allowing for usage density. The usage density of 5-9 CIP DDDs per 1,000 inhabitants within the same influence zone was the resistance triggering level. This level led to E. coli resistance clustering, proving that individual resistance emergence and dissemination was affected by antimicrobial population consumption.

AMBIVALENT IMPLICATIONS OF HEALTH CARE INFORMATION SYSTEMS: A STUDY IN THE BRAZILIAN PUBLIC HEALTH CARE SYSTEM

This article evaluates social implications of the ""SIGA"" Health Care Information System (HIS) in a public health care organization in the city of Sao Paulo. The evaluation was performed by means of an in-depth case study with patients and staff of a public health care organization, using qualitative and quantitative data. On the one hand, the system had consequences perceived as positive such as improved convenience and democratization of specialized treatment for patients and improvements in work organization. On the other hand, negative outcomes were reported, like difficulties faced by employees due to little familiarity with IT and an increase in the time needed to schedule appointments. Results show the ambiguity of the implications of HIS in developing countries, emphasizing the need for a more nuanced view of the evaluation of failures and successes and the importance of social contextual factors.

ScriptLattes: an open-source knowledge extraction system from the Lattes platform

The Lattes platform is the major scientific information system maintained by the National Council for Scientific and Technological Development (CNPq). This platform allows to manage the curricular information of researchers and institutions working in Brazil based on the so called Lattes Curriculum. However, the public information is individually available for each researcher, not providing the automatic creation of reports of several scientific productions for research groups. It is thus difficult to extract and to summarize useful knowledge for medium to large size groups of researchers. This paper describes the design, implementation and experiences with scriptLattes: an open-source system to create academic reports of groups based on curricula of the Lattes Database. The scriptLattes system is composed by the following modules: (a) data selection, (b) data preprocessing, (c) redundancy treatment, (d) collaboration graph generation among group members, (e) research map generation based on geographical information, and (f) automatic report creation of bibliographical, technical and artistic production, and academic supervisions. The system has been extensively tested for a large variety of research groups of Brazilian institutions, and the generated reports have shown an alternative to easily extract knowledge from data in the context of Lattes platform. The source code, usage instructions and examples are available at http://scriptlattes.sourceforge.net/.

Vinculação determinística de Bancos de Dados sobre mortalidade por Aids

A vinculação determinística de bancos de dados sobre mortalidade por aids tem apresentado problemas causados por falhas nos arquivos. Assim, os objetivos deste estudo foram: avaliar o desempenho da vinculação determinística em bancos de óbito por aids do Programa de Aprimoramento das Informações de Mortalidade no Município de São Paulo (PRO-AIM) e da Fundação SEADE entre os anos de 2000 e 2004 e estimar a cobertura de cada banco. Utilizou-se a rotina merge de um software para vincular os bancos. A primeira etapa pareou os registros automaticamente e, na segunda etapa, cada banco foi conferido para localizar novos pares. Estimaram-se os óbitos pela soma entre casos pareados e não pareados para calcular a cobertura dos bancos. A primeira etapa da vinculação identificou 91,6% dos pares. A segunda etapa adicionou 457 pares. O total de óbitos foi estimado em 5.855, com cobertura de 97,1% do PRO-AIM e 96% do SEADE. O uso da vinculação determinística cobriu grande parte dos casos. O banco do PRO-AIM proporcionou a maior cobertura, com maior quantidade de informações completas e melhor localização geográfica dos casos.

Caracterização das vítimas de ferimentos por arma de fogo, atendidas pelo Serviço de Atendimento Móvel de Urgência em Campo Grande-MS

A violência, em todas as suas apresentações, tem crescido de forma avassaladora no país, elevando os indicadores de morbidade e mortalidade por causas externas. O uso das armas de fogo, muitas vezes, faz vítimas fatais ou que podem permanecer sequeladas. Tal fato tem aumentado o ônus do estado com internações hospitalares e acréscimo dos anos de vida perdidos da população jovem, que constitui a grande maioria dessas vítimas. Nesse sentido, o presente estudo objetivou fazer um levantamento das vítimas de ferimentos por arma de fogo, atendidas pelo Serviço de Atendimento Móvel de Urgência no município de Campo Grande-MS, no período de abril de 2005 a abril de 2007, nos dois primeiros anos de funcionamento, desde a implantação desse serviço na capital do Estado de Mato Grosso do Sul. Realizou-se estudo descritivo, baseado em análise documental do sistema de informação do SAMU do município de Campo Grande-MS. Foram descritos 233 atendimentos. Os resultados evidenciaram 213 vítimas do sexo masculino, a faixa etária mais acometida foi dos 20 aos 24 anos de idade, a cabeça e o pescoço foram as partes do corpo mais atingidas e a região Sul do município de Campo Grande foi a que concentrou maior número de atendimentos. Conclui-se que a violência por arma de fogo em Campo Grande-MS atinge a camada economicamente ativa da população e provém de regiões de bolsões de pobreza e desigualdade social, justificando a implantação de um serviço como o SAMU.

Conhecimento e uso do Sistema de Informações sobre Orçamentos Públicos em Saúde (SIOPS) pelos gestores municipais, Pernambuco, Brasil

Considerando a importância do Sistema de Informações sobre Orçamentos Públicos em Saúde (SIOPS) como ferramenta para o planejamento, gestão e controle social dos gastos públicos em saúde, este trabalho teve como objetivo avaliar a relação entre a regularidade na alimentação do SIOPS e o conhecimento e uso do Sistema pelos gestores municipais do Estado de Pernambuco, Brasil. Foram selecionados dez municípios distribuídos nas cinco mesorregiões do estado, sendo cinco regulares e cinco irregulares na alimentação do Sistema, e aplicada uma entrevista semi-estruturada entre os secretários de saúde dos respectivos municípios. Com base na análise dos dados, foi identificado que o domínio de informática e o conhecimento do Sistema não interferem na regularidade da alimentação, em função do distanciamento entre os gestores das Secretarias de Saúde e o SIOPS, em geral alimentado por serviços terceirizados. Constata-se que as informações geradas não têm sido exploradas potencialmente pelos gestores enquanto instrumento de gestão.

Acidentes de transporte em Cuiabá, Mato Grosso: morbi-mortalidade

Os acidentes de trânsito continuam a se constituir em um importante problema de saúde pública no Brasil. Objetivo : Analisar as características dos acidentes de transporte terrestre e suas vítimas no município de Cuiabá. Método: Para o estudo da mortalidade foram obtidos dados do Sistema de Informações sobre Mortalidade /Ministério da Saúde, disponíveis em CD-ROM referente aos anos de 1980-2005; para o de morbidade hospitalar foram utilizados os dados Sistemas de Informações Hospitalares no período de 1998-2006 e para o estudo da demanda das unidades de urgência e emergência foi utilizado um banco de dados construído especialmente para esse fim, referente aos meses de maio a junho de 2005. Adotaram-se os conceitos definições estabelecidos na Classificação Internacional de Doenças 10: acidentes de transporte (categ. V01-V99) e acidente de transporte terrestre (V01-V89). Resultados: Em todas as análises, as taxas de mortalidade/morbidade hospitalar se expressaram com valores maiores que a média brasileira. Apesar de apresentar aspectos distintos entre mortalidade, morbidade hospitalar e morbidade da demanda de unidades de urgência e emergência, destacam-se como principais vítimas os jovens do sexo masculino; a vítima qualificada como "ocupante" predomina nos acidentes fatais e os "motociclistas", nos não fatais.Conclusão: este estudo revela que Cuiabá é uma área onde os acidentes de transporte terrestre devem ser tratados como prioridade devido à sua magnitude, seja na mortalidade ou morbidade, trazendo subsídios para o seu enfrentamento

Trends in morbid obesity and in bariatric surgeries covered by the Brazilian public health system

Background Obesity is an increasingly serious public health problem on a global level. Morbid obesity, defined as a body mass index greater than 40 kg/m2, is associated with increased mortality and a high burden of obesity-related morbidities. Methods To study the prevalence of morbid obesity in Brazil, three national anthropometric surveys were reanalyzed. Data about bariatric surgeries were obtained from the Ministry of Health Hospital Information System, which is available online. Results A 255% rise in the prevalence of morbid obesity was observed, starting at 0.18% in 1975-1976 and growing to 0.33% in 1989 and 0.64% in 2002-2003. There was a higher rate in the South in the first two surveys, but the prevalence in the Southeast rose steadily, reaching 0.77% in 2002-2003 and overtaking the South. Since 1999, the Brazilian Unified Health System has covered surgical treatment for morbid obesity. From 2000 to 2006, there was a sixfold increase in the number of surgeries, which topped the 2,500 mark in 2006. The geographic distribution of these surgeries is heavily concentrated in the Southeast, the most developed region of Brazil, where there is also the highest prevalence of morbid obesity. This was followed by the Southern region. Conclusions The figures for the rise in morbid obesity in Brazil are startling, especially the increase among men. This is a situation that calls for further study, alongside measures to encourage the adoption of healthy lifestyles. Preventive measures aimed at slowing down or reversing the obesity epidemic are urgently required

Support Tool to the Validation Process of Functional Requirements

The activity of validating identified requirements for an information system helps to improve the quality of a requirements specification document and, consequently, the success of a project. Although various different support tools to requirements engineering exist in the market, there is still a lack of automated support for validation activity. In this context, the purpose of this paper is to make up for that deficiency, with the use of an automated tool, to provide the resources for the execution of an adequate validation activity. The contribution of this study is to enable an agile and effective follow-up of the scope established for the requirements, so as to lead the development to a solution which would satisfy the real necessities of the users, as well as to supply project managers with relevant information about the maturity of the analysts involved in requirements specification.

Hormonal Contraceptives and the Length of Their Use Are Not Independent Risk Factors for High-Risk HPV Infections or High-Grade CIN

Aims: To evaluate the role of hormonal contraceptives as a risk factor of high-risk human papillomavirus (HR-HPV), cervical intraepithelial lesions (CIN) and cervical cancer in our multi-center population-based LAMS (Latin American Screening) study. Methods: A cohort study with >12,000 women from Brazil and Argentina using logistic regression to analyze the covariates of hormonal contraception (HOC - oral, injections, patches, implants, vaginal ring and progesterone intrauterine system) use followed by multivariate modeling for predictors of HR-HPV and CIN2+. Results: HR-HPV infection was a consistent risk factor of high-grade CIN in all three groups of women. The length of HOC use was not significantly related to high-grade squamous intraepithelial lesions (HSIL)+ Pap (p = 0.069), LSIL+ Pap (p = 0.781) or ASCUS+ (p = 0.231). The same was true with the length of HOC use and histology CIN3+ (p = 0.115) and CIN2+ (p = 0.515). Frequently, HOC users have previously shown more HPV-related lesions, as well as lower HPV prevalence if they were current smokers. But HOC use and time of usage were not independent risk factors of either HR-HPV infection or high-grade CIN using multiple logistic regressions. Conclusions: No evidence was found for an association between the use of HOC with an increased risk for HR-HPV infection or high-grade CIN in this cohort. Copyright (C) 2010 S. Karger AG, Basel

Trends in Morbid Obesity and in Bariatric Surgeries Covered by the Brazilian Public Health System

Obesity is an increasingly serious public health problem on a global level. Morbid obesity, defined as a body mass index greater than 40 kg/m(2), is associated with increased mortality and a high burden of obesity-related morbidities. To study the prevalence of morbid obesity in Brazil, three national anthropometric surveys were reanalyzed. Data about bariatric surgeries were obtained from the Ministry of Health Hospital Information System, which is available online. A 255% rise in the prevalence of morbid obesity was observed, starting at 0.18% in 1975-1976 and growing to 0.33% in 1989 and 0.64% in 2002-2003. There was a higher rate in the South in the first two surveys, but the prevalence in the Southeast rose steadily, reaching 0.77% in 2002-2003 and overtaking the South. Since 1999, the Brazilian Unified Health System has covered surgical treatment for morbid obesity. From 2000 to 2006, there was a sixfold increase in the number of surgeries, which topped the 2,500 mark in 2006. The geographic distribution of these surgeries is heavily concentrated in the Southeast, the most developed region of Brazil, where there is also the highest prevalence of morbid obesity. This was followed by the Southern region. The figures for the rise in morbid obesity in Brazil are startling, especially the increase among men. This is a situation that calls for further study, alongside measures to encourage the adoption of healthy lifestyles. Preventive measures aimed at slowing down or reversing the obesity epidemic are urgently required.

Flood Risk Assessment in Coastal Drainage Basins through a Multivariate Analysis within a GIS-Based Model

This paper presents a GIS-based multicriteria flood risk assessment and mapping approach applied to coastal drainage basins where hydrological data are not available. It involves risk to different types of possible processes: coastal inundation (storm surge), river, estuarine and flash flood, either at urban or natural areas, and fords. Based on the causes of these processes, several environmental indicators were taken to build-up the risk assessment. Geoindicators include geological-geomorphologic proprieties of Quaternary sedimentary units, water table, drainage basin morphometry, coastal dynamics, beach morphodynamics and microclimatic characteristics. Bioindicators involve coastal plain and low slope native vegetation categories and two alteration states. Anthropogenic indicators encompass land use categories properties such as: type, occupation density, urban structure type and occupation consolidation degree. The selected indicators were stored within an expert Geoenvironmental Information System developed for the State of Sao Paulo Coastal Zone (SIIGAL), which attributes were mathematically classified through deterministic approaches, in order to estimate natural susceptibilities (Sn), human-induced susceptibilities (Sa), return period of rain events (Ri), potential damages (Dp) and the risk classification (R), according to the equation R=(Sn.Sa.Ri).Dp. Thematic maps were automatically processed within the SIIGAL, in which automata cells (""geoenvironmental management units"") aggregating geological-geomorphologic and land use/native vegetation categories were the units of classification. The method has been applied to the Northern Littoral of the State of Sao Paulo (Brazil) in 32 small drainage basins, demonstrating to be very useful for coastal zone public politics, civil defense programs and flood management.

Risco relativo para Aids de homens homo/bissexuais em relação aos heterossexuais

OBJETIVO: Analisar o risco relativo para Aids na população de homens que fazem sexo com homens em relação à população heterossexual masculina. MÉTODOS: Foram utilizadas estimativas sobre a proporção de homens que fazem sexo com homens no Brasil e dados de Aids do Sistema Nacionald e Agravos de Notificação. Foram calculadas estimativas para o risco relativo (RR) para Aids desta população em relação à população heterossexual masculina do Brasil; cidade e estado de São Paulo; e cidade e estado do Rio de Janeiro, para o período de 1996 a 2003. As trajetórias do RR neste período também foram analisadas. RESULTADOS: As estimativas do RR declinaram, mostrando tendência de estabilização: de 34,3 para 19,3 no País como um todo e entre 32,1 e 6,3 nos locais analisados. Para o País em 2003, o RR dos bissexuais masculinos em relação à população heterossexual masculina era 16. O RR para homossexuais exclusivos teve trajetória decrescente em todos os locais analisados, mas não para os bissexuais. CONCLUSÕES: O risco relativo para homens que fazem sexo com homens foi mais elevado em relação aos heterossexuais, em todos os locais. Esse resultado indica alta e persistente vulnerabilidade dessa população.