A mixed transaction processing and operational reporting benchmark

The importance of reporting is ever increasing in today’s fast-paced market environments and the availability of up-to-date information for reporting has become indispensable. Current reporting systems are separated from the online transaction processing systems (OLTP) with periodic updates pushed in. A pre-defined and aggregated subset of the OLTP data, however, does not provide the flexibility, detail, and timeliness needed for today’s operational reporting. As technology advances, this separation has to be re-evaluated and means to study and evaluate new trends in data storage management have to be provided. This article proposes a benchmark for combined OLTP and operational reporting, providing means to evaluate the performance of enterprise data management systems for mixed workloads of OLTP and operational reporting queries. Such systems offer up-to-date information and the flexibility of the entire data set for reporting. We describe how the benchmark provokes the conflicts that are the reason for separating the two workloads on different systems. In this article, we introduce the concepts, logical data schema, transactions and queries of the benchmark, which are entirely based on the original data sets and real workloads of existing, globally operating enterprises.     

Assessment of unilateral spatial neglect: Scoring star cancellation performance from video recordings—method, reliability, benefits, and normative data.

Unilateral spatial neglect, a debilitating condition affecting awareness of one side of space, is commonly assessed using cancellation tasks in which patients cross out targets distributed over a sheet. Standard scores emphasize the left–right distribution of omissions. Here, the additional value of extracting temporal as well as spatial aspects of performance from video recordings was examined. Videos from 18 patients with left neglect and 19 healthy age-matched control participants were obtained. Interrater reliability of the video analysis was high. In addition to overall differences in target detection and bias, patients significantly differed from the control group in terms of the location of first cancellation, overall slowness, greater variability in speed, systematic slowing with time on task and as a function of target location, less coherent search organization, and a sharply increased tendency to recancel targets. Considering a subset of patients whose scores, by standard criteria, were at or near the normal range indicated that these additional variables indeed increased the sensitivity of the task as well as allowed the simultaneous assessment of spatial and nonspatial aspects of the disorder. (PsycINFO Database Record (c) 2010 APA, all rights reserved)     

μPIXE for a μBrain: The vinegar fly’s brain, antenna, sensilla hairs and eye ion concentrations

The vinegar fly Drosophila melanogaster is used as model organism to study a variety of different scientific purposes. Thus, our laboratory studies the olfactory system by neurobiological experiments. These techniques are often disruptive and need to compensate or exchange the body fluid, the lymph, with an artificial Ringer’s solution in defined compartments of the fly. The solution mainly contains Na, Cl, K and Ca and is to keep physiological conditions. Therefore, the knowledge about the ion concentrations in the respective Drosophila lymph is required for a correct mixture of the ions.This paper presents the spatially resolved concentrations of P, S, Cl, K, Ca, Fe, Cu and Zn in lyophilised head cryosections of Drosophila by using quantitative μPIXE at the ion beam facility LIPSION in Leipzig. The PIXE maps enable a detailed analysis of particular regions of interest down to a spatial resolution of 0.5 μm.We quantified the ion concentrations especially in the brain, the antenna and its sensilla hairs acting as the olfactory organ of the fly, in the compound eye and in the mouthparts. The averaged element concentrations of these main compartments are (in descending order): P: 90 mM, K: 81 mM, S: 38 mM, Cl: 18 mM, Ca: 4.9 mM, Fe: 1.4 mM, Zn: 1.2 mM, Cu: 0.06 mM. Certain structures or cavities possess a remarkably high concentration of particular elements and might reflect the different functions of the compartments. An example presented in more detail is the composition of the compound eye. Conclusively, our findings on the ion concentrations might be useful for the mixture of the Drosophila Ringer’s solution to ensure physiological conditions in experiments.     

Non-coherent distributed space–time coding techniques for two-way wireless relay networks

To overcome the overhead involved with channel estimation, several non-coherent distributed space–time coding (DSTC) strategies for two-way wireless relay networks (TWRNs) using the amplify-and-forward and the decode-and-forward protocol have been recently proposed that do not require channel state information (CSI) at any node to decode the information symbols. In this paper, novel differential DSTC strategies for TWRNs using the two- and three-phase protocol are proposed. In our transmission schemes, the relays do not waste power to transmit information known at the respective destination nodes. This is achieved by combining the symbols from both terminals received at the relays into a single symbol of the unaltered constellation. Furthermore, in our strategies, the direct link between the communicating terminals can be naturally incorporated to further improve the diversity gain. Simulations show a substantially improved performance in terms of bit error rate (BER) of the proposed strategies as compared to the existing strategies.     

Displaying a clustering with CLUSPLOT

In a bivariate data set it is easy to represent clusters, e.g. by manually circling them or separating them by lines. But many data sets have more than two variables, or they come in the form of inter-object dissimilarities. There exist methods to partition such a data set into clusters, but the resulting partition is not visual by itself. In this paper we construct a new graphical display called CLUSPLOT, in which the objects are represented as points in a bivariate plot and the clusters as ellipses of various sizes and shapes. The algorithm is implemented as an S-PLUS function. Several options are available, e.g. labelling of objects and clusters, drawing lines connecting clusters, and the use of color. We illustrate this new tool with several examples.     

Microscopic Cascading Devices for Boosting Mucus Penetration in Oral Drug Delivery—Micromotors Nesting Inside Microcontainers

In the case of macromolecules and poorly permeable drugs, oral drug delivery features low bioavailability and low absorption across the intestinal wall. Intestinal absorption can be improved if the drug formulation could be transported close to the epithelium. To achieve this, a cascade delivery device comprising Magnesium-based Janus micromotors (MMs) nesting inside a microscale containers (MCs) has been conceptualized. The device aims at facilitating targeted drug delivery mediated by MMs that can lodge inside the intestinal mucosa. Loading MMs into MCs can potentially enhance drug absorption through increased proximity and unidirectional release. The MMs will be provided with optimal conditions for ejection into any residual mucus layer that the MCs have not penetrated. MMS confined inside MCs propel faster in the mucus environment as compared to non-confined MMs. Upon contact with a suitable fuel, the MM-loaded MC itself can also move. An in vitro study shows fast release profiles and linear motion properties in porcine intestinal mucus compared to more complex motion in aqueous media. The concept of dual-acting cascade devices holds great potential in applications where proximity to epithelium and deep mucus penetration are needed.