Experiences Running OGSA-DQP Queries against a Heterogeneous Distributed Scientific Database

Xiang, H. (2009) Experiences Running OGSA-DQP Queries against a Heterogeneous Distributed Scientific Database. In: In: Procs of the Int Conf on Parallel and Distributed Systems, ICPADS 2009 :. Institute of Electrical and Electronics Engineers (IEEE), pp. 706-710. ISBN 978-1-4244-5788-5
Copy

This paper explores the use of emerging Grid technologies for the manipulation of a scientific dataset with complex schema. We focus on the potential of a well-known grid middleware-OGSA-DQP-for querying such datasets. In particular, we investigate running OGSA-DQP queries against SQL Server and Oracle database to access data in a complex schema of a real scientific database-the Sloan digital sky survey (SDSS) database. We used two common databases which support complex schemas and very large datasets: SQL Server and Oracle. The paper briefly provides the background information on the SDSS database. It then examines the running of a few OGSADQP queries and the query plans. Various join queries run successfully through OGSA-DQP after we optimized the implementation of some of the OGSA-DQP operations.
Item Type Book Section
Additional information “This material is presented to ensure timely dissemination of scholarly and technical work. Copyright and all rights therein are retained by authors or by other copyright holders. All persons copying this information are expected to adhere to the terms and constraints invoked by each author's copyright. In most cases, these works may not be reposted without the explicit permission of the copyright holder." “Copyright IEEE. Personal use of this material is permitted. However, permission to reprint/republish this material for advertising or promotional purposes or for creating new collective works for resale or redistribution to servers or lists, or to reuse any copyrighted component of this work in other works must be obtained from the IEEE.” DOI: 10.1109/ICPADS.2009.142
Date Deposited 15 May 2025 16:14
Last Modified 30 May 2025 23:07

Explore Further

picture_as_pdf
903957.pdf
View Download

Atom BibTeX OpenURL ContextObject in Span OpenURL ContextObject Dublin Core MPEG-21 DIDL Data Cite XML EndNote HTML Citation METS MODS RIOXX2 XML Reference Manager Refer ASCII Citation
Export

Downloads