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.

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]

Bond Enhancement Techniques for PCC Whitetopping, HR-341, 1996

This research was initiated in 1991 as a part of a whitetopping project to study the effectiveness of various techniques to enhance bond strength between a new portland cement concrete (PCC) overlay and an existing asphalt cement concrete (ACC) pavement surface. A 1,676 m (5,500 ft) section of county road R16 in Dallas County was divided into 12 test sections. The various techniques used to enhance bond were power brooming, power brooming with air blast, milling, cement and water grout, and emulsion tack coat. Also, two sections were planed to a uniform cross-section, two pavement thicknesses were placed, and two different concrete mix proportions were used. Bond strength was perceived to be the key to determining an appropriate design procedure for whitetopping. If adequate bond is achieved, a bonded PCC overlay technique can be used for design. Otherwise, an unbonded overlay procedure may be more appropriate. Conclusions are as follows: (1) Bond Strength Differences - Milling increased bond strength versus no milling. Tack coat showed increased bond strength versus no tack coat. Planing, Air Blast and Grouting did not provide noticeable improvements in bond strength; nor did different PCC types or thicknesses affect bond strength significantly. (2) Structure - Structural measurements correlated strongly with the wide variation in pavement thicknesses. They did not provide enough information to determine the strength of bonding or the level of support being provided by the ACC layer. Longitudinal cracking correlated with PCC thicknesses and with planing. (3) Bond Over Time - The bond between PCC and ACC layers is degrading over time in the outside wheel path in all of the sections except tack coat (section 12). The bond strength in the section with tack coat was lower than the others, but remained relatively steady.

Correlation between microtensile bond strength data and clinical outcome of Class V restorations.

OBJECTIVE: To determine if the results of resin-dentin microtensile bond strength (µTBS) is correlated with the outcome parameters of clinical studies on non-retentive Class V restorations. METHODS: Resin-dentin µTBS data were obtained from one test center; the in vitro tests were all performed by the same operator. The µTBS testing was performed 8h after bonding and after 6 months of storing the specimens in water. Pre-test failures (PTFs) of specimens were included in the analysis, attributing them a value of 1MPa. Prospective clinical studies on cervical restorations (Class V) with an observation period of at least 18 months were searched in the literature. The clinical outcome variables were retention loss, marginal discoloration and marginal integrity. Furthermore, an index was formulated to be better able to compare the laboratory and clinical results. Estimates of adhesive effects in a linear mixed model were used to summarize the clinical performance of each adhesive between 12 and 36 months. Spearman correlations between these clinical performances and the µTBS values were calculated subsequently. RESULTS: Thirty-six clinical studies with 15 adhesive/restorative systems for which µTBS data were also available were included in the statistical analysis. In general 3-step and 2-step etch-and-rinse systems showed higher bond strength values than the 2-step/3-step self-etching systems, which, however, produced higher values than the 1-step self-etching and the resin modified glass ionomer systems. Prolonged water storage of specimens resulted in a significant decrease of the mean bond strength values in 5 adhesive systems (Wilcoxon, p<0.05). There was a significant correlation between µTBS values both after 8h and 6 months of storage and marginal discoloration (r=0.54 and r=0.67, respectively). However, the same correlation was not found between µTBS values and the retention rate, clinical index or marginal integrity. SIGNIFICANCE: As µTBS data of adhesive systems, especially after water storage for 6 months, showed a good correlation with marginal discoloration in short-term clinical Class V restorations, longitudinal clinical trials should explore whether early marginal staining is predictive for future retention loss in non-carious cervical restorations.

Bond strength of orthodontic brackets using different light and self-curing cements

The purpose of the study was to evaluate the shear bond strength of stainless steel orthodontic brackets directly bonded to extracted human premolar teeth. Fifty teeth were randomly divided into ¿ve groups: (1) System One (chemically cured composite resin), (2) Light Bond (light-cured composite resin), (3) Vivaglass Cem (self-curing glass ionomer cement), (4) Fuji Ortho LC (light-cured glass ionomer cement) used after 37% orthophosphoric acid¿etching of enamel (5) Fuji Ortho LC without orthophosphoric acid¿etching. The brackets were placed on the buccal and lingual surfaces of each tooth, and the specimens were stored in distilled water (24 hours) at 378C and thermocycled. Teeth were mounted on acrylic block frames, and brackets were debonded using an Instron machine. Shear bond strength values at fracture (Nw)were recorded. ANOVA and Student-Newman-Keuls multiple comparison tests were performed (P , .05). Bonding failure site was recorded by stereomicroscope and analyzed by Chi-square test, selected specimens of each group were observed by scanning electron microscope. System One attained the highest bond strength. Light Bond and Fuji Ortho LC, when using an acid-etching technique, obtained bond strengths that were within the range of estimated bond strength values for successful clinical bonding. Fuji Ortho LC and Vivaglass Cem left an almost clean enamel surface after debracketing.

Investigation of Field Corrosion Performance and Bond/Development Length of Galvanized Reinforcing Steel, TR-666, 2014

In reinforced concrete systems, ensuring that a good bond between the concrete and the embedded reinforcing steel is critical to long-term structural performance. Without good bond between the two, the system simply cannot behave as intended. The bond strength of reinforcing bars is a complex interaction between localized deformations, chemical adhesion, and other factors. Coating of reinforcing bars, although sometimes debated, has been commonly found to be an effective way to delay the initiation of corrosion in reinforced concrete systems. For many years, the standard practice has been to coat reinforcing steel with an epoxy coating, which provides a barrier between the steel and the corrosive elements of water, air, and chloride ions. Recently, there has been an industry-led effort to use galvanizing to provide the protective barrier commonly provided by traditional epoxy coatings. However, as with any new structural product, questions exist regarding both the structural performance and corrosion resistance of the system. In the fall of 2013, Buchanan County, Iowa constructed a demonstration bridge in which the steel girders and all internal reinforcing steel were galvanized. The work completed in this project sought to understand the structural performance of galvanized reinforcing steel as compared to epoxy-coated steel and to initiate a long-term corrosion monitoring program. This work consisted of a series of controlled laboratory tests and the installation of a corrosion monitoring system that can be observed for years in the future. The results of this work indicate there is no appreciable difference between the bond strength of epoxy-coated reinforcing steel and galvanized reinforcing steel. Although some differences were observed, no notable difference in either peak load, slip, or failure mode could be identified. Additionally, a long-term monitoring system was installed in this Buchanan County bridge and, to date, no corrosion activity has been identified.

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.

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

Bond Contribution to Whitetopping Performance on Low Volume Roads, Construction Report, HR-341, 1993

This research was initiated in 1991 as a part of a whitetopping project to study the effectiveness of various techniques to enhance bond strength between a new Portland cement concrete (PCC) overlay and an existing asphalt cement concrete (ACC) pavement surface. A 1,676 m (5,500 ft) section of county road R16 in Dallas County, Iowa was divided into 12 test sections. The various techniques used to enhance bond were power brooming, power brooming with air blast, milling, cement and water grout, and emulsion tack coat. As a part of these bonding techniques, two pavement thicknesses were placed; two different concrete proportions were used; and two sections were planed to a uniform cross-slope.

Effect of water contamination on the shear bond strength of five orthodontic adhesives

Objectives: To evaluate the shear bond strength and site of failure of brackets bonded to dry and wet enamel. Study design: 50 teeth were divided into ten groups of 5 teeth each (10 surfaces). In half the groups enamel was kept dry before bonding, and in the other half distilled water was applied to wet the surface after etching. The following groups were established: 1)Acid/Transbond-XT (dry/wet) XT; 2) Transbond Plus Self Etching Primer (TSEP)/Transbond-XT paste (dry/wet); 3) Concise (dry), Transbond MIP/Concise (wet), 4) FujiOrtho-LC (dry/wet); 5) SmartBond (dry/wet). Brackets were bonded to both buccal and lingual surfaces. Specimens were stored in distilled water (24 hours at 37ºC) and thermocycled. Brackets were debonded using a Universal testing machine (cross-head speed 1 mm/min). Failure sites were classified using a stereomicroscope. Results: No significant differences in bond strength were detected between the adhesives under wet and dry conditions except for Smart- Bond, whose bond strength was significantly lower under dry conditions. For all the adhesives most bond failures were of mixed site location except for Smartbond, which failed at the adhesive-bracket interface. Conclusions: Under wet conditions the bonding capacity of the adhesives tested was similar than under dry conditions, with the exception of SmartBond which improved under wet conditions

Bond strength tests of dental adhesive systems and their correlation with clinical results : a meta-analysis

OBJECTIVE: To evaluate the variability of bond strength test results of adhesive systems (AS) and to correlate the results with clinical parameters of clinical studies investigating cervical restorations. MATERIALS AND METHODS: Regarding the clinical studies, the internal database which had previously been used for a meta-analysis on cervical restorations was updated with clinical studies published between 2008 and 2012 by searching the PubMed and SCOPUS databases. PubMed and the International Association for Dental Research abstracts online were searched for laboratory studies on microtensile, macrotensile and macroshear bond strength tests. The inclusion criteria were (1) dentin, (2) testing of at least four adhesive systems, (3) same diameter of composite and (4) 24h of water storage prior to testing. The clinical outcome variables were retention loss, marginal discoloration, detectable margins, and a clinical index comprising the three parameters by weighing them. Linear mixed models which included a random study effect were calculated for both, the laboratory and the clinical studies. The variability was assessed by calculating a ratio of variances, dividing the variance among the estimated bonding effects obtained in the linear mixed models by the sum of all variance components estimated in these models. RESULTS: Thirty-two laboratory studies fulfilled the inclusion criteria comprising 183 experiments. Of those, 86 used the microtensile test evaluating 22 adhesive systems (AS). Twenty-seven used the macrotensile test with 17 AS, and 70 used the macroshear test with 24 AS. For 28 AS the results from clinical studies were available. Microtensile and macrotensile (Spearman rho=0.66, p=0.007) were moderately correlated and also microtensile and macroshear (Spearman rho=0.51, p=0.03) but not macroshear and macrotensile (Spearman rho=0.34, p=0.22). The effect of the adhesive system was significant for microtensile and macroshear (p<0.001) but not for macrotensile. The effect of the adhesive system could explain 36% of the variability of the microtensile test, 27% of the macrotensile and 33% of the macroshear test. For the clinical trials, about 49% of the variability of retained restorations could be explained by the adhesive system. With respect to the correlation between bond strength tests and clinical parameters, only a moderate correlation between micro- and macrotensile test results and marginal discoloration was demonstrated. However, no correlation between these tests and a retention loss or marginal integrity was shown. The correlation improved when more studies were included compared to assessing only one study. SIGNIFICANCE: The high variability of bond strength test results highlights the need to establish individual acceptance levels for a given test institute. The weak correlation of bond-strength test results with clinical parameters leads to the conclusion that one should not rely solely on bond strength tests to predict the clinical performance of an adhesive system but one should conduct other laboratory tests like tests on the marginal adaptation of fillings in extracted teeth and the retention loss of restorations in non-retentive cavities after artificial aging.

Desenvolupament des de zero d'un sistema Linux per ser instal·lat als ordinadors de les aules ordinàries d'un institut de secundària

Exposició dels passos que cal seguir per construir un sistema GNU/Linux adreçat a les aules dels instituts de secundària prenent com a base Linux From Scratch versió 7.5.

Stock and Bond Market Integration: Evidence from Russian Financial Markets

Minimizing the risks of an investment portfolio but not in the favour of expected returns is one of the key interests of an investor. Typically, portfolio diversification is achieved using two main strategies: investing in different classes of assets thought to have little or negative correlations or investing in similar classes of assets in multiple markets through international diversification. This study investigates integration of the Russian financial markets in the time period of January 1, 2003 to December 28, 2007 using daily data. The aim is to test the intra-country and cross-country integration of the Russian stock and bond markets between seven countries. Our test methodology for the short-run dynamics testing is the vector autoregressive model (VAR) and for the long-run cointegration testing we use the Johansen cointegration test which is an extension to VAR. The empirical results of this study show that the Russian stock and bond markets are not integrated in the long-run either at intra-country or cross-country level which means that the markets are relatively segmented. The short-run dynamics are also relatively low. This implies a presence of potential gains from diversification.