Improving Database Quality through Eliminating Duplicate Records

Redundant or duplicate data are the most troublesome problem in database management and applications. Approximate field matching is the key solution to resolve the problem by identifying semantically equivalent string values in syntactically different representations. This paper considers token-based solutions and proposes a general field matching framework to generalize the field matching problem in different domains. By introducing a concept of String Matching Points (SMP) in string comparison, string matching accuracy and efficiency are improved, compared with other commonly-applied field matching algorithms. The paper discusses the development of field matching algorithms from the developed general framework. The framework and corresponding algorithm are tested on a public data set of the NASA publication abstract database. The approach can be applied to address the similar problems in other databases

The Fueling Diagram: Linking Galaxy Molecular-to-Atomic Gas Ratios to Interactions and Accretion

To assess how external factors such as local interactions and fresh gas accretion influence the global ISM of galaxies, we analyze the relationship between recent enhancements of central star formation and total molecular-to-atomic (H2/HI) gas ratios, using a broad sample of field galaxies spanning early-to-late type morphologies, stellar masses of 10^(7.2-11.2) Msun, and diverse stages of evolution. We find that galaxies occupy several loci in a "fueling diagram" that plots H2/HI vs. mass-corrected blue-centeredness, a metric tracing the degree to which galaxies have bluer centers than the average galaxy at their stellar mass. Spiral galaxies show a positive correlation between H2/HI and mass-corrected blue-centeredness. When combined with previous results linking mass-corrected blue-centeredness to external perturbations, this correlation suggests a link between local galaxy interactions and molecular gas inflow/replenishment. Intriguingly, E/S0 galaxies show a more complex picture: some follow the same correlation, some are quenched, and a distinct population of blue-sequence E/S0 galaxies (with masses below key transitions in gas richness) defines a separate loop in the fueling diagram. This population appears to be composed of low-mass merger remnants currently in late- or post-starburst states, in which the burst first consumes the H2 while the galaxy center keeps getting bluer, then exhausts the H2, at which point the burst population reddens as it ages. Multiple lines of evidence suggest connected evolutionary sequences in the fueling diagram. In particular, tracking total gas-to-stellar mass ratios within the diagram provides evidence of fresh gas accretion onto low-mass E/S0s emerging from central starbursts. Drawing on a comprehensive literature search, we suggest that virtually all galaxies follow the same evolutionary patterns found in our broad sample.Comment: 24 pages, 11 figures (table 4 available at http://user.physics.unc.edu/~dstark/table4_csv.txt), accepted for publication in Ap

Low Catalyst Loadings in Olefin Metathesis: Synthesis of Nitrogen Heterocycles by Ring-Closing Metathesis

A series of ruthenium catalysts have been screened under ring-closing metathesis (RCM) conditions to produce five-, six-, and seven-membered carbamate-protected cyclic amines. Many of these catalysts demonstrated excellent RCM activity and yields with as low as 500 ppm catalyst loadings. RCM of the five-membered carbamate series could be run neat, the six-membered carbamate series could be run at 1.0 M, and the seven-membered carbamate series worked best at 0.2−0.05 M

Forced and unforced decadal behavior of the interhemispheric SST contrast during the instrumental period (1881–2012):contextualizing the abrupt shift around 1970

The sea surface temperature (SST) contrast between the Northern Hemisphere (NH) and Southern Hemisphere (SH) influences the location of the intertropical convergence zone (ITCZ) and the intensity of the monsoon systems. This study examines the contributions of external forcing and unforced internal variability to the interhemispheric SST contrast in HadSST3 and ERSSTv5 observations, and 10 models from phase 5 of the Coupled Model Intercomparison Project (CMIP5) from 1881 to 2012. Using multimodel mean fingerprints, a significant influence of anthropogenic, but not natural, forcing is detected in the interhemispheric SST contrast, with the observed response larger than that of the model mean in ERSSTv5. The forced response consists of asymmetric NH–SH SST cooling from the mid-twentieth century to around 1980, followed by opposite NH–SH SST warming. The remaining best-estimate residual or unforced component is marked by NH–SH SST maxima in the 1930s and mid-1960s, and a rapid NH–SH SST decrease around 1970. Examination of decadal shifts in the observed interhemispheric SST contrast highlights the shift around 1970 as the most prominent from 1881 to 2012. Both NH and SH SST variability contributed to the shift, which appears not to be attributable to external forcings. Most models examined fail to capture such large-magnitude shifts in their control simulations, although some models with high interhemispheric SST variability are able to produce them. Large-magnitude shifts produced by the control simulations feature disparate spatial SST patterns, some of which are consistent with changes typically associated with the Atlantic meridional overturning circulation (AMOC)