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.

Clinical results of autologous infrainguinal revascularization using grafts originating distal to the femoral bifurcation in patients with mild inflow disease.

AIM: Chronic critical limb ischemia (CLI) often requires venous bypass grafting to distal arterial segments. However, graft patency is influenced by the length and quality of the graft and occasionally patients may have limited suitable veins. We investigated short distal bypass grafting from the superficial femoral or popliteal artery to the infrapopliteal, ankle or foot arteries, despite angiographic alterations of inflow vessels, providing that invasive pressure measurement at the site of the planned proximal anastomosis revealed an inflow-brachial pressure difference of <or=10 mmHg. METHODS: Four hundred and twenty-three consecutive infrainguinal bypass grafts were performed for CLI between June, 1999 and November, 2002 at our institution. All patients underwent preoperative clinical examination, arteriography and assessment of the veins by duplex ultrasound. The study group are patients in whom the proximal and distal anastomoses of the bypass are below the femoral bifurcation and the popliteal artery, respectively. Invasive arterial pressure measurements were recorded at the level of the planned proximal anastomosis which was performed at that level if the difference of the inflow-brachial pressure was <or=10 mmHg, irrespective of angiographic alterations of the inflow vessels proximal to the planned anastomosis. All patients had a clinical follow-up included a duplex examination of their graft, at 1 week, 3, 9 and 12 months and, thereafter, annually. No patient was lost to follow-up. RESULTS: Sixty-seven patients underwent 71 short distal bypass grafts in 71 limbs with reversed saphenous vein grafts in 52, in situ saphenous veins in 11, reversed cephalic vein in 1 and composite veins in 7, respectively. Surgical or endovascular interventions to improve inflow were required in 4 limbs (5.6%). The mean follow-up time was 22.5 months and the two-year survival was 92.5%. Primary and secondary patency rates at 2 years were 73% and 93%, respectively, and the limb salvage rate was 98.5%. CONCLUSION: In appropriately selected patients, short distal venous bypass grafts can be performed with satisfactory patency and limb salvage rates even in the presence of morphologic alterations of the inflow vessels providing that these are not hemodynamically significant, or can be corrected intraoperatively.

Assessing small non-zero perceptions of chance: The case of H1N1 (swine) flu risks

Feelings of invulnerability, seen in judgments of 0% risk, can reflect misunderstandings of risk and risk behaviors, suggesting increased need for risk communication. However, judgments of 0% risk may be given by individuals who feel invulnerable, and by individuals who are rounding from small non-zero probabilities. We examined the effect of allowing participants to give more precise responses in the 0-1% range on the validity of reported probability judgments. Participants assessed probabilities for getting H1N1 influenza and dying from it conditional on infection, using a 0-100% visual linear scale. Those responding in the 0-1% range received a follow-up question with more options in that range. This two-step procedure reduced the use of 0% and increased the resolution of responses in the 0-1% range. Moreover, revised probability responses improved predictions of attitudes and self-reported behaviors. Hence, our two-step procedure allows for more precise and more valid measurement of perceived invulnerability. [Authors]

Acute reversible Charles Bonnet syndrome precipitated by sudden severe anemia.

PURPOSE: To report the sudden onset of reversible Charles Bonnet syndrome precipitated byacute severe anemia. METHODS: The charts of three patients (Usher syndrome, bilateral macular degeneration, and bilateral retinal vein occlusion) with acute Charles Bonnet syndrome in the setting of severe anemia were reviewed. RESULTS: Anemia resulted from bladder surgery, recto-colitis, and severe urinary tract infection. Hemoglobin ranged from 78 to 86 g/L. Decreased visual acuity and formed visual hallucinations (giants, flowers, animals) were present in all three patients. Rapid reversal of Charles Bonnet syndrome and visual acuity improvement followed blood transfusion. CONCLUSIONS: Acute severe anemia can precipitate Charles Bonnet syndrome, which may be reversible by blood transfusion.

Fluorescence-activated cell sorting and cloning of bona fide CD8+ CTL with reversible MHC-peptide and antibody Fab' conjugates.

The isolation of subsets of Ag-specific T cells for in vitro and in vivo studies by FACS is compromised by the fact that the soluble MHC-peptide complexes and Abs used for staining, especially when combined, induce unwanted T cell activation and eventually apoptosis. This is especially a problem for CD8+ CTL, which are susceptible to activation-dependent cell death. In this study, we show that reversible MHC-peptide complexes (tetramers) can be prepared by conjugating MHC-peptide monomers with desthiobiotin (DTB; also called dethiobiotin) and multimerization by reaction with fluorescent streptavidin. While in the cold these reagents are stable and allow good staining, they rapidly dissociate in monomers at elevated temperatures, especially in the presence of free biotin. FACS cloning of Melan-A (MART-1)-specific CTL from a melanoma-infiltrated lymph node with reversible HLA-A2 Melan-A26-35 multimers yielded over two times more clones than when using the conventional biotin-containing multimers. CTL clones obtained by means of reversible multimers killed Melan-A-positive tumor cells more efficiently as compared with clones obtained with the stable multimers. Among the CTL obtained with the reversible multimers, but much less among those obtained with the stable multimers, a high proportion of clones exhibited high functional and physical avidity and died upon incubation with soluble MHC-peptide complexes. Finally, we show that Fab' of an anti-CD8 Ab can be converted in reversible DTB streptavidin conjugates the same way. These DTB reagents efficiently and reversibly stained murine and human CTL without affecting their viability.

Thromboangiitis obliterans: a rare cause of a reversible Raynaud's phenomenon.

A 25-year-old woman with progressive Raynaud's phenomenon and digital necrosis is presented. Systemic sclerosis and other connective tissue disorders as well as atherosclerosis and arterial emboli were excluded with appropriate laboratory examinations. Arteriography revealed multiple palmar and digital occlusions with corkscrew-shaped vessels. Based on these characteristic arteriographic and clinical findings, the diagnosis of thromboangiitis obliterans was finally retained. With intravenous perfusion of the prostacyclin analogue iloprost (2 ng/kg/min, 6 h daily during 21 days), a complete healing of Raynaud's phenomenon and of the digital necrosis was observed. There was no recurrence during the 1-year follow-up. This observation demonstrates that thromboangiitis obliterans is a potential reversible cause of severe Raynaud's phenomenon in young women even in the absence of lower limb involvement. Early recognition is important to avoid irreversible complications such as loss of digits.

Oxygen consumption of Litopenaeus vannamei juveniles in heterotrophic medium with zero water exchange

This work aimed at determining the dissolved oxygen consumption rate of Litopenaeus vannamei juveniles maintained in a microbial biofloc raceway system at high density with no aeration. Three 4 L bottles were filled for each treatment, sealed hermetically, and placed in an enclosed greenhouse raceway system. Four shrimp (13.2±1.42 g) were assigned to two sets of the bottles, which underwent the following treatments: light conditions with no shrimp; dark conditions with no shrimp; light conditions with shrimp; and dark conditions with shrimp. Dissolved oxygen content was measured every 10 min for 30 min. A quadratic behavior was observed in dissolved oxygen concentration over time. Significant differences for oxigen consumption were observed only at 10 and 20 min between shrimp maintained in the dark and those under light conditions. At 10 min, a higher value was observed in shrimp maintained under light, and at 20 min, in the dark. Significant differences between 10 and 20 min and between 10 and 30 min were observed when oxygen consumption was analyzed over time in the presence of light. Under dark conditions there were significant differences only between 20 and 30 min. Lethal oxygen concentration (0.65 mg L-1) would be reached in less than one hour either under light or dark conditions with no aeration.

Postictal cortical visual impairment: A symptom of posterior reversible encephalopathy.

We describe a patient presenting with a first generalized convulsion after alcohol consumption, in whom the early postictal finding of a rapidly regressive cortical visual impairment suggested the presence of a posterior reversible encephalopathy. This was confirmed radiologically, and probably represented the key factor in the seizure etiology.

The minimum tree for a given zero-entropy period

We answer the following question: given any n∈ℕ, which is the minimum number of endpoints en of a tree admitting a zero-entropy map f with a periodic orbit of period n? We prove that en=s1s2…sk−∑i=2ksisi+1…sk, where n=s1s2…sk is the decomposition of n into a product of primes such that si≤si+1 for 1≤ie, then the topological entropy of f is positive

Reversible cerebral vasoconstriction syndrome identification of prognostic factors.

OBJECT: Reversible cerebral vasoconstriction syndrome (RCVS) is described as a clinical and radiological entity characterized by thunderclap headaches, a reversible segmental or multifocal vasoconstriction of cerebral arteries with or without focal neurological deficits or seizures. The purpose of this study is to determine risk factors of poor outcome in patients presented a RCVS. METHODS: A retrospective multi-center review of invasive and non-invasive neurovascular imaging between January 2006 and January 2011 has identified 10 patients with criterion of reversible segmental vasoconstriction syndrome. Demographics data, vascular risks and evolution of each of these patients were analyzed. RESULTS: Seven of the ten patients were females with a mean age of 46 years. In four patients, we did not found any causative factors. Two cases presented RCVS in post-partum period between their first and their third week after delivery. The other three cases were drug-induced RCVS, mainly vaso-active drugs. Cannabis was found as the causative factor in two patient, Sumatriptan identified in one patient while cyclosporine was the causative agent in also one patient. The mean duration of clinical follow-up was 10.2 months (range: 0-28 months). Two patients had neurological sequelae: one patient kept a dysphasia and the other had a homonymous lateral hemianopia. We could not find any significant difference of the evolution between secondary RCVS and idiopathic RCVS. The only two factors, which could be correlated to the clinical outcome were the neurological status at admission and the presence of intraparenchymal abnormalities (ischemic stroke, hematoma) in brain imaging. CONCLUSIONS: Fulminant vasoconstriction resulting in progressive symptoms or death has been reported in exceptional frequency. Physicians had to remember that such evolution could happen and predict them by identifying all factors of poor prognosis (neurological status at admission, the presence of intraparenchymal abnormalities).

Reversible and high capacity data hiding in medical images

In this paper we introduce a highly efficient reversible data hiding system. It is based on dividing the image into tiles and shifting the histograms of each image tile between its minimum and maximum frequency. Data are then inserted at the pixel level with the largest frequency to maximize data hiding capacity. It exploits the special properties of medical images, where the histogram of their nonoverlapping image tiles mostly peak around some gray values and the rest of the spectrum is mainlyempty. The zeros (or minima) and peaks (maxima) of the histograms of the image tiles are then relocated to embed the data. The grey values of some pixels are therefore modified.High capacity, high fidelity, reversibility and multiple data insertions are the key requirements of data hiding in medical images. We show how histograms of image tiles of medical images can be exploited to achieve these requirements. Compared with data hiding method applied to the whole image, our scheme can result in 30%-200% capacity improvement and still with better image quality, depending on the medical image content. Additional advantages of the proposed method include hiding data in the regions of non-interest and better exploitation of spatial masking.

Syndrome de vasoconstriction cérébrale réversible : identifications de facteurs pronostiques = [Reversible cerebral vasoconstriction syndrome identification of pronostic factors]

Objectif : Le syndrome de vasoconstriction cérébrale réversible (SVCR) est une entité clinico-radiologique associant des céphalées paroxystiques à un vasospasme uni- ou multifocal réversible des artères cérébrales avec ou sans déficit neurologique transitoire ou crise comitiale. Le but de notre étude est de rechercher les facteurs de mauvais pronostic des patients présentant un SVCR. Méthode : Nous avons réalisé une étude rétrospective des imageries vasculaires cérébrales invasives et non invasives entre janvier 2006 et 2011 et avons retenu 10 patients présentant les critères du RCVS. Les données démographiques, facteurs de risque vasculaires ainsi que l'évolution de chaque patient ont été noté. Résultats : Sept des 10 patients sont des femmes, avec un âge médian de 46 ans. Quatre patients ne présentaient pas de facteur étiologique, deux femmes se trouvaient en période post-partum (entre la première et la troisième semaine) et les trois autres cas sont induits par des drogues vaso-actives (cannabis pour 2 cas dont un associé à la cyclosporine, sumatriptan pour un cas). La durée moyenne du suivi est de 10,2 mois (0¬28 mois). Deux patients ont présentés une séquelle neurologique : un a gardé des troubles phasiques et l'autre une hémianopsie latérale homonyme. Deux autres patients sont décédés dans les suites, ce qui est inhabituel. Nous n'avons pas trouvé de corrélation d'évolution différente entre les cas de SVCR primaire ou secondaire. Les seules facteurs corrélaient à l'évolution clinique sont le status neurologique à l'admission et la présence de lésion parenchymateuse (ischémie ou hématome) à l'imagerie. Conclusion : La vasoconstriction cérébrale réversible impliquant des déficits neurologiques ou la mort a été, rarement, rapportée. Nous devons garder à l'esprit qu'une telle évolution peut survenir notamment pour les cas présentant un état neurologique dégradé à l'admission ou présentant des lésions parenchymateuses à l'imagerie.

Reversible mitochondrial respiratory chain impairment during symptomatic hyperlactatemia associated with antiretroviral therapy

Direct evidence confirming the hypothesis that a dysfunction of the mitochondrial respiratory chain (MRC) underlies the pathogenesis of hyperlactatemia associated with highly active antiretroviral therapy (HAART) is scarce. We studied mitochondrial DNA (mtDNA) content and MRC function in the skeletal muscle of an HIV-infected patient during an episode of symptomatic hyperlactatemia. Skeletal muscle biopsy was performed during the episode when the patient was symptomatic and 3 months later when the patient was clinically recovered. Assessment of mitochondria was performed using histological, polarographic, spectrophotometrical, and Southern blot and real time PCR DNA quantification methods. The histological study disclosed extensive mitochondrial impairment in the form of ragged-red fibers or equivalents on oxidative reactions. These findings were associated with an increase in mitochondrial content and a decrease in both mitochondrial respiratory capacity and MRC enzyme activities. Mitochondrial DNA content declined to 53% of control values. Mitochondrial abnormalities had almost disappeared later when the patient became asymptomatic. Our findings support the hypothesis that MRC dysfunction stands at the basis of HAART-related hyperlactatemia.

Reversible mitochondrial respiratory chain impairment during symptomatic hyperlactatemia associated with antiretroviral therapy

Direct evidence confirming the hypothesis that a dysfunction of the mitochondrial respiratory chain (MRC) underlies the pathogenesis of hyperlactatemia associated with highly active antiretroviral therapy (HAART) is scarce. We studied mitochondrial DNA (mtDNA) content and MRC function in the skeletal muscle of an HIV-infected patient during an episode of symptomatic hyperlactatemia. Skeletal muscle biopsy was performed during the episode when the patient was symptomatic and 3 months later when the patient was clinically recovered. Assessment of mitochondria was performed using histological, polarographic, spectrophotometrical, and Southern blot and real time PCR DNA quantification methods. The histological study disclosed extensive mitochondrial impairment in the form of ragged-red fibers or equivalents on oxidative reactions. These findings were associated with an increase in mitochondrial content and a decrease in both mitochondrial respiratory capacity and MRC enzyme activities. Mitochondrial DNA content declined to 53% of control values. Mitochondrial abnormalities had almost disappeared later when the patient became asymptomatic. Our findings support the hypothesis that MRC dysfunction stands at the basis of HAART-related hyperlactatemia.