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.

Ultra high throughput sequencing excludes MDH1 as candidate gene for RP28-linked retinitis pigmentosa.

PURPOSE: Mutations in IDH3B, an enzyme participating in the Krebs cycle, have recently been found to cause autosomal recessive retinitis pigmentosa (arRP). The MDH1 gene maps within the RP28 arRP linkage interval and encodes cytoplasmic malate dehydrogenase, an enzyme functionally related to IDH3B. As a proof of concept for candidate gene screening to be routinely performed by ultra high throughput sequencing (UHTs), we analyzed MDH1 in a patient from each of the two families described so far to show linkage between arRP and RP28. METHODS: With genomic long-range PCR, we amplified all introns and exons of the MDH1 gene (23.4 kb). PCR products were then sequenced by short-read UHTs with no further processing. Computer-based mapping of the reads and mutation detection were performed by three independent software packages. RESULTS: Despite the intrinsic complexity of human genome sequences, reads were easily mapped and analyzed, and all algorithms used provided the same results. The two patients were homozygous for all DNA variants identified in the region, which confirms previous linkage and homozygosity mapping results, but had different haplotypes, indicating genetic or allelic heterogeneity. None of the DNA changes detected could be associated with the disease. CONCLUSIONS: The MDH1 gene is not the cause of RP28-linked arRP. Our experimental strategy shows that long-range genomic PCR followed by UHTs provides an excellent system to perform a thorough screening of candidate genes for hereditary retinal degeneration.

The PEDRO (Pocketable Electronic Devices in Radiation Oncology) project: how clinical practice is changing among young radiation oncologists.

Purpose. To evaluate the impact of mobile devices and apps on the daily clinical activity of young radiation oncologists. Methods. A web-based questionnaire was sent to 382 young (≤40 years) members of the Italian Association of Radiation Oncology (AIRO). The 14 items investigated the diffusion of mobile devices (smartphones and/or tablets), their impact on daily clinical activity, and possible differences perceived by the participants over time. Results. A total of 158 questionnaires were available for statistical evaluation (response rate 41%). Up to 75% of respondents declared they used an electronic device during their clinical activity. Conversely, 82% considered the impact of smartphones/tables on daily practice low to moderate. Daily device use increased significantly from 2009 to 2012, with high daily use rates rising from 5% to 39.9%. Fulfillment of professional needs was declared by less than 42% of respondents and compliance with app indications by 32%. Almost all physicians desired in 2012 a comprehensive website concerning a variety of apps covering radiation oncologists' needs. Conclusions. Mobile devices are widely used by young Italian radiation oncologists in their daily clinical practice, while the indications so obtained are not always followed. Nevertheless, it would be important to verify the consistency of information found within apps, in order to avoid potential errors that might be detrimental to patients.

The impact of communication skills training in oncology: a linguistic analysis.

This study aimed to investigate the impact of a communication skills training (CST) in oncology on clinicians' linguistic strategies. A verbal communication analysis software (Logiciel d'Analyse de la Communication Verbale) was used to compare simulated patients interviews with oncology clinicians who participated in CST (N = 57) (pre/post with a 6-month interval) with a control group of oncology clinicians who did not (N = 56) (T1/T2 with a 6-month interval). A significant improvement of linguistic strategies related to biomedical, psychological and social issues was observed. Analysis of linguistic aspects of videotaped interviews might become in the future a part of individualised feedback in CST and utilised as a marker for an evaluation of training.

EADock: docking of small molecules into protein active sites with a multiobjective evolutionary optimization.

In recent years, protein-ligand docking has become a powerful tool for drug development. Although several approaches suitable for high throughput screening are available, there is a need for methods able to identify binding modes with high accuracy. This accuracy is essential to reliably compute the binding free energy of the ligand. Such methods are needed when the binding mode of lead compounds is not determined experimentally but is needed for structure-based lead optimization. We present here a new docking software, called EADock, that aims at this goal. It uses an hybrid evolutionary algorithm with two fitness functions, in combination with a sophisticated management of the diversity. EADock is interfaced with the CHARMM package for energy calculations and coordinate handling. A validation was carried out on 37 crystallized protein-ligand complexes featuring 11 different proteins. The search space was defined as a sphere of 15 A around the center of mass of the ligand position in the crystal structure, and on the contrary to other benchmarks, our algorithm was fed with optimized ligand positions up to 10 A root mean square deviation (RMSD) from the crystal structure, excluding the latter. This validation illustrates the efficiency of our sampling strategy, as correct binding modes, defined by a RMSD to the crystal structure lower than 2 A, were identified and ranked first for 68% of the complexes. The success rate increases to 78% when considering the five best ranked clusters, and 92% when all clusters present in the last generation are taken into account. Most failures could be explained by the presence of crystal contacts in the experimental structure. Finally, the ability of EADock to accurately predict binding modes on a real application was illustrated by the successful docking of the RGD cyclic pentapeptide on the alphaVbeta3 integrin, starting far away from the binding pocket.

Proposta de um método para escolha de software de automação de bibliotecas

Apresenta um método para avaliação e seleção de softwares de automação de bibliotecas. Consiste na atribuição de critérios e cálculos estatísticos em uma lista elaborada para a seleção e avaliação deste tipo de software. Este método pretender servir como instrumento de apoio à tomada de decisão no processo de escolha do software mais adequado às necessidades de cada instituição. Este trabalho foi motivado por uma demanda do Instituto Brasileiro de Informação em Ciência e Tecnologia (IBICT) para automatizar a sua biblioteca.

Spatiotemporal analysis of multichannel EEG: CARTOOL.

This paper describes methods to analyze the brain's electric fields recorded with multichannel Electroencephalogram (EEG) and demonstrates their implementation in the software CARTOOL. It focuses on the analysis of the spatial properties of these fields and on quantitative assessment of changes of field topographies across time, experimental conditions, or populations. Topographic analyses are advantageous because they are reference independents and thus render statistically unambiguous results. Neurophysiologically, differences in topography directly indicate changes in the configuration of the active neuronal sources in the brain. We describe global measures of field strength and field similarities, temporal segmentation based on topographic variations, topographic analysis in the frequency domain, topographic statistical analysis, and source imaging based on distributed inverse solutions. All analysis methods are implemented in a freely available academic software package called CARTOOL. Besides providing these analysis tools, CARTOOL is particularly designed to visualize the data and the analysis results using 3-dimensional display routines that allow rapid manipulation and animation of 3D images. CARTOOL therefore is a helpful tool for researchers as well as for clinicians to interpret multichannel EEG and evoked potentials in a global, comprehensive, and unambiguous way.

The new culture of electronic publishing

Local conditions in the past often limited opportunities for scholarly exchange. But now these limits are gone and the global workplace has replaced them. It is important to react to these changes. Every academic department must now adopt new methods and rethink processes. Another is the intense national and international debate about open access to scholarly knowledge. The Open Access Initiative shows that a change is taking place in the communication process. This change is also important for service departments within research institutions. Libraries, computer centers and related units have to ask themselves how to react appropriately to the new conditions. What services must be changed or redeveloped, and in what quality and quantity should they be offered? This article focuses on changes in the scholarly publication process. It describes both technological changes and the changes needed in people's attitudes.

The Brazilian electronic theses and dissertations digital library: providing open access for scholarly information

This paper describes a project led by the Instituto Brasileiro de Informações em Ciência e Tecnologia (Ibict), a government institution, to build a national digital library for electronic theses and dissertations - Bibliteca Digital de Teses e Dissertações (BDTD). The project has been a collaborative effort among Ibict, universities and other research centers in Brazil. The developers adopted a system architecture based on the Open Archives Initiative (OAI) in which universities and research centers act as data providers and Ibict as a service provider. A Brazilian metadata standard for electronic theses and dissertations was developed for the digital library. A toolkit including open source package was also developed by Ibict to be distributed to potential data providers. BDTD has been integrated with the international initiative: the Networked Digital Library of Thesis and Dissertation (NDLTD). Discussions in the paper address various issues related to project design, development and management as well as the role played by Ibict. Conclusions highlight some important lessons learned to date and challenges for the future in expanding the BDTD project.

Multiplan Spreadsheets for Highway and Hydraulic Engineering Computations in County Engineering Offices, HR-284, 1987

Multiplan spreadsheet solutions were developed for a set of hydraulic and highway engineering computations of common interest to county engineers. These include earthwork, vertical and horizontal curves, staking superelevated curves and sign inventories for highways. The hydraulic applications were ditch flow, runoff, culvert size and stage discharge.

Disordered eating behaviors: what about boys?

PURPOSE: To determine the characteristics specific to boys with disordered eating behaviors (DEB) and the general context in which these DEB occur. METHOD: Data were drawn from the SMASH02 database, a survey carried out among post-mandatory school students in Switzerland aged 16-20 years in 2002. Only males (N=3890) were included, and were classified into into one of four groups based on their level of concern about weight/food and on their eating behaviors, as follows: group 1: one concern without behavior (N=862); group 2: more than one concern without behavior (N=361); group 3: at least one behavior (N=798); and a control group (N=1869), according to previously validated items. Groups were compared for personal, family, school, experience of violence, and health-compromising behaviors variables on the bivariate level. All significant variables were included in a multinomial logistic regression using Stata 9 software. RESULTS: About one-half of the boys reported either a concern or unhealthy eating behavior. Compared with the control group, boys from the three groups were more likely to be students and to report a history of sexual abuse, delinquency, depression, and feeling fat. In addition, boys from group 3 were more likely to report a history of dieting, early puberty, peer teasing, having experienced violence, frequent inebriation, and being overweight. CONCLUSION: DEB concern adolescent males more frequently than thought and seem to be integrated in a general dysfunctional context, in which violence is predominant. Adolescent males also need to be screened for DEB. Moreover, prevention programs should target the increasing social and media pressure regarding boys ideal body shape and raise public consciousness about this phenomenon.

Swiss EMBnet node web server.

EMBnet is a consortium of collaborating bioinformatics groups located mainly within Europe (http://www.embnet.org). Each member country is represented by a 'node', a group responsible for the maintenance of local services for their users (e.g. education, training, software, database distribution, technical support, helpdesk). Among these services a web portal with links and access to locally developed and maintained software is essential and different for each node. Our web portal targets biomedical scientists in Switzerland and elsewhere, offering them access to a collection of important sequence analysis tools mirrored from other sites or developed locally. We describe here the Swiss EMBnet node web site (http://www.ch.embnet.org), which presents a number of original services not available anywhere else.

The Gene Ontology in 2010: extensions and refinements.

The Gene Ontology (GO) Consortium (http://www.geneontology.org) (GOC) continues to develop, maintain and use a set of structured, controlled vocabularies for the annotation of genes, gene products and sequences. The GO ontologies are expanding both in content and in structure. Several new relationship types have been introduced and used, along with existing relationships, to create links between and within the GO domains. These improve the representation of biology, facilitate querying, and allow GO developers to systematically check for and correct inconsistencies within the GO. Gene product annotation using GO continues to increase both in the number of total annotations and in species coverage. GO tools, such as OBO-Edit, an ontology-editing tool, and AmiGO, the GOC ontology browser, have seen major improvements in functionality, speed and ease of use.