Encyclopedia of Database Systems

2018 Edition
| Editors: Ling Liu, M. Tamer Özsu

Multitenancy

  • Aaron J. Elmore
Reference work entry
DOI: https://doi.org/10.1007/978-1-4614-8265-9_80639

Synonyms

Database-as-a-service; Database multi-tenancy; Multitenant databases

Definition

Database multitenancy is the ability for a database system to efficiently host multiple applications’ data within a single logical database service. Here, each hosted application is referred to as a tenantin the system. As tenants are distinct applications, each tenant’s data and performance must be isolated from each other. A multitenant database system is composed of one or more database servers that are multiplexed to host multiple tenants. Different techniques, or multitenancy models, exist to multiplex a database server and differ in how they isolate tenants from each other. Sample techniques include the use of multiple virtual machines, multiple schemas within a shared process, or collocating tenants’ data within shared tables. Each multitenancy model exhibits trade-offs between tenant isolation, the maximum level of tenants per server (i.e., tenant consolidation), functionality, and...

This is a preview of subscription content, log in to check access.

Recommended Reading

  1. 1.
    Aulbach S, Grust T, Jacobs D, Kemper A, Rittinger J. Multi-tenant databases for software as a service: schema-mapping techniques. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 2008. p. 1195–206.Google Scholar
  2. 2.
    Bernstein PA, Cseri I, Dani N, Ellis N, Kalhan A, Kakivaya G, Lomet DB, Manne R, Novik L, Talius T. Adapting microsoft SQL server for cloud computing. In: Proceedings of the 27th International Conference on Data Engineering; 2011. p. 1255–63.Google Scholar
  3. 3.
    Curino C, Jones EPC, Madden S, Balakrishnan H. Workload-aware database monitoring and consolidation. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 2011. p. 313–24.Google Scholar
  4. 4.
    Curino C, Jones EPC, Popa RA, Malviya N, Wu E, Madden S, Balakrishnan H, Zeldovich N. Relational cloud: a database service for the cloud. In: Proceedings of the 5th Biennial Conference on Innovative Data Systems Research; 2011. p. 235–40.Google Scholar
  5. 5.
    Elmore AJ, Das S, Pucher A, Agrawal D, El Abbadi A, Yan X. Characterizing tenant behavior for placement and crisis mitigation in multitenant DBMSs. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 2013. p. 517–28.Google Scholar
  6. 6.
    Narasayya VR, Das S, Syamala M, Chandramouli B, Chaudhuri S. SQLVM: performance isolation in multi-tenant relational database-as-a-service. In: Proceedings of the 6th Biennial Conference on Innovative Data Systems Research; 2013.Google Scholar
  7. 7.
    Schaffner J, Januschowski T, Kercher M, Kraska T, Plattner H, Franklin MJ, Jacobs D. RTP: robust tenant placement for elastic in-memory database clusters. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 2013. p. 773–84.Google Scholar
  8. 8.
    Weissman CD, Bobrowski S. The design of the force.com multitenant internet application development platform. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 2009. p. 889–96.Google Scholar
  9. 9.
    Xiong P, Chi Y, Zhu S, Moon HJ, Pu C, Hacigümüs H. Intelligent management of virtualized resources for database systems in cloud environment. In: Proceedings of the 27th International Conference on Data Engineering; 2011. p. 87–98.Google Scholar
  10. 10.
    Yang F, Shanmugasundaram J, Yerneni R. A scalable data platform for a large number of small applications. In: Proceedings of the 4th Biennial Conference on Innovative Data Systems Research; 2009.Google Scholar

Copyright information

© Springer Science+Business Media, LLC, part of Springer Nature 2018

Authors and Affiliations

  1. 1.Department of Computer ScienceUniversity of ChicagoChicagoUSA