In this paper we experiment with using the UNION ALL operator to make data integration queries over a version of the SDSS scientific Database, distributed using OGSA-DQP. The paper starts with background information on the SDSS database and the eScience technologies OGSA-DAI and OGSA-DQP. It recaps how we distributes a SDSS database across three sites. It then examines the running of several OGSA-DQP queries against the database. We discuss our experiences of using UNION ALL for integrating data results from data service resources based on heterogeneous underlying database management systems.
|Title of host publication||Procs 2011 6th IEEE Joint Int Information Technology and Artificial Intelligence Conf|
|Subtitle of host publication||ITAIC|
|Publisher||Institute of Electrical and Electronics Engineers (IEEE)|
|Pages||421 - 425|
|Publication status||Published - 2011|