• DocumentCode
    2518473
  • Title

    Scoped and approximate queries in a relational grid information service

  • Author

    Lu, Dong ; Dinda, Peter A. ; Skicewicz, Jason A.

  • Author_Institution
    Dept. of Comput. Sci., Northwestern Univ., Evanston, IL, USA
  • fYear
    2003
  • fDate
    17 Nov. 2003
  • Firstpage
    192
  • Lastpage
    199
  • Abstract
    We are developing a grid information service, RGIS, that is based on the relational data model. RGIS supports complex queries written in SQL that search for compositions (using joins) of resources. For example, we might ask it to find a Linux cluster with a certain bisection bandwidth and total memory. Such queries can be expensive to execute, however, and so we have developed several approaches that leverage our CIS schema to let us trade off between the number of results returned and the execution time. We describe two of them: scoped queries and approximate queries. Scoped queries constrain search to a network neighborhood, returning all matching results in the neighborhood. Approximate queries reduce the number of joins done by replacing collective constraints with constraints on individual resources, returning a subset of all the possible results in the grid. Scoping, approximation, and nondeterminism (described elsewhere), can be combined. We describe scoped and approximate queries, how they are implemented, and present performance evaluations for two examples. The evaluation suggests that scoping and approximation can greatly reduce query times while still returning a useful number of results.
  • Keywords
    SQL; constraint handling; grid computing; information services; query processing; relational databases; workstation clusters; CIS schema; Linux cluster; RGIS; SQL query; approximate queries; constraint handling; grid information service; relational data model; scoped queries; Bandwidth; Computer science; Data models; Distributed computing; Geographic Information Systems; Grid computing; Large-scale systems; Linux; Monitoring; Time sharing computer systems;
  • fLanguage
    English
  • Publisher
    ieee
  • Conference_Titel
    Grid Computing, 2003. Proceedings. Fourth International Workshop on
  • Print_ISBN
    0-7695-2026-X
  • Type

    conf

  • DOI
    10.1109/GRID.2003.1261715
  • Filename
    1261715