Abstract
Existing multi-tenant database schema design studies either emphasize high performance and scalability at the expense of limited customization or provide enough customization at the cost of low performance and scalability. In this paper, we propose a cluster based schema design for multi-tenant database which supports full customization without sacrificing performance and scalability. We devise the hierarchical agglomerative clustering algorithm and multi-tenancy integration algorithm to integrate the customized schemas based on the schema and instance information. Our method can be easily applied to existing databases with minor revisions. Experimental results show that our method achieves excellent performance and high scalability with schema customization property.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Aulbach, S., Grust, T., Jacobs, D., Kemper, A., Rittinger, J.: Multi-tenant databases for software as a service: schema-mapping techniques. In: SIGMOD Conference, pp. 1195–1206 (2008)
Aulbach, S., Seibold, M., Jacobs, D., Kemper, A.: Extensibility and data sharing in evolving multi-tenant databases. In: ICDE, pp. 99–110 (2011)
Li, W.-S., Clifton, C.: Semantic integration in heterogeneous databases using neural networks. In: VLDB, pp. 1–12 (1994)
Ni, J., Li, G., Zhang, J., Li, L., Feng, J.: Adapt: adaptive database schema design for multi-tenant applications. In: CIKM, pp. 2199–2203 (2012)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2014 Springer International Publishing Switzerland
About this paper
Cite this paper
Ni, J., Feng, J. (2014). A Cluster Based Schema Design for Multi-tenant Database. In: Li, F., Li, G., Hwang, Sw., Yao, B., Zhang, Z. (eds) Web-Age Information Management. WAIM 2014. Lecture Notes in Computer Science, vol 8485. Springer, Cham. https://doi.org/10.1007/978-3-319-08010-9_41
Download citation
DOI: https://doi.org/10.1007/978-3-319-08010-9_41
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-08009-3
Online ISBN: 978-3-319-08010-9
eBook Packages: Computer ScienceComputer Science (R0)