GAGPC: optimization of multiple continuous queries on data

  • Authors:
  • Young-Kyoon Suh;Jin Hyun Son;Myoung Ho Kim

  • Affiliations:
  • Dept. of Information System, Korea Inst. of Science and Tech. Info (KISTI), Yuseong-gu, Daejeon, South Korea;Dept. of Computer Science & Engineering, Hanyang University, Sangrok-gu, Ansan, Kyonggi-do, South Korea;Div. of Computer Science, Korea Advanced Inst. of Science & Tech. (KAIST), Yuseong-gu, Daejeon, South Korea

  • Venue:
  • DBA'06 Proceedings of the 24th IASTED international conference on Database and applications
  • Year:
  • 2006

Quantified Score

Hi-index 0.00

Visualization

Abstract

In general, there can be many reusable intermediate results due to the overlapped windows and periodic execution intervals among Multiple Continuous Queries (MCQ) on data streams. In this regard, we propose an efficient greedy algorithm for a global query plan construction, called GAGPC. GAGPC first decides an execution cycle and finds the maximal Set(s) of Related execution Points (SRP). Next, GAGPC constructs a global execution plan to make MCQ share common join-fragments with the highest benefit in each SRP. The algorithm suggests that the best plan of the same continuous queries may be different according to not only the existence of common expressions, but the size of overlapped windows related to them. It also reflects to reuse not only the whole but partial intermediate results unlike previous work. Finally, we show experimental results for the validation of GAGPC.