VGL: Variable Granularity Lock Mechanism in the Shared Storage Multi-tenant Database

  • Chengliang Sang
  • Qingzhong Li
  • Zhengzheng Liu
  • Lanju Kong
Part of the Advances in Intelligent and Soft Computing book series (AINSC, volume 146)


Lock technology is important to ensure transaction isolation, but if multi-tenant database continues to use traditional fixed granularity database lock, it will bear a very high burden. In this paper, to satisfy requirements in the shared storage multi-tenant database, we propose variable granularity lock (VGL) mechanism. It provides a lock of one granularity for each tenant who uses the shared storage multi-tenant database. In addition, we give experiments indicating that the performance of VGL is excellent.


VGL Transaction Multi-tenant Database Concurrency Isolation 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Jacobs, D., Aulbach, S.: Ruminations on multi-tenant databases. In: BTW, pp. 514–521Google Scholar
  2. 2.
    Chong, F., Carraro, G., Wolter, R.: Multi-tenant Data Architecture. Microsoft Corporation (2006)Google Scholar
  3. 3.
    Aulbach, S., Grust, T., Jacobs, D., Kemper, A., Rittinger, J.: Multi-Tenant Databases for Software as a Service:Schema-Mapping Techniques. In: SIGMOD (2008)Google Scholar
  4. 4.
    Das, S., Agarwal, S., Agrawal, D., El Abbadi, A.: ElasTraS: An Elastic, Scalable, and Self Managing Transactional Database for the Cloud. Technical Report 2010-04, CS, UCSB (2010),
  5. 5.
    Das, S., Agrawal, D., El Abbadi, A.: G-Store: A Scalable Data Store for Transactional Multi key Access in the Cloud. In: ACM SoCC, March 11, pp. 163–174 (2010)Google Scholar
  6. 6.
    Curino, C., Jones, E.P.C., Popa, R.A., Malviya, N.: Relational Cloud: A Database-as-a-Service for the Cloud. In: CIDR (2011)Google Scholar
  7. 7.
    Bernstein, P.A., Newcomer, E.: Princples of Transaction Processing, 2nd edn.Google Scholar
  8. 8.
    Olson, M.A., Bostic, K., Seltzer, M.: Berkeley DB. In: Proceedings of the FREENIX Track: USENIX Annual Technical Conference (1999)Google Scholar
  9. 9.
  10. 10.
  11. 11.
    Rosen, K.H.: Discrete Mathematics and Its Applications, 6th edn.Google Scholar

Copyright information

© Springer-Verlag GmbH Berlin Heidelberg 2012

Authors and Affiliations

  • Chengliang Sang
    • 1
  • Qingzhong Li
    • 1
  • Zhengzheng Liu
    • 2
  • Lanju Kong
    • 1
  1. 1.Computer Science and Technology DepartmentShandong UniversityJinanP.R. China
  2. 2.Dareway Computer Software Co., LtdJinanP.R. China

Personalised recommendations