Multimedia Tools and Applications

, Volume 22, Issue 3, pp 235–262 | Cite as

Heuristics for Optimizing Multi-Clip Queries in Video Databases

  • Harald Kosch
  • Ahmed Mostefaoui
  • László Böszörményi
  • Lionel Brunie


In this paper we address the multi-clip query optimization problem where a multi-clip query requests multiple video clips. We propose a new heuristics called Restricted Search Interval that maximizes clip sharing between queries and consequently reduces the network bandwidth of a video server for a multicast system. An adaptation of our heuristics for optimizing the response time of the query is also presented. The experimental results show that the suggested heuristics reduces the server workload by about 28% on the average in comparison to a classical heuristic approach.

video databases video server multi-clip queries piggypacking 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    S. Adali, M. Sapino, and V. Subrahmanian, “A multimedia presentation algebra,” in Proceedings of the ACM SIGMOD Conference, 1999, pp. 121–132.Google Scholar
  2. 2.
    D. Anderson, “Device reservation in Audio/Video editing systems,” ACM Transactions On Computer Systems Vol. 15,No. 1, pp. 111–133, 1997.Google Scholar
  3. 3.
    N. Balkir and G. Özsoyoglu, “Delivering presentations from multimedia servers,” VLDB Journal, Vol. 7,No. 4, pp. 294–307, 1998a.Google Scholar
  4. 4.
    N. Balkir and G. Özsoyoglu, “Multimedia presentation servers: Buffer management and admission control,” in Proceedings of the International Workshop on Multimedia Database Management Systems, 1998b, pp. 154–161.Google Scholar
  5. 5.
    C. Bouras, V. Kapoulas, D. Miras, V. Ouzounis, P. Spirakis, and A. Tatakis, “On-demand hypermedia/mutimedia service using pre-orcestrated scenarios over the internet,” Networking and Information Systems Journal (Hermes Science), Vol. 2,Nos. 5/6, pp. 741–762, 1999.Google Scholar
  6. 6.
    S.T. Campbell and S. Chung, “Scheduling and optimization of the delivery of multimedia streams using query scripts,” Multimedia Tools and Applications, Vol. 18,No. 1, 2002, pp. 5–30.Google Scholar
  7. 7.
    F.-C.F. Chen and M.H. Dunham, “Common subexpression processing in multiple-query processing,” IEEE Transactions on Knowledge and Data Engineering, Vol. 10,No. 3, pp. 493–499, 1998.Google Scholar
  8. 8.
    A. Dan, D. Sitaram, and P. Shahabuddin, “Scheduling policies for an on-demand video server with batching,” in ACM International Multimedia Conference, pp. 15–23, 1994.Google Scholar
  9. 9.
    C. Diot, B. Levine, B. Lyles, H. Kassem, and D. Balensiefen, “Deployment issues for the IP multicast service and architecture,” IEEE Network, Vol. 14,No. 1, pp. 78–88, 2000.Google Scholar
  10. 10.
    H. El-Rewini, T. Lewis, and H. Ali, Task Scheduling in Parallel and Distributed Systems, Prentice-Hall, 1994.Google Scholar
  11. 11.
    M. Garofalakis, Y. Ioannidis, and B. Özden, “Resource scheduling for composite multimedia objects,” in International Conference on Very Large Databases, New York, 1998, pp. 74–85.Google Scholar
  12. 12.
    J. Huang, P. Wan, and D.-Z. Du, “Criticality-and QoS-based multiresource negotiation and adaptation,” Real-Time Systems, Vol. 15,No. 3, pp. 249–273, 1998.Google Scholar
  13. 13.
    H. Jiang, D. Montesi, and A.K. Elmagarmid, “Content-based access to video databases,” Multimedia Tools and Applications, Vol. 9,No. 3, pp. 227–249, 1999.Google Scholar
  14. 14.
    X. Jiang and P. Mohapatra, “Efficient admission control algorithms for multimedia servers,” Multimedia Systems, Vol. 7,No. 4, pp. 294–304, 1999.Google Scholar
  15. 15.
    T.V. Johnson and A. Zhang, “Dynamic playout scheduling algorithms for continuous multimedia streams,” Multimedia Systems, Vol. 7,No. 4, pp. 312–325, 1999.Google Scholar
  16. 16.
    H. Kosch, “MPEG-7 and multimedia database systems,” SIGMOD Records, Vol. 31,No. 2, 2002.Google Scholar
  17. 17.
    H. Kosch, A. Moustefaoui, and L. Brunie, “Semantic based prefetching in news-on-demand video servers,” Multimedia Tools and Applications, Vol. 18,No. 2, 2002.Google Scholar
  18. 18.
    H. Kosch, R. Tusch, L. Böszörményi, A. Bachlechner, B. Dörflinger, C. Hofbauer, C. Riedler, M. Lang, and C. Hanin, “SMOOTH—A distributed multimedia database system,” in Proceedings of the International VLDB Conference. Rome, Italy, pp. 713–714, 2001.Google Scholar
  19. 19.
    S.-W. Lau, C.S. Lui, and L. Golubchik, “Merging video streams in multimedia storage server: Complexity and heuristics,” Multimedia Systems, Vol. 6,No. 1, pp. 29–42, 1998.Google Scholar
  20. 20.
    T. Lee, L. Sheng, N. Balkir, A. Al-Hamdani, G. Özsoyoglu, and Z. Özsoyoglu, “Query processing techniques for multimedia presentations,” Multimedia Tools and Applications, Vol. 11,No. 1, pp. 63–69, 2000.Google Scholar
  21. 21.
    O. Megzari, L. Yuan, and A. Karmouch, “Meta-data and media management in a multimedia interactive telelearning system,” Multimedia Tools and Applications, Vol. 16,Nos. 1/2, pp. 137–160, 2002.Google Scholar
  22. 22.
    H. Meng, D. Zhong, and S.-F. Chang, “Searching and editing MPEG-compressed video in a distributed online environment,” Multimedia Systems, Vol. 7,No. 4, pp. 282–293, 1999.Google Scholar
  23. 23.
    W.S. Min-You Wu, “Optimal scheduling for parallel CBR video servers,” Multimedia Tools and Applications, Vol. 14,No. 1, pp. 79–99, 2001.Google Scholar
  24. 24.
    V. Oria, M. Özsu, B. Xu, L. Cheng, and P. Iglinski, “VisualMOQL: The DISIMA visual query language,” in IEEE International Conference on Multimedia Computing and Systems, Florence, Italy, Vol. 1, 1999, pp. 536–542.Google Scholar
  25. 25.
    B. Prabhakaran, “Adaptive multimedia presentation strategies,” Multimedia Tools and Applications, Vol. 12,Nos. 2/3, pp. 281–298, 2000.Google Scholar
  26. 26.
    T.N. Raymond and S. Paul, “Optimal clip ordering for multi-clip queries,” VLDB Journal, Vol. 7,No. 4, pp. 239–252, 1998.Google Scholar
  27. 27.
    T.K. Sellis, “Multiple-query optimization,” ACM Transactions on Database Systems, Vol. 13,No. 1, pp. 23–52, 1988.Google Scholar
  28. 28.
    C. Shahabi, A. Dashti, and S. Ghandeharizadeh, “Continuous media retrieval optimizer and hierarchical storage structures,” in Third International Conference on Integrated Design and Process Technology IADT'98, 1998a, pp. 360–367.Google Scholar
  29. 29.
    C. Shahabi, A. Dashti, and S. Ghandeharizadeh, “Profile aware retrieval optimizer for continuous media,” in World Automation Congress (WAC), 1998b.Google Scholar
  30. 30.
    L. Sheng, Z. Özsoyoglu, and G. Özsoyoglu, “A graph query language and its query processing,” in IEEE International Conference on Data Engineering (ICDE), Sydney, Australia, pp. 572–581, 1999.Google Scholar
  31. 31.
    Y. Song, M. Mielke, and A. Zhang, “NetMedia: Synchronized streaming of multimedia presentations in distributed environments,” in IEEE International Conference on Multimedia Computing and Systems, Vol. 2, pp. 585–590, 1999.Google Scholar
  32. 32.
    P. van Beek, A. Benitez, J. Heuer, J. Martinez, P. Salembier, J. Smith, and T. Walker, “MPEG-7: Multimedia description schemes,” ISO/IEC FDIS 15938-5:2001, 2001.Google Scholar
  33. 33.
    W3C, “Synchronized multimedia integration language (SMIL) version 2.0,” REC-smil20-20010807, 2001. Scholar
  34. 34.
    R. Wittmann and M. Zitterbart (Eds.), Multicast Communication, Morgan Kaufmann Publishers, 2000.Google Scholar
  35. 35.
    A. Zhang and S. Gollapudi, “QoS management in educational digital library environments,” Multimedia Tools and Applications, Vol. 10,Nos. 2/3, pp. 133–156, 2000.Google Scholar

Copyright information

© Kluwer Academic Publishers 2004

Authors and Affiliations

  • Harald Kosch
    • 1
  • Ahmed Mostefaoui
    • 2
  • László Böszörményi
    • 3
  • Lionel Brunie
    • 4
  1. 1.Institute of Information TechnologyUniversity KlagenfurtAustria
  2. 2.Computer Science Lab Franche-ComtéUniversity of MontbéliardFrance
  3. 3.Institute of Information TechnologyUniversity KlagenfurtAustria
  4. 4.Information Systems Engineering Laboratory, National Institute of Applied SciencesLyonFrance

Personalised recommendations