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.

Research data management and openness: the role of data sharing in developing institutional policies and practices

Purpose: To investigate the relationship between research data management (RDM) and data sharing in the formulation of RDM policies and development of practices in higher education institutions (HEIs). Design/methodology/approach: Two strands of work were undertaken sequentially: firstly, content analysis of 37 RDM policies from UK HEIs; secondly, two detailed case studies of institutions with different approaches to RDM based on semi-structured interviews with staff involved in the development of RDM policy and services. The data are interpreted using insights from Actor Network Theory. Findings: RDM policy formation and service development has created a complex set of networks within and beyond institutions involving different professional groups with widely varying priorities shaping activities. Data sharing is considered an important activity in the policies and services of HEIs studied, but its prominence can in most cases be attributed to the positions adopted by large research funders. Research limitations/implications: The case studies, as research based on qualitative data, cannot be assumed to be universally applicable but do illustrate a variety of issues and challenges experienced more generally, particularly in the UK. Practical implications: The research may help to inform development of policy and practice in RDM in HEIs and funder organisations. Originality/value: This paper makes an early contribution to the RDM literature on the specific topic of the relationship between RDM policy and services, and openness – a topic which to date has received limited attention.

Globular adiponectin induces platelet activation through the collagen receptor GPVI-Fc receptor gamma chain complex.

We identify gAd as a novel ligand for GPVI that stimulates tyrosine kinase-dependent platelet aggregation. Our data raise the possibility that gAd may promote unwanted platelet activation at sites of vascular injury.

Big data: a normal accident waiting to happen?

Widespread commercial use of the internet has significantly increased the volume and scope of data being collected by organisations. ‘Big data’ has emerged as a term to encapsulate both the technical and commercial aspects of this growing data collection activity. To date, much of the discussion of big data has centred upon its transformational potential for innovation and efficiency, yet there has been less reflection on its wider implications beyond commercial value creation. This paper builds upon normal accident theory (NAT) to analyse the broader ethical implications of big data. It argues that the strategies behind big data require organisational systems that leave them vulnerable to normal accidents, that is to say some form of accident or disaster that is both unanticipated and inevitable. Whilst NAT has previously focused on the consequences of physical accidents, this paper suggests a new form of system accident that we label data accidents. These have distinct, less tangible and more complex characteristics and raise significant questions over the role of individual privacy in a ‘data society’. The paper concludes by considering the ways in which the risks of such data accidents might be managed or mitigated.

Data Assimilation and Inverse Methods in Terms of a Probabilistic Formulation

The weak-constraint inverse for nonlinear dynamical models is discussed and derived in terms of a probabilistic formulation. The well-known result that for Gaussian error statistics the minimum of the weak-constraint inverse is equal to the maximum-likelihood estimate is rederived. Then several methods based on ensemble statistics that can be used to find the smoother (as opposed to the filter) solution are introduced and compared to traditional methods. A strong point of the new methods is that they avoid the integration of adjoint equations, which is a complex task for real oceanographic or atmospheric applications. they also avoid iterative searches in a Hilbert space, and error estimates can be obtained without much additional computational effort. the feasibility of the new methods is illustrated in a two-layer quasigeostrophic model.

Platelet signaling: a complex interplay between inhibitory and activatory networks

The role of platelets in hemostasis and thrombosis is dependent on a complex balance of activatory and inhibitory signaling pathways. Inhibitory signals released from the healthy vasculature suppress platelet activation in the absence of platelet receptor agonists. Activatory signals present at a site of injury initiate platelet activation and thrombus formation; subsequently, endogenous negative signaling regulators dampen activatory signals to control thrombus growth. Understanding the complex interplay between activatory and inhibitory signaling networks is an emerging challenge in the study of platelet biology and necessitates a systematic approach to utilize experimental data effectively. In this review, we will explore the key points of platelet regulation and signaling that maintain platelets in a resting state, mediate activation to elicit thrombus formation or provide negative feedback. Platelet signaling will be described in terms of key signaling molecules that are common to the pathways activated by platelet agonists and can be described as regulatory nodes for both positive and negative regulators. This article is protected by copyright. All rights reserved.

A retrospective study of zygomatico-orbital complex and/or zygomatic arch fractures over a 71-month period

Background/Aim: The aim of this retrospective study was to evaluate the epidemiology, treatment, and complications of zygomatico-orbital complex (ZOC) and/or zygomatic arch (ZA) fractures either associated with other facial fractures or not over a 71-month period. Material and methods: This survey was performed in three hospitals of Ribeirao Preto in Sao Paulo, Brazil, from August 2002 to July 2008. The records of 1575 patients with facial trauma were reviewed. There were 140 cases of ZOC and ZA fractures either associated with other facial fractures or not. Data regarding gender, age, race, addictions, day of trauma, etiology, signs and symptoms, oral hygiene condition, day of initial evaluation, hospital admission, day of surgery, surgery approach, pattern of fractures, treatment performed, post-operative antibiotic therapy, day of hospital discharge, and post-operative complications were collected. The data were subjected to descriptive statistical analyses. Results: The most frequent fractures affected Caucasian men and occurred during the fourth decade of life. The most frequent etiology was traffic accident, and symptoms and signs included pain and edema. Type I fractures were the main injury observed, and the treatment of choice was always rigid internal fixation. Post-operative antibiotic therapy was solely employed when there was an indication. Complications were observed in 13.1% of the cases. Conclusions: The treatment protocol yielded suitable post-operative results and also showed success rates comparable to published data around the world.

Resurrection of Two Species From Synonymy of Anopheles (Nyssorhynchus) strodei Root, and Characterization of a Distinct Morphological Form From the Strodei Complex (Diptera: Culicidae)

Anopheles albertoi Unti and Anopheles arthuri Unti are revived from the synonymy with Anopheles strodei Root, and a distinct morphological form (designated in this study as Anopheles CP Form) from the Strodei Complex of Anopheles (Nyssorhynchus) is characterized. The male genitalia of An. arthuri and An. albertoi are described and illustrated for the first time. An. strodei, An. arthuri, and An. albertoi were first distinguished based on scanning electron microphotos of the eggs, and then each egg type was associated with diagnostic characters of the male genitalia. Identification of Anopheles CP Form was based on morphological characters of the male genitalia, characterized and illustrated in this study. Molecular phylogenetic analysis was most clear when an outgroup was not included, in which case using the nuclear white gene, or the white gene in combination with the mitochondrial cytochrome c oxidase subunit I (COI) gene, clearly separated these four taxa. When Anopheles quadrimaculatus Say and Anopheles stephensi Liston were included as an outgroup, combined white and COI data resolved An. strodei and An. albertoi, whereas An. arthuri was not well resolved. The single sequence of Anopheles CP Form was recovered well separated from other groups in all analyses.

GALAXY EVOLUTION IN A COMPLEX ENVIRONMENT: A MULTI-WAVELENGTH STUDY OF HCG 7

The environment where galaxies are found heavily influences their evolution. Close groupings, like the ones in the cores of galaxy clusters or compact groups, evolve in ways far more dramatic than their isolated counterparts. We have conducted a multi-wavelength study of Hickson Compact Group 7 (HCG 7), consisting of four giant galaxies: three spirals and one lenticular. We use Hubble Space Telescope (HST) imaging to identify and characterize the young and old star cluster populations. We find young massive clusters (YMCs) mostly in the three spirals, while the lenticular features a large, unimodal population of globular clusters (GCs) but no detectable clusters with ages less than a few Gyr. The spatial and approximate age distributions of the similar to 300 YMCs and similar to 150 GCs thus hint at a regular star formation history in the group over a Hubble time. While at first glance the HST data show the galaxies as undisturbed, our deep ground-based, wide-field imaging that extends the HST coverage reveals faint signatures of stellar material in the intragroup medium (IGM). We do not, however, detect the IGM in H I or Chandra X-ray observations, signatures that would be expected to arise from major mergers. Despite this fact, we find that the H I gas content of the individual galaxies and the group as a whole are a third of the expected abundance. The appearance of quiescence is challenged by spectroscopy that reveals an intense ionization continuum in one galaxy nucleus, and post-burst characteristics in another. Our spectroscopic survey of dwarf galaxy members yields a single dwarf elliptical galaxy in an apparent stellar tidal feature. Based on all this information, we suggest an evolutionary scenario for HCG 7, whereby the galaxies convert most of their available gas into stars without the influence of major mergers and ultimately result in a dry merger. As the conditions governing compact groups are reminiscent of galaxies at intermediate redshift, we propose that HCGs are appropriate for studying galaxy evolution at z similar to 1-2.

PCA Tomography: how to extract information from data cubes

Astronomy has evolved almost exclusively by the use of spectroscopic and imaging techniques, operated separately. With the development of modern technologies, it is possible to obtain data cubes in which one combines both techniques simultaneously, producing images with spectral resolution. To extract information from them can be quite complex, and hence the development of new methods of data analysis is desirable. We present a method of analysis of data cube (data from single field observations, containing two spatial and one spectral dimension) that uses Principal Component Analysis (PCA) to express the data in the form of reduced dimensionality, facilitating efficient information extraction from very large data sets. PCA transforms the system of correlated coordinates into a system of uncorrelated coordinates ordered by principal components of decreasing variance. The new coordinates are referred to as eigenvectors, and the projections of the data on to these coordinates produce images we will call tomograms. The association of the tomograms (images) to eigenvectors (spectra) is important for the interpretation of both. The eigenvectors are mutually orthogonal, and this information is fundamental for their handling and interpretation. When the data cube shows objects that present uncorrelated physical phenomena, the eigenvector`s orthogonality may be instrumental in separating and identifying them. By handling eigenvectors and tomograms, one can enhance features, extract noise, compress data, extract spectra, etc. We applied the method, for illustration purpose only, to the central region of the low ionization nuclear emission region (LINER) galaxy NGC 4736, and demonstrate that it has a type 1 active nucleus, not known before. Furthermore, we show that it is displaced from the centre of its stellar bulge.

The occurrence of Laurencia marilzae (Ceramiales, Rhodophyta) in Brazil based on morphological and molecular data

Laurencia marilzae is recorded for the first time from the western Atlantic Ocean; it was found in Laje de Santos Marine State Park, Sao Paulo, southeastern Brazil. The specimens were collected in the rocky subtidal zone from 7 to 15 m depth. The most distinctive characteristic of this species is the presence of corps en cerise in all cells of the thallus, including cortex, medulla, and trichoblasts. The phylogenetic position of the species was inferred by analysis of the chloroplast-encoded rbcL gene sequences from 43 taxa, using two other rhodomelacean taxa and two members of the Ceramiaceae as outgroups. Within the Laurencia assemblage, L. marilzae from Brazil and from the Canary Islands ( type locality) formed a distinctive lineage sister to all other Laurencia species analyzed. Male plants are described for the first time. This study expands the geographical distribution of L. marilzae to the western Atlantic Ocean.

Curiously composite structures of a retrotransposon and a complex repeat associated with chromosome ends of Rhynchosciara americana (Diptera: Sciaridae)

In Drosophila, telomere retrotransposons counterbalance the loss of telomeric DNA. The exceptional mechanism of telomere recovery characterized in Drosophila has not been found in lower dipterans (Nematocera). However, a retroelement resembling a telomere transposon and termed ""RaTART"" has been described in the nematoceran Rhynchosciara americana. In this work, DNA and protein sequence analyses, DNA cloning, and chromosomal localization of probes obtained either by PCR or by screening a genomic library were carried out in order to examine additional features of this retroelement. The analyses performed raise the possibility that RaTART represents a genomic clone composed of distinct repetitive elements, one of which is likely to be responsible for its apparent enrichment at chromosome ends. RaTART sequence in addition allowed to assess a novel subtelomeric region of R. americana chromosomes that was analyzed in this work after subcloning a DNA fragment from a phage insert. It contains a complex repeat that is located in the vicinity of simple and complex tandem repeats characterized previously. Quantification data suggest that the copy number of the repeat is significantly lower than that observed for the ribosomal DNA in the salivary gland of R. americana. A short insertion of the RaTART was identified in the cloned segment, which hybridized preferentially to subtelomeres. Like RaTART, it displays truncated sequences related to distinct retrotransposons, one of which has a conceptual translation product with significant identity with an endonuclease from a lepidopteran retrotransposon. The composite structure of this DNA stretch probably reflects mobile element activity in the subtelomeric region analyzed in this work.

The species complex Astyanax fasciatus Cuvier (Teleostei, Characiformes) - a multidisciplinary approach

Cytogenetic data have provided important clues that the Astyanax fasciatus populations from the Upper Parana River basin could be a part of a more diverse fish group, usually included on the same taxa. Samples collected in Cachoeira de Emas, SP, in Mogi-Guacu River basin, show two major cytotypes presenting 2n = 46 and 2n = 48 chromosomes, with distinct karyotypic formula, despite the fact that the molecular data suggested some degree of gene flow between these cytotypes. Cytogenetic and morphometric analyses were performed in this species, aiming to contribute to the understanding of the natural history from such fish group. Two allopatric populations with distinct standard cytotypes were analysed, and the data obtained suggest the separation into two groups. (c) 2008 The Authors Journal compilation (c) 2008 The Fisheries Society of the British Isles.

Complex meiotic configuration of the holocentric chromosomes: the intriguing case of the scorpion Tityus bahiensis

Mitotic and meiotic chromosomes of Tityus bahiensis were investigated using light (LM) and transmission electron microscopy (TEM) to determine the chromosomal characteristics and disclose the mechanisms responsible for intraspecific variability in chromosome number and for the presence of complex chromosome association during meiosis. This species is endemic to Brazilian fauna and belongs to the family Buthidae, which is considered phylogenetically basal within the order Scorpiones. In the sample examined, four sympatric and distinct diploid numbers were observed: 2n = 5, 2n = 6, 2n = 9, and 2 = 10. The origin of this remarkable chromosome variability was attributed to chromosome fissions and/or fusions, considering that the decrease in chromosome number was concomitant with the increase in chromosome size and vice versa. The LM and TEM analyses showed the presence of chromosomes without localised centromere, the lack of chiasmata and recombination nodules in male meiosis, and two nucleolar organiser regions carrier chromosomes. Furthermore, male prophase I cells revealed multivalent chromosome associations and/or unsynapsed or distinctly associated chromosome regions (gaps, less-condensed chromatin, or loop-like structure) that were continuous with synapsed chromosome segments. All these data permitted us to suggest that the chromosomal rearrangements of T. bahiensis occurred in a heterozygous state. A combination of various factors, such as correct disjunction and balanced segregation of the chromosomes involved in complex meiotic pairing, system of achiasmate meiosis, holocentric nature of the chromosomes, population structure, and species dispersion patterns, could have contributed to the high level of chromosome rearrangements present in T. bahiensis.

A Comparative Cytogenetic Analysis of 2 Bothriuridae Species and Overview of the Chromosome Data of Scorpiones

The order Scorpiones is one of the most cytogenetically interesting groups within Arachnida by virtue of the combination of chromosome singularities found in the 59 species analyzed so far. In this work, mitotic and meiotic chromosomes of 2 species of the family Bothriuridae were detailed. This family occupies a basal position within the superfamily Scorpionoidea. Furthermore, review of the cytogenetic data of all previously studied scorpions is presented. Light microscopy chromosome analysis showed that Bothriurus araguayae and Bothriurus rochensis possess low diploid numbers compared with those of species belonging to closely related families. Gonadal cells examined under light and in transmission electron microscopy revealed, for the first time, that the Bothriuridae species possess typical monocentric chromosomes, and male meiosis presented chromosomes with synaptic and achiasmatic behavior. Moreover, in the sample of B. araguayae studied, heterozygous translocations were verified. The use of techniques to highlight specific chromosomal regions also revealed additional differences between the 2 Bothriurus species. The results herein recorded and the overview elaborated using the available cytogenetic information of Scorpiones elucidated current understanding regarding the processes of chromosome evolution that have occurred in Bothriuridae and in Scorpiones as a whole.