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.

Bi-directional actions of estrogen on the renin-angiotensin system

Estrogen stimulates the renin-angiotensin system by augmenting both tissue and circulating levels of angiotensinogen and renin. We show, however, that angiotensin converting enzyme (ACE) activity in the circulation and in tissues is reduced in two animal models of postmenopausal chronic hormone replacement. We observed a reduction of ACE activity in association with a significant increase in plasma angiotensin I (Ang I) and hyperreninemia in ovariectomized monkeys treated with Premarin (conjugated equine estrogen) replacement for 30 months. Plasma angiotensin II (Ang II) levels were not increased in monkeys treated with estrogen, suggesting that the decrease in ACE curtailed the formation of the peptide. The Ang II/Ang I ratio, an in vivo index of ACE activity, was significantly reduced by estrogen treatment, further supporting the biochemical significance of estrogen's inhibition of ACE. In ovariectomized transgenic hypertensive (mRen2)27 rats submitted to estrogen replacement treatment for 3 weeks, ACE activity in plasma and tissue (aorta and kidney) and circulating Ang II levels were reduced, whereas circulating levels of angiotensin-(1-7) (Ang-(1-7) were increased. Ang-(1-7), the N-terminal fragment of Ang II, is a novel vasodilator and antihypertensive peptide. Thus, the net balance of these effects of estrogen on the renin-angiotensin vasoconstrictor/vasodilator system is to promote the antihypertensive effect.

Effect of practice and span length on the dual-task coordination executive test

The measure "mu", proposed as an index of the ability to coordinate concurrent box-crossing (BC) and digit-span (DS) tasks in the dual task (DT), should reflect the capacity of the executive component of the working memory system. We investigated the effect of practice in BC and of a change in the digit span on mu by adding previous practice trials in BC and diminishing, maintaining or increasing the digit sequence length. The mu behavior was evaluated throughout three trials of the test. Reported strategies in digit tasks were also analyzed. Subjects with diminished span showed the best performance in DT due to a stable performance in DS and BC in the single- and dual-task conditions. These subjects also showed a more stable performance throughout trials. Subjects with diminished span tended to employ effortless strategies, whereas subjects with increased span employed effort-requiring strategies and showed the lowest means of mu. Subjects with initial practice trials showed the best performance in BC and the most differentiated performance between the single- and dual-task conditions in BC. The correlation coefficient between the mu values obtained in the first and second trials was 0.814 for subjects with diminished span and practice trials in BC. It seems that the within-session practice in BC and the performance variability in DS affect the reliability of the index mu. To control these factors we propose the introduction of previous practice trials in BC and a modification of the current method to determine the digit sequence length. This proposal should contribute to the development of a more reliable method to evaluate the executive capacity of coordination in the dual-task paradigm.

The effects of positive end-expiratory pressure on respiratory system mechanics and hemodynamics in postoperative cardiac surgery patients

We prospectively evaluated the effects of positive end-expiratory pressure (PEEP) on the respiratory mechanical properties and hemodynamics of 10 postoperative adult cardiac patients undergoing mechanical ventilation while still anesthetized and paralyzed. The respiratory mechanics was evaluated by the inflation inspiratory occlusion method and hemodynamics by conventional methods. Each patient was randomized to a different level of PEEP (5, 10 and 15 cmH2O), while zero end-expiratory pressure (ZEEP) was established as control. PEEP of 15-min duration was applied at 20-min intervals. The frequency dependence of resistance and the viscoelastic properties and elastance of the respiratory system were evaluated together with hemodynamic and respiratory indexes. We observed a significant decrease in total airway resistance (13.12 ± 0.79 cmH2O l-1 s-1 at ZEEP, 11.94 ± 0.55 cmH2O l-1 s-1 (P<0.0197) at 5 cmH2O of PEEP, 11.42 ± 0.71 cmH2O l-1 s-1 (P<0.0255) at 10 cmH2O of PEEP, and 10.32 ± 0.57 cmH2O l-1 s-1 (P<0.0002) at 15 cmH2O of PEEP). The elastance (Ers; cmH2O/l) was not significantly modified by PEEP from zero (23.49 ± 1.21) to 5 cmH2O (21.89 ± 0.70). However, a significant decrease (P<0.0003) at 10 cmH2O PEEP (18.86 ± 1.13), as well as (P<0.0001) at 15 cmH2O (18.41 ± 0.82) was observed after PEEP application. Volume dependence of viscoelastic properties showed a slight but not significant tendency to increase with PEEP. The significant decreases in cardiac index (l min-1 m-2) due to PEEP increments (3.90 ± 0.22 at ZEEP, 3.43 ± 0.17 (P<0.0260) at 5 cmH2O of PEEP, 3.31 ± 0.22 (P<0.0260) at 10 cmH2O of PEEP, and 3.10 ± 0.22 (P<0.0113) at 15 cmH2O of PEEP) were compensated for by an increase in arterial oxygen content owing to shunt fraction reduction (%) from 22.26 ± 2.28 at ZEEP to 11.66 ± 1.24 at PEEP of 15 cmH2O (P<0.0007). We conclude that increments in PEEP resulted in a reduction of both airway resistance and respiratory elastance. These results could reflect improvement in respiratory mechanics. However, due to possible hemodynamic instability, PEEP should be carefully applied to postoperative cardiac patients.

Design, implementation, and evaluation of an online water quality monitoring system in Lake Saimaa, Finland

Environmental threats are growing nowadays, they became global issues. People around the world try to face these issues by two means: solving the current affected environs and preventing non-affected environs. This thesis describes the design, implementation, and evaluation of online water quality monitoring system in Lake Saimaa, Finland. The water quality in Lake Saimaa needs to be monitored in order to provide responsible bodies with valuable information which allows them to act fast in order to prevent any negative impact on the lake's environment. The objectives were to design a suitable system, implement the system in Lake Saimaa, and then to evaluate the applicability and reliability of such systems for this environment. The needs for the system were first isolated, and then the design, needed modifications, and the construction of the system took place. After that was the testing of the system in Lake Saimaa in two locations nearby Mikkeli city. The last step was to evaluate the whole system. The main results were that the application of online water quality monitoring systems in Lake Saimaa can benefit of many advantages such as reducing the required manpower, time and running costs. However, the point of unreliability of the exact measured values of some parameters is still the drawback of such systems which can be developed by using more advanced equipments with more sophisticated features specifically for the purpose of monitoring in the predefined location.

Translation into Brazilian Portuguese, cultural adaptation and evaluation of the reliability of the Disabilities of the Arm, Shoulder and Hand Questionnaire

The objective of the present study was to translate, adapt and validate a Brazilian Portuguese version of the Disabilities of the Arm, Shoulder and Hand (DASH) Questionnaire. The study was carried out in two steps. The first was to translate the DASH into Portuguese and to perform cultural adaptation and the second involved the determination of the reliability and validity of the DASH for the Brazilian population. For this purpose, 65 rheumatoid arthritis patients of either sex (according to the classification criteria of the American College of Rheumatology), ranging in age from 18 to 60 years and presenting no other diseases involving the upper limbs, were interviewed. The patients were selected consecutively at the rheumatology outpatient clinic of UNIFESP. The following results were obtained: in the first step (translation and cultural adaptation), all patients answered the questions. In the second step, Spearman's correlation coefficients for interobserver evaluation ranged from 0.762 to 0.995, values considered to be highly reliable. In addition, intraclass correlation coefficients ranged from 0.97 to 0.99, also highly reliable values. Spearman's correlation coefficients and the intraclass correlation coefficients obtained during intra-observer evaluation ranged from 0.731 to 0.937 and from 0.90 to 0.96, respectively, being highly reliable values. The Ritchie Index showed a weak correlation with Brazilian DASH scores, while the visual analog scale of pain showed a good correlation with DASH score. We conclude that the Portuguese version of the DASH is a reliable instrument.

Effects of caffeine on the electrophysiological, cognitive and motor responses of the central nervous system

Caffeine is the most consumed psychoactive substance in the world. The effects of caffeine have been studied using cognitive and motor measures, quantitative electroencephalography (qEEG) and event-related potentials. However, these methods are not usually employed in combination, a fact that impairs the interpretation of the results. The objective of the present study was to analyze changes in electrophysiological, cognitive and motor variables with the ingestion of caffeine, and to relate central to peripheral responses. For this purpose we recorded event-related potentials and eyes-closed, resting EEG, applied the Stroop test, and measured reaction time. Fifteen volunteers took caffeine (400 mg) or placebo in a randomized, crossover, double-blind design. A significant reduction of alpha absolute power over the entire scalp and of P300 latency at the Fz electrode were observed after caffeine ingestion. These results are consistent with a stimulatory effect of caffeine, although there was no change in the attention (Stroop) test or in reaction time. The qEEG seems to be the most sensitive index of the changes produced by caffeine in the central nervous system since it proved to be capable of detecting changes that were not evident in the tests of cognitive or motor performance.

The validity and 4-year test-retest reliability of the Brazilian version of the Eating Attitudes Test-26

In a cross-sectional study conducted four years ago to assess the validity of the Brazilian version of the Eating Attitudes Test-26 (EAT-26) for the identification of abnormal eating behaviors in a population of young females in Southern Brazil, 56 women presented abnormal eating behavior as indicated by the EAT-26 and the Edinburgh Bulimic Investigation Test. They were each matched for age and neighborhood to two normal controls (N = 112) and were re-assessed four years later with the two screening questionnaires plus the Composite International Diagnostic Interview (CIDI). The EAT results were then compared to diagnoses originating from the CIDI. To evaluate the temporal stability of the two screening questionnaires, a test-retest design was applied to estimate kappa coefficients for individual items. Given the prevalence of eating disorders of 6.2%, the CIDI psychiatry interview was applied to 161 women. Of these, 0.6% exhibited anorexia nervosa and 5.6%, bulimia nervosa (10 positive cases). The validity coefficients of the EAT were: 40% sensitivity, 84% specificity, and 14% positive predictive value. Cronbach's coefficient was 0.75. For each EAT item, the kappa index was not higher than 0.344 and the correlation coefficient was lower than 0.488. We conclude that the EAT-26 exhibited low validity coefficients for sensitivity and positive predictive value, and showed a poor temporal stability. It is reasonable to assume that these results were not influenced by the low prevalence of eating disorders in the community. Thus, the results cast doubts on the ability of the EAT-26 test to identify cases of abnormal eating behaviors in this population.

Analysis of renin-angiotensin-aldosterone system gene polymorphisms in resistant hypertension

Essential hypertension is a disease multifactorially triggered by genetic and environmental factors. The contribution of genetic polymorphisms of the renin-angiotensin-aldosterone system and clinical risk factors to the development of resistant hypertension was evaluated in 90 hypertensive patients and in 115 normotensive controls living in Southwestern Brazil. Genotyping for insertion/deletion of angiotensin-converting enzyme, angiotensinogen M235T, angiotensin II type 1 receptor A1166C, aldosterone synthase C344T, and mineralocorticoid receptor A4582C polymorphisms was performed by PCR, with further restriction analysis when required. The influence of genetic polymorphisms on blood pressure variation was assessed by analysis of the odds ratio, while clinical risk factors were evaluated by logistic regression. Our analysis indicated that individuals who carry alleles 235-T, 1166-A, 344-T, or 4582-C had a significant risk of developing resistant hypertension (P < 0.05). Surprisingly, when we tested individuals who carried the presumed risk genotypes A1166C, C344T, and A4582C we found that these genotypes were not associated with resistant hypertension. However, a gradual increase in the risk to develop resistant hypertension was detected when the 235-MT and TT genotypes were combined with one, two or three of the supposedly more vulnerable genotypes - A1166C (AC/AA), C344T (TC/TT) and A4582C (AC/CC). Analysis of clinical parameters indicated that age, body mass index and gender contribute to blood pressure increase (P < 0.05). These results suggest that unfavorable genetic renin-angiotensin-aldosterone system patterns and clinical risk variables may contribute to increasing the risk for the development of resistant hypertension in a sample of the Brazilian population.

Value perceptions of measurement and monitoring system customers

The value that the customer perceives from a supplier’s offering, impacts customer’s decision making and willingness to pay at the time of the purchase, and the overall satisfaction. Thus, for a business supplier, it is critical to understand their customers’ value perceptions. The objective of this thesis is to understand what measurement and monitoring system customers value, by examining their key purchasing criteria and perceived benefits. Theoretical part of this study consists on reviewing relevant literature on organizational buying behavior and customer perceived value. This study employs a qualitative interview research method. The empirical part of this research consisted of conducting 20 in-depth interviews with life science customers in USA and in Europe. Quality and technical features are the most important purchasing criteria, while product-related benefits seem to be the most important perceived benefits. At the marketing of the system, the emphasis should be at which regulations the system complies with, references of supplier’s prior experience, the reliability and usability of the system, and total costs. The benefits that should be emphasized are the better control of customer’s process, and the proof of customer’s product quality

Electromagnetic and thermal design of a multilevel converter with high power density and reliability

Electric energy demand has been growing constantly as the global population increases. To avoid electric energy shortage, renewable energy sources and energy conservation are emphasized all over the world. The role of power electronics in energy saving and development of renewable energy systems is significant. Power electronics is applied in wind, solar, fuel cell, and micro turbine energy systems for the energy conversion and control. The use of power electronics introduces an energy saving potential in such applications as motors, lighting, home appliances, and consumer electronics. Despite the advantages of power converters, their penetration into the market requires that they have a set of characteristics such as high reliability and power density, cost effectiveness, and low weight, which are dictated by the emerging applications. In association with the increasing requirements, the design of the power converter is becoming more complicated, and thus, a multidisciplinary approach to the modelling of the converter is required. In this doctoral dissertation, methods and models are developed for the design of a multilevel power converter and the analysis of the related electromagnetic, thermal, and reliability issues. The focus is on the design of the main circuit. The electromagnetic model of the laminated busbar system and the IGBT modules is established with the aim of minimizing the stray inductance of the commutation loops that degrade the converter power capability. The circular busbar system is proposed to achieve equal current sharing among parallel-connected devices and implemented in the non-destructive test set-up. In addition to the electromagnetic model, a thermal model of the laminated busbar system is developed based on a lumped parameter thermal model. The temperature and temperature-dependent power losses of the busbars are estimated by the proposed algorithm. The Joule losses produced by non-sinusoidal currents flowing through the busbars in the converter are estimated taking into account the skin and proximity effects, which have a strong influence on the AC resistance of the busbars. The lifetime estimation algorithm was implemented to investigate the influence of the cooling solution on the reliability of the IGBT modules. As efficient cooling solutions have a low thermal inertia, they cause excessive temperature cycling of the IGBTs. Thus, a reliability analysis is required when selecting the cooling solutions for a particular application. The control of the cooling solution based on the use of a heat flux sensor is proposed to reduce the amplitude of the temperature cycles. The developed methods and models are verified experimentally by a laboratory prototype.

Impacts of increased levels of wind penetration on the Electric Power System of the Åland Islands

The application of VSC-HVDC technology throughout the world has turned out to be an efficient solution regarding a large share of wind power in different power systems. This technology enhances the overall reliability of the grid by utilization of the active and reactive power control schemes which allows to maintain frequency and voltage on busbars of the end-consumers at the required level stated by the network operator. This master’s thesis is focused on the existing and planned wind farms as well as electric power system of the Åland Islands. The goal is to analyze the wind conditions of the islands and appropriately predict a possible production of the existing and planned wind farms with a help of WAsP software program. Further, to investigate the influence of increased wind power it is necessary to develop a simulation model of the electric grid and VSC-HVDC system in PSCAD and examine grid response to different wind power production cases with respect to the grid code requirements and ensure the stability of the power system.

Rheological behavior and color stability of anthocyanins from Merlot (Vitis vinifera L.) and Bordô (Vitis labrusca L.) grapes in a jam model system

Anthocyanins are the pigments responsible for the color of most red grapes and are easily degraded following various reaction mechanisms affected by oxygen, enzymes, pH, and temperature among other variables. In this study, a jam model system was developed using Merlot and Bordô grape extracts and polysaccharides (xanthan and locust bean gums) and different temperatures (45, 55 and 65 °C). The stability of the anthocyanin pigments and the rheological behavior of the jam model system were studied. For the determination of the stability, the half-life time and first-order reaction rate constants for the anthocyanin pigments were calculated. The rheological behavior was determined through the Power law model. The jam model system produced using a temperature of 45 °C showed the best results for the anthocyanin half-life time. The first-order reaction rate constants for the 45, 55, and 65 °C treatments were not significantly different among each other (p > 0.05). It was observed that with an increase in the jam model system temperature there was an increase in the index of consistency.

Hävittäjäohjaajan kognitiivisen kuormituksen tason mittaaminen NASA-Task Load Index ja Modified Cooper-Harper -mittareilla F/A-18 virtuaalisimulaattorissa

F/A-18-monitoimihävittäjän ohjaajan tehtävän kognitiiviset vaatimukset ovat korkeat. Kognitiivisen kuormituksen taso vaikuttaa hävittäjäohjaajan suoritustasoon ja subjektiivisiin tun-temuksiin. Yerkesin ja Dodsonin periaatteen mukaisesti erittäin matala tai erittäin korkea kuormituksen taso laskee suoritustasoa. Optimaalinen kuormituksen taso ja suoritustaso saa-vutetaan jossain ääripäiden välillä. Hävittäjäohjaajan kognitiivisen kuormituksen tasoon vaikuttaa lentotehtävän suorittamiseen vaadittava henkinen ponnistelu. Vaadittavan ponnistelun taso riippuu tehtävien vaatimustasosta ja määrästä, tehtäviin käytettävissä olevasta ajasta sekä yksilöllisistä ominaisuuksista. Tutkimuksessa mitattiin kognitiivisen kuormituksen tasoa subjektiivisen arvioinnin menetelmällä NASA-TLX (National Aeronautics and Space Administration - Task Load Index) ja MCH (Modified Cooper-Harper) -mittareilla. Tutkimuksessa selvitettiin mittareiden havaintoarvojen muutosta, sensitiivisyyttä ja yhdenmukaisuutta kognitiivisen kuormituksen tason muuttuessa. Tutkimuksen mittauksiin osallistui 35 Suomen ilmavoimien aktiivisessa palveluksessa olevaa F/A-18-monitoimihävittäjäohjaajaa. Koehenkilöiden lentotuntien keskiarvo F/A-18-monitoimihävittäjällä oli 598 tuntia ja keskihajonta 445 tuntia. Koehenkilöiden tehtävänä oli lentää F/A-18-virtuaalisimulaattorilla 11 ILS (Instrument Landing System) -mittarilähestymistä eri aloitusetäisyyksiltä kiitotien kynnyksestä. Kognitiivisesti kuormitta-van mittarilähestymistehtävän aikana kuormituksen tasoa nostettiin lisätehtävillä ja vähentä-mällä tehtäviin käytettävissä olevaa aikaa. Koehenkilöitä pyydettiin ponnistelemaan mahdollisimman paljon tehtävien suorittamisen aikana hyvän suoritustason ylläpitämiseksi. Tulosten perusteella mittareiden havaintoarvot muuttuivat kognitiivisen kuormituksen tason muuttuessa. Käytettävissä olevan ajan vaikutus kognitiivisen kuormituksen tasoon oli tilastollisesti erittäin merkitsevä. Mittarit olivat sensitiivisiä kognitiivisen kuormituksen tason muutokselle ja antoivat yhdenmukaisia havaintoarvoja.

BotCloud Detection System

Leveraging cloud services, companies and organizations can significantly improve their efficiency, as well as building novel business opportunities. Cloud computing offers various advantages to companies while having some risks for them too. Advantages offered by service providers are mostly about efficiency and reliability while risks of cloud computing are mostly about security problems. Problems with security of the cloud still demand significant attention in order to tackle the potential problems. Security problems in the cloud as security problems in any area of computing, can not be fully tackled. However creating novel and new solutions can be used by service providers to mitigate the potential threats to a large extent. Looking at the security problem from a very high perspective, there are two focus directions. Security problems that threaten service user’s security and privacy are at one side. On the other hand, security problems that threaten service provider’s security and privacy are on the other side. Both kinds of threats should mostly be detected and mitigated by service providers. Looking a bit closer to the problem, mitigating security problems that target providers can protect both service provider and the user. However, the focus of research community mostly is to provide solutions to protect cloud users. A significant research effort has been put in protecting cloud tenants against external attacks. However, attacks that are originated from elastic, on-demand and legitimate cloud resources should still be considered seriously. The cloud-based botnet or botcloud is one of the prevalent cases of cloud resource misuses. Unfortunately, some of the cloud’s essential characteristics enable criminals to form reliable and low cost botclouds in a short time. In this paper, we present a system that helps to detect distributed infected Virtual Machines (VMs) acting as elements of botclouds. Based on a set of botnet related system level symptoms, our system groups VMs. Grouping VMs helps to separate infected VMs from others and narrows down the target group under inspection. Our system takes advantages of Virtual Machine Introspection (VMI) and data mining techniques.