Traducción técnica del capítulo III del libro Advanced Data Warehouse design: from conventional to spatial and temporal applications

The proposal to work on this final project came after several discussions held with Dr. Elzbieta Malinowski Gadja, who in 2008 published the book entitled Advanced Data Warehouse Design: From Conventional to Spatial and Temporal Applications (Data-Centric Systems and Applications). The project was carried out under the technical supervision of Dr. Malinowski and the direct beneficiary was the University of Costa Rica (UCR) where Dr. Malinowski is a professor at the Department of Computer Science and Informatics. The purpose of this project was twofold: First, to translate chapter III of said book with the intention of generating educational material for the use of the UCR and, second, to venture in the field of technical translation related to data warehouse. For the first component, the goal was to generate a final product that would eventually serve as an educational tool for the post-graduate courses of the UCR. For the second component, this project allowed me to acquire new skills and put into practice techniques that have helped me not only to perfom better in my current job as an Assistant Translator of the Inter-American BAnk (IDB), but also to use them in similar projects. The process was lenggthy and required torough research and constant communication with the author. The investigation focused on the search of terms and definitions to prepare the glossary, which was the basis to start the translation project. The translation process itself was carried out by phases, so that comments and corrections by the author could be taken into account in subsequent stages. Later, based on the glossary and the translated text, illustrations had been created in the Visio software were translated. In addition to the technical revision by the author, professor Carme Mangiron was in charge of revising the non-technical text. The result was a high-quality document that is currently used as reference and study material by the Department of Computer Science and Informatics of Costa Rica.

Success factors of customer and supplier master data system

Especially in global enterprises, key data is fragmented in multiple Enterprise Resource Planning (ERP) systems. Thus the data is inconsistent, fragmented and redundant across the various systems. Master Data Management (MDM) is a concept, which creates cross-references between customers, suppliers and business units, and enables corporate hierarchies and structures. The overall goal for MDM is the ability to create an enterprise-wide consistent data model, which enables analyzing and reporting customer and supplier data. The goal of the study was defining the properties and success factors of a master data system. The theoretical background was based on literature and the case consisted of enterprise specific needs and demands. The theoretical part presents the concept, background, and principles of MDM and then the phases of system planning and implementation project. Case consists of background, definition of as is situation, definition of project, evaluation criterions and concludes the key results of the thesis. In the end chapter Conclusions combines common principles with the results of the case. The case part ended up dividing important factors of the system in success factors, technical requirements and business benefits. To clarify the project and find funding for the project, business benefits have to be defined and the realization has to be monitored. The thesis found out six success factors for the MDM system: Well defined business case, data management and monitoring, data models and structures defined and maintained, customer and supplier data governance, delivery and quality, commitment, and continuous communication with business. Technical requirements emerged several times during the thesis and therefore those can’t be ignored in the project. Conclusions chapter goes through these factors on a general level. The success factors and technical requirements are related to the essentials of MDM: Governance, Action and Quality. This chapter could be used as guidance in a master data management project.

Spectrophotometric study of the chromium(III)/azide system in the ultraviolet region and its analytical application

A sensitive and alternative method for the spectrophotometric determination of chromium(III) based on the formation of chromium(III)/azide complexes was established by investigating a new band in the ultraviolet region. The best experimental conditions for the analytical determination of this metallic ion were: ligand and perchloric acid analytical concentration = 493 and 12.0 mmol L-1, respectively; aqueous medium; T = 25.0 ºC; contact time = 1 hour. The maximum molar absorptivity coefficient occurred at 287 nm (average 1.481 ± 0.008 ´ 10(4) L mol-1 cm-1), leading to the determination of metal ion concentrations one hundred times lower than the ones formerly determined in the visible region. The system obeys Beer's Law and is suitable for chromium determination in the 0.702-2.81 mg L-1 concentration range (15-65% T, 1.00 cm-width quartz cells). Analytical applications of the current method were tested with a nutritional supplement containing chromium. Results were compared with those obtained with atomic absorption spectrometry.

Role of culture in knowledge transfer and sharing - case ERP implementation

The main objective of this study was to examine how culture influences knowledge transfer and sharing within multicultural ERP project implementation in China. The main interest was to explain how national culture and knowledge are linked by understanding how culture influences knowledge transfer and sharing in a project organization. The other objective of this work was to discuss what Chinese cultural characteristic inhibit and en-hance knowledge sharing in ERP project. The perspective of this study was qualitative and the empirical material was collected from theme interviews among Stora Enso employees. Conclusion of this thesis is that Finns have a very direct style of communication and sharing knowledge whereas Chinese respect face shaving and indirect communication. Another conclusion is that knowledge sharing does not “just happen”, it is needed that project members understand national culture to get all project members commitment to project. In China most important is understand local business processes and understand role of trust and guanxi.

Carbon footprint as part of a company’s external environmental communication

The aim of this thesis was to find out how the carbon footprint calculations can be utilized in the company’s external environmental communication, what is the demand for carbon footprint from the market, and how the other actors in the forest industry have approached the issue. The aim was to recognize the best practises to communicate carbon footprints and to find possibilities to extend the UPM-Kymmene Wood Oy’s mill specific carbon footprints. This research included a literature review, an inquiry to the UPM-Kymmene Wood Oy’s sales offices, and Internet survey concerning the external environmental communication in the forest industry and three small case studies based on mill specific parameters. The inquiry to the sales offices showed that the carbon footprint is not yet a common demand from the customers in the wood product sector. In addition, the Internet survey showed that generally in the forest industry, not much has been done concerning carbon footprint communication so far. The biggest challenge in carbon footprint communication is the variation in the knowledge level of the receivers. In addition btob and btoc communication situations demand a different approach to the issue. Carbon profile brochures developed in the company can be seen as suitable for btob communication situations. Case studies have shown that the contribution of final product transport to the overall carbon footprint was significant. It was recommended to include post mill transport in the carbon footprint information supplied to the btob customers. When discussing environmental communication on a general level it can be stated that a good external environmental communication is based on facts, is open and proactive and takes into account the needs of the receiver. However, the openness and the quality of external environmental communication are essentially strategic decisions. The significance of internal communication as well as the knowhow in the communication and marketing networks play a major role in achieving success in external environmental communication. Carbon footprints are only one part of good balanced external environmental communication. One specific environmental feature like carbon footprint should not be over emphasized to the detriment of other important environmental aspects.

Customer-related skills and capabilities in knowledge-intensive business services

The roles of knowledge and customer involvement form distinct features in providing knowledge-intensive business services. The objective of this study was to investigate the customer-related skills and capabilities of knowledge-intensive business services. The research was carried out as case study, involving two polar cases. The other case represented customized services, and the other standardized services. The research method was qualitative, and included focus group workshops, individual interviews and a survey. The capabilities of business services have been mainly studied on organizational level. This study provides valuable insight into the role of individual skills as a part of capabilities of knowledge-intensive business services. According to this study, the most important capabilities are related to acquiring and integrating of knowledge, resource management, managing the customer’s role as a co-producer of the service, and active and effective communication. The study indicates that the level of tacit knowledge is high in the needed individual skills. Based on the study, the needed capabilities and skills are affected by the level of customization of the service, the demand for customer knowledge, the demand for consultation and the stage of the service providing.

Communicative and Anticipatory Decision-Making Supported by Bayesian Networks

The purpose of this research is to draw up a clear construction of an anticipatory communicative decision-making process and a successful implementation of a Bayesian application that can be used as an anticipatory communicative decision-making support system. This study is a decision-oriented and constructive research project, and it includes examples of simulated situations. As a basis for further methodological discussion about different approaches to management research, in this research, a decision-oriented approach is used, which is based on mathematics and logic, and it is intended to develop problem solving methods. The approach is theoretical and characteristic of normative management science research. Also, the approach of this study is constructive. An essential part of the constructive approach is to tie the problem to its solution with theoretical knowledge. Firstly, the basic definitions and behaviours of an anticipatory management and managerial communication are provided. These descriptions include discussions of the research environment and formed management processes. These issues define and explain the background to further research. Secondly, it is processed to managerial communication and anticipatory decision-making based on preparation, problem solution, and solution search, which are also related to risk management analysis. After that, a solution to the decision-making support application is formed, using four different Bayesian methods, as follows: the Bayesian network, the influence diagram, the qualitative probabilistic network, and the time critical dynamic network. The purpose of the discussion is not to discuss different theories but to explain the theories which are being implemented. Finally, an application of Bayesian networks to the research problem is presented. The usefulness of the prepared model in examining a problem and the represented results of research is shown. The theoretical contribution includes definitions and a model of anticipatory decision-making. The main theoretical contribution of this study has been to develop a process for anticipatory decision-making that includes management with communication, problem-solving, and the improvement of knowledge. The practical contribution includes a Bayesian Decision Support Model, which is based on Bayesian influenced diagrams. The main contributions of this research are two developed processes, one for anticipatory decision-making, and the other to produce a model of a Bayesian network for anticipatory decision-making. In summary, this research contributes to decision-making support by being one of the few publicly available academic descriptions of the anticipatory decision support system, by representing a Bayesian model that is grounded on firm theoretical discussion, by publishing algorithms suitable for decision-making support, and by defining the idea of anticipatory decision-making for a parallel version. Finally, according to the results of research, an analysis of anticipatory management for planned decision-making is presented, which is based on observation of environment, analysis of weak signals, and alternatives to creative problem solving and communication.

Exploration and Design of Power-Efficient Networked Many-Core Systems

Multiprocessing is a promising solution to meet the requirements of near future applications. To get full benefit from parallel processing, a manycore system needs efficient, on-chip communication architecture. Networkon- Chip (NoC) is a general purpose communication concept that offers highthroughput, reduced power consumption, and keeps complexity in check by a regular composition of basic building blocks. This thesis presents power efficient communication approaches for networked many-core systems. We address a range of issues being important for designing power-efficient manycore systems at two different levels: the network-level and the router-level. From the network-level point of view, exploiting state-of-the-art concepts such as Globally Asynchronous Locally Synchronous (GALS), Voltage/ Frequency Island (VFI), and 3D Networks-on-Chip approaches may be a solution to the excessive power consumption demanded by today’s and future many-core systems. To this end, a low-cost 3D NoC architecture, based on high-speed GALS-based vertical channels, is proposed to mitigate high peak temperatures, power densities, and area footprints of vertical interconnects in 3D ICs. To further exploit the beneficial feature of a negligible inter-layer distance of 3D ICs, we propose a novel hybridization scheme for inter-layer communication. In addition, an efficient adaptive routing algorithm is presented which enables congestion-aware and reliable communication for the hybridized NoC architecture. An integrated monitoring and management platform on top of this architecture is also developed in order to implement more scalable power optimization techniques. From the router-level perspective, four design styles for implementing power-efficient reconfigurable interfaces in VFI-based NoC systems are proposed. To enhance the utilization of virtual channel buffers and to manage their power consumption, a partial virtual channel sharing method for NoC routers is devised and implemented. Extensive experiments with synthetic and real benchmarks show significant power savings and mitigated hotspots with similar performance compared to latest NoC architectures. The thesis concludes that careful codesigned elements from different network levels enable considerable power savings for many-core systems.

Coercion, Perceived Care and Quality of Life Among Patients in Psychiatric Hospitals

The goals of the study were to describe patients’ perceptions of care after experiencing seclusion/restraint and their quality of life. The goal was moreover to identify methodological challenges related to studies from the perspective of coerced patients. The study was conducted in three phases between September 2008 and April 2012. In the first phase, the instrument Secluded/ Restrained Patients’ Perception of their Treatment (SR-PPT) was developed and validated in Japan in cooperation with a Finnish research group (n = 56). Additional data were collected over one year from secluded/restrained patients using the instrument (n = 90). In the second phase, data were collected during the discharge process (n = 264). In the third phase, data were collected from electronic databases. Methodological and ethical issues were reviewed (n = 32) using systematic review method. Patients perceived that co-operation with the staff was poor; patients’ opinions were not taken into account, treatment targets collated and treatment methods were seen in different ways. Patients also felt that their concerns were not well enough understood. However, patients received getting nurses’ time. In particular, seclusion/restraint was considered unnecessary. The patients felt that they benefited from the isolation in treating their problems more than they needed it, even if the benefit was seen to be minor. Patients treated on forensic wards rated their treatment and care significantly lower than in general units. During hospitalization secluded/restrained patients evaluated their quality of life, however, better than did non-secluded/restrained patients. However, no conclusion is drawn to the effect that the better quality of life assessment is attributable to the seclusion/restraint because patients’ treatment period after the isolation was long and because of many other factors, as rehabilitation, medication, diagnostic differences, and adaptation. According to the systematic mixed studies review variation between study designs was found to be a methodological challenge. This makes comparison of the results more difficult. A research ethical weakness is conceded as regards descriptions of the ethical review process (44 %) and informed consent (32 %). It can be concluded that patients in psychiatric hospital care and having a voice as an equal expert require special attention to clinical nursing, decision-making and service planning. Patients and their family members will be consulted in plans of preventive and alternative methods for seclusion and restraint. The study supports the theory that in ethical decision-making situations account should be taken of medical indications, in addition to the patients’ preferences, the effect of treatment on quality of life, and this depends on other factors. The connection between treatment decisions and a patient’s quality of life should be evaluated more structurally in practice. Changing treatment culture towards patients’ involvement will support daily life in nursing and service planning taking into account improvements in patients’ quality of life.

Social networks and networking facilitating internationalization: Experiences of two Finnish fashion companies

Background: Fashion is a dynamic and creative industry where larger retailers are enjoying international success. Small businesses however are struggling in the face of international expansion, as they lack the necessary resources and managerial know-how. The Finnish fashion industry has neither been able to develop the industry environment to support small and micro firms nor has Finland relevant finance or public domains, such as, seen in other Nordic countries. Networking has been recognized to facilitate organizational growth and international expansion in industries such as manufacturing and high technology. It has enabled smaller companies to gain resources, knowledge and experiences otherwise unattainable. Objective: The purpose of this study was to explore how networking has been utilized in the Finnish fashion industry. Particularly social relationships and networks are examined, as they emphasize the importance of individuals. Exploration on the past actions should also provide insight how networks and networking could be utilized and developed in the future. Main findings: It was discovered that the Finnish fashion industry (social) network is rather dense. This was mainly due to the small size of the Finnish market. In the early years of the establishment of the company, close contacts seemed to be utilized. As a company expands and extends its business, the relationships tended to move towards more utilitarian in nature. However, in some cases, the long term relationships had also affectionate features, such as trust and commitment. International networking was found to have positive impact on business opportunities. Participation to events, such as trade shows, was perceived as one of the best ways to meet new international contacts and to develop ones network. Active networking in the Finnish market, however, created both domestic and international opportunities. Furthermore, cooperation and open communication were discovered to facilitate innovation and projects. The public sector seemed to lack the interest in supporting the fashion industry according to the interviewees. The major issues for the fashion industry still concerned, among others, funding, administrative guidance and public support for developing the industry as a whole.

Design and evaluation of web interface signs to improve web usability : a semiotic framework

Technological innovations, the development of the internet, and globalization have increased the number and complexity of web applications. As a result, keeping web user interfaces understandable and usable (in terms of ease-of-use, effectiveness, and satisfaction) is a challenge. As part of this, designing userintuitive interface signs (i.e., the small elements of web user interface, e.g., navigational link, command buttons, icons, small images, thumbnails, etc.) is an issue for designers. Interface signs are key elements of web user interfaces because ‘interface signs’ act as a communication artefact to convey web content and system functionality, and because users interact with systems by means of interface signs. In the light of the above, applying semiotic (i.e., the study of signs) concepts on web interface signs will contribute to discover new and important perspectives on web user interface design and evaluation. The thesis mainly focuses on web interface signs and uses the theory of semiotic as a background theory. The underlying aim of this thesis is to provide valuable insights to design and evaluate web user interfaces from a semiotic perspective in order to improve overall web usability. The fundamental research question is formulated as What do practitioners and researchers need to be aware of from a semiotic perspective when designing or evaluating web user interfaces to improve web usability? From a methodological perspective, the thesis follows a design science research (DSR) approach. A systematic literature review and six empirical studies are carried out in this thesis. The empirical studies are carried out with a total of 74 participants in Finland. The steps of a design science research process are followed while the studies were designed and conducted; that includes (a) problem identification and motivation, (b) definition of objectives of a solution, (c) design and development, (d) demonstration, (e) evaluation, and (f) communication. The data is collected using observations in a usability testing lab, by analytical (expert) inspection, with questionnaires, and in structured and semi-structured interviews. User behaviour analysis, qualitative analysis and statistics are used to analyze the study data. The results are summarized as follows and have lead to the following contributions. Firstly, the results present the current status of semiotic research in UI design and evaluation and highlight the importance of considering semiotic concepts in UI design and evaluation. Secondly, the thesis explores interface sign ontologies (i.e., sets of concepts and skills that a user should know to interpret the meaning of interface signs) by providing a set of ontologies used to interpret the meaning of interface signs, and by providing a set of features related to ontology mapping in interpreting the meaning of interface signs. Thirdly, the thesis explores the value of integrating semiotic concepts in usability testing. Fourthly, the thesis proposes a semiotic framework (Semiotic Interface sign Design and Evaluation – SIDE) for interface sign design and evaluation in order to make them intuitive for end users and to improve web usability. The SIDE framework includes a set of determinants and attributes of user-intuitive interface signs, and a set of semiotic heuristics to design and evaluate interface signs. Finally, the thesis assesses (a) the quality of the SIDE framework in terms of performance metrics (e.g., thoroughness, validity, effectiveness, reliability, etc.) and (b) the contributions of the SIDE framework from the evaluators’ perspective.

Respiration, oxidative phosphorylation, and uncoupling protein in Candida albicans

The respiration, membrane potential (Dy), and oxidative phosphorylation of mitochondria in situ were determined in spheroplasts obtained from Candida albicans control strain ATCC 90028 by lyticase treatment. Mitochondria in situ were able to phosphorylate externally added ADP (200 µM) in the presence of 0.05% BSA. Mitochondria in situ generated and sustained stable mitochondrial Dy respiring on 5 mM NAD-linked substrates, 5 mM succinate, or 100 µM N,N,N',N'-tetramethyl-p-phenylenediamine dihydrochloride plus 1 mM ascorbate. Rotenone (4 µM) inhibited respiration by 30% and 2 µM antimycin A or myxothiazole and 1 mM cyanide inhibited it by 85%. Cyanide-insensitive respiration was partially blocked by 2 mM benzohydroxamic acid, suggesting the presence of an alternative oxidase. Candida albicans mitochondria in situ presented a carboxyatractyloside-insensitive increase of Dy induced by 5 mM ATP and 0.5% BSA, and Dy decrease induced by 10 µM linoleic acid, both suggesting the existence of an uncoupling protein. The presence of this protein was subsequently confirmed by immunodetection and respiration experiments with isolated mitochondria. In conclusion, Candida albicans ATCC 90028 possesses an alternative electron transfer chain and alternative oxidase, both absent in animal cells. These pathways can be exceptional targets for the design of new chemotherapeutic agents. Blockage of these respiratory pathways together with inhibition of the uncoupling protein (another potential target for drug design) could lead to increased production of reactive oxygen species, dysfunction of Candida mitochondria, and possibly to oxidative cell death.

From genotype to phenotype : diversity and population structure of Flavobacterium psychrophilum

Flavobacterium psychrophilum is the etiological agent of bacterial cold-water disease (BCWD) causing high fish mortalities and significant economic losses to the freshwater salmonid aquaculture industry around the world. Today BCWD outbreaks are mainly treated with environmentally hazardous antimicrobial agents and alternative preventative measures are urgently needed in order to ensure the well-being of animals and the sustainability of aquaculture. The diversity of pathogenic bacteria challenges the development of universal control strategies and in many cases the pathogen population structure, i.e. the total genetic diversity of the species must be taken into account. This work integrates the tools of modern molecular biology and conventional phenotypic microbiology to gain knowledge about the diversity and population structure of F. psychrophilum. The present work includes genetic characterization of a large collection of isolates collected from diverse origins and years, from aquaculture in a whole region including different countries, and provides the first international validation of a universal multilocus sequence typing (MLST) approach for unambiguous genetic typing of F. psychrophilum. Population structure analyses showed that the global F. psychrophilum population is subdivided into pathogenic species-specific clones, of which one particular genetic lineage, clonal complex CC-ST2, has been responsible for the majority of BCWD outbreaks in rainbow trout (Oncorhynchus mykiss) in European aquaculture facilities over several decades. Genotypic and phenotypic population heterogeneity affecting antimicrobial resistance in F. psychrophilum within BCWD outbreaks was discovered. Specific genotypes were associated with severe infections in farmed rainbow trout and Atlantic salmon (Salmo salar), and in addition to high adherence, antimicrobial resistance was strongly associated with outbreak strains. The study brought additional support for the hypothesis of an epidemic F. psychrophilum population structure, where recombination is an important force for the generation and maintenance of genetic diversity, and a significant contribution towards mapping the genetic diversity of this important fish pathogen. Evidence indicating dissemination of virulent strains with commercial movement of fish and fish products was strengthened.

Visual communication stimulates reproduction in Nile tilapia, Oreochromis niloticus (L.)

Reproductive fish behavior is affected by male-female interactions that stimulate physiological responses such as hormonal release and gonad development. During male-female interactions, visual and chemical communication can modulate fish reproduction. The aim of the present study was to test the effect of visual and chemical male-female interaction on the gonad development and reproductive behavior of the cichlid fish Nile tilapia, Oreochromis niloticus (L.). Fifty-six pairs were studied after being maintained for 5 days under one of the four conditions (N = 14 for each condition): 1) visual contact (V); 2) chemical contact (Ch); 3) chemical and visual contact (Ch+V); 4) no sensory contact (Iso) - males and females isolated. We compared the reproductive behavior (nesting, courtship and spawning) and gonadosomatic index (GSI) of pairs of fish under all four conditions. Visual communication enhanced the frequency of courtship in males (mean ± SEM; V: 24.79 ± 3.30, Ch+V: 20.74 ± 3.09, Ch: 0.1 ± 0.07, Iso: 4.68 ± 1.26 events/30 min; P < 0.05, two-way ANOVA with LSD post hoc test), induced spawning in females (3 spawning in V and also 3 in Ch+V condition), and increased GSI in males (mean ± SEM; V: 1.39 ± 0.08, Ch+V: 1.21 ± 0.08, Ch: 1.04 ± 0.07, Iso: 0.82 ± 0.07%; P < 0.05, two-way ANOVA with LSD post hoc test). Chemical communication did not affect the reproductive behavior of pairs nor did it enhance the effects of visual contact. Therefore, male-female visual communication is an effective cue, which stimulates reproduction among pairs of Nile tilapia.

Creating Value for Corporate Sustainability: Stakeholder Engagement

The thesis aims to build a coherent view and understanding of stakeholder engagement’s contribution to corporate sustainability value creation. Theory suggests that corporate sustainability relies on sustainable relationships between the firm and its multiple stakeholders. This study is qualitative and evidence is derived from integrative analysis of literature, secondary data and case study analysis. The findings from the interviews analysis supplement the framework developed as the results of the literature review. The results obtained throughout the thesis research imply that stakeholder engagement helps develop more thorough understandings of issues and alternative perspectives, which in turn facilitates the decision-making processes improvement. The improvement is also achieved through ethical analysis, by weighing the impact of firm’s decisions on all relevant groups. Therefore, clear communication and exchange of information also improve the acceptance of sustainability initiatives amongst stakeholders both in terms of building trust and managing expectations. As practical implications, this thesis presents organizational practices that can be employed by companies to support effective engagement with stakeholders. The described practices could enhance processes such as partnership and co-creation resulting in greater sustainable development.