CuDB : a Relational Database Engine Boosted by Graphics Processing Units

Proceedings of the First PhD Symposium on Sustainable Ultrascale Computing Systems (NESUS PhD 2016) Timisoara, Romania. February 8-11, 2016.GPUs benefit from much more computation power with the same order of energy consumption than CPUs. Thanks to their massive data parallel architecture, GPUs can outperform CPUs, especially on Single Program Multiple Data (SPMD) programming paradigm on a large amount of data. Database engines are now everywhere, from different sizes and complexities, for multiple usages, embedded or distributed; in 2012, 500 million of SQLite active instances were estimated over the world. Our goal is to exploit the computation power of GPUs to improve performance of SQLite, which is a key software component of many applications and systems. In this paper, we introduce CuDB, a GPU-boosted in-memory database engine (IMDB) based on SQLite. The SQLite API remains unchanged, allowing developers to easily upgrade database engine from SQlite to CuDB even on already existing applications. Preliminary results show significant speedups of 70x with join queries on datasets of 1 million records. We also demonstrate the "memory bounded" character of GPU-databases and show the energy efficiency of our approach.European Cooperation in Science and Technology. COS

Once more on θ\theta-vacua in 2+12+1 dimensional QED and 3+1 dimensional gluodynamics

Two different but tightly connected problems, $U(1)$ and strong CP violation problems, are discussed in two different models which exhibit both asymptotic freedom and confinement. One of them is the 3d Polyakov's model of compact QED and the other is 4d gluodynamics. It is shown that although both these models possess the long range interactions of the topological charges, only in the former case physics does not depend on $\theta$; while the latter exhibits an explicit $\theta$- dependence. The crucial difference is due to the observation, that the pseudoparticles of 4d gluodynamics possess an aditional quantum number, apart of the topological charge $Q$ .Comment: 15 page

Amélioration des performances d'un moteur de base de données relationnelle embarqué par l'utilisation de GPU

International audienceConcomitamment à la montée en puissance des systèmes de type « Big Data », les systèmes de gestion de base de données relationnelle (SGBDR) restent toujours largement utilisés. Dans cet article, nous présentons une solution capable d'améliorer la rapidité et la consommation énergétique d'un SGBDR embarqué SQLite. Notre solution, nommée CuDB, tente d'exploiter au mieux les spécificités des architectures modernes CPU/GPU. Nous combinons des traite-ments massivement parallèles avec un placement stratégique des données au plus près des unités de calculs. CuDB est un SGBDR embarqué de type « In-Memory » (IMDB). En fonction du contenu, de la sélectivité et du poids des échanges, nos mesures révèlent des facteurs d'ac-célération allant jusqu'à 90x sur GPU GTX770 par rapport à une implémentation classique de SQLite sur CPU Core i7. L'accélération des traitements fournis par notre solution engendre de surcroît une nette amélioration de l'efficience énergétique globale du système

Ethyl 4-(4-methoxy­phen­yl)-2-oxo-6-phenyl­cyclo­hex-3-ene-1-carboxyl­ate

The asymmetric unit of the title compound, C22H22O4, consists of two independent mol­ecules (A and B) which differ significantly in the orientations of ethyl carboxyl­ate groups. The phenyl ring in mol­ecule B is disordered over two orientations with occupancies of 0.55 (2) and 0.45 (2). The cyclo­hexenone ring of both mol­ecules adopts an envelope conformation. The dihedral angle between the two aromatic rings is 81.12 (7)° in mol­ecule A and 70.8 (3)° in mol­ecule B [57.5 (4)° in the minor disorder component]. The crystal structure is stabilized by weak intermolecular C—H⋯O hydrogen bonds and C—H⋯π inter­actions

Ethyl 6-(4-chloro­phen­yl)-4-(4-methoxy­phen­yl)-2-oxocyclo­hex-3-ene-1-carboxyl­ate

In the title compound, C22H21ClO4, the cyclo­hex-3-ene unit adopts an envelope conformation in both independent mol­ecules comprising the asymmetric unit. The two benzene rings are inclined to each other at a dihedral angle of 82.03 (5)° [86.37 (5)°]. In the crystal, the molecules interact via C—H⋯O, C—H⋯Cl and C—H⋯π interactions

2-(Pyrene-1-yl)-1,3-dithiane

In the title compound, C20H16S2, the pyrene ring is planar [maximum deviation 0.0144 (15) Å] and the dithiane ring adopts a chair conformation. The crystal packing is stabilized by C—H⋯π inter­actions. An intra­molecular C—H⋯S hydrogen bond generates an S(5) ring motif

Ethyl 4-(2,4-difluoro­phen­yl)-6-methyl-1-phenyl-2-thioxo-1,2,3,4-tetra­hydro­pyrimidine-5-carboxyl­ate

The asymmetric unit of the title compound, C20H18F2N2O2S, contains four independent mol­ecules, two of which are paired into a dimer by way of two N—H⋯S hydrogen bonds. The other two independent mol­ecules are paired into two centrosymmetric dimers via pairs of inter­molecular N—H⋯S hydrogen bonds. In one mol­ecule, the carboxyl­ate O atoms, methyl­ene and methyl groups attached to the benzene ring are disordered between two positions in a 0.908 (3):0.092 (3) ratio. In two of the independent mol­ecules, the F and H atoms of the diflourophenyl ring are flip-flop disordered (i.e. by 180° about the C—C bond axis linking the ring to the rest of the molecule) in a 3:2 ratio. The crystal packing is stabilized by weak inter­molecular C—H⋯O hydrogen bonds

Ethyl 4-(2-bromo-5-fluoro­phen­yl)-6-methyl-1-phenyl-2-thioxo-1,2,3,4-tetra­hydro­pyrimidine-5-carboxyl­ate

In the title mol­ecule, C20H18BrFN2O2S, the pyrimidine ring adopts a flattened envelope conformation. The halogenated benzene ring is orthogonal to the planar part of the pyrimidine ring [dihedral angle = 89.05 (4)°], while the other phenyl ring is oriented at an angle of 85.14 (5)°. The ethoxy group is disordered over two orientations with site occpancies of ca 0.869 (4) and 0.131 (4). Intra­molecular C—H⋯Br and C—H⋯O hydrogen bonds generate S(5) and S(6) ring motifs. The crystal structure is stabilized by inter­molecular N—H⋯S, C—H⋯F, C—H⋯O and C—H⋯Br hydrogen bonds

Guidelines on fibrinogen assays

No abstract available

4-(4-Bromo­benzyl­ideneamino)-3-{1-[4-(2-methyl­prop­yl)phen­yl]eth­yl}-1-(mor­phol­ino­meth­yl)-1H-1,2,4-triazole-5(4H)-thione

There are two mol­ecules (A and B) in the asymmetric unit of the title compound, C26H32BrN5OS, with almost identical geometry. The morpholine ring adopts the usual chair conformation in both mol­ecules. The triazole ring forms dihedral angles of 4.84 (6) and 74.19 (6)°, respectively, with the bromo­phenyl and isobutylbenzene rings in mol­ecule A, and angles of 16.68 (7) and 87.29 (6)°, respectively, in mol­ecule B. Intra­molecular C—H⋯S hydrogen bonds generate S(5) and S(6) ring motifs in both independent mol­ecules. The crystal structure is stabilized by C—H⋯N, C—H⋯Br and C—H⋯O hydrogen-bonding inter­actions, together with C—H⋯π inter­actions