• DocumentCode
    1686117
  • Title

    Join query optimization in parallel database systems

  • Author

    Jhingran, Anant ; Padmanabhan, Sriram ; Shatdal, Ambuj

  • Author_Institution
    IBM T. J. Watson Res. Center, Yorktown Heights, NY, USA
  • fYear
    1993
  • fDate
    10/6/1993 12:00:00 AM
  • Firstpage
    114
  • Lastpage
    119
  • Abstract
    The authors present a new framework for studying query optimization. They first note that scheduling and optimization must go together in a parallel environment. They introduce the concept of response time envelopes which integrates scheduling and optimization. It is shown that it can be used effectively to develop parallel query optimization algorithms which have same order of complexity as the traditional sequential query optimization algorithms and produce provably optimal or near optimal join plans
  • Keywords
    distributed databases; optimisation; parallel algorithms; query processing; scheduling; complexity; parallel database systems; query optimization; query optimization algorithms; response time envelopes; scheduling; Concurrent computing; Cost function; Database systems; Delay; Dynamic programming; Heuristic algorithms; Optimization methods; Petroleum; Processor scheduling; Query processing;
  • fLanguage
    English
  • Publisher
    ieee
  • Conference_Titel
    Advances in Parallel and Distributed Systems, 1993., Proceedings of the IEEE Workshop on
  • Conference_Location
    Princeton, NJ
  • Print_ISBN
    0-8186-5250-0
  • Type

    conf

  • DOI
    10.1109/APADS.1993.588851
  • Filename
    588851