VerdictDB: Universalizing Approximate Query Processing

Despite 25 years of research in academia, approximate query processing (AQP) has had little industrial adoption. One of the major causes of this slow adoption is the reluctance of traditional vendors to make radical changes to their legacy codebases, and the preoccupation of newer vendors (e.g., SQL-on-Hadoop products) with implementing standard features. Additionally, the few AQP engines that are available are each tied to a specific platform and require users to completely abandon their existing databases---an unrealistic expectation given the infancy of the AQP technology. Therefore, we argue that a universal solution is needed: a database-agnostic approximation engine that will widen the reach of this emerging technology across various platforms. Our proposal, called VerdictDB, uses a middleware architecture that requires no changes to the backend database, and thus, can work with all off-the-shelf engines. Operating at the driver-level, VerdictDB intercepts analytical queries issued to the database and rewrites them into another query that, if executed by any standard relational engine, will yield sufficient information for computing an approximate answer. VerdictDB uses the returned result set to compute an approximate answer and error estimates, which are then passed on to the user or application. However, lack of access to the query execution layer introduces significant challenges in terms of generality, correctness, and efficiency. This paper shows how VerdictDB overcomes these challenges and delivers up to 171$\times$ speedup (18.45$\times$ on average) for a variety of existing engines, such as Impala, Spark SQL, and Amazon Redshift, while incurring less than 2.6% relative error. VerdictDB is open-sourced under Apache License.Comment: Extended technical report of the paper that appeared in Proceedings of the 2018 International Conference on Management of Data, pp. 1461-1476. ACM, 201

Jamming and Fluctuations in Granular Drag

We investigate the dynamic evolution of jamming in granular media through fluctuations in the granular drag force. The successive collapse and formation of jammed states give a stick-slip nature to the fluctuations which is independent of the contact surface between the grains and the dragged object -- thus implying that the stress-induced collapse is nucleated in the bulk of the granular sample. We also find that while the fluctuations are periodic at small depths, they become "stepped" at large depths, a transition which we interpret as a consequence of the long-range nature of the force chains.Comment: 7 pages, 4 figures, RevTe

Synthetic biology: Building the language for a new science brick by metaphorical brick

Changes in the biosciences and their relations to society over the last decades provide a unique opportunity to examine whether or not such changes leave traces in the language we use to talk about them. In this article we examine metaphors used in English-speaking press coverage to conceptualize a new type of (interdisciplinary) bioscience: synthetic biology. Findings show that three central metaphors were used between 2008 and May 2010. They exploit social and cultural knowledge about books, computers and engines and are linked to knowledge of three revolutions in science and society (the printing, information and industrial revolutions). These three central metaphors are connected to each other through the concepts of reading/writing, designing and mass production and they focus on science as a revolutionary process rather than on the end results or products of science. Overall, we observed the use of a complex bricolage of mixed metaphors and chains of metaphors that root synthetic biology in historical events and achievements, while at the same time extolling its promises for the future. © 2011 Copyright Taylor and Francis Group, LLC

Radiative Muon Capture on Hydrogen and the Induced Pseudoscalar Coupling

The first measurement of the elementary process $\mu^- p \rightarrow \nu_{\mu} n \gamma$ is reported. A photon pair spectrometer was used to measure the partial branching ratio ($2.10 \pm 0.22) \times 10^{-8}$ for photons of k > 60 MeV. The value of the weak pseudoscalar coupling constant determined from the partial branching ratio is $g_p(q^{2}=-0.88m_{\mu}^2) = (9.8 \pm 0.7 \pm 0.3) \cdot g_a(0)$, where the first error is the quadrature sum of statistical and systematic uncertainties and the second error is due to the uncertainty in $\lambda_{op}$, the decay rate of the ortho to para $p \mu p$ molecule. This value of g_p is $\sim$1.5 times the prediction of PCAC and pion-pole dominance.Comment: 13 pages, RevTeX type, 3 figures (encapsulated postscript), submitted to Phys. Rev. Let

Parity-violating Electron Deuteron Scattering and the Proton's Neutral Weak Axial Vector Form Factor

We report on a new measurement of the parity-violating asymmetry in quasielastic electron scattering from the deuteron at backward angles at Q2= 0.038 (GeV/c)2. This quantity provides a determination of the neutral weak axial vector form factor of the nucleon, which can potentially receive large electroweak corrections. The measured asymmetry A=-3.51 +/- 0.57(stat) +/- 0.58(sys)ppm is consistent with theoretical predictions. We also report on updated results of the previous experiment at Q2=0.091 (GeV/c)2, which are also consistent with theoretical predictions.Comment: 4 pages, 2 figures, submitted to Phys. Rev. Let

Future Directions in Parity Violation: From Quarks to the Cosmos

I discuss the prospects for future studies of parity-violating (PV) interactions at low energies and the insights they might provide about open questions in the Standard Model as well as physics that lies beyond it. I cover four types of parity-violating observables: PV electron scattering; PV hadronic interactions; PV correlations in weak decays; and searches for the permanent electric dipole moments of quantum systems.Comment: Talk given at PAVI 06 workshop on parity-violating interactions, Milos, Greece (May, 2006); 10 page

Dietary Intake and Rural-Urban Migration in India: A Cross-Sectional Study

BACKGROUND: Migration from rural areas of India contributes to urbanisation and lifestyle change, and dietary changes may increase the risk of obesity and chronic diseases. We tested the hypothesis that rural-to-urban migrants have different macronutrient and food group intake to rural non-migrants, and that migrants have a diet more similar to urban non-migrants. METHODS AND FINDINGS: The diets of migrants of rural origin, their rural dwelling sibs, and those of urban origin together with their urban dwelling sibs were assessed by an interviewer-administered semi-quantitative food frequency questionnaire. A total of 6,509 participants were included. Median energy intake in the rural, migrant and urban groups was 2731, 3078, and 3224 kcal respectively for men, and 2153, 2504, and 2644 kcal for women (p<0.001). A similar trend was seen for overall intake of fat, protein and carbohydrates (p<0.001), though differences in the proportion of energy from these nutrients were <2%. Migrant and urban participants reported up to 80% higher fruit and vegetable intake than rural participants (p<0.001), and up to 35% higher sugar intake (p<0.001). Meat and dairy intake were higher in migrant and urban participants than rural participants (p<0.001), but varied by region. Sibling-pair analyses confirmed these results. There was no evidence of associations with time in urban area. CONCLUSIONS: Rural to urban migration appears to be associated with both positive (higher fruit and vegetables intake) and negative (higher energy and fat intake) dietary changes. These changes may be of relevance to cardiovascular health and warrant public health interventions