ETL Pipeline Resource Predictions in Distributed Data Warehouses

Data warehouses of large corporations are increasing in size. Many companies have adopted a distributed data warehouse system， which may store data on many machines. Every day, millions of ETL jobs send data to those warehouses, but some jobs fail due to lack of resources and need to be restarted. Predicting ETL resource demands in distributed data warehouse systems is crucial for efficient use of resources and improved ETL pipeline tasks execution performance. The subject of resource-demand predictions for the ETL data pipeline has not yet been discussed in the literature. This paper discusses a method of predicting resource demands based on history. The linear regression function y = k x +b is used to predict memory, as well as disk usage, thus enabling improvement of accuracy of resource usage and the performance of ETL pipeline tasks execution

Improving the Performance of SQL Join Operation in the Distributed Enterprise Information System by Caching

The enterprise information system (EIS) contains databases and other data sources in multiple data centers. Users query the EIS via clients. The client has a working space in the cloud. Caching data in client space will reduce the total execution time of the query. However, the client space has limited resources to store data. There are two options for caching data at the client space: caching the final results of query operations, or caching the source data tables. The problem is that some query operations such as “joining multiple big tables” will simply produce a result too big to store in cache in some cases. By contrast, caching source data tables may be a better choice in those situations. This paper presents an algorithm that combines active caching and passive caching to improve the cache hit, thus improving performance of the SQL join query in the cloud computing environment

Improving the Data Warehouse Architecture Using Design Patterns

Data warehousing is an important part of the enterprise information system. Business intelligence (BI) relies on data warehouses to improve business performance. Data quality plays a key role in BI. Source data is extracted, transformed, and loaded (ETL) into the data warehouses periodically. The ETL operations have the most crucial impact on the data quality of the data warehouse. ETL-related data warehouse architectures including structure-oriented layer architectures and enterprise-view data mart architecture were studied in the literature. Existing architectures have the layer and data mart components but do not make use of design patterns; thus, those approaches are inefficient and pose potential problems. This paper relays how to use design patterns to improve data warehouse architectures

Cardiac-derived CTRP9 protects against myocardial ischemia/reperfusion injury via calreticulin-dependent inhibition of apoptosis.

Cardiokines play an essential role in maintaining normal cardiac functions and responding to acute myocardial injury. Studies have demonstrated the heart itself is a significant source of C1q/TNF-related protein 9 (CTRP9). However, the biological role of cardiac-derived CTRP9 remains unclear. We hypothesize cardiac-derived CTRP9 responds to acute myocardial ischemia/reperfusion (MI/R) injury as a cardiokine. We explored the role of cardiac-derived CTRP9 in MI/R injury via genetic manipulation and a CTRP9-knockout (CTRP9-KO) animal model. Inhibition of cardiac CTRP9 exacerbated, whereas its overexpression ameliorated, left ventricular dysfunction and myocardial apoptosis. Endothelial CTRP9 expression was unchanged while cardiomyocyte CTRP9 levels decreased after simulated ischemia/`reperfusion (SI/R) in vitro. Cardiomyocyte CTRP9 overexpression inhibited SI/R-induced apoptosis, an effect abrogated by CTRP9 antibody. Mechanistically, cardiac-derived CTRP9 activated anti-apoptotic signaling pathways and inhibited endoplasmic reticulum (ER) stress-related apoptosis in MI/R injury. Notably, CTRP9 interacted with the ER molecular chaperone calreticulin (CRT) located on the cell surface and in the cytoplasm of cardiomyocytes. The CTRP9-CRT interaction activated the protein kinase A-cAMP response element binding protein (PKA-CREB) signaling pathway, blocked by functional neutralization of the autocrine CTRP9. Inhibition of either CRT or PKA blunted cardiac-derived CTRP9\u27s anti-apoptotic actions against MI/R injury. We further confirmed these findings in CTRP9-KO rats. Together, these results demonstrate that autocrine CTRP9 of cardiomyocyte origin protects against MI/R injury via CRT association, activation of the PKA-CREB pathway, ultimately inhibiting cardiomyocyte apoptosis

The differences of corneal astigmatism in different populations and its quantitative analysis

Objective: To analyze the differences of corneal astigmatism in different age groups. Methods: The clinical data of the patients from the outpatient Department of Ophthalmology of the Tengzhou Central People\u2019s Hospital from April 2014 to June 2014 was screened and statistically analyzed. The corneal curvature was measured by three different instruments: Keratometer, IOL Master and Sirius corneal topography. The changes of the corneal astigmatism in different groups were evalutaed in the study. Results: Corneal astigmatism of different groups showed no statistical difference and the average corneal astigmatism of 70~79 age group were higher than younger groups. As the age grew, the with-the-rule astigmatism gradually reduced from 85.8% ( A Group) to 31.0% (F Group). The against-the-rule astigmatism increased from 6.7% ( A Group ) to 45.0% (F Group). Conclusion: The proportion of the with-the-rule astigmatism gradually reduced with the growth of age. The proportion of the against-the-rule astigmatism increased significantly. The oblique astigmatism had no obvious change before the age of 40. The proportion of oblique astigmatism increased obviously at the 40~49 group and tended to be stable. After the age of 60, the proportion of different types of astigmatism tended to be stable

Study on elastohydrodynamic lubrication performance of double-layer composite water-lubricated bearings

Double-layer composite water-lubricated bearing is a new type of water-lubricated bearing which can integrate the good damping performance of low elastic under-layer bush and good tribological performance of plastic layer bush. This paper analyzes its elastohydrodynamic lubrication performance by fluid–structure interaction (FSI) method, and studies the effects of eccentricity ratio, rotational speed, elastic modulus distribution and thickness distribution of bearing bush on its lubrication performance. Results show that the lubrication performance of double-layer bearing is more like that of plastic bearing. As rotational speed and eccentricity ratio increase, the maximum water film pressure, the load carrying capacity and the maximum bush deformation increase significantly. As the elastic modulus of the low elastic under-layer bush decreases, the total bush deformation increases significantly, but the load carrying capacity decreases slightly. The bush thickness distribution influences the deformation distribution of both low elastic under-layer bush and plastic layer bush, but have little impact on the total bush deformation and bearing lubrication performance

EST analysis of gene expression in the tentacle of Cyanea capillata

AbstractJellyfish, Cyanea capillata, has an important position in head patterning and ion channel evolution, in addition to containing a rich source of toxins. In the present study, 2153 expressed sequence tags (ESTs) from the tentacle cDNA library of C. capillata were analyzed. The initial ESTs consisted of 198 clusters and 818 singletons, which revealed approximately 1016 unique genes in the data set. Among these sequences, we identified several genes related to head and foot patterning, voltage-dependent anion channel gene and genes related to biological activities of venom. Five kinds of proteinase inhibitor genes were found in jellyfish for the first time, and some of them were highly expressed with unknown functions

Application of diaminium iodides in binary ionic liquid electrolytes for dye-sensitized solar cells

N-(2-hydroxyethyl)ethylenediaminium iodides (HEEDAIs) and N-(2-hydroxyethyl)piperazinium iodides (HEPIs) were synthesized, and their thermal properties were analysed. The influence of HEEDAI and HEPI on I 3 − /I − redox behavior in binary ionic liquid was investigated. The result revealed that HEEDAI can suppress the recombination between I 3 − and the injected electrons in TiO 2 conduction band and be used as the alternative of 4-tert-butylpyridine in the electrolyte of dye-sensitized solar cells. The electrolyte C, 0.15 mol·L −1 I 2 , HEEDAI and MPII with mass ratio of 1 : 4, gave the short-circuit photocurrent density of 9.36 mA·cm −2 , open-circuit photovoltage of 0.67 V, fill factor of 0.52, and the corresponding photoelectric conversion efficiency of 3.24% at the illumination (air mass 1.5, 100 mW·cm −2 , active area 0.25 cm 2 )

Phosphorylation of HOX11/TLX1 on Threonine-247 during mitosis modulates expression of cyclin B1

RIGHTS : This article is licensed under the BioMed Central licence at http://www.biomedcentral.com/about/license which is similar to the 'Creative Commons Attribution Licence'. In brief you may : copy, distribute, and display the work; make derivative works; or make commercial use of the work - under the following conditions: the original author must be given credit; for any reuse or distribution, it must be made clear to others what the license terms of this work are.Abstract Background The HOX11/TLX1 (hereafter referred to as HOX11) homeobox gene was originally identified at a t(10;14)(q24;q11) translocation breakpoint, a chromosomal abnormality observed in 5-7% of T cell acute lymphoblastic leukemias (T-ALLs). We previously reported a predisposition to aberrant spindle assembly checkpoint arrest and heightened incidences of chromosome missegregation in HOX11-overexpressing B lymphocytes following exposure to spindle poisons. The purpose of the current study was to evaluate cell cycle specific expression of HOX11. Results Cell cycle specific expression studies revealed a phosphorylated form of HOX11 detectable only in the mitotic fraction of cells after treatment with inhibitors to arrest cells at different stages of the cell cycle. Mutational analyses revealed phosphorylation on threonine-247 (Thr247), a conserved amino acid that defines the HOX11 gene family and is integral for the association with DNA binding elements. The effect of HOX11 phosphorylation on its ability to modulate expression of the downstream target, cyclin B1, was tested. A HOX11 mutant in which Thr247 was substituted with glutamic acid (HOX11 T247E), thereby mimicking a constitutively phosphorylated HOX11 isoform, was unable to bind the cyclin B1 promoter or enhance levels of the cyclin B1 protein. Expression of the wildtype HOX11 was associated with accelerated progression through the G2/M phase of the cell cycle, impaired synchronization in prometaphase and reduced apoptosis whereas expression of the HOX11 T247E mutant restored cell cycle kinetics, the spindle checkpoint and apoptosis. Conclusions Our results demonstrate that the transcriptional activity of HOX11 is regulated by phosphorylation of Thr247 in a cell cycle-specific manner and that this phosphorylation modulates the expression of the target gene, cyclin B1. Since it is likely that Thr247 phosphorylation regulates DNA binding activity to multiple HOX11 target sequences, it is conceivable that phosphorylation functions to regulate the expression of HOX11 target genes involved in the control of the mitotic spindle checkpoint.Published versio

Creating a Dynamic Quadrupedal Robotic Goalkeeper with Reinforcement Learning

We present a reinforcement learning (RL) framework that enables quadrupedal robots to perform soccer goalkeeping tasks in the real world. Soccer goalkeeping using quadrupeds is a challenging problem, that combines highly dynamic locomotion with precise and fast non-prehensile object (ball) manipulation. The robot needs to react to and intercept a potentially flying ball using dynamic locomotion maneuvers in a very short amount of time, usually less than one second. In this paper, we propose to address this problem using a hierarchical model-free RL framework. The first component of the framework contains multiple control policies for distinct locomotion skills, which can be used to cover different regions of the goal. Each control policy enables the robot to track random parametric end-effector trajectories while performing one specific locomotion skill, such as jump, dive, and sidestep. These skills are then utilized by the second part of the framework which is a high-level planner to determine a desired skill and end-effector trajectory in order to intercept a ball flying to different regions of the goal. We deploy the proposed framework on a Mini Cheetah quadrupedal robot and demonstrate the effectiveness of our framework for various agile interceptions of a fast-moving ball in the real world.Comment: First two authors contributed equally. Accompanying video is at https://youtu.be/iX6OgG67-Z