Towards the design of a unified semantics model for OLTP and OLAP systems

The concepts of on-line transactional processing (OLTP) and on-line analytical processing (OLAP) are often confused with the technologies or models that are used to design transactional and analytics based information systems. This in some way has contributed to existence of gaps between the semantics in information captured during transactional processing and information stored for analytical use. In this paper, we propose the use of a unified semantics design model, as a solution to help bridge the semantic gaps between data captured by OLTP systems and the information provided by OLAP systems. The central focus of this design approach is on enabling business intelligence using not just data, but data with context.

A conceptual framework for aligning business and information systems from organisational learning perspective

The three decades of on-going executives’ concerns of how to achieve successful alignment between business and information technology shows the complexity of such a vital process. Most of the challenges of alignment are related to knowledge and organisational change and several researchers have introduced a number of mechanisms to address some of these challenges. However, these mechanisms pay less attention to multi-level effects, which results in a limited un-derstanding of alignment across levels. Therefore, we reviewed these challenges from a multi-level learning perspective and found that business and IT alignment is related to the balance of exploitation and exploration strategies with the intellec-tual content of individual, group and organisational levels.

Mobile-to-mobile MIMO transmit-receive diversity systems: analysis and performance in three-dimensional double-correlated channels

Mobile-to-mobile (M-to-M) communications are expected to play a crucial role in future wireless systems and networks. In this paper, we consider M-to-M multiple-input multiple-output (MIMO) maximal ratio combining system and assess its performance in spatially correlated channels. The analysis assumes double-correlated Rayleigh-and-Lognormal fading channels and is performed in terms of average symbol error probability, outage probability, and ergodic capacity. To obtain the receive and transmit spatial correlation functions needed for the performance analysis, we used a three-dimensional (3D) M-to-M MIMO channel model, which takes into account the effects of fast fading and shadowing. The expressions for the considered metrics are derived as a function of the average signal-to-noise ratio per receive antenna in closed-form and are further approximated using the recursive adaptive Simpson quadrature method. Numerical results are provided to show the effects of system parameters, such as distance between antenna elements, maximum elevation angle of scatterers, orientation angle of antenna array in the x–y plane, angle between the x–y plane and the antenna array orientation, and degree of scattering in the x–y plane, on the system performance. Copyright © 2011 John Wiley & Sons, Ltd.

Analysis and compensation for the joint effects of HPA nonlinearity, I/Q imbalance and crosstalk in MIMO beamforming systems

In this paper, we investigate the joint effects of high-power amplifier (HPA) nonlinearity, in-phase/quadrature-phase (I/Q) imbalance and crosstalk, on the performance of multiple-input multiple-output (MIMO) transmit beamforming (TB) systems, and propose a compensation method for the three impairments together. The performance of the MIMO TB system equipped with the proposed compensation scheme is evaluated in terms of average symbol error probability and capacity when transmissions are performed over uncorrelated Rayleigh fading channels. Numerical results are provided and show the effects on performance of several system parameters, namely, the HPA parameters, image-leakage ratio, crosstalk, numbers of antennas, length of pilot symbols and phase-shift keying modulation order.

A review of the performance of different ventilation and airflow distribution systems in buildings

The objective of this article is to review the scientific literature on airflow distribution systems and ventilation effectiveness to identify and assess the most suitable room air distribution methods for various spaces. In this study, different ventilation systems are classified according to specific requirements and assessment procedures. This study shows that eight ventilation methods have been employed in the built environment for different purposes and tasks. The investigation shows that numerous studies have been carried out on ventilation effectiveness but few studies have been done regarding other aspects of air distribution. Amongst existing types of ventilation systems, the performance of each ventilation methods varies from one case to another due to different usages of the ventilation system in a room and the different assessment indices used. This review shows that the assessment of ventilation effectiveness or efficiency should be determined according to each task of the ventilation system, such as removal of heat, removal of pollutant, supply fresh air to the breathing zone or protecting the occupant from cross infection. The analysis results form a basic framework regarding the application of airflow distribution for the benefit of designers, architects, engineers, installers and building owners.

Institutional pressures on financial services firms: the role of information systems in regulatory compliance

The financial crisis of 2008 led to new international regulatory controls for the governance, risk and compliance of financial services firms. Information systems play a critical role here as political, functional and social pressures may lead to the deinstitutionalization of existing structures, processes and practices. This research examines how an investment management system is introduced by a leading IT vendor across eight client sites in the post-crisis era. Using institutional theory, it examines changes in working practices occurring at the environmental and organizational levels and the ways in which technological interventions are used to apply disciplinary effects in order to prevent inappropriate behaviors. The results extend the constructs of deinstitutionalization and identify empirical predictors for the deinstitutionalization of compliance and trading practices within financial organizations.

The role of rules-based compliance systems in the new EU regulatory landscape: perspectives of institutional change

Purpose The research objective of this study is to understand how institutional changes to the EU regulatory landscape may affect corresponding institutionalized operational practices within financial organizations. Design/methodology/approach The study adopts an Investment Management System as its case and investigates different implementations of this system within eight financial organizations, predominantly focused on investment banking and asset management activities within capital markets. At the systems vendor site, senior systems consultants and client relationship managers were interviewed. Within the financial organizations, compliance, risk and systems experts were interviewed. Findings The study empirically tests modes of institutional change. Displacement and Layering were found to be the most prevalent modes. However, the study highlights how the outcomes of Displacement and Drift may be similar in effect as both modes may cause compliance gaps. The research highlights how changes in regulations may create gaps in systems and processes which, in the short term, need to be plugged by manual processes. Practical implications Vendors abilities to manage institutional change caused by Drift, Displacement, Layering and Conversion and their ability to efficiently and quickly translate institutional variables into structured systems has the power to ease the pain and cost of compliance as well as reducing the risk of breeches by reducing the need for interim manual systems. Originality/value The study makes a contribution by applying recent theoretical concepts of institutional change to the topic of regulatory change uses this analysis to provide insight into the effects of this new environment

An evaluation of the theoretical potential and practical opportunity for using greywater for domestic purposes in Ghana

Assessments concerning the effects of climate change, water resource availability and water deprivation in West Africa have not frequently considered the positive contribution to be derived from collecting and reusing water for domestic purposes. Where the originating water is taken from a clean water source and has been used the first time for washing or bathing, this water is commonly called “greywater”. Greywater is a prolific resource that is generated wherever people live. Treated greywater can be used for domestic cleaning, for flushing toilets where appropriate, for washing cars, sometimes for watering kitchen gardens, and for clothes washing prior to rinsing. Therefore, a large theoretical potential exists to increase total water resource availability if greywater were to be widely reused. Locally treated greywater reduces the distribution network requirement, lower construction effort and cost and, wherever possible, minimising the associated carbon footprint. Such locally treated greywater offers significant practical opportunities for increasing the total available water resources at a local level. The reuse of treated greywater is one important action that will help to mitigate the reducing availability of clean water supplies in some areas, and the expected mitigation required in future aligns well with WHO/UNICEF (2012) aspirations. The evaluation of potential opportunities for prioritising greywater systems to support water reuse takes into account the availability of water resources, water use indicators and published estimates in order to understand typical patterns of water demand. The approach supports knowledge acquisition regarding local conditions for enabling capacity building for greywater reuse, the understanding of systems that are most likely to encourage greywater reuse, and practices and future actions to stimulate greywater infrastructure planning, design and implementation. Although reuse might be considered to increase the uncertainty of achieving a specified quality of the water supply, robust methods and technologies are available for local treatment. Resource strategies for greywater reuse have the potential to consistently improve water efficiency and availability in water impoverished and water stressed regions of Ghana and West Africa. Untreated greywater is referred to as “greywater”; treated greywater is referred to as “treated greywater” in this paper.

Design of a unified data with business rules storage model for OLTP and OLAP systems

This paper reviews the literature concerning the practice of using Online Analytical Processing (OLAP) systems to recall information stored by Online Transactional Processing (OLTP) systems. Such a review provides a basis for discussion on the need for the information that are recalled through OLAP systems to maintain the contexts of transactions with the data captured by the respective OLTP system. The paper observes an industry trend involving the use of OLTP systems to process information into data, which are then stored in databases without the business rules that were used to process information and data stored in OLTP databases without associated business rules. This includes the necessitation of a practice, whereby, sets of business rules are used to extract, cleanse, transform and load data from disparate OLTP systems into OLAP databases to support the requirements for complex reporting and analytics. These sets of business rules are usually not the same as business rules used to capture data in particular OLTP systems. The paper argues that, differences between the business rules used to interpret these same data sets, risk gaps in semantics between information captured by OLTP systems and information recalled through OLAP systems. Literature concerning the modeling of business transaction information as facts with context as part of the modelling of information systems were reviewed to identify design trends that are contributing to the design quality of OLTP and OLAP systems. The paper then argues that; the quality of OLTP and OLAP systems design has a critical dependency on the capture of facts with associated context, encoding facts with contexts into data with business rules, storage and sourcing of data with business rules, decoding data with business rules into the facts with the context and recall of facts with associated contexts. The paper proposes UBIRQ, a design model to aid the co-design of data with business rules storage for OLTP and OLAP purposes. The proposed design model provides the opportunity for the implementation and use of multi-purpose databases, and business rules stores for OLTP and OLAP systems. Such implementations would enable the use of OLTP systems to record and store data with executions of business rules, which will allow for the use of OLTP and OLAP systems to query data with business rules used to capture the data. Thereby ensuring information recalled via OLAP systems preserves the contexts of transactions as per the data captured by the respective OLTP system.

Translation practices in political institutions: a comparison of national, supranational, and non-governmental organisations

This paper explores the settings and practices of translation at three types of political institutions, i.e. national, supranational, and non-governmental organisations. The three institutions are the translation service of the German Foreign Office, the translation department of the European Central Bank, and translation provision by the non-governmental organisation Amnesty International. The three case studies describe the specific translation practices in place at these institutions and illustrate some characteristic translation strategies. In this way, we reflect on how different translation practices can impact on translation agency and how these practices in turn are influenced by the type of institution and its organisational structure. The article also aims to explore to which extent the characteristics of collectivity, anonymity and standardisation, and of institutional translation as self-translation are applicable to the institutions under discussion.

The impact of national context effects on HRM practices in Russian subsidiaries of Western MNCs

This article contributes to the research on comparative human resource management by providing a model of the Russian business system and its effect on human resource management practices at Russian subsidiaries of Western multinational companies. Whitley’s approach was adopted to illustrate the links between institutional arenas, business systems, and human resource management practices. The empirical part is based on interviews with senior human resources managers of Western multinational companies operating in Russia. The findings provide insight into the interaction between the national business system and human resource management practices in Russia.

Conflicting language ideologies and contradictory language practices in Singaporean bilingual families

Informed by family language policy (FLP) as the theoretical framework, I illustrate in this paper how language ideologies can be incongruous and language policies can be conflicting through three multilingual families in Singapore representing three major ethnic groups – Chinese, Malay and Indian. By studying their family language audits, observing their language practices, and engaging in conversations about their language ideologies, I look at what these families do and do not do and what they claim to do and not to do. Data were collected over a period of 6 months with more than 700 minutes of recording of actual interactions. Analysis of the data reveals that language ideologies are ‘power-inflected’ and tend to become the source of educational and social tensions which in turn shape family language practices. In Singapore these tensions are illustrated by the bilingual policy recognising mother tongues (MTs) and English as official languages, and its educational policy establishing English as the medium of instruction. The view of English as having instrumental values and MTs as having cultural functions reveals that language choices and practices in family domains are value-laden in everyday interactions and explicitly negotiated and established through FLP.

The role of big data in governance: a regulatory and legal perspective of analytics in global financial services

This paper discusses how global financial institutions are using big data analytics within their compliance operations. A lot of previous research has focused on the strategic implications of big data, but not much research has considered how such tools are entwined with regulatory breaches and investigations in financial services. Our work covers two in-depth qualitative case studies, each addressing a distinct type of analytics. The first case focuses on analytics which manage everyday compliance breaches and so are expected by managers. The second case focuses on analytics which facilitate investigation and litigation where serious unexpected breaches may have occurred. In doing so, the study focuses on the micro/data to understand how these tools are influencing operational risks and practices. The paper draws from two bodies of literature, the social studies of information systems and finance to guide our analysis and practitioner recommendations. The cases illustrate how technologies are implicated in multijurisdictional challenges and regulatory conflicts at each end of the operational risk spectrum. We find that compliance analytics are both shaping and reporting regulatory matters yet often firms may have difficulties in recruiting individuals with relevant but diverse skill sets. The cases also underscore the increasing need for financial organizations to adopt robust information governance policies and processes to ease future remediation efforts.

Influence of rhBMP-2 on bone formation and osseointegration in different implant systems after sinus-floor elevation. An in vivo study on sheep

Background Several studies have reported certain bone morphogenic proteins (BMPs) to have positive effects on bone generation Although some investigators have studied the effects of human recombinant BMP (rhBMP-2) in sinus augmentation in sheep, none of these studies looked at the placement of implants at the time of sinus augmentation Furthermore, no literature could be found to report on the impact that different implant systems, as well as the positioning of the implants had on bone formation if rhBMP-2 was utilized in sinus-lift procedures Purpose The aim of this study was to compare sinus augmentation with rhBMP-2 on a poly-D, L-lactic-co-glycolic acid gelatine (PLPG) sponge with sinus augmentation with autologous pelvic cancellous bone in the maxillary sinus during the placement of different dental Implants Materials and methods Nine adult female sheep were submitted to bilateral sinus-floor elevation In one side (test group) the sinus lift was performed with rhBMP-2 on a PLPG-sponge, while the contralateral side served as the control by using cancellous bone from the iliac crest Three different implants (Branemark (R), 31 (R) and Straumann (R)) were inserted either simultaneously with the sinus augmentation or as a two staged procedure 6 weeks later The animals were sacrificed at 6 and 12 weeks for histological and histomorphometrical evaluations during which bone-to-implant contact (BIC) and bone density (BD) were evaluated Results BD and BIC were significantly higher at 12 weeks in the test group if the Implants were placed at the time of the sinus lift (p < 0 05) No difference was observed between the different implant systems or positions Conclusions The use of rhBMP-2 with PLPG-sponge increased BIC as well as BD in the augmented sinuses if compared to autologous bone Different implant systems and positions of the implants had no effect on BIC or BD (C) 2010 European Association for Cranio-Maxillo-Facial Surgery

Disruption of Saccharomyces cerevisiae by Plantaricin 149 and investigation of its mechanism of action with biomembrane model systems

The action of a synthetic antimicrobial peptide analog of Plantaricin 149 (Pln149a) against Saccharomyces cerevisiae and its interaction with biomembrane model systems were investigated. Pln149a was shown to inhibit S. cerevisiae growth by more than 80% in YPD medium, causing morphological changes in the yeast wall and remaining active and resistant to the yeast proteases even after 24 h of incubation. Different membrane model systems and carbohydrates were employed to better describe the Pln149a interaction with cellular components using circular dichroism and fluorescence spectroscopies, adsorption kinetics and surface elasticity in Langmuir monolayers. These assays showed that Pln149a does not interact with either mono/polysaccharides or zwitterionic LUVs, but is strongly adsorbed to and incorporated into negatively charged surfaces, causing a conformational change in its secondary structure from random-coil to helix upon adsorption. From the concurrent analysis of Pln149a adsorption kinetics and dilatational surface elasticity data, we determined that 2.5 mu M is the critical concentration at which Pln149a will disrupt a negative DPPG monolayer. Furthermore, Pln149a exhibited a carpet-like mechanism of action, in which the peptide initially binds to the membrane, covering its surface and acquiring a helical structure that remains associated to the negatively charged phospholipids. After this electrostatic interaction, another peptide region causes a strain in the membrane, promoting its disruption. (C) 2009 Elsevier B.V. All rights reserved.