Skip to main content
SpringerLink
Log in

Multitenancy

  • Reference work entry
  • First Online:
Encyclopedia of Database Systems

  • 47 Accesses

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 via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 4,499.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Hardcover Book
USD 6,499.99
Price excludes VAT (USA)
  • Durable hardcover edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Recommended Reading

  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. 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. 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. 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. 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. 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. 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. 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. 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. 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 

Download references

Author information

Authors and Affiliations

  1. Department of Computer Science, University of Chicago, Chicago, IL, USA

    Aaron J. Elmore

Authors
  1. Aaron J. Elmore
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Aaron J. Elmore .

Editor information

Editors and Affiliations

  1. Georgia Institute of Technology College of Computing, Atlanta, GA, USA

    Ling Liu

  2. University of Waterloo School of Computer Science, Waterloo, ON, Canada

    M. Tamer Özsu

Rights and permissions

Reprints and permissions

Copyright information

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

About this entry

Check for updates. Verify currency and authenticity via CrossMark

Cite this entry

Elmore, A.J. (2018). Multitenancy. In: Liu, L., Özsu, M.T. (eds) Encyclopedia of Database Systems. Springer, New York, NY. https://doi.org/10.1007/978-1-4614-8265-9_80639

Download citation

Publish with us

Policies and ethics

Search

Navigation