The Survey Science Centre of the XMM-Newton satellite released the first incremental version of the 2XMM catalogue in August 2008 . With more than 220,000 X-ray sources, the 2XMMi was at that time the largest catalogue of X-ray sources ever published
and thus constitutes an unprecedented resource for studying the high-energy properties of various classes of X-ray emitters such as AGN and stars. The advent of the 7th release of the Sloan Digital Sky Survey offers the opportunity to cross-match two major surveys and extend the spectral energy distribution of many 2XMMi sources towards the optical bands. We here present a cross-matching algorithm based on the classical likelihood ratio estimator. The method developed has the advantage of providing true probabilities of identifications without resorting to Monte-Carlo simulations. Over 30,000 2XMMi sources have SDSS counterparts with individual probabilities of identification higher than 90%. Using spectroscopic identifications from the SDSS DR7 catalogue supplemented by extraction from other catalogues, we build an identified sample from which the way the various classes of X-ray emitters gather in the multi dimensional parameter space can be analysed. We investigate two scientific use cases. In the first example we show how these multi-wavelength data can be used to search for new QSO2s. Although no specific range of observed properties allows us to identify Compton Thick QSO2s, we show that the prospects are much better for Compton Thin AGN2 and discuss several possible multi-parameter selection strategies. In a second example, we confirm the hardening of the mean X-ray spectrum with increasing X-ray luminosity on a sample of over 500 X-ray active stars and reveal that on average X-ray active M stars display bluer $g-r$ colour indexes than less active ones (abridged).
We report the results of an optical campaign carried out by the XMM-Newton Survey Science Centre with the specific goal of identifying the brightest X-ray sources in the XMM-Newton Galactic Plane Survey of Hands et al. (2004). In addition to photomet
ric and spectroscopic observations obtained at the ESO-VLT and ESO-3.6m, we used cross-correlations with the 2XMMi, USNO-B1.0, 2MASS and GLIMPSE catalogues to progress the identification process. Active coronae account for 16 of the 30 identified X-ray sources. Many of the identified hard X-ray sources are associated with massive stars emitting at intermediate X-ray luminosities of 10^32-34 erg/s. Among these are a very absorbed likely hyper-luminous star with X-ray/optical spectra and luminosities comparable with those of eta Carina, a new X-ray selected WN8 Wolf-Rayet star, a new Be/X-ray star belonging to the growing class of Gamma-Cas analogs and a possible supergiant X-ray binary of the kind discovered recently by INTEGRAL. One of the sources, XGPS-25 has a counterpart which exhibits HeII 4686 and Bowen CIII-NIII emission lines suggesting a quiescent or X-ray shielded Low Mass X-ray Binary, although its properties might also be consistent with a rare kind of cataclysmic variable (CV). We also report the discovery of three new CVs, one of which is a likely magnetic system. The soft (0.4-2.0 keV) band LogN-LogS curve is completely dominated by active stars in the flux range of 1x10^-13 to 1x10^-14 erg/cm2/s. In total, we are able to identify a large fraction of the hard (2-10 keV) X-ray sources in the flux range of 1x10^-12 to 1x10^-13 erg/cm2/s with Galactic objects at a rate consistent with that expected for the Galactic contribution only. (abridged)
