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

H. Xiang

doi:10.1109/ICPADS.2009.142

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

H. Xiang

Research output: Chapter in Book/Report/Conference proceeding › Conference contribution

5 Citations (Scopus)

61 Downloads (Pure)

Abstract

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.

Original language	English
Title of host publication	In: Procs of the Int Conf on Parallel and Distributed Systems, ICPADS 2009
Publisher	Institute of Electrical and Electronics Engineers (IEEE)
Pages	706-710
ISBN (Print)	978-1-4244-5788-5
DOIs	https://doi.org/10.1109/ICPADS.2009.142
Publication status	Published - 2009

Access to Document

10.1109/ICPADS.2009.142

903957.pdf

Cite this

@inproceedings{4ecbaa82024b42b9a117087273ea5c56,

title = "Experiences Running OGSA-DQP Queries against a Heterogeneous Distributed Scientific Database",

abstract = "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.",

author = "H. Xiang",

note = "“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",

year = "2009",

doi = "10.1109/ICPADS.2009.142",

language = "English",

isbn = "978-1-4244-5788-5",

pages = "706--710",

booktitle = "In: Procs of the Int Conf on Parallel and Distributed Systems, ICPADS 2009",

publisher = "Institute of Electrical and Electronics Engineers (IEEE)",

address = "United States",

}

TY - GEN

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

AU - Xiang, H.

N1 - “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

PY - 2009

Y1 - 2009

N2 - 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.

AB - 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.

U2 - 10.1109/ICPADS.2009.142

DO - 10.1109/ICPADS.2009.142

M3 - Conference contribution

SN - 978-1-4244-5788-5

SP - 706

EP - 710

BT - In: Procs of the Int Conf on Parallel and Distributed Systems, ICPADS 2009

PB - Institute of Electrical and Electronics Engineers (IEEE)

ER -

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

Abstract

Access to Document

Fingerprint

Cite this