Controlling concurrent accesses in multimedia databases for decision support

  • Authors:
  • Woochun Jun;Suk-ki Hong

  • Affiliations:
  • Dept. of Computer Education, Seoul National University of Education, Seoul, Korea;Division of Business & Economics, Dankook University, Seoul, Korea

  • Venue:
  • PCM'04 Proceedings of the 5th Pacific Rim Conference on Advances in Multimedia Information Processing - Volume Part II
  • Year:
  • 2004

Quantified Score

Hi-index 0.00

Visualization

Abstract

The decision support processing is essential in multimedia databases since it reveals valuable information from tremendous hidden data. In decision support environments, most transactions have long-term read operations accessing significant portions of database. In this sense, the traditional concurrency control schemes that are tuned to online transaction processing (OLTP) are not suitable for decision supporting environments since long transactions may cause serious locking overhead. In this paper, a locking-based concurrency control scheme is presented for decision support environments in multimedia databases. In this work, transactions are classified into two groups, the typical OLTP transaction and query transaction that is composed of read operation for decision support. Assuming that query transactions read considerable portions of whole database, the proposed scheme incurs less locking overhead than the existing scheme called explicit locking. This paper also proves that the proposed scheme performs better than the existing scheme.