Sampling-Based Query Re-Optimization

Despite of decades of work, query optimizers still make mistakes on "difficult" queries because of bad cardinality estimates, often due to the interaction of multiple predicates and correlations in the data. In this paper, we propose a low-cost post-processing step that can take a plan produced by the optimizer, detect when it is likely to have made such a mistake, and take steps to fix it. Specifically, our solution is a sampling-based iterative procedure that requires almost no changes to the original query optimizer or query evaluation mechanism of the system. We show that this indeed imposes low overhead and catches cases where three widely used optimizers (PostgreSQL and two commercial systems) make large errors.Comment: This is the extended version of a paper with the same title and authors that appears in the Proceedings of the ACM SIGMOD International Conference on Management of Data (SIGMOD 2016

An Efficient QBIR System Using Adaptive Segmentation and Multiple Features

AbstractQuery by Image Content Retrieval abbreviated as QBIR, has become new thirst now a days. By using this systems, user can retrieve the similar images of an already existed image (or) a rough sketch (or) a symbolic representation. To make more efficient and user friendly QBIR multiple features areemployed. This paper proposes a novel approach for image retrieval using adaptive k-means clustering and shape, texture features. The experimental results portraystheperformance of the proposed retrieval system in terms of better precision. To evaluate the proposed method COIL and MPEG-7 shape 1 datasets are used

Plants Used in Ethnoveterinary Practices by Koyas of Pakhal Wildlife Sanctuary, Andhra Pradesh, India

The paper deals with the 21 medicinal plant species used in ethnoveterinary practices by Koya tribes inhabiting in the Pakhal Wildlife Sanctuary, Warangal district, Andhra Pradesh, India

X-ray properties of UV-selected star forming galaxies at z~1 in the Hubble Deep Field North

We present an analysis of the X-ray emission from a large sample of ultraviolet (UV) selected, star forming galaxies with 0.74<z<1.32 in the Hubble Deep Field North (HDF-N) region. By excluding all sources with significant detected X-ray emission in the 2 Ms Chandra observation we are able to examine the properties of galaxies for which the emission in both UV and X-ray is expected to be predominantly due to star formation. Stacking the X-ray flux from 216 galaxies in the soft and hard bands produces significant detections. The derived mean 2-10 keV rest-frame luminosity is 2.97+/-0.26x10^(40) erg/s, corresponding to an X-ray derived star formation rate (SFR) of 6.0+/-0.6 Msolar/yr. Comparing the X-ray value with the mean UV derived SFR, uncorrected for attenuation, we find that the average UV attenuation correction factor is \~3. By binning the galaxy sample according to UV magnitude and colour, correlations between UV and X-ray emission are also examined. We find a strong positive correlation between X-ray emission and rest-frame UV emission. A correlation between the ratio of X-ray-to-UV emission and UV colour is also seen, such that L(X)/L(UV) increases for redder galaxies. Given that X-ray emission offers a view of star formation regions that is relatively unaffected by extinction, results such as these can be used to evaluate the effects of dust on the UV emission from high-z galaxies. For instance we derive a relationship for estimating UV attenuation corrections as a function of colour excess. The observed relation is inconsistent with the Calzetti et al. (2000) reddening law which over predicts the range in UV attenuation corrections by a factor of ~100 for the UV selected z~1 galaxies in this sample (abridged).Comment: 10 pages, 7 figures, accepted for publication in MNRA

Dynamic analysis of a pre-and-post ice impacted blade

The dynamic characteristics of an engine blade are evaluated under pre-and-post ice impact conditions using the NASA in-house computer code BLASIM. The ice impacts the leading edge of the blade causing severe local damage. The local structural response of the blade due to the ice impact is predicted via a transient response analysis by modeling only a local patch around the impact region. After ice impact, the global geometry of the blade is updated using deformations of the local patch and a free vibration analysis is performed. The effects of ice impact location, size and ice velocity on the blade mode shapes and natural frequencies are investigated. The results indicate that basic nature of the mode shapes remains unchanged after impact and that the maximum variation in natural frequencies occurs for the twisting mode of the blade

Structural tailoring of aircraft engine blade subject to ice impact constraints

Results are presented for the minimum weight design of SR2 unswept blade made of (titanium/graphite-epoxy/titanium) sub s fiber composite. The blade which is rotating at high RPM is subject to ice impact. The root chord length, blade thicknesses at five stations, and graphite-epoxy ply orientation are chosen as design variables. Design constraints are placed on the behavior variables: local leading edge strain and root damage parameter (combined stress failure criteria) as a function due to ice impact, maximum spanwise centrifugal stress at the root of the deformed blade due to local damage, first three natural frequencies, and resonance margin after impact. The method of feasible directions is employed to solve the inequality constrained minimization problem. The effect of ice speed and the ice impact location on the final design are discussed

Root damage analysis of aircraft engine blade subject to ice impact

The blade root response due to ice impact on an engine blade is simulated using the NASA in-house code BLASIM. The ice piece is modeled as an equivalent spherical object impacting on the leading edge of the blade and has the velocity opposite to that of the aircraft with direction parallel to the engine axis. The effect of ice impact is considered to be an impulse load on the blade with its amplitude computed based on the momentum transfer principle. The blade response due to the impact is carried out by modal superposition using the first three modes. The maximum dynamic stresses at the blade root are computed at the quarter cycle of the first natural frequency. A combined stress failure function based on modified distortion energy is used to study the spanwise bending damage response at the blade root. That damage function reaches maximum value for very low ice speeds and increases steeply with increases in engine speed