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.

Rockfall monitoring by Terrestrial Laser Scanning ¿ case study of the basaltic rock face at Castellfollit de la Roca (Catalonia, Spain)

This case study deals with a rock face monitoring in urban areas using a Terrestrial Laser Scanner. The pilot study area is an almost vertical, fifty meter high cliff, on top of which the village of Castellfollit de la Roca is located. Rockfall activity is currently causing a retreat of the rock face, which may endanger the houses located at its edge. TLS datasets consist of high density 3-D point clouds acquired from five stations, nine times in a time span of 22 months (from March 2006 to January 2008). The change detection, i.e. rockfalls, was performed through a sequential comparison of datasets. Two types of mass movement were detected in the monitoring period: (a) detachment of single basaltic columns, with magnitudes below 1.5 m3 and (b) detachment of groups of columns, with magnitudes of 1.5 to 150 m3. Furthermore, the historical record revealed (c) the occurrence of slab failures with magnitudes higher than 150 m3. Displacements of a likely slab failure were measured, suggesting an apparent stationary stage. Even failures are clearly episodic, our results, together with the study of the historical record, enabled us to estimate a mean detachment of material from 46 to 91.5 m3 year¿1. The application of TLS considerably improved our understanding of rockfall phenomena in the study area.

Protection of Structural Concrete Substructures, HR-220, Progress Report, 1984

The corrosion of reinforcing steel within concrete has always been a problem in construction of bridge decks. With low slump concrete and epoxy rebar, progress has been made in controlling the corrosion. There is concern, however, that the chloride also attacks the substructures, specifically the pier columns. They are subject to chloride attack by chemical deicers in the drainage from the bridge deck. Piers supporting grade separation bridges are also subject to chlorides contained in the direct splash from the lower level traffic. In this project, a field evaluation was conducted to evaluate the effectiveness of commercially available products in preventing chloride intrusion.

Indications, perspectives et limites de la stimulation électrique épidurale en cas d'artériopathie périphérique ou coronarienne [Indications, limits and future of epidural spinal cord electrical stimulation for coronary and peripheral artery disease]

The electrical stimulation of the dorsal columns of the spinal cord exerts a dual analgesic and vasodilatory effect on ischemic tissues. It is increasingly considered a valuable method to treat severe and otherwise intractable coronary and peripheral artery disease. The quality of the results depends from both a strict selection of the patients by vascular specialists and the frequency and quality of the follow-up controls. However the indications, limits, mode of action and results of spinal cord stimulation are still poorly understood. This article, based on a personal experience of 164 implantations for peripheral and coronary artery disease, aims to draw attention to this technique and to provide information on recent and future developments.

Contribution of the Global Regulator Gene gacA to Persistence and Dissemination of Pseudomonas fluorescens Biocontrol Strain CHA0 Introduced into Soil Microcosms.

Structural and regulatory genes involved in the synthesis of antimicrobial metabolites are essential for the biocontrol activity of fluorescent pseudomonads and, in principle, amenable to genetic engineering for strain improvement. An eventual large-scale release of such bacteria raises the question of whether such genes also contribute to the persistence and dissemination of the bacteria in soil ecosystems. Pseudomonas fluorescens wild-type strain CHA0 protects plants against a variety of fungal diseases and produces several antimicrobial metabolites. The regulatory gene gacA globally controls antibiotic production and is crucial for disease suppression in CHA0. This gene also regulates the production of extracellular protease and phospholipase. The contribution of gacA to survival and vertical translocation of CHA0 in soil microcosms of increasing complexity was studied in coinoculation experiments with the wild type and a gacA mutant which lacks antibiotics and some exoenzymes. Both strains were marked with spontaneous resistance to rifampin. In a closed system with sterile soil, strain CHA0 and the gacA mutant multiplied for several weeks, whereas these strains declined exponentially in nonsterile soil of different Swiss origins. The gacA mutant was less persistent in nonrhizosphere raw soil than was the wild type, but no competitive disadvantage when colonizing the rhizosphere and roots of wheat was found in the particular soil type and during the period studied. Vertical translocation was assessed after strains had been applied to undisturbed, long (60-cm) or short (20-cm) soil columns, both planted with wheat. A smaller number of cells of the gacA mutant than of the wild type were detected in the percolated water and in different depths of the soil column. Single-strain inoculation gave similar results in all microcosms tested. We conclude that mutation in a single regulatory gene involved in antibiotic and exoenzyme synthesis can affect the survival of P. fluorescens more profoundly in unplanted soil than in the rhizosphere.

CELLULAR AND MOLECULAR STUDY OF SUBCORTICAL BAND HETEROTOPIA IN THE MOUSE MUTANT HECO

The HeCo mouse model is characterized by a subcortical heterotopia formed by misplaced neurons normally migrating into the superficial cortical layers. The mutant mouse has a tendency to epileptic seizures. In my thesis project we discovered the mutated Eml1 gene, a member of the echinoderm microtubule-associated protein (EMAP) family, in HeCo as well as in a family of three children showing complex malformation of cortical development. This discovery formed an important step in exploring the pathogenic mechanisms underlying the HeCo phenotype. In vitro results showed that during cell division the EML1 protein is associated with the midbody and a mutated version of Eml1 highlighted an important role of the protein in the astral MT array during cell cycle. In vivo, we found that already at an early age of cortical development (E13), ectopic progenitors such as RGs (PAX6) and IPCs (TBR2) accumulate in the IZ along the entire neocortex. We demonstrated that in the VZ of the HeCo mouse, spindle orientation and cell cycle exit are perturbed. In later stages (E17), RG fibers are strongly disorganized with deep layer (TBR1) and upper layer (CUX1) neurons trapped within an ectopic mass. At P3, columns of upper layer neurons were present between the heterotopia and the developing cortex; these columns were also present at P7 but at lesser extent. Time lapse video recording (E15.5) revealed that the parameters characterizing the migration of individual neurons are not disturbed in HeCo; however, this analysis showed that the density of migrating neuron was smaller in HeCo. In conclusion, truncated EML1 is likely to play a prominent role during cell cycle but also acts on the cytoskeletal architecture altering the shape of RG fibers thus influencing the pattern of neuronal migration. The signal transduction between external cues and intracellular effector pathways through MTs may be secondary but sustains the heterotopia development and further studies are needed to clarify the impact of EML1 in progenitors versus post-mitotic cells.

The Role of Magnesium in Concrete Deterioration, HR-355, Appendix, 1994

In the main report concerning the role that magnesium may have in highway concrete aggregate, over 20,000 electron microprobe data were obtained, primarily from automated scans, or traverses, across dolomite aggregate grains and the adjacent cement paste. Representative traverses were shown in figures and averages of the data were presented in Table II. In this Appendix, detailed representative and selected analyses of carbonate aggregate only are presented. These analyses were not presented in the main report because they would be interesting to only a few specialists in dolomite· rocks. In this Appendix, individual point analyses of mineral compositions in the paste have been omitted along with dolomite compositions at grain boundaries and cracks. Clay minerals and quartz inclusions in the aggregate are also not included. In the analyses, the first three column headings from left to right show line number, x-axis, and y-axis (Line number is an artifact of the computer print-out for each new traverse. Consecutive line numbers indicate a continuous traverse with distances between each point of 1.5 to a few μ-m. X-axis and y-axis are coordinates on the electron microscope stage). The next columns present weight percent oxide content of FeO, K20, CaO, Si02, Al203, MgO, SrO, BaO, MnO, Na20, and C02 (calculated assuming the number of moles of C02 is equal to the sum of moles of oxides, chiefly CaO and MgO), TOTAL (the sum of all oxides), and total (sum of all oxides excluding COi). In many of the analyses total is omitted.

Highway Applications for Rammed Aggregate Piers in Iowa Soils, TR-443, 2003

This report describes a study to evaluate Geopier® soil reinforcement technology in transportation construction. Three projects requiring settlement control were chosen for evaluation—an embankment foundation, a box culvert, and a bridge approach fill. For each project, construction observations, in situ soil testing, laboratory material characterization, and performance monitoring were carried out. For the embankment foundation project, Geopier elements were installed within and around an abutment footprint for the new I-35 overpass at the US Highway 5/Interstate 35 interchange in Des Moines, Iowa. Although the main focus of this investigation was to evaluate embankment foundation reinforcement using Geopier elements, a stone column reinforced soil provided an opportunity to compare systems. In situ testing included cone penetration tests (CPTs), pressuremeter tests (PMTs), Ko stepped blade tests, and borehole shear tests (BSTs), as well as laboratory material testing. Comparative stiffness and densities of Geopier elements and stone columns were evaluated based on full-scale modulus load tests and standard penetration tests. Vibrating wire settlement cells and total stress cells were installed to monitor settlement and stress concentration on the reinforcing elements and matrix soil. Settlement plates were also monitored by conventional optical survey methods. Results show that the Geopier system and the stone columns performed their intended functions. The second project involved settlement monitoring of a 4.2 m wide x 3.6 m high x 50 m long box culvert constructed beneath a bridge on Iowa Highway 191 south of Neola, Iowa. Geopier elements were installed to reduce total and differential settlement while ensuring the stability of the existing bridge pier foundations. Benefits of the box culvert and embankment fill included (1) ease of future roadway expansion and (2) continual service of the roadway throughout construction. Site investigations consisted of in situ testing including CPTs, PMTs, BSTs, and dilatometer tests. Consolidated drained triaxial compression tests, unconsolidated undrained triaxial compression test, oedometer tests, and Atterberg limit tests were conducted to define strength and consolidation parameters and soil index properties for classification. Vibrating wire settlement cells, total stress cells, and piezometers were installed for continuous monitoring during and after box culvert construction and fill placement. This project was successful at controlling settlement of the box culvert and preventing downdrag of the bridge foundations, but could have been enhanced by reducing the length of Geopier elements at the ends of the box culvert. This would have increased localized settlement while reducing overall differential settlement. The third project involved settlement monitoring of bridge approach fill sections reinforced with Geopier elements. Thirty Geopier elements, spaced 1.8 m apart in six rows of varying length, were installed on both sides of a new bridge on US Highway 18/218 near Charles City, Iowa. Based on the results of this project, it was determined that future applications of Geopier soil reinforcement should consider extending the elements deeper into the embankment foundation fill, not just the fill itself.

Feasibility Investigation of Segmentally Precast Bridge Piers for Accelerated Construction, TR-556, 2009

An innovative structural system for pier columns was investigated through a series of laboratory experiments. The columns and connections examined were comprised of precast concrete segments to accelerate construction. In addition some of the columns employed unbonded post-tensioning to self-center the columns when subjected to lateral loads and structural fuses to control large lateral deflections, dissipate energy, and expedite repair in the event of a catastrophic loading event. Six cantilever columns with varying component materials and connection details were subjected to a regimen of vertical dead loads and cyclic, quasi-static lateral loads. One column was designed as a control column to represent the behavior of a conventional reinforced concrete column and provide a basis for comparison with the remaining five jointed columns designed with the proposed structural system. After sustaining significant damage, the self-centering, jointed columns were repaired by replacing the structural fuses and retested to failure to investigate the effectiveness of the repair. The experiments identified both effective and unsatisfactory details for the jointed system. Two of the jointed columns demonstrated equivalent lateral strength, greater lateral stiffness, and greater lateral deformation capacity than the control column. The self-centering capability of the jointed columns was clearly demonstrated as well, and the repair technique proved effective as demonstrated by nearly identical pre and post repair behavior. The authors believe the proposed system to be a feasible alternative to conventional pier systems and recommend further development of details.

Low-Cost Rural Surface Alternatives: Demonstration Project, TR-664, 2015

The goals of this project were to implement several stabilization methods for preventing or mitigating freeze-thaw damage to granular surfaced roads and identify the most effective and economical methods for the soil and climate conditions of Iowa. Several methods and technologies identified as potentially suitable for Iowa were selected from an extensive analysis of existing literature provided with Iowa Highway Research Board (IHRB) Project TR-632. Using the selected methods, demonstration sections were constructed in Hamilton County on a heavily traveled two-mile section of granular surfaced road that required frequent maintenance during previous thawing periods. Construction procedures and costs of the demonstration sections were documented, and subsequent maintenance requirements were tabulated through two seasonal freeze-thaw periods. Extensive laboratory and field tests were performed prior to construction, as well as before and after the two seasonal freeze-thaw periods, to monitor the performance of the demonstration sections. A weather station was installed at the project site and temperature sensors were embedded in the subgrade to monitor ground temperatures up to a depth of 5 ft and determine the duration and depths of ground freezing and thawing. An economic analysis was performed using the documented construction and maintenance costs, and the estimated cumulative costs per square yard were projected over a 20-year timeframe to determine break-even periods relative to the cost of continuing current maintenance practices. Overall, the sections with biaxial geogrid or macadam base courses had the best observed freeze-thaw performance in this study. These two stabilization methods have larger initial costs and longer break-even periods than aggregate columns, but counties should also weigh the benefits of improved ride quality and savings that these solutions can provide as excellent foundations for future paving or surface upgrades.

Analysis of cannabinoids in oral fluid by liquid chromatography-tandem mass spectrometry

A sensitive method was developed for quantifying a wide range of cannabinoids in oral fluid (OF) by liquid chromatography-tandem mass spectrometry (LC-MS/MS). These cannabinoids include a dagger(9)-tetrahydrocannabinol (THC), 11-hydroxy-a dagger(9)-tetrahydrocannabinol (11-OH-THC), 11-nor-9-carboxy-a dagger(9)-tetrahydrocannabinol (THCCOOH), cannabinol (CBN), cannabidiol (CBD), a dagger(9)-tetrahydrocannabinolic acid A (THC-A), 11-nor-9-carboxy-a dagger(9)-tetrahydrocannabinol glucuronide (THCCOOH-gluc), and a dagger(9)-tetrahydrocannabinol glucuronide (THC-gluc). Samples were collected using a Quantisal (TM) device. The advantages of performing a liquid-liquid extraction (LLE) of KCl-saturated OF using heptane/ethyl acetate versus a solid-phase extraction (SPE) using HLB copolymer columns were determined. Chromatographic separation was achieved in 11.5 min on a Kinetex (TM) column packed with 2.6-mu m core-shell particles. Both positive (THC, 11-OH-THC, CBN, and CBD) and negative (THCCOOH, THC-gluc, THCCOOH-gluc, and THC-A) electrospray ionization modes were employed with multiple reaction monitoring using a high-end AB Sciex API 5000 (TM) triple quadrupole LC-MS/MS system. Unlike SPE, LLE failed to extract THC-gluc and THCCOOH-gluc. However, the LLE method was more sensitive for the detection of THCCOOH than the SPE method, wherein the limit of detection (LOD) and limit of quantification (LOQ) decreased from 100 to 50 pg/ml and from 500 to 80 pg/ml, respectively. The two extraction methods were successfully applied to OF samples collected from volunteers before and after they smoked a homemade cannabis joint. High levels of THC were measured soon after smoking, in addition to significant amounts of THC-A. Other cannabinoids were found in low concentrations. Glucuronide conjugate levels were lower than the method's LOD for most samples. Incubation studies suggest that glucuronides could be enzymatically degraded by glucuronidase prior to OF collection

Microtubule-associated protein 1a is involved in the early development of the rat spinal cord.

The expression of microtubule-associated protein 1a (MAP1a) in the developing rat spinal cord was studied using the monoclonal antibody BW6. Immunoblots of microtubule preparations revealed the presence of MAP1a in spinal cord tissue of rats aged embryonal day 16 and postnatal day 0. The spinal cord matrix layer, between embryonal days 12-17, displayed a pattern of MAP1a-positive processes, horizontally oriented in between the membrane limitans interna and externa. The mantle layer stained intensely for MAP1a between embryonal day 12 and postnatal day 2. MAP1a was found in neuronal cell bodies, axons and dendrites, located mainly in the ventral and intermediate mantle layer. In the marginal layer, MAP1a-positive axons could be observed between embryonal days 14-18. During further development, the intensity of the MAP1a staining in the spinal columns gradually decreased. These expression patterns indicate an involvement of MAP1a in the proliferation and differentiation of neuroblasts, and the maturation of the long spinal fiber systems, i.e. early events in spinal cord development

Iowa Department of Public Health: SFY 2015 Annual County Service Contract Listing, 2016

Iowa Department of Public Health SFY 2015 Annual County Service Contract Listing. This publication strives to identify all service contracts administered by the Iowa Department of Public Health during the period of July 1, 2014 through June 30, 2015. Contracts may have been increased or decreased, and contract titles changed during the published period. Contracts listed in this summary are shown in alphabetical order by contractor within the county. Interdepartmental Agreements with state government agencies are at the back of the listing. Each page is divided into eight columns which identify the following: column 1: the county of the contractor; column 2: the contractor; column 3: the contract number; column 4: the contract title; column 5: the contract amount; column 6: the funding source; column 7: the start date of the contract and column 8: the end date of the contract.

Doublecortin cells and neurodegenerative disease

Introduction : Doublecortin (DCX) is a microtubule associated protein expressed by migrating neural precursors. DCX is also expressed in approximately 4% of all cortical cells in adult normal primate brain. DCX expression is also enhanced locally in response to an acute insult made to the brain. This is thought to play a role in plasticity or neural repair. That being said, it would be interesting to know how the expression of DCX is modified in a more chronic insult, like in neurodegeneration such as in Parkinson's Disease (PD) and Alzheimer's Disease (AD). The aim of my study is to study the expression of DCX cells in the cortex of patients having a neurodegenerative disease, compared to control patients. Method: DCX cells quantification on 9 DCX‐stained 5 μm thick formalin fixed paraffin embedded brain sections: 3 Alzheimer's disease patients, 3 Parkinson's disease patients and 3 control patients. Each patient had several sections that we could stain with different stainings (GALLYA, TAU, DCX). By using a computerized image analysis system (Explora Nova, La Rochelle, France), cortical columns were selected on areas on the cortex with a lot of degeneration subjectively observed on GALLYA stained sections and on TAU stained sections. Then total number of cells was counted on TAU sections, where all nuclei were colored in blue. Then the DCX cells were counted on the corresponding DCX sections. These values were standardized to a reference surface area. The ratio of DCX cells over total cells was then calculated. Results : There is a difference of DCX cell expression between Alzheimer's Disease patients and control patients. The percentage of dcx cells in the cortex of an Alzheimer's patient is around 12.54% ± 2.17%, where as in the cortex of control patients, it is around 5.47% ± 0.83%. On the other hand, there is no significant difference in the ratio of DCX cells over total cells between parkinson's patients and control patients, both having around 5% of DCX cells. Discussion: There is a dramatic increase of DCX expression in AD (12.5%) compared to PD and controls (5.5%). The increase in DCX ratio in AD may have two potential causes: 1.The increased ratio is due to DCX cells being more resistant to degeneration compared to surrounding cells which are degenerating due to AD, leading to the cortical atrophy observed in AD patients. So the decrease of total cells without any change in the number of DCX cells makes the ratio bigger in AD compared to the controls. 2.The increased ratio is due to an actual increase in DCX cells. This means that there is some neural repair to compensate the degenerative process, just like the repair process observed in acute lesions to the brain. This second idea can be integrated in the broader point of view of neuroinflammation. The progression of the disease would trigger neuroinflammation and the process following the primary inflammatory response which is neural repair. So our study can show that the increase in DCX cells is an attempt to repair the degenerated neurons, in the context of neuroinflammation triggered by the physiopathological progression of the disease.

Rockfall monitoring by Terrestrial Laser Scanning ¿ case study of the basaltic rock face at Castellfollit de la Roca (Catalonia, Spain)

This case study deals with a rock face monitoring in urban areas using a Terrestrial Laser Scanner. The pilot study area is an almost vertical, fifty meter high cliff, on top of which the village of Castellfollit de la Roca is located. Rockfall activity is currently causing a retreat of the rock face, which may endanger the houses located at its edge. TLS datasets consist of high density 3-D point clouds acquired from five stations, nine times in a time span of 22 months (from March 2006 to January 2008). The change detection, i.e. rockfalls, was performed through a sequential comparison of datasets. Two types of mass movement were detected in the monitoring period: (a) detachment of single basaltic columns, with magnitudes below 1.5 m3 and (b) detachment of groups of columns, with magnitudes of 1.5 to 150 m3. Furthermore, the historical record revealed (c) the occurrence of slab failures with magnitudes higher than 150 m3. Displacements of a likely slab failure were measured, suggesting an apparent stationary stage. Even failures are clearly episodic, our results, together with the study of the historical record, enabled us to estimate a mean detachment of material from 46 to 91.5 m3 year¿1. The application of TLS considerably improved our understanding of rockfall phenomena in the study area.