Abstract
The update transactions to be executed in spatial databases have been usually known as interactive and long duration works. When a spatial object has a very large geometry of which size is larger than the screen window, it needs to concurrently update such a large spatial object for improving concurrency of updating spatial objects. Under the existing locking protocols, it is not allowed a large spatial object to be concurrently updated. We propose a partial locking scheme of allowing a transaction to set locks on parts of the large object. The partial locking scheme acquires a lock for part of the large object to allow several users to concurrently update the same object. The scheme gives benefits of improving the concurrency of updating a large object while maintaining the consistency of long duration transactions for interactively updating spatial data.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
Bernstein, P.A., Goodman, N.: An Algorithm for Concurrency Control and Recovery in Replicated Distributed Databases. ACM Tran. on Database Systems 4(9), 596–615 (1984)
Choi, J.O., Shin, Y.S., Hong, B.H.: Update Propagation of Replicated Data in Distributed Spatial Databases. In: Bench-Capon, T.J.M., Soda, G., Tjoa, A.M. (eds.) DEXA 1999. LNCS, vol. 1677, pp. 952–963. Springer, Heidelberg (1999)
Garza, J.F., Kim, W.: Transaction Management in an Object-Oriented Database System. In: Proc. of the 1988 ACM SIGMOD, pp. 37–45 (1988)
Gray, J., Helland, P., Shasha, D.: The Dangers of Replication and a Solution. In: Proc. of the 1996 ACM SIGMOD, pp. 173–182 (1996)
Kim, W., Banerjee, J., Chou, H.T., Garza, J.E., Woelk, D.: Composite Object support in an Object-Oriented Database Systems. In: Proc. 2nd Intl. Conf. on Object-Oriented Programming Systems, Languages, and Applications(OOPSLA), pp. 118–125 (1987)
Korth, H.F., Speegle, G.D.: Long-Duration Transaction in Software Design Projects. In: Proc. of Int. Conf. on Data Engineering, pp. 568–574 (1990)
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
Seo, Y., Kim, D., Hong, B. (2004). Concurrent Updating of Large Spatial Objects. In: Lee, Y., Li, J., Whang, KY., Lee, D. (eds) Database Systems for Advanced Applications. DASFAA 2004. Lecture Notes in Computer Science, vol 2973. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-24571-1_29
Download citation
DOI: https://doi.org/10.1007/978-3-540-24571-1_29
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-21047-4
Online ISBN: 978-3-540-24571-1
eBook Packages: Springer Book Archive