SLA-Based Guidelines for Database Transitioning

Component-based Software Engineering (CBSE) and Service-Oriented Architecture (SOA) became popular ways to develop software over the last years. During the life-cycle of a software system, several components and services can be developed, evolved and replaced. In production environments, the replacement of core components, such as databases, is often a risky and delicate operation, where several factors and stakeholders should be considered. Service Level Agreement (SLA), according to ITILv3’s official glossary, is “an agreement between an IT service provider and a customer. The agreement consists on a set of measurable constraints that a service provider must guarantee to its customers.”. In practical terms, SLA is a document that a service provider delivers to its consumers with minimum quality of service (QoS) metrics.This work is intended to assesses and improve the use of SLAs to guide the transitioning process of databases on production environments. In particular, in this work we propose SLA-Based Guidelines/Process to support migrations from a relational database management system (RDBMS) to a NoSQL one. Our study is validated by case studies.

Desempenho dos serviços de atenção primária do município de Natal/RN para o diagnóstico e controle da tuberculose

Tuberculosis (TB) is one of the most important health problems being faced worldwide. In Brazil, the responsibility for the actions of to diagnosis and control of this disease was transferred to the municipalities within the Primary Health Care (PHC), aiming at improvement in epidemiological indicators, requiring reorientation of the practice of family health teams and requiring methodologies to analyze the extent to which components of the PHC are being achieved. Thus, this study aims to analyze the performance of primary care services in the city of Natal-RN for the diagnosis and control of TB, from the perspective of health professionals (doctors and nurses). The study is descriptive, cross-sectional and quantitative. Data collection was conducted from March to July 2011 and involved 121 health professionals working in 52 health units (family health unit, basic health unit and mixed units). The instrument is structured based on the Primary Care Assessment Tool (PCAT), validated and adapted to assess attention to TB in Brazil, and includes questions regarding the Structure and Process components of health services. For quantitative analysis, it was constructed indicators, whose response patterns are followed according to the Likert scale between one and five, which meant the degree of preference relation (or agreement) of the claims. Values between 1 and 3 were considered unsatisfactory for the indicator, between 3 and less than 4, regular, and between 4 and 5, satisfactory. With regard to inputs and equipment, the units had satisfactory condition for form (  = 4.26), consultation (  = 4.02) and basic basket (  = 4.24); regular condition to pot (  = 3.56) and unsatisfactory conditions for transportation tickets (  = 1.50) and sputum smear microscopy (  = 2.42) and X-rays (  = 1.07). In relation to actions, there was satisfactory development for those focused on the individual patient. Actions aimed at the collective level, as the search for respiratory symptoms (RS), monitoring of contacts and guidelines for the community ranged from regular to unsatisfactory (  = 3.16 -  = 1.34). With regard to training, 94,2% received training to identify RS. As regards the time for diagnosis, the median time elapsed between the identification of RS and the beginning of treatment it was 22 days. In relation to the difficulties faced by professionals in the diagnosis of TB, 56,2% reported that they are related only to health services, especially for the failure in the rearguard laboratory and in the specialized services reference, the lack of human and material resources and low performing an active search. The professionals perceive the performance of diagnosis and control of TB, permeated with limitations and barriers to organizational and operational character of various sizes, emerging the need for effective coordination of various sectors and key stakeholders of TB care, to adoption of a new intersectoral strategies that aim to increase the responsiveness of the PHC, providing the best performance in service delivery to the user, family and community, and ensuring effective action and resolving the needs of this population group.

Diagnóstico para implantação do sistema de gestão ambiental em postos revendedores de combustíveis no município de Paranamirim RN: um estudo de caso

natural resources that still enjoy, in the certainty that if we do not, could culminate at the end of that remains. The environmental contamination by fuels in the retail service of oil and biofuels, has been a subject of growing research in Brazil, due to the large pollution potential of this activity. The aim of this study was to evaluate the importance of implementing the Environmental Management System (EMS) in fuel retail service stations in the city of Parnamirim-RN, but also describe the current situation the same as licensing and environmental characterization; identify existing barriers to implementation of EMS on the costs, technologies, knowledge, vision, present the potential benefits for the implementation of the EMS (social, economic and environmental), to identify the existence of plans for future action to implement the EMS , as a subsidy to promote the implementation of it. The methodology was developed through analysis of documents provided by the environmental agency responsible for licensing of retail service stations and fuel pala ANP. For data collection, we used the questionnaire was applied directly to managers or managers of sub-stations. Data were collected in 12 of 30 posts in the municipality. For purposes of data treatment was performed a descriptive analysis with respect to the opinion of twelve managers (respondents). The data acquired, according to the Likert scale were tabulated and analyzed using software SPSS 17.0 and Excel 2003, it was generated tables and graphs to observe the behavior of the data. The results showed that most respondents have a schooling level higher (58.3%) of the jobs surveyed 50% work on average 6 to 10 years and 41.6% are in operation for over 11 years , 75.0% do not have a license to operate and 12 stations, 58.3% were sued for not having a license to operate and are therefore in full commercial activity, 83% of jobs have some practice environmentally responsible, 75% agree in making planning future action to implement 8 the EMS in their ventures, 70% in full agreement that the high cost is a form of impediment to implementation of EMS; 66.67% agreed that resistance to change is an impediment to implementation of EMS; 90.91% agreed that the implementation of EMS is very complex, 80% of respondents agreed in a very significant environmental legislation is also a key factor preventing the implementation of EMS is noteworthy that 100% of respondents agreed that the knowledge about the use of the EMS will help to solve environmental problems in the fuel retail service stations, the implementation of the EMS will benefit with increased efficiency of resources applied to the findings by the agreement of 91.66% of respondents, where only 8, 33% disagreed, there was also a percentage of 100%, agreed that the company's image will be a great benefit, but also a contribution to solving environmental problems in the fuel retail service stations. Thus, the importance of the implementation of EMS in the fuel retail service stations in the city of Parnamirim-RN, with an urgent need to be deployed. And the bodies responsible for policy on state-run and supervise more tightly and action, this type of activity, in order to regulate the sustainable functioning of retail service stations of fuel, thus promoting a better quality of life for the population of the municipality of natal-RN