Análise de desempenho de vendas em telecomunicações utilizando técnicas de mineração de dados

Nowadays, telecommunications is one of the most dynamic and strategic areas in the world. Organizations are always seeking to find new management practices within an ever increasing competitive environment where resources are getting scarce. In this scenario, data obtained from business and corporate processes have even greater importance, although this data is not yet adequately explored. Knowledge Discovery in Databases (KDD) appears then, as an option to allow the study of complex problems in different areas of management. This work proposes both a systematization of KDD activities using concepts from different methodologies, such as CRISP-DM, SEMMA and FAYYAD approaches and a study concerning the viability of multivariate regression analysis models to explain corporative telecommunications sales using performance indicators. Thus, statistical methods were outlined to analyze the effects of such indicators on the behavior of business productivity. According to business and standard statistical analysis, equations were defined and fit to their respective determination coefficients. Tests of hypotheses were also conducted on parameters with the purpose of validating the regression models. The results show that there is a relationship between these development indicators and the amount of sales

Estudo do aproveitamento do rejeito da mineração de esmeraldas na produção de refratários conformados isolantes

Emerald mining is an important area of the economy in Brazil, country which is in second place among the exporting nations of this gem. Due to the process of extraction, a great amount of reject is generated. Since there is no appropriate destination, the reject is abandoned around the mining industries, contributing to environment degradation. Nowadays, some of the most relevant things to an industry in general are: energy conservation, cost reduction, quality and productivity enhancement. The production of isolating, transformed refractory materials achieves the sustainability dimension when protection of the environment is incorporated to such process. This work investigates the use of emerald mining rejects in the ceramic body of refractory materials, aiming at obtaining a product whose characteristics are compatible with commercial products and, at the same time, allow the use of such rejects to solve the environmental issue caused by its disposal in nature. X-ray fluorescence analysis show that the emerald reject obtained after the flotation to extract molybdenum and mica has 70% of silica and alumina (SiO2+Al2O3) and 21% of a basic oxides and alkaline metals and earthy alkaline mixture (Na2O, K2O, CaO e MgO). Because of the significant amount of silica and alumina present in the reject, four refractory ceramic bodies were prepared. Samples with a rectangular shape and dimensions 100x50x10 mm were pressed in a steel mold at 27,5 MPa and sintered at 1200ºC for 40 min. under environment atmosphere in a resistive oven. The sintered samples were characterized in relation to the chemical composition (FRX), mineralogical composition (DRX), microstructure (MEV) and physical and mechanical properties. The results indicate that the mixture with 45% of reject, 45% of alumina and 10% of kaolin presents a refractory quality of 1420ºC, dimensional linear variation below 2.00%, apparent specific mass of 1,56 g/cm3 and porosity of 46,68%, which demonstrates the potential use of the reject as raw material for the industry of isolating transformed refractory materials

Avaliação da contribuição de desenvolvedores para projetos de software usando mineração de repositórios de software e mineração de processos

Software Repository Mining (MSR) is a research area that analyses software repositories in order to derive relevant information for the research and practice of software engineering. The main goal of repository mining is to extract static information from repositories (e.g. code repository or change requisition system) into valuable information providing a way to support the decision making of software projects. On the other hand, another research area called Process Mining (PM) aims to find the characteristics of the underlying process of business organizations, supporting the process improvement and documentation. Recent works have been doing several analyses through MSR and PM techniques: (i) to investigate the evolution of software projects; (ii) to understand the real underlying process of a project; and (iii) create defect prediction models. However, few research works have been focusing on analyzing the contributions of software developers by means of MSR and PM techniques. In this context, this dissertation proposes the development of two empirical studies of assessment of the contribution of software developers to an open-source and a commercial project using those techniques. The contributions of developers are assessed through three different perspectives: (i) buggy commits; (ii) the size of commits; and (iii) the most important bugs. For the opensource project 12.827 commits and 8.410 bugs have been analyzed while 4.663 commits and 1.898 bugs have been analyzed for the commercial project. Our results indicate that, for the open source project, the developers classified as core developers have contributed with more buggy commits (although they have contributed with the majority of commits), more code to the project (commit size) and more important bugs solved while the results could not indicate differences with statistical significance between developer groups for the commercial project

Uma ferramenta de análise automatizada de técnicas de seleção de testes de regressão baseada em mineração de repositórios de software

The main goal of Regression Test (RT) is to reuse the test suite of the latest version of a software in its current version, in order to maximize the value of the tests already developed and ensure that old features continue working after the new changes. Even with reuse, it is common that not all tests need to be executed again. Because of that, it is encouraged to use Regression Tests Selection (RTS) techniques, which aims to select from all tests, only those that reveal faults, this reduces costs and makes this an interesting practice for the testing teams. Several recent research works evaluate the quality of the selections performed by RTS techniques, identifying which one presents the best results, measured by metrics such as inclusion and precision. The RTS techniques should seek in the System Under Test (SUT) for tests that reveal faults. However, because this is a problem without a viable solution, they alternatively seek for tests that reveal changes, where faults may occur. Nevertheless, these changes may modify the execution flow of the algorithm itself, leading some tests no longer exercise the same stretch. In this context, this dissertation investigates whether changes performed in a SUT would affect the quality of the selection of tests performed by an RTS, if so, which features the changes present which cause errors, leading the RTS to include or exclude tests wrongly. For this purpose, a tool was developed using the Java language to automate the measurement of inclusion and precision averages achieved by a regression test selection technique for a particular feature of change. In order to validate this tool, an empirical study was conducted to evaluate the RTS technique Pythia, based on textual differencing, on a large web information system, analyzing the feature of types of tasks performed to evolve the SUT

Doenças respiratórias associadas à atividade de mineração no município de Parelhas, região do seridó norte-riograndense

This work aims to characterize the workers in mineral activities exposed to lung injuries in Parelhas Municipality, Rio Grande do Norte State, seeking to relate respiratory diseases to the mining activity. The studied area (Parelhas City), with about 19,700 inhabitants, is located in the Serido region, approximately 232 km far from Natal City. The number of people involved in informal mining activity (garimpo) in the Seridó region reaches about 5,000. These workers generally do not use any kind of individual protection equipments and develop, at early ages of greater productivity, severe forms of diseases, which end up disabling them to professional activities, family and social life. Deceases by respiratory problems (e.g. silicosis) have been reported in very young adults. A descriptive observational study was conducted based on information from the records found in Dr. José Augusto Dantas Hospital, between the years 1996- 2006. The occupational and socio-economic features of the population, which was selected by using the hospital records, were achieved through individually answered forms. The purpose was to link the occupational activities with the respiratory diseases. The next stage of the research was an observational case-control study, in the 1:1 proportion. The achieved data allowed confirming the central hypothesis of the research, which states that the pneumoconiosis cases are due to the mineral-based activities in the studied area. The final step of the investigation tried to assess the knowledge of relatives of students in public and private elementary and high schools from Parelhas City, regarding silicosis. About 15.4% of urban schools were analyzed through application of a structured questionnaire. The results show distinct socio-economic levels and a difference in the perception of the relatives of students in public and private schools, concerning silicosis. It was possible to identify the characteristics of the population economically involved with mineral-based activities and to define the group that deserves preferential attention in preventive actions. The work indicates some environmental problems caused by inadequate mining operations in the region

A mineração artesanal e de pequena escala em pegmatitos e cerâmica no município de Parelhas, região do Seridó/Rio Grande do Norte

The working conditions, occupational health, occupational illness and workers quality of life, usually referring to the artisanal activities and the workers with a poor professional support. Because this reality is still present in locals without good infrastructure of social and economic attention, there is a need for a broad knowledge of problems related to the productive processes that include features of unsanitary and unhealthy. Despite the intense process of industrialization promoted by globalization and the growth of developing nations like Brazil, the activities of artisanal and small-scale mining are still suffering from the marginalization of their production processes and their workers. This dissertation deals with the description of mineral-based activities (MBA), especially the activities related to production processes of extraction and processing of red pottery and minerals in pegmatites in Parelhas city, Seridó, Rio Grande do Norte, which are conducted by small mining companies or artisanal miners. The study of the work process was based on direct observation, photographic documentation, ergonomics, health and occupational safety analysis, interviews and structured questionnaire with workers of the two activities. The results indicate the need for improvement in both workplaces (red pottery and pegmatites), adaptation of workers to safety standards specific to the workplace, more attention and care related to ergonomics and occupational safety, greater importance to economic and social relations among performed activities, workers and firms of mineral branch and better and greater integration of social policies, supported by different sectors of society with the intention of transforming the current social, cultural, labor and education situation

A céu aberto: garimpando a memória e a identidade dos mineradores de Brejuí

The Brejuí Mine, situated in the municipality of Currais Novos (RN), was responsible for the local economy growth between the years of 1943 and 1990, causing the interest of miner's working class to its urban center. After the end of scheelita extraction, the mine became a "theme park", in 2004. The company left its mark on the city by building several monuments in reference to the mining activity and the company's founder, Tomaz Salustino. However, there are no written records that describe such activities on its early years, nor their pioneers in the mining subject. Therefore, it is important to investigate the miner’s memories and ask if, along the more than five decades that lasted the heyday of mining, an identity linked to the profession was built; the extent to which workers make reference to this history as membersand what are the symbols that are being triggered in the development of a working class identity. Further, I investigate what memory was mad concerning the pioneers, mostly farmers attracted by miner work. To do so, I make use of audiovisual archival resources and oral records of the interlocutors that were filmed in the preparations of the documentary “Lembranças de velhos garimpeiros". We have noticed that, in the script of the official history of the Brejuí Mine, the "boss" figure overlaps the workers and that the forms patronage, originated from the rural world, followed punctuating the social relations in the mine. Today, with the resumption of the mining activity, it is possible that the strengthening of the working class and the Seridó miner identity desire reborn.

Estudo da adição do resíduo proveniente da extração de minério de ferro em argilas do Rio Grande do Norte

The mining industry is responsible for the generation of waste from their natural process of extraction. The mining impacts in urban areas are of special importance due to the high urban occupation, which are exacerbated due to the proximity of the mined areas and populated areas. Some solutions to wastedisposal have the potential to significantly reduce the environmental risks and liabilities, but represent higher costs in the stages of deployment and operation. The addition of mining waste as raw material in the development of commercial products reduces the environmental impacts, transforming the waste into a positive element in the generation of employment and income. This thesis studies the incorporation of waste iron ore in two clays, one from the ceramic industry of the City of Natal and the other from the ceramic industry of the Seridó Region, both in the State of Rio Grande do Norte, Brazil. Percentages of iron ore waste of 5%, 10% , 15%, 20%, 25% and 30% were used in the tested ceramic matrix. The two clays and the iron ore waste used as part of this investigation were characterized by X-ray diffraction tests, X-ray fluorescence tests, differential thermal analysis, thermogravimetric analysis and dilatometric analysis. The samples were sintered under temperatures of 850 °C, 950 °C and 1050°C at a heating rate of 5 °C/min with isotherms of two hours. The following tests were performed with the samples: linear shrinkage, water absorption, apparent porosity, apparent density, mass loss in fire and bending resistance in order to obtain their physical and mechanical properties. An amount of 5% of waste iron ore in the matrix clay at a temperature of 850 0C resulted in na increase of about 65% in the tensile strength of the clay samples from the Natal ceramic industry. A linear shrinkage of only 0.12% was observed for the samples, which indicates that the physical properties of the final product were not influenced by the addition of the waste

Desenvolvimento, pobreza e meio ambiente no seridó potiguar: um estudo centrado nas micro-regiões do seridó oriental e ocidental

This research work intends to carry out a study focused on the dynamic between development, poverty reduction and conservation of natural resources. To consider this relationship to the region chosen was the micro-region of Eastern and Western Seridó in the state of Rio Grande do Norte. In recent years, several studies (Araújo, 2011; BASTOS, 2009) have pointed out that after a period of economic crisis in its tripodproductive, formed by the activities of farming, cotton farming, mining and faced in the eighties, this region of the State of Rio Grande do Norte, has not only shown signs of economic recovery but also improve their social indicators. On the other hand, studies of desertification as the view of the state of RN (produced in cooperation between the Government of RN and research institutions) and the Sustainable Development Plan of Seridó (ADES, 2000), indicate that there is an ongoing French process of degradation of natural resources that is capable of compromising the ability of sustaining such a system. To verify this reality and likely finding this relationship, this work is adopted for this study, the analysis of evolution of secondary data from official bodies such as the IBGE on HDI, per capita income and other social indicators between 2000 and 2009. Here is another time of the survey analysis of qualitative data collected from interviews with institutions of academic intervention in nature, researchers at the Federal University of Rio Grande do Norte (UFRN) State agencies that address the issue of the Middle Environment in Seridó: Institute for Sustainable Development of the NB (IDEMA) and the Brazilian Institute of Environment and the Amazon (IBAMA) and institutions of direct intervention in the region, as the Agency's Sustainable Development Seridó (adhesive) and the Joint Semi-Arid (ASA). After crossing data from quantitative and qualitative, it was found that the dynamics of the region's economic Seridó Potiguar partially answers the improvement of social indicators of poverty. Contribution by the State in this shared stock transfer income. Regarding the influence of productive restructuring in the region on issues of environment, it is noted that the ceramic tile industry, responsible for the absorption percentage of the population with limited ingress into the urban economy, given the low education, accounts for the increase of susceptibility to the ongoing process of desertification in North Seridó Rio Grande. We conclude finally that the guarantee of increased income, freedom and conservation of natural resources ensures primarily by changing the beliefs and values, especially on the part of the business sector, which use natural resources so predatory, aimed at maintaining their rates of return on investment. And concomitantly, the synchronization between technological change, through the use of new energy sources, and institutional change.

Emprego de redes neurais artificiais supervisionadas e não supervisionadas no estudo de parâmetros reológicos de excipientes farmacêuticos sólidos

In this paper artificial neural network (ANN) based on supervised and unsupervised algorithms were investigated for use in the study of rheological parameters of solid pharmaceutical excipients, in order to develop computational tools for manufacturing solid dosage forms. Among four supervised neural networks investigated, the best learning performance was achieved by a feedfoward multilayer perceptron whose architectures was composed by eight neurons in the input layer, sixteen neurons in the hidden layer and one neuron in the output layer. Learning and predictive performance relative to repose angle was poor while to Carr index and Hausner ratio (CI and HR, respectively) showed very good fitting capacity and learning, therefore HR and CI were considered suitable descriptors for the next stage of development of supervised ANNs. Clustering capacity was evaluated for five unsupervised strategies. Network based on purely unsupervised competitive strategies, classic "Winner-Take-All", "Frequency-Sensitive Competitive Learning" and "Rival-Penalize Competitive Learning" (WTA, FSCL and RPCL, respectively) were able to perform clustering from database, however this classification was very poor, showing severe classification errors by grouping data with conflicting properties into the same cluster or even the same neuron. On the other hand it could not be established what was the criteria adopted by the neural network for those clustering. Self-Organizing Maps (SOM) and Neural Gas (NG) networks showed better clustering capacity. Both have recognized the two major groupings of data corresponding to lactose (LAC) and cellulose (CEL). However, SOM showed some errors in classify data from minority excipients, magnesium stearate (EMG) , talc (TLC) and attapulgite (ATP). NG network in turn performed a very consistent classification of data and solve the misclassification of SOM, being the most appropriate network for classifying data of the study. The use of NG network in pharmaceutical technology was still unpublished. NG therefore has great potential for use in the development of software for use in automated classification systems of pharmaceutical powders and as a new tool for mining and clustering data in drug development

Avaliação do concreto de cimento portland com resíduo da produção de scheelita em substituição ao agregado miúdo

From the 70`s, with the publication of the Manifesto for Environment UN Conference, held in Stockholm, in Sweden (1972), defend and improve the environment became part of our daily lives. Thus, several studies have emerged in several segments in order to reuse the waste. Some examples of waste incorporated in portland cement concrete are: rice husk ash, bagasse ash of cane sugar, powder-stone, microsilica, tire rubber, among others. This research used the residue of the mining industry Scheelite, to evaluate the incorporation of the residue composition of Portland cement concrete, replacing the natural sand. The percentage of residue were incorporated from 0% to 100%, with a variation of 10%, 11 being produced concrete mix in the ratio 1:2:3:0.60, by mass. We evaluated the following characteristics of concrete: slump test, compressive strength, tensile strength by diametral compression, water absorption, porosity and density, based on the ABNT, through tests performed in the Laboratory of Civil Construction, UFRN. The trace with the addition of 60% scheelite residue was obtained which better performance. Therefore, the use of the waste from the production of Scheelite is feasible due to the durability parameters (water absorption and porosity), sustainability, and the good results of the resistance of the concrete

Análise dos custos assistenciais de uma operadora de plano de saúde no Brasil

The relevance of rising healthcare costs is a main topic in complementary health companies in Brazil. In 2011, these expenses consumed more than 80% of the monthly health insurance in Brazil. Considering the administrative costs, it is observed that the companies operating in this market work, on average, at the threshold between profit and loss. This paper presents results after an investigation of the welfare costs of a health plan company in Brazil. It was based on the KDD process and explorative Data Mining. A diversity of results is presented, such as data summarization, providing compact descriptions of the data, revealing common features and intrinsic observations. Among the key findings was observed that a small portion of the population is responsible for the most demanding of resources devoted to health care

Análise de Agrupamentos Com Base na Teoria da Informação: Uma Abordagem Representativa

Currently, one of the biggest challenges for the field of data mining is to perform cluster analysis on complex data. Several techniques have been proposed but, in general, they can only achieve good results within specific areas providing no consensus of what would be the best way to group this kind of data. In general, these techniques fail due to non-realistic assumptions about the true probability distribution of the data. Based on this, this thesis proposes a new measure based on Cross Information Potential that uses representative points of the dataset and statistics extracted directly from data to measure the interaction between groups. The proposed approach allows us to use all advantages of this information-theoretic descriptor and solves the limitations imposed on it by its own nature. From this, two cost functions and three algorithms have been proposed to perform cluster analysis. As the use of Information Theory captures the relationship between different patterns, regardless of assumptions about the nature of this relationship, the proposed approach was able to achieve a better performance than the main algorithms in literature. These results apply to the context of synthetic data designed to test the algorithms in specific situations and to real data extracted from problems of different fields

Eosi: um modelo para desenvolvimento de sistemas embarcados tolerantes a falhas

The semiconductor technologies evolutions leads devices to be developed with higher processing capability. Thus, those components have been used widely in more fields. Many industrial environment such as: oils, mines, automotives and hospitals are frequently using those devices on theirs process. Those industries activities are direct related to environment and health safe. So, it is quite important that those systems have extra safe features yield more reliability, safe and availability. The reference model eOSI that will be presented by this work is aimed to allow the development of systems under a new view perspective which can improve and make simpler the choice of strategies for fault tolerant. As a way to validate the model na architecture FPGA-based was developed.

Extração e Representação de Conhecimento de Séries Temporais de Demanda de Energia Elétrica Usando TSKR

The opening of the Brazilian market of electricity and competitiveness between companies in the energy sector make the search for useful information and tools that will assist in decision making activities, increase by the concessionaires. An important source of knowledge for these utilities is the time series of energy demand. The identification of behavior patterns and description of events become important for the planning execution, seeking improvements in service quality and financial benefits. This dissertation presents a methodology based on mining and representation tools of time series, in order to extract knowledge that relate series of electricity demand in various substations connected of a electric utility. The method exploits the relationship of duration, coincidence and partial order of events in multi-dimensionals time series. To represent the knowledge is used the language proposed by Mörchen (2005) called Time Series Knowledge Representation (TSKR). We conducted a case study using time series of energy demand of 8 substations interconnected by a ring system, which feeds the metropolitan area of Goiânia-GO, provided by CELG (Companhia Energética de Goiás), responsible for the service of power distribution in the state of Goiás (Brazil). Using the proposed methodology were extracted three levels of knowledge that describe the behavior of the system studied, representing clearly the system dynamics, becoming a tool to assist planning activities