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.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
Bernstein, P., Hadzilacos, V., Goodman, N.: Concurrency Control and Recovery in Database Systems. Addison-Wesley, Reading (1987)
Cart, M., Ferrie, J.: Integrating Concurrency Control into an Object-Oriented Database System. In: 2nd Int. Conf. on Extending Data Base Technology, Venice, Italy, March 1990, pp. 363–377 (1990)
Durham, M.: Data Mining. Prentice-Hall, Upper Saddle River (2003)
Garza, J., Kim, W.: Transaction Management in an Object-Oriented Database System. In: ACM SIGMOD Int. Conf. on Management of Data, Chicago, Illinois, June 1988, pp. 37–45 (1988)
Han, J., Kamber, M.: Data Mining: Concepts and Techniques. Morgan-Kaufmann Press, San Francisco (2001)
Jun, W., Gruenwald, L.: An Optimal Locking Scheme in Object-Oriented Database Systems. In: Lu, H., Zhou, A. (eds.) WAIM 2000. LNCS, vol. 1846, pp. 95–105. Springer, Heidelberg (2000)
Khoshafian, S., Dasananda, S., Minassian, M.: The Jasmine Object Database: Multimedia Applications for the Web. Morgan-Kaufmann Publishers, Inc., San Francisco (1999)
Kim, H., Park, S.: Two Version Concurrency Control Algorithm with Query Locking for Decision Support. In: Kambayashi, Y., Lee, D.-L., Lim, E.-p., Mohania, M., Masunaga, Y. (eds.) ER Workshops 1998. LNCS, vol. 1552, pp. 157–168. Springer, Heidelberg (1998)
Lee, L., Liou, R.: A Multi-Granularity Locking Model for Concurrency Control in Object-Oriented Database Systems. IEEE Trans. on Knowledge and Data Engineering 8(1), 144–156 (1996)
Malta, C., Martinez, J.: Automating Fine Concurrency Control in Object-Oriented Databases. In: 9th IEEE Conf. on Data Engineering, Vienna, Austria, April 1993, pp. 253–260 (1993)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2004 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Jun, W., Hong, Sk. (2004). Controlling Concurrent Accesses in Multimedia Databases for Decision Support. In: Aizawa, K., Nakamura, Y., Satoh, S. (eds) Advances in Multimedia Information Processing - PCM 2004. PCM 2004. Lecture Notes in Computer Science, vol 3332. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-30542-2_23
Download citation
DOI: https://doi.org/10.1007/978-3-540-30542-2_23
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-23977-2
Online ISBN: 978-3-540-30542-2
eBook Packages: Computer ScienceComputer Science (R0)