Improving reporting management with relational database management system

Data management consists of collecting, storing, and processing the data into the format which provides value-adding information for decision-making process. The development of data management has enabled of designing increasingly effective database management systems to support business needs. Therefore as well as advanced systems are designed for reporting purposes, also operational systems allow reporting and data analyzing. The used research method in the theory part is qualitative research and the research type in the empirical part is case study. Objective of this paper is to examine database management system requirements from reporting managements and data managements perspectives. In the theory part these requirements are identified and the appropriateness of the relational data model is evaluated. In addition key performance indicators applied to the operational monitoring of production are studied. The study has revealed that the appropriate operational key performance indicators of production takes into account time, quality, flexibility and cost aspects. Especially manufacturing efficiency has been highlighted. In this paper, reporting management is defined as a continuous monitoring of given performance measures. According to the literature review, the data management tool should cover performance, usability, reliability, scalability, and data privacy aspects in order to fulfill reporting managements demands. A framework is created for the system development phase based on requirements, and is used in the empirical part of the thesis where such a system is designed and created for reporting management purposes for a company which operates in the manufacturing industry. Relational data modeling and database architectures are utilized when the system is built for relational database platform.

Evaluation of the main energy scenarios for the global energy transition

Energy scenarios are used as a tool to examine credible future states and pathways. The one who constructs a scenario defines the framework in which the possible outcomes exist. The credibility of a scenario depends on its compatibility with real world experiences, and on how well the general information of the study, methodology, and originality and processing of data are disclosed. In the thesis, selected global energy scenarios’ transparency and desirability from the society’s point of view were evaluated based on literature derived criteria. The global energy transition consists of changes to social conventions and economic development in addition to technological development. Energy solutions are economic and ethical choices due to far-reaching impacts of energy decision-making. Currently the global energy system is mostly based on fossil fuels, which is unsustainable over the long-term due to various reasons: negative climate change impacts, negative health impacts, depletion of fossil fuel reserves, resource-use conflicts with water management and food supply, loss of biodiversity, challenge to preserve ecosystems and resources for future generations, and inability of fossil fuels to provide universal access to modern energy services. Nuclear power and carbon capture and storage cannot be regarded as sustainable energy solutions due to their inherent risks and required long-term storage. The energy transition is driven by a growing energy demand, decreasing costs of renewables, modularity and scalability of renewable technologies, macroeconomic benefits of using renewables, investors’ risk awareness, renewable energy related attractive business opportunities, almost even distribution of solar and wind resources on the planet, growing awareness of the planet’s environmental status, environmental movements and tougher environmental legislation. Many of the investigated scenarios identified solar and wind power as a backbone for future energy systems. The scenarios, in which the solar and wind potentials were deployed in largest scale, met best the set out sustainability criteria. In future research, energy scenarios’ transparency can be improved by better disclosure on who has ordered the study, clarifying the funding, clearly referencing to used sources and indicating processed data, and by exploring how variations in cost assumptions and deployment of technologies influence on the outcomes of the study.

Les habiletés olfactives des aveugles de naissance : organisation anatomo-fonctionnelle et aspects comportementaux

La littérature décrit certains phénomènes de réorganisation physiologique et fonctionnelle dans le cerveau des aveugles de naissance, notamment en ce qui a trait au traitement de l’information tactile et auditive. Cependant, le système olfactif des aveugles n’a reçu que très peu d’attention de la part des chercheurs. Le but de cette étude est donc de comprendre comment les aveugles traitent l’information olfactive au niveau comportemental et d’investiguer les substrats neuronaux impliqués dans ce processus. Puisque, en règle générale, les aveugles utilisent leurs sens résiduels de façon compensatoire et que le système olfactif est extrêmement plastique, des changements au niveau de l’organisation anatomo-fonctionnelle pourraient en résulter. Par le biais de méthodes psychophysiques et d’imagerie cérébrale (Imagerie par Résonance Magnétique fonctionnelle-IRMf), nous avons investigué les substrats anatomo-fonctionnels sollicités par des stimuli olfactifs. Nous avons trouvé que les aveugles ont un seuil de détection plus bas que les voyants, mais que leur capacité à discriminer et identifier des odeurs est similaire au groupe contrôle. Ils ont aussi plus conscience de l’environnement olfactif. Les résultats d’imagerie révèlent un signal BOLD plus intense dans le cortex orbitofrontal droit, le thalamus, l’hippocampe droit et le cortex occipital lors de l’exécution d’une tâche de détection d’odeur. Nous concluons que les individus aveugles se fient d’avantage à leur sens de l’odorat que les voyants afin d’évoluer dans leur environnement physique et social. Cette étude démontre pour la première fois que le cortex visuel des aveugles peut être recruté par des stimuli olfactifs, ce qui prouve que cette région assume des fonctions multimodales.

The Jurisprudence of Surveillance:a Critical Look at the Laws of Intimacy

Affirmer que les citoyens des démocraties occidentales sont l’objet d’une surveillance systématique efficace et à grande échelle a de quoi provoquer une réaction incrédule. Démagogie, diront certains. Pourtant, les progrès réalisés dans les technologies de collecte, de traitement et de stockage d’information forcent une réflexion sur cette hypothèse. Il a été souligné justement que les coûts élevés liés aux moyens rudimentaires employés par les polices secrètes d’antan endiguaient en quelque sorte la menace. Les filatures, les infiltrations, les rapts nocturnes de dissidents pêchaient par manque de subtilité. Au contraire, le génie des techniques modernes vient de ce qu’elles n’entravent pas le quotidien des gens. Mais au-delà du raffinement technique, le contrôle panoptique de la masse atteint un sommet d’efficience dès lors que celle-ci est amenée à y consentir. Comme le faisait remarquer le professeur Raab : « [TRADUCTION] La surveillance prospère naturellement dans les régimes autoritaires qui ne s’exposent pas au débat public ni à la critique. Lorsqu’elle est utilisée dans des régimes dits démocratiques, elle est légitimée et circonscrite par des arguments de nécessité ou de justifications spéciales, tout comme la censure »[1]. Or, le droit, en tant que discours de rationalité, accomplit savamment ce travail de légitimation. C’est dans cet esprit qu’une analyse radicale des règles de droit encadrant le droit à la vie privée apporte une lucidité nouvelle sur notre faux sentiment de sécurité.

Activité électrocorticale lors du traitement de stimuli émotionnels et différences sexuelles associées à la schizophrénie

D’importantes faiblesses dans l'expérience, l'expression et la reconnaissance des émotions chez les patients souffrant de schizophrénie ont été relativement bien documentées au fil des années. Par ailleurs, les différences sexuelles dans le comportement et l'activité cérébrale associée aux processus émotionnels ont été rapportées dans la population générale. Il apparaît donc surprenant que si peu ait été publié afin d’améliorer notre compréhension des différences sexuelles dans la schizophrénie. La présente étude vise à comparer les différences dans le mode de fonctionnement d’hommes et de femmes atteints de schizophrénie. Il s’agit, avec cette population, de comprendre la réponse comportementale et électrocorticale associés au traitement des images émotionnelles. Ces données ont été enregistrées à l’aide des potentiels évoqués cognitifs (PÉC), et des temps de réponses lors du visionnement passif d’images émotionnelles. L’activation des composantes P200, N200 antérieure et P300 a été comparée chez 18 patients avec une schizophrénie stabilisée (9 femmes et 9 hommes) et 24 participants formant un groupe contrôle (13 femmes et 11 hommes) sans problème psychiatrique. L’analyse des PÉC a globalement révélé que la valence et l’activation émotionnelle influencent les composantes précoces de même que les composantes tardives de façon indépendante, ce qui prouve l’importance d’investiguer ces deux dimensions émotionnelles sur plusieurs composantes. Une découverte d’intérêt réside dans l’observation de différences sexuelles qui entrent en interaction avec le groupe, à différentes latences et attribuées tant à la valence qu’à l’activation. De plus, les données provenant des hormones gonadiques montrent que la progestérone pourrait avoir un impact fonctionnel sur les processus de traitement des émotions tant chez les femmes que chez les hommes. Cependant, d’autres études sont nécessaires pour pouvoir comprendre davantage le rôle des hormones gonadiques en neuropsychopathologie.

Derivation of an Efficient Rule System Pattern Matcher

Formalizing algorithm derivations is a necessary prerequisite for developing automated algorithm design systems. This report describes a derivation of an algorithm for incrementally matching conjunctive patterns against a growing database. This algorithm, which is modeled on the Rete matcher used in the OPS5 production system, forms a basis for efficiently implementing a rule system. The highlights of this derivation are: (1) a formal specification for the rule system matching problem, (2) derivation of an algorithm for this task using a lattice-theoretic model of conjunctive and disjunctive variable substitutions, and (3) optimization of this algorithm, using finite differencing, for incrementally processing new data.

La Comunidad geospacial y el acceso a datos oceanográficos

Nowadays, Oceanographic and Geospatial communities are closely related worlds. The problem is that they follow parallel paths in data storage, distributions, modelling and data analyzing. This situation produces different data model implementations for the same features. While Geospatial information systems have 2 or 3 dimensions, the Oceanographic models uses multidimensional parameters like temperature, salinity, streams, ocean colour... This implies significant differences between data models of both communities, and leads to difficulties in dataset analysis for both sciences. These troubles affect directly to the Mediterranean Institute for Advanced Studies ( IMEDEA (CSIC-UIB)). Researchers from this Institute perform intensive processing with data from oceanographic facilities like CTDs, moorings, gliders… and geospatial data collected related to the integrated management of coastal zones. In this paper, we present an approach solution based on THREDDS (Thematic Real-time Environmental Distributed Data Services). THREDDS allows data access through the standard geospatial data protocol Web Coverage Service, inside the European project (European Coastal Sea Operational Observing and Forecasting system). The goal of ECOOP is to consolidate, integrate and further develop existing European coastal and regional seas operational observing and forecasting systems into an integrated pan- European system targeted at detecting environmental and climate changes

Diagnosing Patients Combining Principal Components Analysis and Case Based Reasoning

This paper addresses the application of a PCA analysis on categorical data prior to diagnose a patients data set using a Case-Based Reasoning (CBR) system. The particularity is that the standard PCA techniques are designed to deal with numerical attributes, but our medical data set contains many categorical data and alternative methods as RS-PCA are required. Thus, we propose to hybridize RS-PCA (Regular Simplex PCA) and a simple CBR. Results show how the hybrid system produces similar results when diagnosing a medical data set, that the ones obtained when using the original attributes. These results are quite promising since they allow to diagnose with less computation effort and memory storage

Desarrollo de una aplicación de computador para analizar parámetros estadísticos genético-poblacionales de microsatélites en poblaciones humanas

La información y los datos genéticos que emanan hoy de las investigaciones del genoma humano demandan el desarrollo de herramientas informáticas capaces de procesar la gran cantidad de información disponible. La mayor cantidad de datos genéticos es el resultado de equipos que realizan el análisis simultáneo de cientos o miles de polimorfismos o variaciones genéticas, de nuevas técnicas de laboratorio de mayor rendimiento que, en conjunto, ofrecen una mayor disponibilidad de información en un corto espacio de tiempo. Esta problemática conduce a la necesidad de desarrollar nuevas herramientas informáticas capaces de lidiar con este mayor volumen de datos genéticos. En el caso de la genética de poblaciones, a pesar de que existen herramientas informáticas que permiten procesar y facilitar el análisis de los datos, estas tienen limitaciones como la falta de conocimiento de los usuarios de algunos lenguajes de programación para alimentar la información y otras herramientas informáticas no realizan todas las estimaciones que se requieren y otros presentan limitaciones en cuanto al número de datos que pueden incorporar o manejar. En algunos casos hay redundancia al tener que usarse dos o más herramientas para poder procesar un conjunto de datos de información genética. El presente trabajo tiene por objetivo el desarrollo de una herramienta informática basada en aplicaciones de computador comunes, en este caso Microsoft Excel® y que resuelva todos los problemas y las limitaciones descritas antes. El desarrollo del conjunto de subprogramas que constituyen a Lustro; permiten superar lo anterior, presentar los resultados en un ambiente sencillo, conocido y fácil de operar, simplificando de esta forma el proceso de adaptación del usuario del programa, sin entrenamiento previo, obteniéndose en corto tiempo el procesamiento de la información genética de interés.

Evaluation of the effectiveness of an organization in the field of brand perception using a computer agent-based simulation system

Este proyecto de investigación busca usar un sistema de cómputo basado en modelación por agentes para medir la percepción de marca de una organización en una población heterogénea. Se espera proporcionar información que permita dar soluciones a una organización acerca del comportamiento de sus consumidores y la asociada percepción de marca. El propósito de este sistema es el de modelar el proceso de percepción-razonamiento-acción para simular un proceso de razonamiento como el resultado de una acumulación de percepciones que resultan en las acciones del consumidor. Este resultado definirá la aceptación de marca o el rechazo del consumidor hacia la empresa. Se realizó un proceso de recolección información acerca de una organización específica en el campo de marketing. Después de compilar y procesar la información obtenida de la empresa, el análisis de la percepción de marca es aplicado mediante procesos de simulación. Los resultados del experimento son emitidos a la organización mediante un informe basado en conclusiones y recomendaciones a nivel de marketing para mejorar la percepción de marca por parte de los consumidores.

O papel do farmacêutico no acompanhamento de doentes com asma

A asma é uma doença inflamatória crónica das vias aéreas que, em indivíduos susceptíveis, origina sintomas característicos. Dada a prevalência, características da doença, utilização segura e correcta dos medicamentos e adesão à terapêutica, é de extrema importância incentivar os profissionais de saúde, doentes e suas famílias a tomarem medidas que permitam um melhor controlo da doença, de forma a obter ganhos em saúde. Assim, foi realizado um estudo descritivo envolvendo os doentes asmáticos da farmácia Santo António, tendo por base um questionário que avaliou o grau de controlo da asma, bem como o conhecimento sobre a doença e cuidados a ter. Após tratamento dos dados, foi possível determinar que 35% dos asmáticos em questão apresentam asma não controlada ou parcialmente controlada, 43% não conhece medidas não farmacológicas relativas a esta patologia e 12% não usa correctamente a medicação prescrita. Os resultados do estudo indicam que é necessário que o farmacêutico intervenha junto da população asmática, nomeadamente através de acções de formação sobre a utilização correcta dispositivos de inalação (no que diz respeito à importância da utilização de medicação SOS apenas nas situações adequadas e não como medicação diária), informação sobre medidas não farmacológicas (que em alguns doentes podem ser um factor decisivo no controlo da doença) e importância da monitorização do controlo da patologia pelo próprio doente.

Influência das estratégias de avaliação contínua no rendimento escolar dos alunos

A avaliação contínua é um importante instrumento à disposição do professor. O presente trabalho estuda a medida em que um conjunto de conteúdos ministrados no 10º ano do ensino secundário, acompanhados de procedimentos baseados na avaliação contínua, pode contribuir para melhorar o desempenho e a aprendizagem relativamente a quatro elementos químicos da tabela periódica, nomeadamente o oxigénio, o hidrogénio, o carbono e o azoto. O trabalho será realizado em três turmas do ensino secundário. Os conteúdos programáticos relativos à “Tabela periódica-organização dos elementos químicos” a desenvolver nas três turmas serão os mesmos, mas ministrados por duas docentes distintas. Em duas das turmas, e durante quatro aulas, serão elaborados pequenos testes no início de cada aula sobre a matéria lecionada na aula anterior, que serão recolhidos e classificados pela docente por forma a averiguar uma esperada evolução. Nestas turmas as aprendizagens relativas a estes testes serão avaliadas de forma contínua. Na outra turma, turma de controlo, o programa será tratado da forma tradicional. No final proceder-se-á ao tratamento dos dados recolhidos e à elaboração das conclusões e de possíveis recomendações.

Scalability of efficient parallel K-Means

Clustering is defined as the grouping of similar items in a set, and is an important process within the field of data mining. As the amount of data for various applications continues to increase, in terms of its size and dimensionality, it is necessary to have efficient clustering methods. A popular clustering algorithm is K-Means, which adopts a greedy approach to produce a set of K-clusters with associated centres of mass, and uses a squared error distortion measure to determine convergence. Methods for improving the efficiency of K-Means have been largely explored in two main directions. The amount of computation can be significantly reduced by adopting a more efficient data structure, notably a multi-dimensional binary search tree (KD-Tree) to store either centroids or data points. A second direction is parallel processing, where data and computation loads are distributed over many processing nodes. However, little work has been done to provide a parallel formulation of the efficient sequential techniques based on KD-Trees. Such approaches are expected to have an irregular distribution of computation load and can suffer from load imbalance. This issue has so far limited the adoption of these efficient K-Means techniques in parallel computational environments. In this work, we provide a parallel formulation for the KD-Tree based K-Means algorithm and address its load balancing issues.

Information servers, present and future

Mainframes, corporate and central servers are becoming information servers. The requirement for more powerful information servers is the best opportunity to exploit the potential of parallelism. ICL recognized the opportunity of the 'knowledge spectrum' namely to convert raw data into information and then into high grade knowledge. Parallel Processing and Data Management Its response to this and to the underlying search problems was to introduce the CAFS retrieval engine. The CAFS product demonstrates that it is possible to move functionality within an established architecture, introduce a different technology mix and exploit parallelism to achieve radically new levels of performance. CAFS also demonstrates the benefit of achieving this transparently behind existing interfaces. ICL is now working with Bull and Siemens to develop the information servers of the future by exploiting new technologies as available. The objective of the joint Esprit II European Declarative System project is to develop a smoothly scalable, highly parallel computer system, EDS. EDS will in the main be an SQL server and an information server. It will support the many data-intensive applications which the companies foresee; it will also support application-intensive and logic-intensive systems.

Dynamic load balancing in parallel KD-tree k-means

One among the most influential and popular data mining methods is the k-Means algorithm for cluster analysis. Techniques for improving the efficiency of k-Means have been largely explored in two main directions. The amount of computation can be significantly reduced by adopting geometrical constraints and an efficient data structure, notably a multidimensional binary search tree (KD-Tree). These techniques allow to reduce the number of distance computations the algorithm performs at each iteration. A second direction is parallel processing, where data and computation loads are distributed over many processing nodes. However, little work has been done to provide a parallel formulation of the efficient sequential techniques based on KD-Trees. Such approaches are expected to have an irregular distribution of computation load and can suffer from load imbalance. This issue has so far limited the adoption of these efficient k-Means variants in parallel computing environments. In this work, we provide a parallel formulation of the KD-Tree based k-Means algorithm for distributed memory systems and address its load balancing issue. Three solutions have been developed and tested. Two approaches are based on a static partitioning of the data set and a third solution incorporates a dynamic load balancing policy.