Title :
Integrated queries over a heterogeneously distributed scientific database using OGSA-DQP
Author_Institution :
Comput. Sci., Univ. of Hertfordshire, Hatfield, UK
Abstract :
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.
Keywords :
distributed databases; grid computing; natural sciences computing; query processing; OGSA-DAI; OGSA-DQP queries; SDSS database; SDSS scientific database; Sloan Digital Sky Survey; UNION ALL operator; data integration queries; data service resources; eScience technologies; heterogeneous underlying database management systems; heterogeneously distributed scientific database; integrated queries; open grid services architecture-distributed query processing; Database systems; Distributed databases; Educational institutions; Java; Middleware; Servers; Distributed Database; Distributed Query; Heterogeneous Database; OGSA-DQP;
Conference_Titel :
Information Technology and Artificial Intelligence Conference (ITAIC), 2011 6th IEEE Joint International
Conference_Location :
Chongqing
Print_ISBN :
978-1-4244-8622-9
DOI :
10.1109/ITAIC.2011.6030237
