Servei de Generació d'Informes Corporatiu

Es vol crear un entorn de treball que permeti als diferents usuaris de l¿empresa, obtenir informació de les seves dades, tant a nivell de direcció, per propòsits de divulgació, ajuda a la presa de decisions, anàlisis i control, com a nivell de consulta de les dades de l¿operativa bàsica diària per diferents necessitats.

On-Line Analytical Processing of Inventory Turnover

Operatiivisen tiedon tuottaminen loppukäyttäjille analyyttistä tarkastelua silmällä pitäen aiheuttaa ongelmia useille yrityksille. Diplomityö pyrkii ratkaisemaan ko. ongelman Teleste Oyj:ssä. Työ on jaettu kolmeen pääkappaleeseen. Kappale 2 selkiyttää On-Line Analytical Processing (OLAP)- käsitteen. Kappale 3 esittelee muutamia OLAP-tuotteiden valmistajia ja heidän arkkitehtuurejaan sekä tyypillisten sovellusalueiden lisäksi huomioon otettavia asioita OLAP käyttöönoton yhteydessä. Kappale 4, tuo esille varsinaisen ratkaisun. Teknisellä arkkitehtuurilla on merkittävä asema ratkaisun rakenteen kannalta. Tässä on sovellettu Microsoft:n tietovarasto kehysrakennetta. Kappaleen 4 edetessä, tapahtumakäsittelytieto muutetaan informaatioksi ja edelleen loppukäyttäjien tiedoksi. Loppukäyttäjät varustetaan tehokkaalla ja tosiaikaisella analysointityökalulla moniulotteisessa ympäristössä. Vaikka kiertonopeus otetaan työssä sovellusesimerkiksi, työ ei pyri löytämään optimaalista tasoa Telesten varastoille. Siitä huolimatta eräitä parannusehdotuksia mainitaan.

Teknisen tiedon tietovarastoanalyysi kunnossapidon ja suunnittelun tarpeisiin

Työn tavoitteena oli selvittää UPM-Kymmene Oyj Kaukaan tehtaalla käytettävän teknisen tiedon tietovarastoja, tiedon määrää ja laatua. Lisäksi työssä selvitetään tiedon kasvuvauhtia lähivuosina sekä sen dokumentointia ja dokumentoinnin kehitystä. Työssä keskityttiin tekniseen tietoon, mitä käyttää pääsääntöisesti kunnossapito, suunnittelu ja materiaalihallinto. Työn johdosta havaittiin, että tehtaalla käytetään huomattavia määriä henkilöstöresursseja tiedon etsimiseen ja sen päivittämiseen. Lisäksi huomattiin tehtaan teknisessä tiedossa olevan selkeitä päällekkäisyyksiä tiedon tallentamisen osalta, mikä aiheuttaa epävarmuutta tiedon validiutta arvioitaessa. Toimenpiteiksi ehdotettiin tietovarastojen systemaattista läpikäymistä siten, että tiedot luokiteltaisiin luotavalla asteikolla tärkeisiin ja vähemmän tärkeisiin kokonaisuuksiin. Kriteerinä voisi toimia esimerkiksi kriittisyys tuotantoon nähden.

Utilizing analytic modelling process in industrial retail context

Nykypäivän monimutkaisessa ja epävakaassa liiketoimintaympäristössä yritykset, jotka kykenevät muuttamaan tuottamansa operatiivisen datan tietovarastoiksi, voivat saavuttaa merkittävää kilpailuetua. Ennustavan analytiikan hyödyntäminen tulevien trendien ennakointiin mahdollistaa yritysten tunnistavan avaintekijöitä, joiden avulla he pystyvät erottumaan kilpailijoistaan. Ennustavan analytiikan hyödyntäminen osana päätöksentekoprosessia mahdollistaa ketterämmän, reaaliaikaisen päätöksenteon. Tämän diplomityön tarkoituksena on koota teoreettinen viitekehys analytiikan mallintamisesta liike-elämän loppukäyttäjän näkökulmasta ja hyödyntää tätä mallinnusprosessia diplomityön tapaustutkimuksen yritykseen. Teoreettista mallia hyödynnettiin asiakkuuksien mallintamisessa sekä tunnistamalla ennakoivia tekijöitä myynnin ennustamiseen. Työ suoritettiin suomalaiseen teollisten suodattimien tukkukauppaan, jolla on liiketoimintaa Suomessa, Venäjällä ja Balteissa. Tämä tutkimus on määrällinen tapaustutkimus, jossa tärkeimpänä tiedonkeruumenetelmänä käytettiin tapausyrityksen transaktiodataa. Data työhön saatiin yrityksen toiminnanohjausjärjestelmästä.

Life cycle of the QBO-modulated 11-year solar cycle signals in the Northern Hemispheric winter

This paper provides some insights on the quasi-biennial oscillation (QBO) modulated 11-year solar cycle (11-yr SC) signals in Northern Hemisphere (NH) winter temperature and zonal wind. Daily ERA-40 Reanalysis and ECMWF Operational data for the period of 1958-2006 were used to examine the seasonal evolution of the QBO-solar cycle relationship at various pressure levels up to the stratopause. The results show that the solar signals in the NH winter extratropics are indeed QBO-phase dependent, moving poleward and downward as winter progresses with a faster descent rate under westerly QBO than under easterly QBO. In the stratosphere, the signals are highly significant in late January to early March and have a life span of 30-50 days. Under westerly QBO, the stratospheric solar signals clearly lead and connect to those in the troposphere in late March and early April where they have a life span of 10 days. As the structure changes considerably from the upper stratosphere to the lower troposphere, the exact month when the maximum solar signals occur depends largely on the altitude chosen. For the low-latitude stratosphere, our analysis supports a vertical double-peaked structure of positive signature of the 11-yr SC in temperature, and demonstrates that this structure is further modulated by the QBO. These solar signals have a longer life span (3-4 months) in comparison to those in the extratropics. The solar signals in the lower stratosphere are stronger in early winter but weaker in late winter, while the reverse holds in the upper stratosphere.

Methodology To model the energy and greenhouse gas emissions of electronic software distributions

A new electronic software distribution (ESD) life cycle analysis (LCA)methodology and model structure were constructed to calculate energy consumption and greenhouse gas (GHG) emissions. In order to counteract the use of high level, top-down modeling efforts, and to increase result accuracy, a focus upon device details and data routes was taken. In order to compare ESD to a relevant physical distribution alternative,physical model boundaries and variables were described. The methodology was compiled from the analysis and operational data of a major online store which provides ESD and physical distribution options. The ESD method included the calculation of power consumption of data center server and networking devices. An in-depth method to calculate server efficiency and utilization was also included to account for virtualization and server efficiency features. Internet transfer power consumption was analyzed taking into account the number of data hops and networking devices used. The power consumed by online browsing and downloading was also factored into the model. The embedded CO2e of server and networking devices was proportioned to each ESD process. Three U.K.-based ESD scenarios were analyzed using the model which revealed potential CO2e savings of 83% when ESD was used over physical distribution. Results also highlighted the importance of server efficiency and utilization methods.

Development Of Climate Change Information Database And Its Use In Civic Consciousness Enlightenment

GCM outputs such as CMIP3 are available via network access to PCMDI web site. Meteorological researchers are familiar with the usage of the GCM data, but the most of researchers other than meteorology such as agriculture, civil engineering, etc., and general people are not familiar with the GCM. There are some difficulties to use GCM; 1) to download the enormous quantity of data, 2) to understand the GCM methodology, parameters and grids. In order to provide a quick access way to GCM, Climate Change Information Database has been developed. The purpose of the database is to bridge the users and meteorological specialists and to facilitate the understanding the climate changes. The resolution of the data is unified, and climate change amount or factors for each meteorological element are provided from the database. All data in the database are interpolated on the same 80km mesh. Available data are the present-future projections of 27 GCMs, 16 meteorological elements (precipitation, temperature, etc.), 3 emission scenarios (A1B, A2, B1). We showed the summary of this database to residents in Toyama prefecture and measured the effect of showing and grasped the image for the climate change by using the Internet questionary survey. The persons who feel a climate change at the present tend to feel the additional changes in the future. It is important to show the monitoring results of climate change for a citizen and promote the understanding for the climate change that had already occurred. It has been shown that general images for the climate change promote to understand the need of the mitigation, and that it is important to explain about the climate change that might occur in the future even if it did not occur at the present in order to have people recognize widely the need of the adaptation.

Diagnóstico operacional de lagoas de estabilização

This work intends to develop an approach based through scientific criteria in the operational diagnosis of ponds of stabilization, starting from analyses accomplished in loco and in laboratory of 78 systems of sewer treatment through ponds of stabilization in the State of Rio Grande do Norte. The objectives of the research are: to map, to evaluate and to diagnose the operational acting of the ponds of stabilization of the state of Rio Grande do Norte, through visits in loco and analyses laboratory; to build a SIG, through the map rain, locate the points of releases of sewages of the systems of existent ponds in Rio Grande do Norte, as well as operational data and his/her respective efficiency diagnosis in the removal of BOD and Coliforms Termotolerantes; to evaluate, in real scale, three systems of ponds of stabilization of RN in the operational efficiency for the parameters BOD5, COD, pH, Temperature, OD and Coliforms Termotolerantes. Of 78 ETEs of appraised RN just, 9% or 7 had maximum concepts in what concerns the removal of BOD and Coliforms Termotolerantes and 41% or 32, they had the worst concepts in term of operational efficiency. The flowing concentrations ETEs of RN of BOD and Coliforms were of 410mg/L and 2,50x107UFC/100ml, the predominant configuration is of the type F1+M1+M2, the relationship BOD/COD revealed for the sewer tributary characteristic biodegradable high. For the study of case of 3 ETEs, the best operational efficiencies in decreasing order were: Cidade (Municipal district), it Roça (State) and São Miguel (SAAE). The removals of final BOD were 51,6mg/L; 108,27mg/L and 62,6mg/L, tends efficiency of 82%; 74% and 81%. In term of coliforms removal in the final effluentes were 1,90x103UFC/100ml; 1,50x104UFC/100ml and 3,10x104UFC/100ml, tends efficiencies of 99,99%; 99,95% and 99,90%. In what it concerns the practice of agricultural reúso of cultures consumed raw, none of 3 ETEs assisted the parameters of the Resolution CONAMA 357/05, for other reúso practices, all assisted the categories B and C of OMS. For release in body receiving ETE Cidade just, they assist the demands of the resolution of CONAMA 357/05, by study of purification solemnity of the receiving body. The maintenance lack and operation; exclusive operator in ETEs and operation knowledge was the contributory factors for the operational fall in appraised ETEs of RN

Probabilistic neural network to predict cracks in taphole mud used in blast furnaces

One of the major problems facing Blast Furnaces is the occurrence of cracks in taphole mud, as the underlying causes are not easily identifiable. The absence of this knowledge makes it difficult the use of conventional techniques for predictability and mitigation. This paper will address the application of Probabilistic Neural Network using the Matlab software as a means to detect and control such cracks. The most relevant BF operational variables were picked through the statistic tool "Principal Component Analysis - PCA." Based upon the selection of these variables a probabilistic neural network was built. A set of BF operational data, consisting of 30 controlling variables, was divided into 2 groups, one of which for network training, and the other one to validate the neural network. The neural network got 98% of the cases right. The results show the effectiveness of this tool for crack prediction in relation to clay intrinsic properties and as a result of the fluctuation in operational variables.

Cluster identification and characterization in the riser of a circulating fluidized bed from numerical simulation results

A methodology of identification and characterization of coherent structures mostly known as clusters is applied to hydrodynamic results of numerical simulation generated for the riser of a circulating fluidized bed. The numerical simulation is performed using the MICEFLOW code, which includes the two-fluids IIT's hydrodynamic model B. The methodology for cluster characterization that is used is based in the determination of four characteristics, related to average life time, average volumetric fraction of solid, existing time fraction and frequency of occurrence. The identification of clusters is performed by applying a criterion related to the time average value of the volumetric solid fraction. A qualitative rather than quantitative analysis is performed mainly owing to the unavailability of operational data used in the considered experiments. Concerning qualitative analysis, the simulation results are in good agreement with literature. Some quantitative comparisons between predictions and experiment were also presented to emphasize the capability of the modeling procedure regarding the analysis of macroscopic scale coherent structures. (c) 2007 Elsevier B.V. All rights reserved.

Experimentos de mineração de dados aplicados a sistemas scada de usinas hidrelétricas

O atual modelo do setor elétrico brasileiro permite igualdade de condições a todos os agentes e reduz o papel do Estado no setor. Esse modelo obriga as empresas do setor a melhorarem cada vez mais a qualidade de seu produto e, como requisito para este objetivo, devem fazer uso mais efetivo da enorme quantidade de dados operacionais que são armazenados em bancos de dados, provenientes da operação dos seus sistemas elétricos e que tem nas Usinas Hidrelétricas (UHE) a sua principal fonte de geração de energia. Uma das principais ferramentas para gerenciamento dessas usinas são os sistemas de Supervisão, Controle e Aquisição de Dados (Supervisory Control And Data Acquisition - SCADA). Assim, a imensa quantidade de dados acumulados nos bancos de dados pelos sistemas SCADA, muito provavelmente contendo informações relevantes, deve ser tratada para descobrir relações e padrões e assim ajudar na compreensão de muitos aspectos operacionais importantes e avaliar o desempenho dos sistemas elétricos de potência. O processo de Descoberta de Conhecimento em Banco de Dados (Knowledge Discovery in Database - KDD) é o processo de identificar, em grandes conjuntos de dados, padrões que sejam válidos, novos, úteis e compreensíveis, para melhorar o entendimento de um problema ou um procedimento de tomada de decisão. A Mineração de Dados (ou Data Mining) é o passo dentro do KDD que permite extrair informações úteis em grandes bases de dados. Neste cenário, o presente trabalho se propõe a realizar experimentos de mineração de dados nos dados gerados por sistemas SCADA em UHE, a fim de produzir informações relevantes para auxiliar no planejamento, operação, manutenção e segurança das hidrelétricas e na implantação da cultura da mineração de dados aplicada a estas usinas.

Catalogação, formas de representação e construções mentais

The cataloging process, is responsible for building systems consisting of sets of interconnected elements and combined forms of representation, creating tools to facilitate the flow of information in various informational environments. It presents structures that offer favorable conditions for access to formal codes of symbolic representation and to the channels of information transfer, performing with competence the decoding and encoding of codes and rules used to represent knowledge and to describe information, documents and resources. The objective of this paper is to present the challenge of transforming operational data into consistent information, the role of the forms of representation and the mental constructions for defining the memory markers of users of catalogs. It shows as results the memory markers indicated by three categories of users for the description of a book like resource and points to the need of collaborative and cooperative work in cataloging and to the need of catalog modelling focused on the user.

An Evaluation of Compression Schemes for Wireless Networks

Data gathering, either for event recognition or for monitoring applications is the primary intention for sensor network deployments. In many cases, data is acquired periodically and autonomously, and simply logged onto secondary storage (e.g. flash memory) either for delayed offline analysis or for on demand burst transfer. Moreover, operational data such as connectivity information, node and network state is typically kept as well. Naturally, measurement and/or connectivity logging comes at a cost. Space for doing so is limited. Finding a good representative model for the data and providing clever coding of information, thus data compression, may be a means to use the available space to its best. In this paper, we explore the design space for data compression for wireless sensor and mesh networks by profiling common, publicly available algorithms. Several goals such as a low overhead in terms of utilized memory and compression time as well as a decent compression ratio have to be well balanced in order to find a simple, yet effective compression scheme.

Review of the Performance of Residential PV systems in Belgium

The main objective of this paper is to review the state of the art of residential PV systems in Belgium by the analysis of the operational data of 993 installations. For that, three main questions are posed: how much energy do they produce? What level of performance is associated to their production? Which are the key parameters that most influence their quality? This work brings answers to these questions. A middling commercial PV system, optimally oriented, produces a mean annual energy of 892 kWh/kWp. As a whole, the orientation of PV generators causes energy productions to be some 6% inferior to optimally oriented PV systems. The mean performance ratio is 78% and the mean performance index is 85%. That is to say, the energy produced by a typical PV system in Belgium is 15% inferior to the energy produced by a very high quality PV system. Finally, on average, the real power of the PV modules falls 5% below its corresponding nominal power announced on the manufacturer's datasheet. Differences between real and nominal power of up to 16% have been detected.

Review of the Performance of Residential PV systems in France

The main objective of this paper is to review the state of the art of residential PV systems in France. This is done analyzing the operational data of 6868 installations. Three main questions are posed. How much energy do they produce? What level of performance is associated to their production? Which are the key parameters that most influence their quality? During the year 2010, the PV systems in France have produced a mean annual energy of 1163 kWh/kWp. As a whole, the orientation of PV generators causes energy productions to be some 7% inferior to optimally oriented PV systems. The mean Performance Ratio is 76% and the mean Performance Index is 85%. That is to say, the energy produced by a typical PV system in France is 15% inferior to the energy produced by a very high quality PV system. On average, the real power of the PV modules falls 4.9% below its corresponding nominal power announced on the manufacturer's datasheet. A brief analysis by PV modules technology has led to relevant observations about two technologies in particular. On the one hand, the PV systems equipped with heterojunction with intrinsic thin layer (HIT) modules show performances higher than average. On the other hand, the systems equipped with the copper indium (di)selenide (CIS) modules show a real power that is 16% lower than their nominal value.