Abstract
An important challenge in the design of multi-tenant databases that support Software as a Service (SaaS) applications is providing a platform that manages multiple tenants’ data in single database storage. To address this challenge, we have previously proposed a multi-tenant database schema called Elastic Extension Tables (EET) that uses single shared database and shared schema for all tenants. In this paper, we extend this work with a multi-tenant database proxy service called Elastic Extension Tables Proxy Service (EETPS) that combines tenants’ relational tables with virtual relational tables into single database schema for each tenant. This service enables data access by calling functions in order to avoid writing SQL queries and backend data management code. It allows the tenants to focus on their core business and easily create SaaS, mobile, web, and desktop software applications. We present the EETPS algorithms and perform several experiments to assess their feasibility and effectiveness by comparing the performance of retrieving data from traditional physical tables, virtual tables, and integrated physical and virtual tables.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Similar content being viewed by others
References
Aulbach, S., Grust, T., Jacobs, D., Kemper, A., Rittinger, J.: Multitenant databases for software as a service: schema mapping techniques. In: Proceedings of the 34th SIGMOD International Conference on Management of Data, pp. 1195–1206. ACM, Vancouver (2008)
Aulbach, S., Grust, T., Jacobs, D., Kemper, A., Seibold, M.: A comparison of flexible schemas for software as a service. In: Proceedings of the 35th SIGMOD International Conference on Management of Data, pp. 881–888. ACM, Rhode Island (2009)
Bezemer, C., Zaidman, A.: Multi-tenant SaaS applications: maintenance dream or nightmare? In: Proceedings of the Joint Workshop on Software Evolution and International Workshop on Principles of Software Evolution, pp. 88–92. ACM, Antwerp (2010)
Bobrowski, S.: Optimal multitenant designs for cloud apps. In: 4th International Conference on Cloud Computing, pp. 654–659. IEEE Press, Washington (2012)
Demchenko, Y., Grosso, P., de Laat, C., Membrey, P.: Addressing big data issues in scientific data infrastructure. In: International Conference on Collaboration Technologies and Systems, pp. 48–55. IEEE, California (2013)
Domingo, E.J., Nino, J.T., Lemos, A.L., Lemos, M.L., Palacios, R.C., BerbĂs, J.M.G.: CLOUDIO: A cloud computing-oriented multi-tenant architecture for business information systems. In: 3rd International Conference on Cloud Computing, pp. 532–533. IEEE Press, Madrid (2010)
Dimovski, D.: Database management as a cloud-based service for small and medium organizations. Master Thesis, Masaryk University Brno (2013)
Du, J., Wen, H.Y., Yang, Z.J.: Research on data layer structure of multi-tenant e-commerce system. In: International Conference on Industrial Engineering and Engineering Management, Xiamen, pp. 362–365 (2010)
Foping, F.S., Dokas, I.M., Feehan, J., Imran, S.: A new hybrid schema-sharing technique for multitenant applications. In: Fourth International Conference on Digital Information Management, pp. 1–6. IEEE Press, Michigan (2009)
Force.com. http://www.salesforce.com/us/developer/docs/soql_sosl/salesforce_soql_sosl.pdf
Google Developers. https://developers.google.com/appengine/docs/python/datastore/overview#Comparison_with_Traditional_Databases
Heng, L., Dan, Y., Xiaohong, Z.: Survey on multi-tenant data architecture for SaaS. Int. J. Comput. Sci. Issues(IJCSI) 9(6) (2012)
Indrawan-Santiago, M.: Database research: are we at a crossroad? Reflection on NoSQL. In: 15th International Conference on Network-Based Information Systems, pp. 45–51. IEEE Press, Melbourne (2012)
Kwok, T., Nguyen, T., Lam, L.: A software as a service with multi-tenancy support for an electronic contract management application. In: International Conference on Services Computing, pp. 179–186. IEEE, Hawaii (2008)
Liao, C.F., Chen, K., Chen, J.J.: Toward a tenant-aware query rewriting engine for universal table schema-mapping. In: Cloud Computing Technology and Science, pp. 833–838. IEEE, Taipei (2012)
Liu, G.: Research on independent SaaS platform. In: Information Management and Engineering, pp. 110–113. IEEE, Chengdu (2010)
Martinez, C.G.: Study of Resource Management for Multitenant Database Systems in Cloud Computing. Doctoral Thesis, University of Colorado (2012)
Mietzner, R., Unger, T., Titze, R., Leymann, F.: Combining different multi-tenancy patterns in service-oriented applications. In: Enterprise Distributed Object Computing Conference, pp. 131–140. IEEE, Auckland (2009)
Mietzner, R., Metzger, A., Leymann, F., Pohl, K.: Variability modeling to support customization and deployment of multi-tenant-aware software as a service applications. In: ICSE Workshop on Principles of Engineering Service Oriented Systems, pp. 18–25. IEEE, Vancouver (2009)
Weissman C.D., Bobrowski S.: The design of the force.com multitenant internet application development platform. In: Proceedings of the 35th SIGMOD International Conference on Management of Data, pp. 889–896. ACM, Rhode Island (2009)
Yaish, H., Goyal, M., Feuerlicht, G.: An elastic multi-tenant database schema for software as a service. In: Ninth IEEE International Conference on Dependable, Autonomic and Secure Computing, pp. 737–743. IEEE, Sydney (2011)
Yaish, H., Goyal, M., Feuerlicht, G.: Multi-tenant database access control. In: International Conference on Computational Science and Engineering, pp. 870–877. IEEE, Sydney (2013)
Yaish, H., Goyal, M., Feuerlicht, G.: Evaluating the performance of multi-tenant elastic extension tables. In: The International Conference on Computational Science, pp. 614–626. Elsevier, Cairns (2014)
Yaish, H., Goyal, M., Feuerlicht, G.: Multi-tenant elastic extension tables data management. In: The International Conference on Computational Science, pp. 2168–2181. Elsevier, Cairns (2014)
Acknowledgments
All authors wish to acknowledge UTS FEIT Research Seed Fund 2014 for financial support, and George Feuerlicht wishes to acknowledge the support of GAÄŚR grant No. P403/11/0574.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2015 Springer-Verlag Berlin Heidelberg
About this chapter
Cite this chapter
Yaish, H., Goyal, M., Feuerlicht, G. (2015). A Proxy Service for Multi-tenant Elastic Extension Tables. In: Hameurlain, A., KĂĽng, J., Wagner, R., Sakr, S., Wang, L., Zomaya, A. (eds) Transactions on Large-Scale Data- and Knowledge-Centered Systems XX. Lecture Notes in Computer Science(), vol 9070. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-662-46703-9_1
Download citation
DOI: https://doi.org/10.1007/978-3-662-46703-9_1
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-662-46702-2
Online ISBN: 978-3-662-46703-9
eBook Packages: Computer ScienceComputer Science (R0)