Mynodbcsv: Lightweight Zero-Config Database Solution for Handling Very Large CSV Files.

Volumes of data used in science and industry are growing rapidly. When researchers face the challenge of analyzing them, their format is often the first obstacle. Lack of standardized ways of exploring different data layouts requires an effort each time to solve the problem from scratch. Possibility to access data in a rich, uniform manner, e.g. using Structured Query Language (SQL) would offer expressiveness and user-friendliness. Comma-separated values (CSV) are one of the most common data storage formats. Despite its simplicity, with growing file size handling it becomes non-trivial. Importing CSVs into existing databases is time-consuming and troublesome, or even impossible if its horizontal dimension reaches thousands of columns. Most databases are optimized for handling large number of rows rather than columns, therefore, performance for datasets with non-typical layouts is often unacceptable. Other challenges include schema creation, updates and repeated data imports. To address the above-mentioned problems, I present a system for accessing very large CSV-based datasets by means of SQL. It's characterized by: "no copy" approach - data stay mostly in the CSV files; "zero configuration" - no need to specify database schema; written in C++, with boost [1], SQLite [2] and Qt [3], doesn't require installation and has very small size; query rewriting, dynamic creation of indices for appropriate columns and static data retrieval directly from CSV files ensure efficient plan execution; effortless support for millions of columns; due to per-value typing, using mixed text/numbers data is easy; very simple network protocol provides efficient interface for MATLAB and reduces implementation time for other languages. The software is available as freeware along with educational videos on its website [4]. It doesn't need any prerequisites to run, as all of the libraries are included in the distribution package. I test it against existing database solutions using a battery of benchmarks and discuss the results.

Le pragmatisme, solution au problème moral de la modernité ?

Etude critique de Charles Larmore, Modernité et morale (Paris, PUF, 1993). Cet article présente et discute le projet de son auteur de défendre l'idée d'une morale « pragmatiste » et « intuitionniste ». Restituant la position de l'auteur, il expose les arguments en faveur d'une conception pragmatiste de la vérité morale et ceux en faveur du recours à l'intuition pour découvrir le contenu de nos obligations morales. Dans une brève note critique finale, il suggère que le pragmatisme semble peu à même d'échapper tout à fait au reproche de relativisme.

FastEpistasis: a high performance computing solution for quantitative trait epistasis.

Motivation: Genome-wide association studies have become widely used tools to study effects of genetic variants on complex diseases. While it is of great interest to extend existing analysis methods by considering interaction effects between pairs of loci, the large number of possible tests presents a significant computational challenge. The number of computations is further multiplied in the study of gene expression quantitative trait mapping, in which tests are performed for thousands of gene phenotypes simultaneously. Results: We present FastEpistasis, an efficient parallel solution extending the PLINK epistasis module, designed to test for epistasis effects when analyzing continuous phenotypes. Our results show that the algorithm scales with the number of processors and offers a reduction in computation time when several phenotypes are analyzed simultaneously. FastEpistasis is capable of testing the association of a continuous trait with all single nucleotide polymorphism ( SNP) pairs from 500 000 SNPs, totaling 125 billion tests, in a population of 5000 individuals in 29, 4 or 0.5 days using 8, 64 or 512 processors.

Critical values of nitrogen indices in tomato plants grown in soil and nutrient solution determined by different statistical procedures

The objective of this study was to establish critical values of the N indices, namely soil-plant analysis development (SPAD), petiole sap N-NO3 and organic N in the tomato leaf adjacent to the first cluster (LAC), under soil and nutrient solution conditions, determined by different statistical approaches. Two experiments were conducted in randomized complete block design with four repli-cations. Tomato plants were grown in soil, in 3 L pot, with five N rates (0, 100, 200, 400 and 800 mg kg-1) and in solution at N rates of 0, 4, 8, 12 and 16 mmol L-1. Experiments in nutrient solution and soil were finished at thirty seven and forty two days after transplanting, respectively. At those times, SPAD index and petiole sap N-NO3 were evaluated in the LAC. Then, plants were harvested, separated in leaves and stem, dried at 70ºC, ground and weighted. The organic N was determined in LAC dry matter. Three statistical procedures were used to calculate critical N values. There were accentuated discrepancies for critical values of N indices obtained with plants grown in soil and nutrient solution as well as for different statistical procedures. Critical values of nitrogen indices at all situations are presented.

Recent Advances in Valorization Methods of Inorganic/Organic Solid, Liquid, and Gas Wastes

The main goal of this special issue was to gather contributions dealing with the latest breakthrough methods for providing value compounds and energy/fuel from waste valorization. Valorization is a relatively new approach in the area of industrial wastes management, a key issue to promote sustainable development. In this field, the recovery of value-added substances, such as antioxidants, proteins, vitamins, and so forth, from the processing of agroindustrial byproducts, is worth mentioning. Another important valorization approach is the use of biogas from waste treatment plants for the production of energy. Several approaches involving physical and chemical processes, thermal and biological processes that ensure reduced emissions and energy consumptions were taken into account. The papers selected for this topical issue represent some of the mostly researched methods that currently promote the valorization of wastes to energy and useful materials ...

Inorganic and organic phosphorus fractions in peat from drained mires in northern Finland

Abstract

An evaluation of the inorganic and organic geochemistry of the San Vicente Mississippi Valley-type zinc-lead district, central Peru: Implications for ore fluid composition, mixing processes, and sulfate reduction

Mississippi Tialley-type zinc-lead deposits and ore occurrences in the San Vicente belt are hosted in dolostones of the eastern Upper Triassic to Lower Jurassic Pucara basin, central Peru. Combined inorganic and organic geochemical data from 22 sites, including the main San Vicente deposit, minor ore occurrences, and barren localities, provide better understanding of fluid pathways and composition, ore precipitation mechanisms, Eh-pH changes during mineralization, and relationships between organic matter and ore formation. Ore-stage dark replacement dolomite and white sparry dolomite are Fe and rare earth element (REE) depleted, and Mn enriched, compared to the host dolomite. In the main deposit, they display significant negative Ce and probably Eu anomalies. Mixing of an incoming hot, slightly oxidizing, acidic brine (H2CO3 being the dominant dissolved carbon species), probably poor in REE and Fe, with local intraformational, alkaline, reducing waters explains the overall carbon and oxygen isotope variation and the distributions of REE and other trace elements in the different hydrothermal carbonate generations. The incoming ore fluid flowed through major aquifers, probably basal basin detrital units, with limited interaction with the carbonate host rocks. The hydrothermal carbonates show a strong regional chemical homogeneity, indicating access of the ore fluids by interconnected channelways near the ore occurrences. Negative Ce anomalies in the main deposit, that are absent at the district scale, indicate local ore-fluid chemical differences. Oxidation of both migrated and indigenous hydrocarbons by the incoming fluid provided the local reducing conditions necessary for sulfate reduction to H2S, pyrobitumen precipitation, and reduction of Eu3+ to Eu2+. Fe-Mn covariations, combined with the REE contents of the hydrothermal carbonates, are consistent with the mineralizing system shifting from reducing/rock-dominated to oxidizing/fluid-dominated conditions following ore deposition. Sulfate and sulfide sulfur isotopes support sulfide origin from evaporite-derived sulfate by thermochemical organic reduction; further evidence includes the presence of C-13-depleted calcite cements (similar to-12 parts per thousand delta(13)C) as sulfate pseudomorphs, elemental sulfur, altered organic matter in the host dolomite, and isotopically heavier, late, solid bitumen. Significant alteration of the indigenous and extrinsic hydrocarbons, with absent bacterial membrane biomarkers (hopanes) is observed. The light delta(34)S of sulfides from small mines and occurrences compared to the main deposit reflect a local contribution of isotopically light sulfur, evidence of local differences in the ore-fluid chemistry.

Pattern-based sensing of nucleotides in aqueous solution with a multicomponent indicator displacement assay

A multicomponent indicator displacement assay ( MIDA) based on an organometallic receptor and three dyes can be used for the identification and quantification of nucleotides in aqueous solution at neutral pH.

The release of antidiuretic hormone is appropriate in response to hypovolemia and/or sodium administration in children with severe head injury: a trial of lactated Ringer's solution versus hypertonic saline.

We conducted an open, randomized, and prospective study to determine the effect of hypertonic saline on the secretion of antidiuretic hormone (ADH) and aldosterone in children with severe head injury (Glasgow coma scale <8). Thirty-one consecutive patients at a level III pediatric intensive care unit at a children's hospital received either lactated Ringer's solution (Ringer's group, n = 16) or hypertonic saline (Hypertonic Saline group, n = 15) over a 3-day period. Serum ADH levels were significantly larger in the Hypertonic Saline group as compared with the Ringer's group (P = 0.001; analysis of variance) and were correlated to sodium intake (Ringer's group: r = 0.39, R(2) = 0.15, P = 0.02; Hypertonic Saline group: r = 0.42, R(2) = 0.18, P = 0.02) and volume of fluids given IV (Ringer's group: r = 0.38, R(2) = 0.15, P = 0.02; Hypertonic Saline group: r = 0.32, R(2) = 0.1, P = not significant). Correlation of ADH to plasma osmolality was significant if plasma osmolality was >280 mOsm/kg (r = 0.5, R(2) = 0.25, P = 0.06), indicating an osmotic threshold for ADH release. Serum aldosterone levels were larger on the first day than during Days 2 and 3 in both groups and inversely correlated to serum sodium levels only in the Ringer's group (r = -0.55, R(2) = 0.3, P < 0.001). This group received a significantly larger fluid volume on Day 1 (P = 0.05, Mann-Whitney U-test) than did patients in the Hypertonic Saline group, indicating hypovolemia during the first day. Head-injured children have appropriate levels of ADH. They may be hypovolemic during the first day of treatment, especially if they receive lactated Ringer's solution. IMPLICATIONS: In head-injured patients, we recommend fluid restriction to avoid inappropriate secretion of antidiuretic hormone. In a prospective, randomized, and controlled study in 31 children, we were able to show that the antidiuretic hormone levels are appropriate in response to hypovolemia, sodium load, or both.

Exotic terrains in the Alps - A solution for a single Jurassic ocean

The Brianconnais area is explained as a large scale exotic terrain separating from Europe during the opening of the Valais ocean. It's displacement history during the Alpine evolution allows to replace older concepts of multiple oceans separating narrow strips of continental crust.

Cadmium-free quantum dots in aqueous solution: potential for fingermark detection, synthesis and an application to the detection of fingermarks in blood on non-porous surfaces

The use of quantum dots (QDs) in the area of fingermark detection is currently receiving a lot of attention in the forensic literature. Most of the research efforts have been devoted to cadmium telluride (CdTe) quantum dots often applied as powders to the surfaces of interests. Both the use of cadmium and the nano size of these particles raise important issues in terms of health and safety. This paper proposes to replace CdTe QDs by zinc sulphide QDs doped with copper (ZnS:Cu) to address these issues. Zinc sulphide-copper doped QDs were successfully synthesized, characterized in terms of size and optical properties and optimized to be applied for the detection of impressions left in blood, where CdTe QDs proved to be efficient. Effectiveness of detection was assessed in comparison with CdTe QDs and Acid Yellow 7 (AY7, an effective blood reagent), using two series of depletive blood fingermarks from four donors prepared on four non-porous substrates, i.e. glass, transparent polypropylene, black polyethylene and aluminium foil. The marks were cut in half and processed separately with both reagents, leading to two comparison series (ZnS:Cu vs. CdTe, and ZnS:Cu vs. AY7). ZnS:Cu proved to be better than AY7 and at least as efficient as CdTe on most substrates. Consequently, copper-doped ZnS QDs constitute a valid substitute for cadmium-based QDs to detect blood marks on non-porous substrates and offer a safer alternative for routine use.