DualTable: A Hybrid Storage Model for Update Optimization in Hive

Hive is the most mature and prevalent data warehouse tool providing SQL-like interface in the Hadoop ecosystem. It is successfully used in many Internet companies and shows its value for big data processing in traditional industries. However, enterprise big data processing systems as in Smart Grid applications usually require complicated business logics and involve many data manipulation operations like updates and deletes. Hive cannot offer sufficient support for these while preserving high query performance. Hive using the Hadoop Distributed File System (HDFS) for storage cannot implement data manipulation efficiently and Hive on HBase suffers from poor query performance even though it can support faster data manipulation.There is a project based on Hive issue Hive-5317 to support update operations, but it has not been finished in Hive's latest version. Since this ACID compliant extension adopts same data storage format on HDFS, the update performance problem is not solved. In this paper, we propose a hybrid storage model called DualTable, which combines the efficient streaming reads of HDFS and the random write capability of HBase. Hive on DualTable provides better data manipulation support and preserves query performance at the same time. Experiments on a TPC-H data set and on a real smart grid data set show that Hive on DualTable is up to 10 times faster than Hive when executing update and delete operations.Comment: accepted by industry session of ICDE201

Flexural behavior of slab-rib integrated bridge decks with GFRP skin and polyurethane foam core

This paper presents experimental and analytical studies on flexural behavior of slab-rib integrated Sandwich composite decks. The influences of layers of glass fiber-reinforced polymer (GFRP) facesheets, foam densities, and the existence of webs and cross beams are discussed herein. The test results showed that the existence of vertical webs remarkably improved the debonding of the facesheets from the foam core, thus increasing the ultimate load by 59% compared with the specimens without webs. However, the existence of horizontal webs has insignificant effect on the failure mode and ultimate load. Increasing the number of layers of GFRP facesheets from 2 to 4 and 6 results in 100% and 214% increments in ultimate loads, respectively, while the specimen with lower density of foam had a higher ultimate load than the specimen with higher density of foam due to deformation compatibility between GFRP skins and foam core with low density. The analysis software Abaqus Explicit was used to simulate the flexural behavior of test specimens, and the numerical results agreed well with the test data. The verified finite element model was extended to analyze the influences of the number of GFRP layers on the top of decks and the height of vertical webs. Based on equivalent method and compatibility of shear deformation, the flexural and shear rigidities were estimated. Then, analytical solution for displacement of the slab-rib integrated Sandwich composite decks subjected to four-point load was derived out. Comparison of analytical and experimental results shows that the displacements can be precisely predicted by the present theoretical model

Immune Efficacy of a Genetically Engineered Vaccine against Lymphocystis Disease Virus: Analysis of Different Immunization Strategies

Here, we report the construction of a vaccine against lymphocystis disease virus (LCDV) using nucleic acid vaccination technology. A fragment of the major capsid protein encoding gene from an LCDV isolated from China (LCDV-cn) was cloned into an eukaryotic expression vector pEGFP-N2, yielding a recombinant plasmid pEGFP-N2-LCDV-cn0.6 kb. This plasmid was immediately expressed after liposomal transfer into the Japanese flounder embryo cell line. The recombinant plasmid was inoculated into Japanese flounder via two routes (intramuscular injection and hypodermic injection) at three doses (0.1, 5, and 15 μg), and then T-lymphopoiesis in different tissues and antibodies raised against LCDV were evaluated. The results indicated that this recombinant plasmid induced unique humoral or cell-mediated immune responses depending on the inoculation route and conferred immune protection. Furthermore, the humoral immune responses and protective effects were significantly increased at higher vaccine doses via the two injection routes. Plasmid pEGFP-N2-LCDV0.6 kb is therefore a promising vaccine candidate against LCDV in Japanese flounder

Real-time visualization of clustering and intracellular transport of gold nanoparticles by correlative imaging.

Mechanistic understanding of the endocytosis and intracellular trafficking of nanoparticles is essential for designing smart theranostic carriers. Physico-chemical properties, including size, clustering and surface chemistry of nanoparticles regulate their cellular uptake and transport. Significantly, even single nanoparticles could cluster intracellularly, yet their clustering state and subsequent trafficking are not well understood. Here, we used DNA-decorated gold (fPlas-gold) nanoparticles as a dually emissive fluorescent and plasmonic probe to examine their clustering states and intracellular transport. Evidence from correlative fluorescence and plasmonic imaging shows that endocytosis of fPlas-gold follows multiple pathways. In the early stages of endocytosis, fPlas-gold nanoparticles appear mostly as single particles and they cluster during the vesicular transport and maturation. The speed of encapsulated fPlas-gold transport was critically dependent on the size of clusters but not on the types of organelle such as endosomes and lysosomes. Our results provide key strategies for engineering theranostic nanocarriers for efficient health management

The Roles of Buyang Huanwu Decoction in Anti-Inflammation, Antioxidation and Regulation of Lipid Metabolism in Rats with Myocardial Ischemia

Buyang Huanwu Decoction (BYHWD) is a well-known Chinese medicine formula. Recent studies have reported that BYHWD can be used to treat ischemic heart disease. This study investigated the potential mechanism underlying the roles of BYHWD in alleviating the myocardial ischemia induced by isoproterenol (ISO) in rats. Different doses of BYHWD (25.68, 12.84 and 6.42 g kg−1) were lavaged to rats, respectively. Then the expression of the cluster of differentiation 40 (CD40) in the mononuclear cells was measured using flow cytometry, and the expressions of CD40 and its ligand (CD40L) in myocardial tissues were determined by western blotting. The serum biochemical values of superoxide dismutase (SOD) activity, the malondialdehyde (MDA) level and the free fatty acid (FFA) content were measured. The results showed that the SOD activities of BYHWD groups were significantly higher than that of the ISO group, while the MDA levels and FFA contents of all BYHWD groups were lower than that of the ISO group. BYHWD could decrease the expression of CD40 in the mononuclear cells and the CD40 and CD40L expressions in myocardial tissues. Our data suggest that the roles of BYHWD are not only related to its antioxidative action and regulation of lipid metabolisms, but also to the inhibition of inflammatory pathway by the decreased CD40 and CD40L expressions in rats with myocardial ischemia

An outbreak of aseptic meningitis caused by a distinct lineage of coxsackievirus B5 in China

SummaryIn 2009, an outbreak of aseptic meningitis caused by coxsackievirus B5 (CVB5) occurred in China. Epidemiological investigations of this outbreak revealed that the proportion of severe cases (14/43, 33%) was higher than in other outbreaks associated with CVB5 in China. Phylogenetic analysis of the entire VP1 sequences demonstrated that the CVB5 isolates from the severe cases form a distinct lineage belonging to genogroup E with the Shandong isolates of 2009. A substitution of serine (S) to asparagine (N) at amino acid 95 in the VP1 region may be a major virulence determinant for the virus. Our findings suggest that this new lineage of CVB5 is circulating in China. Further genetic studies are needed in order to gain a better insight into the genetic variability of CVB5 isolates and the relationship with pathogenicity

Nanocontact Disorder in Nanoelectronics for Modulation of Light and Gas Sensitivities

To fabricate reliable nanoelectronics, whether by top-down or bottom-up processes, it is necessary to study the electrical properties of nanocontacts. The effect of nanocontact disorder on device properties has been discussed but not quantitatively studied. Here, by carefully analyzing the temperature dependence of device electrical characteristics and by inspecting them with a microscope, we investigated the Schottky contact and Mott\u27s variable-range-hopping resistances connected in parallel in the nanocontact. To interpret these parallel resistances, we proposed a model of Ti/TiOx in the interface between the metal electrodes and nanowires. The hopping resistance as well as the nanocontact disorder dominated the total device resistance for high-resistance devices, especially at low temperatures. Furthermore, we introduced nanocontact disorder to modulate the light and gas responsivities of the device; unexpectedly, it multiplied the sensitivities compared with the intrinsic sensitivity of the nanowires. Our results improve the collective understanding of electrical contacts to low-dimensional semiconductor devices and will aid performance optimization in future nanoelectronics

Long-term culture captures injury-repair cycles of colonic stem cells

The colonic epithelium can undergo multiple rounds of damage and repair, often in response to excessive inflammation. The responsive stem cell that mediates this process is unclear, in part because of a lack of in vitro models that recapitulate key epithelial changes that occur in vivo during damage and repair. Here, we identify a Hop