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

    Research output: Chapter in Book/Report/Conference proceedingConference contribution

    5 Citations (Scopus)
    39 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 languageEnglish
    Title of host publicationIn: Procs of the Int Conf on Parallel and Distributed Systems, ICPADS 2009
    PublisherInstitute of Electrical and Electronics Engineers (IEEE)
    Pages706-710
    ISBN (Print)978-1-4244-5788-5
    DOIs
    Publication statusPublished - 2009

    Fingerprint

    Dive into the research topics of 'Experiences Running OGSA-DQP Queries against a Heterogeneous Distributed Scientific Database'. Together they form a unique fingerprint.

    Cite this