Implementing a Three-Tier Data Warehouse

This paper aims at developing a 3-tier inter-universities data warehouse prototype for the Egyptian universities. The implementation scope is restricted to the student enrollment process. The bottom-up approach and the multi-tier (3-tier) client/server architecture were used to implement the proposed prototype. The implementation required a number of steps to be undertaken. First, a star schema data warehouse was built based on an operational database of a public university. Second, another star schema data warehouse was built based on an operational database of a private university. Third, data from the two warehouses were abstracted to formulate the inter-universities data warehouse (tier 3). Hence, a data cube based on the resulting interuniversities data warehouse was developed using an OLAP server (tier 2). The data cube is then accessed by a client tool (tier 1) for the purpose of query and analysis. Although two universities were used to implement the interuniversities data warehouse, this scenario could be applied with any number of universities in a quite similar way. This inter-universities prototype is scalable and flexible to retain more than two universities regardless of the size of the operational databases. The interuniversities prototype fosters the coordination between participating universities and supports the decision making process. The proposed system could be used to generate a variety of strategic reports

Pathspace Kalman Filters with Dynamic Process Uncertainty for Analyzing Time-course Data

Kalman Filter (KF) is an optimal linear state prediction algorithm, with applications in fields as diverse as engineering, economics, robotics, and space exploration. Here, we develop an extension of the KF, called a Pathspace Kalman Filter (PKF) which allows us to a) dynamically track the uncertainties associated with the underlying data and prior knowledge, and b) take as input an entire trajectory and an underlying mechanistic model, and using a Bayesian methodology quantify the different sources of uncertainty. An application of this algorithm is to automatically detect temporal windows where the internal mechanistic model deviates from the data in a time-dependent manner. First, we provide theorems characterizing the convergence of the PKF algorithm. Then, we numerically demonstrate that the PKF outperforms conventional KF methods on a synthetic dataset lowering the mean-squared-error by several orders of magnitude. Finally, we apply this method to biological time-course dataset involving over 1.8 million gene expression measurements.Comment: 32 pages, 8 figures, Submitted for revie

Granular circulation in a cylindrical pan: simulations of reversing radial and tangential flows

Granular flows due to simultaneous vertical and horizontal excitations of a flat-bottomed cylindrical pan are investigated using event-driven molecular dynamics simulations. In agreement with recent experimental results, we observe a transition from a solid-like state, to a fluidized state in which circulatory flow occurs simultaneously in the radial and tangential directions. By going beyond the range of conditions explored experimentally, we find that each of these circulations reverse their direction as a function of the control parameters of the motion. We numerically evaluate the dynamical phase diagram for this system and show, using a simple model, that the solid-fluid transition can be understood in terms of a critical value of the radial acceleration of the pan bottom; and that the circulation reversals are controlled by the phase shift relating the horizontal and vertical components of the vibrations. We also discuss the crucial role played by the geometry of the boundary conditions, and point out a relationship of the circulation observed here and the flows generated in vibratory conveyors.Comment: 10 pages, 8 figure

Messy entanglements: research assemblages in heart transplantation discourses and practices

The paper engages with a variety of data around a supposedly single biomedical event, that of heart transplantation. In conventional discourse, organ transplantation constitutes an unproblematised form of spare part surgery in which failing biological components are replaced by more efficient and enduring ones, but once that simple picture is complicated by employing a radically interdisciplinary approach, any biomedical certainty is profoundly disrupted. Our aim, as a cross-sectorial partnership, has been to explore the complexities of heart transplantation by explicitly entangling research from the arts, biosciences and humanities without privileging any one discourse. It has been no easy enterprise yet it has been highly productive of new insights. We draw on our own ongoing funded research with both heart donor families and recipients to explore our different perceptions of what constitutes data and to demonstrate how the dynamic entangling of multiple data produces a constitutive assemblage of elements in which no one can claim priority. Our claim is that the use of such research assemblages and the collaborations that we bring to our project breaks through disciplinary silos to enable a fuller comprehension of the significance and experience of heart transplantation in both theory and practice

Black Stork Down: Military Discourses in Bird Conservation in Malta

Tensions between Maltese hunters and bird conservation NGOs have intensified over the past decade. Conservation NGOs have become frustrated with the Maltese State for conceding to the hunter lobby and negotiating derogations from the European Union’s Bird Directive. Some NGOs have recently started to organize complex field-operations where volunteers are trained to patrol the landscape, operate drones and other surveillance technologies, detect illegalities, and lead police teams to arrest poachers. We describe the sophisticated military metaphors which conservation NGOs have developed to describe, guide and legitimize their efforts to the Maltese public and their fee-paying members. We also discuss why such groups might be inclined to adopt these metaphors. Finally, we suggest that anthropological studies of discourse could help understand delicate contexts such as this where conservation NGOs, hunting associations and the State have ended in political deadlock

Effects of antenatal betamethasone on preterm human and mouse ductus arteriosus: comparison with baboon data.

BackgroundAlthough studies involving preterm infants ≤34 weeks gestation report a decreased incidence of patent ductus arteriosus after antenatal betamethasone, studies involving younger gestation infants report conflicting results.MethodsWe used preterm baboons, mice, and humans (≤276/7 weeks gestation) to examine betamethasone's effects on ductus gene expression and constriction both in vitro and in vivo.ResultsIn mice, betamethasone increased the sensitivity of the premature ductus to the contractile effects of oxygen without altering the effects of other contractile or vasodilatory stimuli. Betamethasone's effects on oxygen sensitivity could be eliminated by inhibiting endogenous prostaglandin/nitric oxide signaling. In mice and baboons, betamethasone increased the expression of several developmentally regulated genes that mediate oxygen-induced constriction (K+ channels) and inhibit vasodilator signaling (phosphodiesterases). In human infants, betamethasone increased the rate of ductus constriction at all gestational ages. However, in infants born ≤256/7 weeks gestation, betamethasone's contractile effects were only apparent when prostaglandin signaling was inhibited, whereas at 26-27 weeks gestation, betamethasone's contractile effects were apparent even in the absence of prostaglandin inhibitors.ConclusionsWe speculate that betamethasone's contractile effects may be mediated through genes that are developmentally regulated. This could explain why betamethasone's effects vary according to the infant's developmental age at birth

CORM-3 induces DNA damage through Ru(II) binding to DNA

When the ‘CO-releasing molecule-3’, CORM-3 (Ru(CO)3Cl(glycinate)), is dissolved in water it forms a range of ruthenium complexes. These are taken up by cells and bind to intracellular ligands, notably thiols such as cysteine and glutathione, where the Ru(II) reaches high intracellular concentrations. Here, we show that the Ru(II) ion also binds to DNA, at exposed guanosine N7 positions. It therefore has a similar cellular target to the anticancer drug cisplatin, but not identical, because Ru(II) shows no evidence of forming intramolecular crossbridges in the DNA. The reaction is slow, and with excess Ru, intermolecular DNA crossbridges are formed. The addition of CORM-3 to human colorectal cancer cells leads to strand breaks in the DNA, as assessed by the alkaline comet assay. DNA damage is inhibited by growth media containing amino acids, which bind to extracellular Ru and prevent its entry into cells. We conclude that the cytotoxicity of Ru(II) is different from that of platinum, making it a promising development target for cancer therapeutics

Understanding Behavioral Sources of Process Variation Following Enterprise System Deployment

This paper extends the current understanding of the time-sensitivity of intent and usage following large-scale IT implementation. Our study focuses on perceived system misfit with organizational processes in tandem with the availability of system circumvention opportunities. Case study comparisons and controlled experiments are used to support the theoretical unpacking of organizational and technical contingencies and their relationship to shifts in user intentions and variation in work-processing tactics over time. Findings suggest that managers and users may retain strong intentions to circumvent systems in the presence of perceived task-technology misfit. The perceived ease with which this circumvention is attainable factors significantly into the timeframe within which it is attempted, and subsequently impacts the onset of deviation from prescribed practice and anticipated dynamics

Targeting the latent cytomegalovirus reservoir with an antiviral fusion toxin protein.

Reactivation of human cytomegalovirus (HCMV) in transplant recipients can cause life-threatening disease. Consequently, for transplant recipients, killing latently infected cells could have far-reaching clinical benefits. In vivo, myeloid cells and their progenitors are an important site of HCMV latency, and one viral gene expressed by latently infected myeloid cells is US28. This viral gene encodes a cell surface G protein-coupled receptor (GPCR) that binds chemokines, triggering its endocytosis. We show that the expression of US28 on the surface of latently infected cells allows monocytes and their progenitor CD34+ cells to be targeted and killed by F49A-FTP, a highly specific fusion toxin protein that binds this viral GPCR. As expected, this specific targeting of latently infected cells by F49A-FTP also robustly reduces virus reactivation in vitro. Consequently, such specific fusion toxin proteins could form the basis of a therapeutic strategy for eliminating latently infected cells before haematopoietic stem cell transplantation