Abstract
SaaS-based multi-tenant application deployment model is becoming more popular as it is a more cost-effective way of deployment, quickly go online in less time. There are numerous technical or deployment issues/challenges needs to be addressed when applications are deployed in multi-tenant SaaS model, so that all tenants co-exist together and continue their operations smoothly without impacting their business operations. One of the complex and challenging design issues in multi-tenant SaaS application model is database design. When single database(shared schema with shared table) is shared among all the tenants it leads to complex database design. If all the tenants require different columns along with the core columns within the same table, it will become extremely difficult to design and maintain the database by itself. In this paper, we propose a JSON-based solution to address the complex database design for the multitenant SaaS model.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Chong, F., Carraro, G., Wolter, R.: Microsoft Corporation, “Multi-Tenant Data Architecture”. https://msdn.microsoft.com/enus/library/aa479086.aspx (2006). Accessed June 2006
Hudli, A.V., Shivaradhya, B., Hudli, R.V.: Level-4 SaaS applications for healthcareindustry. In: Proceedings of the 2nd Bangalore Annual Compute Conference, Bangalore, India, p. 19 (2009)
Gao, B., An, W.H., Sun, X., Wang, Z.H., Fan, L., Guo, C.J., Sun, W.: A non-intrusivemulti-tenant database software for large scale SaaS application. In: e-Business Engineering, Beijing, China, pp. 324–328 (2011)
Xia, C., Yu, G., Tang, M.: Efficient implement of ORM (object/relational mapping) usein J2EE framework: hibernate. In: Computational Intelligence and Software Engineering, pp. 1–3 (2009)
Liu, G.: Research on independent SaaS platform. In: Information Management and Engineering, Chengdu, China, pp. 110–113 (2010)
Chen, W., Shen, B., Qi, Z.: Template-based business logic customization for SaaS applications. In: Progress in Informatics and Computing, vol. 1, Shanghai, China, pp. 584–588 (2010)
Du, J., Wen, H.Y., Yang, Z.J.: Research on data layer structure of multi-tenant ecommerce system. In: 2010 IEEE 17th International Conference on Industrial Engineering and Engineering Management, Xiamen, pp. 362–365 (2010). https://doi.org/10.1109/icieem.2010.5646593
Yaish, H., Goyal, M.: A multi-tenant database architecture design for software applications. In: 2013 IEEE 16th International Conference on Computational Science and Engineering, Sydney, NSW, pp. 933–940 (2013). https://doi.org/10.1109/cse.2013.139
Yaish, H., Goyal, M., Feuerlicht, G.: An elastic multi-tenant database schema for software as a service. In: 2011 IEEE Ninth International Conference on Dependable, Autonomic and Secure Computing, Sydney, NSW, pp. 737–743 (2011). https://doi.org/10.1109/dasc.2011.127
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2018 Springer Nature Singapore Pte Ltd.
About this paper
Cite this paper
Raghu, R., Varma, N.S. (2018). JSON as ORM Mapping Database Layer for the SaaS-Based Multi-tenant Application. In: Sa, P., Bakshi, S., Hatzilygeroudis, I., Sahoo, M. (eds) Recent Findings in Intelligent Computing Techniques . Advances in Intelligent Systems and Computing, vol 709. Springer, Singapore. https://doi.org/10.1007/978-981-10-8633-5_30
Download citation
DOI: https://doi.org/10.1007/978-981-10-8633-5_30
Published:
Publisher Name: Springer, Singapore
Print ISBN: 978-981-10-8632-8
Online ISBN: 978-981-10-8633-5
eBook Packages: EngineeringEngineering (R0)