Translating data between MySQL and Stata

As web-based and other electronic data collection methods become more widely used in research, the opportunities to use statistical software in conjunction with conventional database systems are increasing. Among such systems, MySQL is particularly well suited for research purposes. For example, MySQL's ENUM and SET column types are ideal for storing data collected via the multiple choice questions typically used in social surveys. At the same time, Stata is uniquely suited for working in conjunction with a database; for example, its implementation of characteristics makes it possible to preserve (in a usable form) important information about how the database and front-end application are constructed (e.g., column types and other attributes). In this presentation, we shall describe a Python script we have developed for translating data from MySQL to Stata, and will indicate briefly how we are using it in the development of tools for the collection and management of research data.

Geomorphology of the middle Mississippi River

DBS-SAS-MAS 9.Includes bibliographical references (pages 79-80).Prepared for U.S. Army Engineer Waterways Experiment Station, Corps of Engineers, Vicksburg, Mississippi under Contract No. DACW39-73-C- 0026 by Engineering Research Center, Colorado State University, Fort Collins, Colorado.January 1974.Sponsored by U.S. Army Engineer District, St. Louis

Literaturauswahl und -bestellung leichter gemacht!

Im vorliegenden Artikel werden Mehrwertdienste und Unterstützungstools rund um die Literaturauswahl und den Bestellprozess vorgestellt, welche die Bearbeitung von elektronischen Erwerbungsunterlagen vereinfachen. Die vorgestellten Softwarewerkzeuge sind Eigenentwicklungen aus drei Bibliotheken und können durch andere Bibliotheken angepasst sowie nachgenutzt werden

Noise Thermometry with Two Weakly Coupled Bose-Einstein Condensates

Here we report on the experimental investigation of thermally induced fluctuations of the relative phase between two Bose-Einstein condensates which are coupled via tunneling. The experimental control over the coupling strength and the temperature of the thermal background allows for the quantitative analysis of the phase fluctuations. Furthermore, we demonstrate the application of these measurements for thermometry in a regime where standard methods fail. With this we confirm that the heat capacity of an ideal Bose gas deviates from that of a classical gas as predicted by the third law of thermodynamics.Comment: 4 pages, 4 figure

A Classification of BPEL Extensions

The Business Process Execution Language (BPEL) has emerged as de-facto standard for business processes implementation. This language is designed to be extensible for including additional valuable features in a standardized manner. There are a number of BPEL extensions available. They are, however, neither classified nor evaluated with respect to their compliance to the BPEL standard. This article fills this gap by providing a framework for classifying BPEL extensions, a classification of existing extensions, and a guideline for designing BPEL extensions

Nineteenth Annual Bibliography, 2003 (Contemporary German Literature Collection)

Bibliography of contemporary German literature volumes added the previous year to Washington University Libraries\u27 Contemporary German Literature Collection. These acquisitions generally include novels, poetry, short story collections, essays, autobiographical works, and literary and cultural periodicals from publishers in Germany, Austria, and Switzerland. This Collection serves as the research arm for the Department of Germanic Languages and Literature\u27s Max Kade Center for Contemporary German Literature. This bibliography is compiled by Washington University\u27s Department of Germanic Languages and Literatures in cooperation with the University Libraries. See also Contemporary German Literature Collection and Max Kade Center for Contemporary German Literature

The emergence of topographic steady state in a perpetually dynamic self-organized critical landscape

We conducted a series of four physical modeling experiments of mountain growth at differing rates of uplift and three distinct climates ranging from relatively wet to relatively dry. The spatial and temporal pattern of landscape behavior is characterized by ∼f−1 scaling in sediment discharge and power law scaling in the magnitude and frequency of ridge movement in all four experiments. We find that internally generated self-organized critical (SOC) processes generate dynamically stable catchment geometries after ∼1 relief depths of erosion: these regularly spaced catchments have an average outlet-spacing ratio of 2.16, well within the range of values reported in field studies. Once formed, large catchment bounding ridges oscillate about a critically balanced mean location, with occasional large-scale changes in catchment size. Ridge movement appears to be driven by the competition for discharge as landslides push ridges back and forth. These dynamics lead to the emergence of a complex twofold scaling in catchment dynamics that is fully established by 1.8 relief depths of erosion; at this stage, a clear threshold has emerged separating two distinct scaling regimes, where large ridge mobility is insensitive to relief and small ridge mobility is relief dependent. Overall, we demonstrate that the development of dynamically stable large-scale landforms is related to the emergence of a complex-system hierarchy in topographic dynamics. Once formed, these landscapes do not evolve; statistical properties such as average topography and discharge become stationary while topography remains highly dynamic at smaller length scales

Ulcerative colitis-risk loci on chromosomes 1p36 and 12q15 found by genome-wide association study.

Ulcerative colitis is a chronic inflammatory disease of the colon that presents as diarrhea and gastrointestinal bleeding. We performed a genome-wide association study using DNA samples from 1,052 individuals with ulcerative colitis and preexisting data from 2,571 controls, all of European ancestry. In an analysis that controlled for gender and population structure, ulcerative colitis loci attaining genome-wide significance and subsequent replication in two independent populations were identified on chromosomes 1p36 (rs6426833, combined P = 5.1 x 10(-13), combined odds ratio OR = 0.73) and 12q15 (rs1558744, combined P = 2.5 x 10(-12), combined OR = 1.35). In addition, combined genome-wide significant evidence for association was found in a region spanning BTNL2 to HLA-DQB1 on chromosome 6p21 (rs2395185, combined P = 1.0 x 10(-16), combined OR = 0.66) and at the IL23R locus on chromosome 1p31 (rs11209026, combined P = 1.3 x 10(-8), combined OR = 0.56; rs10889677, combined P = 1.3 x 10(-8), combined OR = 1.29)