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.

What process research tells us about brief intervention efficacy.

ISSUE: This article explores mechanisms of the efficacy of brief intervention (BI). APPROACH: We conducted a BI trial at the emergency department of the Lausanne University Hospital, of whom 987 at-risk drinkers were randomised into BI and control groups. The overall results demonstrated a general decrease in alcohol use with no differences across groups. The intention to change was explored among 367 patients who completed BI. Analyses of 97 consecutive tape-recorded sessions explored patient and counsellor talks during BI, and their relationship to alcohol use outcome. KEY FINDINGS: Evaluation of the articulation between counsellor behaviours and patient language revealed a robust relationship between counsellor motivational interviewing (MI) skills and patient change talk during the intervention. Further exploration suggested that communication characteristics of patients during BI predicted changes in alcohol consumption 12 months later. Moreover, despite systematic training, important differences in counsellor performance were highlighted. Counsellors who had superior MI skills achieved better outcomes overall, and maintained efficacy across all levels of patient ability to change, whereas counsellors with inferior MI skills were effective mostly with patients who had higher levels of ability to change. Finally, the descriptions of change talk trajectories within BI and their association with drinking 12 months later showed that final states differed from initial states, suggesting an impact resulting from the progression of change talk during the course of the intervention. IMPLICATION: These findings suggest that BI should focus on the general MI attitude of counsellors who are capable of eliciting beneficial change talk from patients. [Daeppen J-B, Bertholet N, Gaume J. What process research tells us about brief intervention efficacy.

Neurophysiological origin of human brain asymmetry for speech and language.

The physiological basis of human cerebral asymmetry for language remains mysterious. We have used simultaneous physiological and anatomical measurements to investigate the issue. Concentrating on neural oscillatory activity in speech-specific frequency bands and exploring interactions between gestural (motor) and auditory-evoked activity, we find, in the absence of language-related processing, that left auditory, somatosensory, articulatory motor, and inferior parietal cortices show specific, lateralized, speech-related physiological properties. With the addition of ecologically valid audiovisual stimulation, activity in auditory cortex synchronizes with left-dominant input from the motor cortex at frequencies corresponding to syllabic, but not phonemic, speech rhythms. Our results support theories of language lateralization that posit a major role for intrinsic, hardwired perceptuomotor processing in syllabic parsing and are compatible both with the evolutionary view that speech arose from a combination of syllable-sized vocalizations and meaningful hand gestures and with developmental observations suggesting phonemic analysis is a developmentally acquired process.