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.

Estudo epidemiológico das parasitoses oculares na população de escolares da cidade de Natal-RN, Brasil

The objective of this study is to estimate the prevalence of Ocular Toxocariasis, Diffuse Unilateral Subacute Neuroretinitis (DUSN), Toxoplasma gondii infection and Ocular Toxoplasmosis in a student population in Natal-RN/Brazil and relate it to demographic, epidemiologic and socio-economic risk factors. The incidence of DUSN was observed in patients at the Federal University of Rio Grande do Norte Ophthalmology Service and the Prontoclinica de Olhos Ophthalmology clinic in Natal. In cases where a worm was found in the subretinal space, the result of treatment with photocoagulation using Green Laser (Eye Light ALCON) was evaluated in relation to final visual result. The sample was randomly selected among the schools of the four districts of Natal, according to the type of institution (public or private), its level (elementary or secondary), and study period (morning, afternoon or evening). The school population was studied from March to May, 2001. Initially, the students answered a questionnaire to evaluate demographic, epidemiologic and socio-economic risk factors. Afterwards, the following procedures were carried out: blood samples were taken for Toxoplasmosis (IgG, IgM) serology, hemogram, ophthalmological examination, consisting of clinical history, measurement of visual acuity, refraction under cycloplegia, biomicroscopy of the anterior segment and annexa, funduscopy and examination of extrinsic motility. The prevalence of Toxocariasis was 0.2% or 2 per one thousand students. The sample was insufficient to estimate the prevalence of DUSN. Seventy patients with DUSN diagnosis were examined from January, 2001 to January, 2003. A live worm was found in the subretinal space of all four patients in the acute phase, and these were treated with laser photocoagulation. After follow-up (average = 11.5 months), visual acuity improved in three eyes and remained unaltered in one eye. Worms were found in 22 of the 66 patients in the chronic phase, and these also were treated with laser photocoagulation. After a follow-up period of 13.1 months, on average, visual acuity improved in two of the patients, remained unchanged in 19 and worsened in one. The comparison of visual result before and after treatment was not statistically significant (p = 0.302). The diagnosis of DUSN in the acute phase, followed by prompt localization and destruction of the worm by photocoagulation, can improve the patient s vision. However, destruction of the worm by laser photocoagulation in eyes with DUSN in the chronic phase does not improve visual acuity. Seroprevalence for IgG was 46% (Confidence Interval CI 95%-42.9-49.2%) and for IgM it was 1.4% (CI 95% = 0.8-2.4%). The prevalence of ocular lesion was 1.15% (CI 95% = 0.6 - 2.0%). Socio-economic conditions were determinants in the prevalence of Systemic and Ocular Toxoplasmosis in the bivaried analysis and confirmed in the multivaried analysis (mother s scholarity illiterate/ OR = 2.9 and p < 0.001). The T. gondii infection prevalence, although high, was less than that found in studies performed in the South and Southeast of Brazil and that of Ocular Toxoplasmosis was completely discrepant, varying from 5 to 17 times less. Although important epidemiological variables such as owning a cat, drinking unfiltered water, and coming into contact with rivers or lakes showed an association in the preliminary analysis, they lost their influence when included in the logistic model. Future studies are scheduled to begin in March, 2004, in collaboration with other Brazilian and American universities in an attempt to discover the reason for these findings, as well as identifying the different strains of Toxoplasma gondii, and studying the sources of water utilized by the population of Natal Brazil

Hipertensão arterial e fatores de risco em servidores atendidos pelo departamento de assistência da Universidade Federal do Rio Grande do Norte

Systemic arterial hypertension is a multifactorial disease that contributes to the country´s high cardiovascular morbi-mortality rates. Considering that hypertension affects individuals in their most productive age while facing work and living risk factors, it is important to investigate its occurrence and predisposing factors in different occupational segments. The objective of this study was to identify the prevalence of hypertension among workers attended to in a medical service of a public university, their hypertension levels, the risk factors present, and their knowledge of the factors that influence the arterial pressure. The epidemiologic study was conducted in the Health Department of the Federal University of Rio Grande do Norte with 102 workers that sought care in the medical clinic during the months of March to May 2009. Data were collected by means of a questionnaire and measurements of systolic and diastolic arterial pressure (SAP and DAP) that were classified in stages according to the Brazilian Society of Hypertension and the degree of risk for cardiovascular events according to the criteria of the Brazilian Society for Cardiology. Data were analyzed using descriptive statistics. The workers were, on average, 54 years of age; the majority (67%) was male and had primary or middle educational level; they worked mainly in supplemental units and deanship offices conducting different functions such as security guards, administrative assistants, health auxiliaries and constructions workers; 48 (47%) of the workers identified themselves as hypertensive for 8 years on average, with the majority executing hard labor and administrative functions. Among the workers with hypertension, the number of the pressure levels classified as pre-hypertensive, stage I and II were: (12% in the SAP and 20% in the DAP); (16% in the SAP and 9% in the DAP); and (15% in the SAP and 5% in the DAP), respectively. The workers that did not identify themselves as hypertensive presented classifications with greater frequencies were: normal (16% in the SAP and 30% in the DAP); and pre-hypertensive (21% in the SAP and 16% in the DAP). The risk factors identified in more than 50% of the workers were: tobacco smoking, alcohol consumption and indices of being overweight, although physical activities are also present. Of the 48 workers diagnosed as hypertensive, those that had 5 risk factors present and limitrophic pressure levels (12%), in stage I hypertension (16%) and stage II hypertension (15¨%) were categorized as being in high risk for vascular events. The number of workers that indicated they had knowledge of the factors that influence their hypertension was less than 39% for each factor. It is concluded that there is a high prevalence of systemic arterial hypertension in the university workers, even amongst those already under treatment. They constitute a population at risk considering their age group, their work functions, and their inadequate life habits. Health care of these hypertensive workers that seek attention in the Health Department is an important aspect of the internal workers health policy in the institution. Educational interventions are recommended for the improvement of quality of life and of work in these workers

Uma proposta para preparação de pequenas e médias empresas brasileiras prestadoras de serviços ao setor de telecomunicações para implantação da metodologia Seis Sigma

The objective of this work consists of considering a script so that operating companies in the telecommunications sector, mainly small and medium-sized enterprises, can reach excellency in its operations and get, thus, conditions to compete with companies consolidated in its niche of market. The proposal intends to lead the enterprises to a level of qualification of processes that to become them apt to adopt the Six Sigma method as part of its culture. From the analysis of the essential processes of the sector, methods and tools will be suggested for guarantee the continuous improvement of these processes, without forgetting the internal peculiarities of each company

Gestão ambiental na saúde pública: um estudo sobre a percepção ambiental de gerenciamento de resíduos sólidos de serviços de saúde, dos servidores do Hospital Universitário Onofre Lopes do Rio Grande do Norte

This research has aimed at studying the perception of University Hospital Onofre Lopes (HUOL) s workers on the environmental management plan of RSSS. They have been interviewed 250 workers: doctors, nurses, nursing assistants, and cleaners. It was used an exploratory and descriptive research of the type Survey, which aims at obtaining of data or information on characteristics, actions or opinions of any group of people. The questions of the questionnaire were of the kind objective", formulated in a model "scale", analyzed in according to the positioning of the interviewee. The wastes of health service have high potential for environmental impact in the activities from HUOL. Actions or environmental protective policy can improve the image of HUOL. They have been detected divergences on the rigor in application of law of ANVISA. The HUOL s workers unaware of the law of ANVISA and they have little or no knowledge about the practices of environmental control, public health and, they do not know the Environmental Management System ISO 14001. They have divergent views on the degree of importance of ISO 14001. There is not a Waste Management Plan for Health Service and / or is not disclosed for most of HUOL workers. It has not carried out audits or defined the goals and objectives. Besides, it has not been identified legal requirements, and there has not been communication about the service is performed or has been made a critical analysis and no control of documents the environmental management plan. The HUOL have not had a committee of environmental management. The direction of HUOL has not been organized courses, training and recycling of waste on environmental control of the health service. On a scale from 01 to 05, the level of aware level concerning to the waste management from health services of the workers, so is at the threshold between 01 and 02. For the reversal of this situation, the first and urgent step is the creation and institutionalization the environmental management committee of the University Hospital Onofre Lopes

Diagnóstico do usuário no aprimoramento dos serviços de tecnologia da informação: um projeto de intervenção para o Ministério Público do Estado do Rio Grande do Norte

The information tecnology (IT) has, over the years, gaining prominence as a strategic element and competitive edge in organizations, public or private. In the judiciary, with the implementation of actions related to Judiciário Eletrônico, information technology (IT), definitely earns its status as a strategic element and significantly raises the level of dependence of the organs of their services and products. Increasingly, the quality of services provided by IT has direct impact on the quality of services provided by the agency as a whole. The Ministério Público do Estado do Rio Grande do Norte (MPRN) deployments shares of Electronic Government, along with an administrative reform, beyond these issues raised, caused a large increase in institutional demand for products and services provided by the Diretoria de Tecnologia da Informação (DTI), a sector responsible for the provision of IT services. Taking as starting point strategic goal set by MPRN to reach a 85% level of user satisfaction in four years, we seek to propose a method that assists in meeting the goal, respecting the capacity constraints of the IT sector. To achieve the proposed objective, we conducted a work in two distinct and complementary stages. In the first step we conducted a case study in MPRN, in which, through an internal and external diagnosis of DTI, accomplished by an action of internal consulting and one research of the user satisfaction, we seek to identify opportunities of change seeking to raise the quality perceived of the services provided by the DTI , from the viewpoint of their customers. The situational report, drawn from the data collected, fostered changes in DTI, which were then evaluated with the managers. In the second stage, with the results obtained in the initial process, empirical observation, evaluation of side projects of quality improvement in the sector, and validation with the managers, of the initial model, we developed an improved process, gazing beyond the identification of gaps in service a strategy for the selection of best management practices and deployment of these, in a incremental and adaptive way, allowing the application of the process in organs with little staff allocated to the provision of information technology services

O uso do território pelos serviços privados de saúde em Natal/RN

Nowadays we can observe in Natal city, the development of the structure and the health s private service. However, the spatial distribution of these services will be marked by an uneven distribution on the places, what will be in according with the conditions offered by the same in each historical period. Accordingly, the objective of this job is analyze the use of the territory by the health s private service and the dynamics that promotes in Natal city in the technical scientific information period. Thus, seeking to search this goal, realized literature, documentary, empirical, considering the process of development and the spatial distribution of the health s private service in the city. From a topology we can observe that prevails in the city a service s concentration at all levels of complexity in only a few neighborhoods, being Tirol and Petrópolis, which are neighborhoods that have high densities of engineer system, bigger fluidity, and the best level salaries of the city, which present a greater number of these establishments. However, equal this concentration has occurred a dispersion of these services to other neighborhoods, as for example Lagoa Nova which is presenting the same attractiveness in the view of attributes territorial, begins to protect services presenting the same profile like the firsts. However, the city has a significant demand to this kind of service found in these neighborhoods, some events provided the emergency of another type of market of health s private service, that are those created to attend guests with a lower purchasing power, which will have their establishments in the same way selectively distributed in some areas of the city, which will not be the same pursued by the other, showing how selective is the installation of an enterprise guide by the logic of capitalism reproduction. So, the imperative of spatial selectivity presented by the health s private sector exposes an use of the differential territory for these services

Qualidade dos serviços hoteleiros: percepções dos turistas de negócios de Teresina-PI

Business tourism is one of tourist segments with different market characteristics in relation to others segmentations, such as low seasonality, there is no requirement of natural attractions, it serves as destination projection and it generates profitable larger numbers. Due to the context around business travels, the hotel so many times has a fundamental whole among the elements of the production chain in this segmentation. Business tourism in Teresina is the primary segmentation of the capital, since it represents almost 70% of hotel demand; hence this research has as objective to evaluate through the perceptions of business travelers, the level of quality services of hotels of Teresina. The research is exploratory and descriptive, of functionalist character. This study is characterized by qualitative and quantitative research, supported by a basis of methodological pluralism. For primary data collection was performed applying a suitable research instrument of SERVPERF model (Service Performance). The universe of this study were Teresina's accommodations, restricted to only those that fit in hotel category and it was inside metropolitan area of Teresina. The study subjects were business travelers who were hosted in these hotels. For the analysis, it was considered certain factors: descriptive analysis, factor analysis, correlation matrix analysis of the variables; It was still compiling a graphic of lexicons obtained in the survey about respondent's the notion of quality of vision in the hotel service; Finally, qualitative analysis was based on the theories of marketing, targeting and quality of tourism services applied. The results show that the Teresina hotel service is on a regular average, especially for Reliability and Safety dimensions were highlighted. Whereas, the factor analysis showed the emergence of two factors to explain "Empathy" dimension, one of this is about the organization and the other one is about consumer. And by Lexicometria was possible to observe the importance to the customer of other variables such as: personal aspects, price and location for this tour segmentation.

Serviço de nuvem pública e sua relação com os arranjos de governança de TI e o alinhamento estratégico

Increasingly, the Information Technology (IT) has been used to sustain the business strategies, causing increased its relevance. Therefore IT governance is seen as one of the priorities of organizations at the time. The search for strategic alignment between business and IT is debated as a factor for business success, but even with that importance, usually the main business managers are reluctant to take responsibility for decisions involving IT, mainly due to the complexity of your infrastructure. Since cloud computing is being seen as an element capable of assisting in the implementation of organizational strategies, because their characteristics enable greater efficiency and agility in IT, and is considered as a new computing paradigm. The main objective of the analyze the relationship between IT governance arrangements and strategic alignment with the infrastructure as a service (IaaS) of public cloud computing. Therefore, an exploratory, descriptive and inferential was developed, with approach to the problem of quantitatively research, with descriptive survey method and cross section. An electronic questionnaire that was applied to the ISACA chapters Associates of São Paulo and the Distrito Federal, totaling 164 respondents was used. The instrument used based on the theories of Weill and Ross (2006) for array of IT governance arrangement; Henderson and Venkatraman (1993) and Luftman (2000), for maturity of the strategic alignment model; and NIST (2011 b), ITGI (2007) and CSA (2010) for infrastructure maturity as a service (IaaS) public in its essential characteristics. As regards the main results, this research proved that with public IaaS decision-making structures have changed, with a greater participation of senior executives in all five key IT decisions (IT governance arrangement array) including more technical decisions as architecture and IT infrastructure. With increased participation of senior executives the decrease was also observed in the share of IT specialists, characterizing the decision process with the duopoly archetype (shared decision). With regard to strategic alignment, it was observed that it changes with cloud computing, and organizations with public IaaS, a maturity of strategic alignment with statistically significant and greater difference when compared to organizations without IaaS. The maturity of public IaaS is at the intermediate level (level 3 - "defined process"), with the elasticity and measurement achieved level 4 - "managed and measurable" It was also possible to infer in organizations with public IaaS, there are positive correlations between the key decisions and the maturity of IaaS, especially at the beginning, architecture and infrastructure, and the archetypes involving senior executives and IT specialists. In the correlation between the maturity and mature strategic alignment of public IaaS therefore the higher the strategic alignment, the greater the maturity of the public IaaS and vice versa.

Avaliação clínica e da qualidade de vida utilizando dois protocolos para recuperação miofuncional em pacientes que se submeteram à cirurgia ortognática: resultados preliminares

The objective of this randomized, blind and prospective clinical trial was to compare the pain, the edema, the mandibular movements, the masticatory efficiency and life quality, in the first 60 days after surgery using 2 different clinical protocols for myofunctional recovery, in patients who underwent orthognathic surgery. A sample of 19 patients was used and divided into 2 groups. The control group (CG) consisted of 10 patients who had postoperative rehabilitation guided by a standard protocol, conducted by the Service of Surgery and Traumatology Oral and Maxillofacial. In other hand, the experimental group (EC) totaled 9 patients who received the speech therapy rehabilitation protocol specialized, by professionals in the area. The variables pain, edema and mandibular movements were analyzed during 48h, 96h, 7 days, 14 days, 30 and 60 days post-surgery. The masticatory efficiency and the quality of life were classified with 60 days after surgery . The data were submitted an analysis of variance, Student's t-test and Fisher's independence, at the level of 5% probability. It was identified that patients of GE have benefited in the first 14 days(p<0,001), as they have had reported less pain than those in the CG. Significant statistics differences between groups for pain parameters (after 14 days) (p=0,065), edema(p=0,063), mandibular movements(p=0,068), masticatory efficiency(p=0,630) and the impact on quality of life (p=0,813) were not observed on this study. The speech therapy protocol for myofunctional recovery (EG), although it has not obtained statistical results superiors than the CG in the general context, presents itself as a viable alternative to conventional therapy assumed by many maxillofacial surgeons, allowing the surgeon to optimize time with patients in the period postoperatively.