Query processing of pre-partitioned data using Sandwich Operators

textabstractIn this paper we present the Sandwich Operators, an elegant approach to exploit pre-sorting or pre-grouping from clustered storage schemes in operators such as Aggregation/Grouping, HashJoin, and Sort of a database management system. Thereby, each of these operator types is "sandwiched" by two new operators, namely PartitionSplit and PartitionRestart. PartitionSplit splits the input relation into its smaller independent groups on which the sandwiched operator is executed. After a group is processed PartitionRestart is used to trigger the execution on the following group. Executing one of these operator types with the help of the Sandwich Operators introduces minimal overhead and does not penalty performance of the sandwiched operator as its implementation remains unchanged. On the contrary, we show that sandwiched execution of an operator results in lower memory consumption and faster execution time. PartitionSplit and PartitionRestart replace special implementations of partitioned versions of these operator. Sandwich Operators also turn blocking operators in streaming operators, resulting in faster response times for the first query results

Automatic Schema Design for Co-Clustered Tables

Schema design of analytical workloads provides opportunities to index, cluster, partition and/or materialize. With these opportunities also the complexity of finding the right setup rises. In this paper we present an automatic schema design approach for a table co-clustering scheme called Bitwise Dimensional Co-Clustering, aimed at schemas with a moderate amount dimensions, but not limited to typical star and snowflake schemas. The goal is to design one primary schema and keep the knobs to turn to a minimum while providing a robust schema for a wide range of queries. In our approach a clustered schema is derived by trying to apply dimensions throughout the whole schema and co-cluster as many tables as possible according to at least one common dimension. Our approach is based on the assumption that initially foreign key relationships and a set of dimensions are defined based on classic DDL

Charge-Induced Fragmentation of Sodium Clusters

The fission of highly charged sodium clusters with fissilities X>1 is studied by {\em ab initio} molecular dynamics. Na_{24}^{4+} is found to undergo predominantly sequential Na_{3}^{+} emission on a time scale of 1 ps, while Na_{24}^{Q+} (5 \leq Q \leq 8) undergoes multifragmentation on a time scale \geq 0.1 ps, with Na^{+} increasingly the dominant fragment as Q increases. All singly-charged fragments Na_{n}^{+} up to size n=6 are observed. The observed fragment spectrum is, within statistical error, independent of the temperature T of the parent cluster for T \leq 1500 K. These findings are consistent with and explain recent trends observed experimentally.Comment: To appear in Physical Review Letter

Machine learning based prediction of squamous cell carcinoma in ex vivo confocal laser scanning microscopy

Image classification with convolutional neural networks (CNN) offers an unprecedented opportunity to medical imaging. Regulatory agencies in the USA and Europe have already cleared numerous deep learning/machine learning based medical devices and algorithms. While the field of radiology is on the forefront of artificial intelligence (AI) revolution, conventional pathology, which commonly relies on examination of tissue samples on a glass slide, is falling behind in leveraging this technology. On the other hand, ex vivo confocal laser scanning microscopy (ex vivo CLSM), owing to its digital workflow features, has a high potential to benefit from integrating AI tools into the assessment and decision-making process. Aim of this work was to explore a preliminary application of CNN in digitally stained ex vivo CLSM images of cutaneous squamous cell carcinoma (cSCC) for automated detection of tumor tissue. Thirty-four freshly excised tissue samples were prospectively collected and examined immediately after resection. After the histologically confirmed ex vivo CLSM diagnosis, the tumor tissue was annotated for segmentation by experts, in order to train the MobileNet CNN. The model was then trained and evaluated using cross validation. The overall sensitivity and specificity of the deep neural network for detecting cSCC and tumor free areas on ex vivo CLSM slides compared to expert evaluation were 0.76 and 0.91, respectively. The area under the ROC curve was equal to 0.90 and the area under the precision-recall curve was 0.85. The results demonstrate a high potential of deep learning models to detect cSCC regions on digitally stained ex vivo CLSM slides and to distinguish them from tumor-free skin

Rearrangement of cluster structure during fission processes

Results of molecular dynamics simulations of fission reactions $Na_{10}^{2+} \to Na_7^+ + Na_3^+$ and $Na_{18}^{2+} \to 2 Na_9^+$ are presented. Dependence of the fission barriers on isomer structure of the parent cluster is analyzed. It is demonstrated that the energy necessary for removing homothetic groups of atoms from the parent cluster is largely independent of the isomer form of the parent cluster. Importance of rearrangement of the cluster structure during the fission process is elucidated. This rearrangement may include transition to another isomer state of the parent cluster before actual separation of the daughter fragments begins and/or forming a "neck" between the separating fragments

Validity constraints for data analysis workflows

\ua9 2024Porting a scientific data analysis workflow (DAW) to a cluster infrastructure, a new software stack, or even only a new dataset with some notably different properties is often challenging. Despite the structured definition of the steps (tasks) and their interdependencies during a complex data analysis in the DAW specification, relevant assumptions may remain unspecified and implicit. Such hidden assumptions often lead to crashing tasks without a reasonable error message, poor performance in general, non-terminating executions, or silent wrong results of the DAW, to name only a few possible consequences. Searching for the causes of such errors and drawbacks in a distributed compute cluster managed by a complex infrastructure stack, where DAWs for large datasets typically are executed, can be tedious and time-consuming. We propose validity constraints (VCs) as a new concept for DAW languages to alleviate this situation. A VC is a constraint specifying logical conditions that must be fulfilled at certain times for DAW executions to be valid. When defined together with a DAW, VCs help to improve the portability, adaptability, and reusability of DAWs by making implicit assumptions explicit. Once specified, VCs can be controlled automatically by the DAW infrastructure, and violations can lead to meaningful error messages and graceful behavior (e.g., termination or invocation of repair mechanisms). We provide a broad list of possible VCs, classify them along multiple dimensions, and compare them to similar concepts one can find in related fields. We also provide a proof-of-concept implementation for the workflow system Nextflow

Children's game library as a Unique Extracurricular Educational Establishment in the USSR (the middle of the 20th century)

The article reveals the history of emergence and work of children's game libraries in the USSR in the middle of the 20th century. The first children's game libraries, which were educational establishments where children could come and play different games, using various game and sport equipment free of charge, appeared in the 1930th and became wide spread in the USSR in the 1930th - 1950th. Children's game libraries had different tasks of their work (organizing children's cultural leisure time, increasing the educational and political levels of children's games and entertainments which were conducted in schools, summer camps and extracurricular educational establishments). They also had different directions of their work, namely: organizational, methodic, educational, experimental, instructive and consultative directions. It has been shown in the article that children’s game libraries had great results of their work (they involved a lot of children and adults in their activities; the network of children's game libraries began to grow; a lot of new toys and games were created and produced by them). However, children's game libraries faced certain difficulties in their work, namely: absence of own premises of children’s game libraries, lack of enough support for their activities by some educational institutions and teaching staff, lack of the required amount of toys and games, insufficient instructive and publishing activities of children’s game libraries

Regulation of cell survival by sphingosine-1-phosphate receptor S1P1 via reciprocal ERK-dependent suppression of bim and PI-3-kinase/protein kinase C-mediated upregulation of Mcl-1

Although the ability of bioactive lipid sphingosine-1-phosphate (S1P) to positively regulate anti-apoptotic/pro-survival responses by binding to S1P1 is well known, the molecular mechanisms remain unclear. Here we demonstrate that expression of S1P1 renders CCL39 lung fibroblasts resistant to apoptosis following growth factor withdrawal. Resistance to apoptosis was associated with attenuated accumulation of pro-apoptotic BH3-only protein Bim. However, although blockade of extracellular signal-regulated kinase (ERK) activation could reverse S1P1-mediated suppression of Bim accumulation, inhibition of caspase-3 cleavage was unaffected. Instead S1P1-mediated inhibition of caspase-3 cleavage was reversed by inhibition of phosphatidylinositol-3-kinase (PI3K) and protein kinase C (PKC), which had no effect on S1P1 regulation of Bim. However, S1P1 suppression of caspase-3 was associated with increased expression of anti-apoptotic protein Mcl-1, the expression of which was also reduced by inhibition of PI3K and PKC. A role for the induction of Mcl-1 in regulating endogenous S1P receptor-dependent pro-survival responses in human umbilical vein endothelial cells was confirmed using S1P receptor agonist FTY720-phosphate (FTY720P). FTY720P induced a transient accumulation of Mcl-1 that was associated with a delayed onset of caspase-3 cleavage following growth factor withdrawal, whereas Mcl-1 knockdown was sufficient to enhance caspase-3 cleavage even in the presence of FTY720P. Consistent with a pro-survival role of S1P1 in disease, analysis of tissue microarrays from ER+ breast cancer patients revealed a significant correlation between S1P1 expression and tumour cell survival. In these tumours, S1P1 expression and cancer cell survival were correlated with increased activation of ERK, but not the PI3K/PKB pathway. In summary, pro-survival/anti-apoptotic signalling from S1P1 is intimately linked to its ability to promote the accumulation of pro-survival protein Mcl-1 and downregulation of pro-apoptotic BH3-only protein Bim via distinct signalling pathways. However, the functional importance of each pathway is dependent on the specific cellular context