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.

Etude de la variation interlaboratoire du test de dépistage prénatal des défauts de fermeture du tube neural [Interlaboratory variation in the prenatal screening test for neural tube closing defects].

Early detection of neural-tude defects is possible by determining Alpha-fetoprotein (AFP) in maternal serum. 16'685 pregnant women were observed. Three methods for the determination of the "normal" range are compared. The first one, already used in similar studies, makes use of a constant multiple of the median. The other two ones make use of robust estimates of location and scale. Their comparison shows the interest of the robust methods to reduce the interlaboratory variability.

Percutaneous endoscopic gastrostomy in head and neck cancer patients: indications, techniques, complications and results.

The aim of this study was to review our experience in percutaneous endoscopic gastrostomy (PEG) performed in patients with cancer of the upper aerodigestive tract. Descriptive retrospective study of 142 patients (115 males, 27 females), mean age 62.4 years (25-84 years), with head and neck or esophageal cancer, who underwent PEG tube insertion between January 2006 and December 2008. The studied parameters were indications, success rate, rate and type of complications, and their management. Percutaneous endoscopic gastrostomy was inserted before chemoradiation therapy in 80% and during or after cancer treatment in 20% of the patients. PEG placement was possible in 137 patients (96%). Major complications were observed in 9 (7%) and minor complications in 22 (17%) of the 137 patients. Seven of the 9 patients with a major complication needed revision surgery. The mortality directly related to the procedure was 0.7%. Percutaneous endoscopic gastrostomy tube insertion has a high success rate. In patients with upper aerodigestive tract cancer, PEG should be the first choice for enteral nutrition when sufficient oral intake is not possible. Although apparently easy, the procedure may occasionally lead to severe complications. Therefore, a strict technique and knowledge of clinical signs of possible complications are mandatory.

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.

Hand-disinfectant alcoholic vapors in incubators

Objective: To analyze the atmosphere inside incubators regarding alcoholic solvent such as isopropanol or ethanol which are commonly used in hand disinfecting solutions. Design: Observational. Setting: The third level neonatal unit of the Centre Hospitalier Universitaire Vaudois, Lausanne, Switzerland. Patients: Nine neonates with median (range) gestational age of 29 4/7 (25 5/7-39 0/7) weeks and birth weight of 960 (550-3050) grams. All neonates were inside incubators. Interventions: Alcoholic vapors inside incubators were directly and cumulatively measured by photoionisation and gas chromatography respectively after absorption on a charcoal sampling tube. Results: Eleven studies (mean study time: 230 ± 19 minutes) were performed. Highly variable isopropanol/ethanol concentrations profiles were found inside incubators. Peak value for isopropanol was 1982 part per million and for ethanol was 906 part per million. Conclusions: Incubators' inner atmosphere can be highly polluted by alcohol vapors. To reduce them staff should respect long evaporation time between hands disinfection and manipulations inside incubators. The use of an ethanol-based disinfecting solution, because of its short evaporation time, could be favored. As alcohol vapor toxicity for neonate remains largely unknown, further studies could be welcome.

The activity of the anti-apoptotic fragment generated by the caspase-3/p120 RasGAP stress-sensing module displays strict Akt isoform specificity.

The caspase-3/p120 RasGAP module acts as a stress sensor that promotes pro-survival or pro-death signaling depending on the intensity and the duration of the stressful stimuli. Partial cleavage of p120 RasGAP generates a fragment, called fragment N, which protects stressed cells by activating Akt signaling. Akt family members regulate many cellular processes including proliferation, inhibition of apoptosis and metabolism. These cellular processes are regulated by three distinct Akt isoforms: Akt1, Akt2 and Akt3. However, which of these isoforms are required for fragment N mediated protection have not been defined. In this study, we investigated the individual contribution of each isoform in fragment N-mediated cell protection against Fas ligand induced cell death. To this end, DLD1 and HCT116 isogenic cell lines lacking specific Akt isoforms were used. It was found that fragment N could activate Akt1 and Akt2 but that only the former could mediate the protective activity of the RasGAP-derived fragment. Even overexpression of Akt2 or Akt3 could not rescue the inability of fragment N to protect cells lacking Akt1. These results demonstrate a strict Akt isoform requirement for the anti-apoptotic activity of fragment N.

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.

Methicillin-resistant Staphylococcus aureus with intermediate susceptibility to vancomycin: are strict additional contact measures sufficient?

Background: A hospitalised patient infected with MRSA was found to harbour a VISA strain after 6 weeks of treatment with vancomycin. Additional contact measures were reinforced according to CDCs recommendations. We decide to evaluate if these applied control measures were effective. Objective: To evaluate the efficacy of strict additional contact measures to contain the dissemination of VISA from an infected patient. Methods: All patients from the unit were screened weekly for MRSA during a 6-week period, whereas health care workers (HCW) were screened only once. Screening specimen included nose, throat, groin, and clinical specimens for patients, and only nose and throat for HCW. Broth enrichment and chromogenic agar (MRSA-select) were used for MRSA detection. All MRSA isolates were tested on Van screen plates, and growing colonies were tested for MIC of vancomycin. MIC was performed using Etest. Population analysis was done for VISA confirmation. One strain per person was typed by Double Locus Sequence Typing (based on clfB and spa sequencing). Results: 66 patients hospitalized in the same service during the 6 weeks and 55 HCW were screened for MRSA and VISA. MRSA was found in 16/66 (24%) patients and 1/55 (2%) HCW. 16/17 MRSA from patients belonged to the same genotype that the VISA strain. The remaining patient had a MRSA identical to the HCW isolate. Among the 16 MRSA isolates sharing the same genotype than the VISA strain, two showed Etests vancomycin MIC of only 4 mg/L. MIC results were confirmed by the population analysis. They were not considered as VISA, but as MRSA with increased vancomycin MICs. Both isolates were obtained from two roommates. Conclusion: Strict additional contact measures were found to be effective to contain VISA dissemination. However, the identification of two isolates with increased vancomycin MIC (4 mg/L) in two roommates raised the question of the need to routinely test this susceptibility and of adequate control measures for patients harbouring such isolates.

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.