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.

Impact of preoperative risk factors on morbidity after esophagectomy: is there room for improvement?

BACKGROUND: Despite progress in multidisciplinary treatment of esophageal cancer, oncologic esophagectomy is still the cornerstone of therapeutic strategies. Several scoring systems are used to predict postoperative morbidity, but in most cases they identify nonmodifiable parameters. The aim of this study was to identify potentially modifiable risk factors associated with complications after oncologic esophagectomy. METHODS: All consecutive patients with complete data sets undergoing oncologic esophagectomy in our department during 2001-2011 were included in this study. As potentially modifiable risk factors we assessed nutritional status depicted by body mass index (BMI) and preoperative serum albumin levels, excessive alcohol consumption, and active smoking. Postoperative complications were graded according to a validated 5-grade system. Univariate and multivariate analyses were used to identify preoperative risk factors associated with the occurrence and severity of complications. RESULTS: Our series included 93 patients. Overall morbidity rate was 81 % (n = 75), with 56 % (n = 52) minor complications and 18 % (n = 17) major complications. Active smoking and excessive alcohol consumption were associated with the occurrence of severe complications, whereas BMI and low preoperative albumin levels were not. The simultaneous presence of two or more of these risk factors significantly increased the risk of postoperative complications. CONCLUSIONS: A combination of malnutrition, active smoking and alcohol consumption were found to have a negative impact on postoperative morbidity rates. Therefore, preoperative smoking and alcohol cessation counseling and monitoring and improving the nutritional status are strongly recommended.

Exploration of the visual system : Part 2. In vivo analysis methods : virtual-reality optomotor system, fundus examination and fluorescent angiography

The mouse has emerged as an animal model for many diseases. At IRO, we have used this animal to understand the development of many eye diseases and treatment of some of them. Precise evaluation of vision is a prerequisite for both these approaches. In this unit we describe three ways to measure vision: testing the optokinetic response, and evaluating the fundus by direct observation and by fluorescent angiography.

Heterogeneity of atherosclerotic plaque phenotypes and composition in four different arterial beds: an intravascular ultrasound virtual histology study

Purpose: The purpose of this study was to compare the plaque morphology between coronary and peripheral arteries using intravascular ultrasound (IVUS). Methods: IVUS was performed in 68 patients with coronary and 93 with peripheral artery lesions (29 carotid, 50 renal, and 14 iliac). Plaques were classified as fibroatheroma (VH-FA) (further subclassified as thin-capped [VH-TCFA] and thick-capped [VH-ThCFA]), fibrocalcific plaque (VH-FC) and pathological intimal thickening (VH-PIT). Results: Plaque rupture (13% of coronary, 7% of carotid, 6% of renal, and 7% of iliac arteries; P=NS) and VH-TCFA (37% of coronary, 24% of carotid, 16% of renal, and 7% of iliac arteries; P=0.02) was observed in all arteries. Compared to coronary arteries, VH-FA was less frequently observed in renal (P<0.001) and iliac arteries (P<0.006), while VH-PIT and VH-FC were prevalent in both of these peripheral arteries. Lesions with positive remodeling demonstrated more characteristics of VH-FA in coronary, carotid, and renal arteries compared to those with intermediate/negative remodeling (all P<0.01). There was positive relationship between RI and percent necrotic core area in all four arteries. Conclusions: Atherosclerotic plaque phenotypes were heterogeneous among four different arteries. In contrast, the associations of remodeling mode with plaque phenotype and composition were similar among the various arterial beds.

Cold fission: splitting the pombe cell at room temperature.

The mechanisms responsible for cytokinesis and its coordination with other events of the cell cycle are poorly understood. Genetic studies of cytokinesis in fission yeast are one useful approach to this problem. A number of conditional mutants of fission yeast that show defects in the formation of the septum of cytokinesis have been identified. Cloning of the genes affected in these mutants has begun to shed light upon the elements required to direct the construction of the division septum and also upon how the initiation of septum formation may be coordinated with mitosis.

Pediatric emergencies admitted in the resuscitation room of a swiss university hospital.

OBJECTIVES: Pediatric resuscitation is an intense, stressful, and challenging process. The aim of this study was to review the life-threatening pediatric (LTP) emergencies admitted in a Swiss university hospital with regards to patients' demographics, reason for admission, diagnosis, treatment, significant events, critical incidents, and outcomes. METHODS: A retrospective observational cohort study of prospectively collected data was conducted, including all LTP emergencies admitted over a period of 2 years in the resuscitation room (RR). Variables, including indication for transfer, mode of prehospital transportation, diagnosis, and time spent in RR, were recorded. RESULTS: Of the 60,939 pediatric emergencies treated in our university hospital over 2 years, a total of 277 LTP emergencies (0.46%) were admitted in the RR. They included 160 boys and 117 girls, aged 6 days to 15.95 years (mean, 6.69 years; median, 5.06). A medical problem was identified in 55.9% (n = 155) of the children. Of the 122 children treated for a surgical problem, 35 (28.3%) went directly from the RR to the operating room. Hemodynamic instability was noted in 19.5% of all LTP emergencies, of which 1.1% benefited from O negative transfusion. Admission to the intensive care unit was necessary for 61.6% of the children transferred from another hospital. The average time spent in the RR was 46 minutes. The overall mortality rate was 7.2%. CONCLUSIONS: The LTP emergencies accounted for a small proportion of all pediatric emergencies. They were more medical than surgical cases and resuscitation measures because of hemodynamic instability were the most frequent treatment.

Modified 'dumbbell' technique: a simple and intuitive method to position balloon-expandable stent valves.

Intraoperative cardiac imaging plays a key role during transcatheter aortic valve replacement. In recent years, new techniques and new tools for improved image quality and virtual navigation have been proposed, in order to simplify and standardize stent valve positioning and implantation. But routine performance of the new techniques may require major economic investments or specific knowledge and skills and, for this reason, they may not be accessible to the majority of cardiac centres involved in transcatheter valve replacement projects. Additionally, they still require injections of contrast medium to obtain computed images. Therefore, we have developed and describe here a very simple and intuitive method of positioning balloon-expandable stent valves, which represents the evolution of the 'dumbbell' technique for echocardiography-guided transcatheter valve replacement without angiography. This method, based on the partial inflation of the balloon catheter during positioning, traps the crimped valve in the aortic valve orifice and, consequently, very near to the ideal landing zone. It does not require specific echocardiographic knowledge; it does not require angiographies that increase the risk of postoperative kidney failure in elderly patients, and it can be also performed in centres not equipped with a hybrid operating room.

Estimation of sex and age of "virtual skeletons"--a feasibility study.

This article presents a feasibility study with the objective of investigating the potential of multi-detector computed tomography (MDCT) to estimate the bone age and sex of deceased persons. To obtain virtual skeletons, the bodies of 22 deceased persons with known age at death were scanned by MDCT using a special protocol that consisted of high-resolution imaging of the skull, shoulder girdle (including the upper half of the humeri), the symphysis pubis and the upper halves of the femora. Bone and soft-tissue reconstructions were performed in two and three dimensions. The resulting data were investigated by three anthropologists with different professional experience. Sex was determined by investigating three-dimensional models of the skull and pelvis. As a basic orientation for the age estimation, the complex method according to Nemeskéri and co-workers was applied. The final estimation was effected using additional parameters like the state of dentition, degeneration of the spine, etc., which where chosen individually by the three observers according to their experience. The results of the study show that the estimation of sex and age is possible by the use of MDCT. Virtual skeletons present an ideal collection for anthropological studies, because they are obtained in a non-invasive way and can be investigated ad infinitum.

Docking, virtual high throughput screening and in silico fragment-based drug design.

ABSTRACT The drug discovery process has been profoundly changed recently by the adoption of computational methods helping the design of new drug candidates more rapidly and at lower costs. In silico drug design consists of a collection of tools helping to make rational decisions at the different steps of the drug discovery process, such as the identification of a biomolecular target of therapeutical interest, the selection or the design of new lead compounds and their modification to obtain better affinities, as well as pharmacokinetic and pharmacodynamic properties. Among the different tools available, a particular emphasis is placed in this review on molecular docking, virtual high throughput screening and fragment-based ligand design.

The rapid urinary drug toxicology screen in the emergency room: a useful tool ?

Intoxications are a frequent problem in the ER. In the vast majorityof cases, supportive treatment is sufficient. Severe intoxications withunknown agents are considered an indication for a urinary drug screen,and are recommended by several toxicology centers. However, theirusefulness for patient management remains uncertain.Study objectives: Evaluation of the impact of a urinary drug screen(Biosite Triage TOX Drug Screen) testing 11 substances(acetaminophen, amphetamines, methamphetamines, barbiturates,benzodiazepines, cocaïne, methadone, opioids, phencyclidine,cannabis, tricyclic antidepressants) on initial adult patient managementin the emergency department of a university hospital with ~35.000annual admissions.Methods: Observational retrospective analysis of all tests performedbetween 09/2009 and 09/2010. A test utility was defined as useful if itresulted in the administration of a specific antidote (Flumazenil/Naloxone), the use of a quantitative confirmatory toxicologic test, or achange in patient's disposition.Results: 57 tests were performed. Patient age was 32 ± 11 (SD) years;58% were men; 30% were also intoxicated with alcohol. Two patientsdied (3.5%): the first one of a diphenhydramin overdose, the other of ahypertensive intracerebral hemorrhage believed to be caused cocaineabuse but a negative urine test. Test indications were: 54% firstpsychotic episode; 25% acute respiratory failure; 18% coma; 12%seizure; 11% opioids toxidrome; 7% sympathicomimetic toxidrome; 5%hypotension; 4% ventricular arrhythmia (VT, VF, torsades de pointes)or long QT. 75% of tests were positives for >=1 substance (mean 1.7 ±0.9). 47% of results were unexpected by history. 18% of resultsinfluenced patient management: 7% had a negative test that confirmedthe diagnosis of endogenous psychosis in a first psychotic episode, andallowed transfer to psychiatry; 5% received flumazenil/naloxone;2% had an acetaminophen blood level after a positive screen; finally,4% had an unexpected methadone abuse that required prolongationof hospital stay.Conclusions: A rapid urinary toxicologic screen was seldom used inour emergency department, and its impact on patient managementwas marginal: only one in 6 tests influenced treatment decisions.

Prognostic accuracy of cerebral blood flow measurement by perfusion computed tomography, at the time of emergency room admission, in acute stroke patients.

The purpose of this study was to determine the prognostic accuracy of perfusion computed tomography (CT), performed at the time of emergency room admission, in acute stroke patients. Accuracy was determined by comparison of perfusion CT with delayed magnetic resonance (MR) and by monitoring the evolution of each patient's clinical condition. Twenty-two acute stroke patients underwent perfusion CT covering four contiguous 10mm slices on admission, as well as delayed MR, performed after a median interval of 3 days after emergency room admission. Eight were treated with thrombolytic agents. Infarct size on the admission perfusion CT was compared with that on the delayed diffusion-weighted (DWI)-MR, chosen as the gold standard. Delayed magnetic resonance angiography and perfusion-weighted MR were used to detect recanalization. A potential recuperation ratio, defined as PRR = penumbra size/(penumbra size + infarct size) on the admission perfusion CT, was compared with the evolution in each patient's clinical condition, defined by the National Institutes of Health Stroke Scale (NIHSS). In the 8 cases with arterial recanalization, the size of the cerebral infarct on the delayed DWI-MR was larger than or equal to that of the infarct on the admission perfusion CT, but smaller than or equal to that of the ischemic lesion on the admission perfusion CT; and the observed improvement in the NIHSS correlated with the PRR (correlation coefficient = 0.833). In the 14 cases with persistent arterial occlusion, infarct size on the delayed DWI-MR correlated with ischemic lesion size on the admission perfusion CT (r = 0.958). In all 22 patients, the admission NIHSS correlated with the size of the ischemic area on the admission perfusion CT (r = 0.627). Based on these findings, we conclude that perfusion CT allows the accurate prediction of the final infarct size and the evaluation of clinical prognosis for acute stroke patients at the time of emergency evaluation. It may also provide information about the extent of the penumbra. Perfusion CT could therefore be a valuable tool in the early management of acute stroke patients.

Acute pain in adults admitted to the emergency room: development and implementation of abbreviated guidelines.

AIM: Although acute pain is frequently reported by patients admitted to the emergency room, it is often insufficiently evaluated by physicians and is thus undertreated. With the aim of improving the care of adult patients with acute pain, we developed and implemented abbreviated clinical practice guidelines (CG) for the staff of nurses and physicians in our hospital's emergency room. METHODS: Our algorithm is based upon the practices described in the international literature and uses a simultaneous approach of treating acute pain in a rapid and efficacious manner along with diagnostic and therapeutic procedures. RESULTS: Pain was assessed using either a visual analogue scale (VAS) or a numerical rating scale (NRS) at ER admission and again during the hospital stay. Patients were treated with paracetamol and/or NSAID (VAS/NRS <4) or intravenous morphine (VAS/NRS > or =04). The algorithm also outlines a specific approach for patients with headaches to minimise the risks inherent to a non-specific treatment. In addition, our algorithm addresses the treatment of paroxysmal pain in patients with chronic pain as well as acute pain in drug addicts. It also outlines measures for pain prevention prior to minor diagnostic or therapeutic procedures. CONCLUSIONS: Based on published guidelines, an abbreviated clinical algorithm (AA) was developed and its simple format permitted a widespread implementation. In contrast to international guidelines, our algorithm favours giving nursing staff responsibility for decision making aspects of pain assessment and treatment in emergency room patients.

Inhibition of the renin-angiotensin-aldosterone system: is there room for dual blockade in the cardiorenal continuum?

Antagonism of renin-angiotensin-aldosterone system is exerted through angiotensin-converting enzyme inhibitors, angiotensin receptor antagonists, renin inhibitors and mineralocorticoid receptor antagonists. These drugs have been successfully tested in numerous trials and in different clinical settings. The original indications of renin-angiotensin-aldosterone system blockers have progressively expanded from the advanced stages to the earlier stages of cardiorenal continuum. To optimize the degree of blockade of renin-angiotensin-aldosterone system, dose uptitrations of angiotensin-converting enzyme inhibitors and angiotensin receptor antagonists or the use of a dual blockade, initially identified with the combination of angiotensin-converting enzyme inhibitors and angiotensin receptor antagonists, have been proposed. The data from the Ongoing Telmisartan Alone and in Combination with Ramipril Global Endpoint Trial (ONTARGET) study do not support this specific dual blockade approach. However, the dual blockade of angiotensin-converting enzyme inhibitors/angiotensin receptor antagonists with direct renin inhibitors is currently under investigation while that based on an aldosterone blocker with any of the previous three drugs requires more evidence beyond heart failure. In this review, we revisited potential advantages of dual blockade of renin-angiotensin-aldosterone system in arterial hypertension and diabetes.

THE USE OF SIMULATIONS IN EVOLUTIONARY POPULATION GENETICS: APPLICATIONS ON HUMANS, OWLS AND VIRTUAL ORGANISMS

Summary (in English) Computer simulations provide a practical way to address scientific questions that would be otherwise intractable. In evolutionary biology, and in population genetics in particular, the investigation of evolutionary processes frequently involves the implementation of complex models, making simulations a particularly valuable tool in the area. In this thesis work, I explored three questions involving the geographical range expansion of populations, taking advantage of spatially explicit simulations coupled with approximate Bayesian computation. First, the neutral evolutionary history of the human spread around the world was investigated, leading to a surprisingly simple model: A straightforward diffusion process of migrations from east Africa throughout a world map with homogeneous landmasses replicated to very large extent the complex patterns observed in real human populations, suggesting a more continuous (as opposed to structured) view of the distribution of modern human genetic diversity, which may play a better role as a base model for further studies. Second, the postglacial evolution of the European barn owl, with the formation of a remarkable coat-color cline, was inspected with two rounds of simulations: (i) determine the demographic background history and (ii) test the probability of a phenotypic cline, like the one observed in the natural populations, to appear without natural selection. We verified that the modern barn owl population originated from a single Iberian refugium and that they formed their color cline, not due to neutral evolution, but with the necessary participation of selection. The third and last part of this thesis refers to a simulation-only study inspired by the barn owl case above. In this chapter, we showed that selection is, indeed, effective during range expansions and that it leaves a distinguished signature, which can then be used to detect and measure natural selection in range-expanding populations. Résumé (en français) Les simulations fournissent un moyen pratique pour répondre à des questions scientifiques qui seraient inabordable autrement. En génétique des populations, l'étude des processus évolutifs implique souvent la mise en oeuvre de modèles complexes, et les simulations sont un outil particulièrement précieux dans ce domaine. Dans cette thèse, j'ai exploré trois questions en utilisant des simulations spatialement explicites dans un cadre de calculs Bayésiens approximés (approximate Bayesian computation : ABC). Tout d'abord, l'histoire de la colonisation humaine mondiale et de l'évolution de parties neutres du génome a été étudiée grâce à un modèle étonnement simple. Un processus de diffusion des migrants de l'Afrique orientale à travers un monde avec des masses terrestres homogènes a reproduit, dans une très large mesure, les signatures génétiques complexes observées dans les populations humaines réelles. Un tel modèle continu (opposé à un modèle structuré en populations) pourrait être très utile comme modèle de base dans l'étude de génétique humaine à l'avenir. Deuxièmement, l'évolution postglaciaire d'un gradient de couleur chez l'Effraie des clocher (Tyto alba) Européenne, a été examiné avec deux séries de simulations pour : (i) déterminer l'histoire démographique de base et (ii) tester la probabilité qu'un gradient phénotypique, tel qu'observé dans les populations naturelles puisse apparaître sans sélection naturelle. Nous avons montré que la population actuelle des chouettes est sortie d'un unique refuge ibérique et que le gradient de couleur ne peux pas s'être formé de manière neutre (sans l'action de la sélection naturelle). La troisième partie de cette thèse se réfère à une étude par simulations inspirée par l'étude de l'Effraie. Dans ce dernier chapitre, nous avons montré que la sélection est, en effet, aussi efficace dans les cas d'expansion d'aire de distribution et qu'elle laisse une signature unique, qui peut être utilisée pour la détecter et estimer sa force.

Are virtual planning and guided surgery for head and neck reconstruction economically viable?

PURPOSE: Virtual planning and guided surgery with or without prebent or milled plates are becoming more and more common for mandibular reconstruction with fibular free flaps (FFFs). Although this excellent surgical option is being used more widely, the question of the additional cost of planning and cutting-guide production has to be discussed. In capped payment systems such additional costs have to be offset by other savings if there are no special provisions for extra funding. Our study was designed to determine whether using virtual planning and guided surgery resulted in time saved during surgery and whether this time gain resulted in self-funding of such planning through the time saved. MATERIALS AND METHODS: All consecutive cases of FFF surgery were evaluated during a 2-year period. Institutional data were used to determine the price of 1 minute of operative time. The time for fibula molding, plate adaptation, and insetting was recorded. RESULTS: During the defined period, we performed 20 mandibular reconstructions using FFFs, 9 with virtual planning and guided surgery and 11 freehand cases. One minute of operative time was calculated to cost US $47.50. Multiplying this number by the time saved, we found that the additional cost of virtual planning was reduced from US $5,098 to US $1,231.50 with a prebent plate and from US $6,980 to US $3,113.50 for a milled plate. CONCLUSIONS: Even in capped health care systems, virtual planning and guided surgery including prebent or milled plates are financially viable.