Computer Vision and Pattern Recognition 2020

International Journal of Computer Vision -     

Bitwise dimensional co-clustering for analytical workloads

Analytical workloads in data warehouses often include heavy joins where queries involve multiple fact tables in addition to the typical star-patterns, dimensional grouping and selections. In this paper we propose a new processing and storage framework called bitwise dimensional co-clustering (BDCC) that avoids replication and thus keeps updates fast, yet is able to accelerate all these foreign key joins, efficiently support grouping and pushes down most dimensional selections. The core idea of BDCC is to cluster each table on a mix of dimensions, each possibly derived from attributes imported over an incoming foreign key and this way creating foreign key connected tables with partially shared clusterings. These are later used to accelerate any join between two tables that have some dimension in common and additionally permit to push down and propagate selections (reduce I/O) and accelerate aggregation and ordering operations. Besides the general framework, we describe an algorithm to derive such a physical co-clustering database automatically and describe query processing and query optimization techniques that can easily be fitted into existing relational engines. We present an experimental evaluation on the TPC-H benchmark in the Vectorwise system, showing that co-clustering can significantly enhance its already high performance and at the same time significantly reduce the memory consumption of the system.     

Stream engines meet wireless sensor networks: cost-based planning and processing of complex queries in AnduIN

Wireless sensor networks are powerful, distributed, self-organizing systems used for event and environmental monitoring. In-network query processors like TinyDB offer a user friendly SQL-like application development. Due to the sensor nodes?? resource limitations, monolithic approaches often support only a restricted number of operators. For this reason, complex processing is typically outsourced to the base station. Nevertheless, previous work has shown that complete or partial in-network processing can be more efficient than the base station approach. In this paper, we introduce AnduIN, a system for developing, deploying, and running complex in-network processing tasks. In particular, we present the query planning and execution strategies used in AnduIN, a system combining sensor-local in-network processing and a data stream engine. Query planning employs a multi-dimensional cost model taking energy consumption into account and decides autonomously which query parts will be processed within the sensor network and which parts will be processed at the central instance.     

Comparison of RRR-α- and all-rac-α-tocopherol uptake by permanent rat skeletal muscle myoblasts (L6 cells): Effects of exogenous lipoprotein lipase

The purpose of the present investigation was to test whether permanent skeletal muscle cells (rat L6 cells) could serve as an in vitro model for α-tocopherol (αTocH) biodiscrimination studies. L6 cells were incubated in the presence of high density lipoprotein (HDL), low density lipoprotein (LDL), and very low density lipoprotein (VLDL) labeled in the lipid moiety with either all-rac-or RRR-[¹⁴C]αTocH. These incubations were performed either in the absence or in the presence of exogenously added bovine lipoprotein lipase (LPL) since skeletal muscle is one of the major expression sites of LPL in vivo. Time-dependent uptake studies (up to 24 h) in the absence of LPL have shown that equipotent doses of all-rac- and RRR-[¹⁴C]αTocH (1.36∶1) led to almost identical accumulation of the tracer, independent of the lipoprotein class used as αTocH carrier. With regard to αTocH donor capacity, it appeared that HDL is the most potent αTocH donor, followed by LDL and VLDL. In the presence of LPL, all-rac- and RRR-[¹⁴C]αTocH uptake was significantly enhanced (between two- and tenfold). Biodiscrimination studies using chiral high-performance liquid chromatographic analysis with radiometric detection of the corresponding methyl ether derivatives on a Chiralcel OD column have demonstrated that the 2S-and 2R-isomers of αTocH were taken up in a 1∶1 ratio by L6 cells independent of the absence or presence of LPL. In addition, we have not observed biodiscrimination between the four 2R-isomers, i.e., there was no preferential accumulation of the RRR-isomer. These data suggest that L6 cells do not discriminate between different αTocH isomers and that the addition of endogenous LPL significantly enhances the uptake of RRR- and all-rac-αTocH.     

Performance and durability of a generator set CI engine using synthetic and petroleum based fuels for military applications

The long term performance and durability evaluation of a compression ignition (CI) engine of a diesel power generator using ultra-low sulfur diesel (ULSD) and Synthetic Paraffinic Kerosene, (S-8) fuels have been investigated under military specifications. The brake specific fuel consumptions (BSFC) were 0.308 ± 0.013 and 0.267 ± 0.019 kg/kW-h for ULSD and S-8, respectively. The corresponding brake thermal efficiencies (BTE) were 0.287 ± 0.002 and 0.309 ± 0.005. Degradation of engine performance or engine part wear was not observed during these test periods. Analysis of lubricating oil suggests negligible engine part wear. The frequency and power output of the generator, however, were not as stable with S-8 as those with ULSD. These power and frequency instabilities can be attributed to higher volatility and lower density and viscosity of S-8, all of which affect the fuel injection characteristics.     

A Novel Formalism for Partially Defined Asynchronous Feedback Digital Circuits

In contrast to combinational logic and master clocked sequential logical, asynchronous feedback circuits are partially defined due to analogous meta-stabilities. We present a novel formalism to exactly explore this digitally assisted analog phenomenon in order to build up a representative test bench that is able to enforce race constraints (meta-stable behavior) for non-deterministics, instabilities as well as for oscillations in feedback structures. Further, we introduce our definitions for consistently modeling under state transition graphs, we provide all entities for modeling asynchronous feedback structures and state our proposed methodology with an exemplary asynchronous circuitry. The given example is explained at a high level of abstraction, all data for revision is provided, too. The approach seems to be capable to test for meta-stabilities, analog behavior in feedback digital structures.     

Dissolution Testing: Semiautomatic Sampling and Analysis for $700

A semiautomatic sampling and analysis system (SASAS) has been developed for dissolutions of formulations containing a UV(VIS) absorbing active ingredient. The basis of the system is a peristaltic pump which transfers samples from the dissolution vessels to a flow cell in a UV(VIS) spectrophotometer. Sample selection is performed by the analyst, reducing processing time to less than 30 seconds per sample. SASAS was first applied to Theophylline tablets and sustained release capsules at a cost of $700. As many as 36 samples were tested by one analyst concurrently.