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

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

Ln3+ (Ln = Eu, Dy) - doped Sr2CeO4 fine phosphor particles: wet chemical preparation, energy transfer and tunable luminescence

The Sr2CeO4:Ln3+ (Ln = Eu, Dy) fine phosphor particles were prepared by a facile wet chemical approach, in which the consecutive hydrothermal-combustion reaction was performed. The doping of Ln3+ into Sr2CeO4 has little influence on the structure of host, and the as-prepared samples display well-crystallized spherical or elliptical shape with an average particle size at about 100–200 nm. For Eu3+ ions-doped Sr2CeO4, with the increase of Eu3+-doping concentration, the blue light emission band with the maximum at 468 nm originating from a Ce4+ → O2− charge transfer of the host decreases obviously and the characteristic red light emission of Eu3+ (5D0→7F2 transition at 618 nm) is enhanced gradually. Simultaneously, the fluorescent lifetime of the broadband emission of Sr2CeO4 decreases with the doping of Eu3+, indicating an efficient energy transfer from the host to the doping Eu3+ ions. The energy transfer efficiency from the host to Eu3+ was investigated in detail, and the emitting color of Sr2CeO4:Eu3+ can be easily tuned from blue to red by varying the doping concentration of Eu3+ ions. Moreover, the luminescence of Dy3+-doped Sr2CeO4 was also studied. Similar energy transfer phenomenon can be observed, and the incorporation of Dy3+ into Sr2CeO4 host leads to the characteristic emission of 4F9/2 → 6H15/2 (488 nm, blue light) and 4F9/2 → 6H13/2 (574 nm, yellow light) of Dy3+. The Sr2CeO4:Ln3+ fine particles with tunable luminescence are quite beneficial for its potential applications in the optoelectronic fields.publishe

TENSILE: A Tensor granularity dynamic GPU memory scheduling method towards multiple dynamic workloads system

Recently, deep learning has been an area of intense research. However, as a kind of computing-intensive task, deep learning highly relies on the scale of GPU memory, which is usually prohibitive and scarce. Although there are some extensive works have been proposed for dynamic GPU memory management, they are hard to be applied to systems with multiple dynamic workloads, such as in-database machine learning systems. In this paper, we demonstrated TENSILE, a method of managing GPU memory in tensor granularity to reduce the GPU memory peak, considering the multiple dynamic workloads. TENSILE tackled the cold-starting and across-iteration scheduling problem existing in previous works. We implement TENSILE on a deep learning framework built by ourselves and evaluated its performance. The experiment results show that TENSILE can save more GPU memory with less extra time overhead than prior works in both single and multiple dynamic workloads scenarios

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

Pt 3 Co Concave Nanocubes: Synthesis, Formation Understanding, and Enhanced Catalytic Activity toward Hydrogenation of Styrene

We report a facile synthesis route to prepare high‐quality Pt 3 Co nanocubes with a concave structure, and further demonstrate that these concave Pt 3 Co nanocubes are terminated with high‐index crystal facets. The success of this preparation is highly dependent on an appropriate nucleation process with a successively anisotropic overgrowth and a preservation of the resultant high‐index planes by control binding of oleyl‐amine/oleic acid with a fine‐tuned composition. Using a hydrogenation of styrene as a model reaction, these Pt 3 Co concave nanocubes as a new class of nanocatalysts with more open structure and active atomic sites located on their high‐index crystallographic planes exhibit an enhanced catalytic activity in comparison with low‐indexed surface terminated Pt 3 Co nanocubes in similar size. Anisotropic overgrowth : Pt 3 Co concave nanocubes bounded by high‐index facets were prepared with a facile wet‐chemical method. The formation process for such concave nanostructures was systematically studied, and a plausible mechanism was proposed. These nanocrystals can be used as advanced nanocatalysts, showing high activity and reusability toward hydrogenation of styrene (see figure).Peer Reviewedhttp://deepblue.lib.umich.edu/bitstream/2027.42/102689/1/chem_201301724_sm_miscellaneous_information.pdfhttp://deepblue.lib.umich.edu/bitstream/2027.42/102689/2/1753_ftp.pd

Hydrothermal combustion synthesis and characterization of Sr2CeO4 phosphor powders

In this paper, the blue-light-emitting Sr2CeO4 phosphor powders were prepared by hydrothermal combustion reactions and a subsequent sintering process. During the process, the mixed urea and glycine were both used as leavening agent and fuel. The particle crystallization, surface morphology as well as the luminescence intensities of the Sr2CeO4 phosphor powders were effectively improved by adjusting the amount of glycine and post-sintering temperatures. The Sr2CeO4 phosphor exhibited strong crystallization and well-distributed spherical particle after optimization. Moreover, the intense blue-light emission band with the maximum at 468 nm in the range of 400–600 nm was observed as excited with ultraviolet light 277 nm. In particular, after the precursors were heat-treated at 1100 °C, the samples could be well-excited around 350 nm. The excitation bands were ascribed to the charge transfer from O to Ce, and the enlarged excitation range may facilitate its uses in optoelectronic fields.publishe

Quantitative determination and pharmacokinetics of salvianolic acid l, a novel phenolic acid constituent from salvia miltiorrhiza, in rat plasma by high-performance liquid chromatography

A simple, rapid and selective HPLC method was developed for the determination of a novel phenolic acid constituent in rat plasma, salvianolic acid L (SAL), extracted from the dried root of Salvia miltiorrhiza (Danshen). Plasma samples were extracted by ethyl acetate after addition of the internal standard tinidazole. The appropriate separations were achieved using a C18 column with the mobile phase composed of a mixture of acetonitrile/water/formic acid (35:65:0.1, v/v/v) at the flow rate of 0.8 mL/min, and the wavelength of determination by diode-array detector (DAD) detection was 327 nm. Good linearity (r = 0.9996) was obtained within the concentration of 0.05-50 μg/mL. The intra- and inter-day assay precisions ranged from 0.60 to 5.91% and 3.52 to 7.00%, respectively. The accuracy was between 95.8 to 103.8%. In addition, the stability and extraction recovery involved in the method were also validated. This method was successfully applied to investigate the pharmacokinetic study of SAL in rats after a single intravenous administration dose of 2.0, 4.0, and 8.0 mg/kg, respectively.Colegio de Farmacéuticos de la Provincia de Buenos Aire