Skip to main content
SpringerLink
Log in

A Proxy Service for Multi-tenant Elastic Extension Tables

  • Chapter
  • First Online:
Transactions on Large-Scale Data- and Knowledge-Centered Systems XX

Part of the book series: Lecture Notes in Computer Science ((TLDKS,volume 9070))

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.

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 39.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight 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

References

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

    Google Scholar 

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

    Google Scholar 

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

    Google Scholar 

  4. Bobrowski, S.: Optimal multitenant designs for cloud apps. In: 4th International Conference on Cloud Computing, pp. 654–659. IEEE Press, Washington (2012)

    Google Scholar 

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

    Google Scholar 

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

    Google Scholar 

  7. Dimovski, D.: Database management as a cloud-based service for small and medium organizations. Master Thesis, Masaryk University Brno (2013)

    Google Scholar 

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

    Google Scholar 

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

    Google Scholar 

  10. Force.com. http://www.salesforce.com/us/developer/docs/soql_sosl/salesforce_soql_sosl.pdf

  11. Google Developers. https://developers.google.com/appengine/docs/python/datastore/overview#Comparison_with_Traditional_Databases

  12. Heng, L., Dan, Y., Xiaohong, Z.: Survey on multi-tenant data architecture for SaaS. Int. J. Comput. Sci. Issues(IJCSI) 9(6) (2012)

    Google Scholar 

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

    Google Scholar 

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

    Google Scholar 

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

    Google Scholar 

  16. Liu, G.: Research on independent SaaS platform. In: Information Management and Engineering, pp. 110–113. IEEE, Chengdu (2010)

    Google Scholar 

  17. Martinez, C.G.: Study of Resource Management for Multitenant Database Systems in Cloud Computing. Doctoral Thesis, University of Colorado (2012)

    Google Scholar 

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

    Google Scholar 

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

    Google Scholar 

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

    Google Scholar 

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

    Google Scholar 

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

    Google Scholar 

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

    Google Scholar 

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

    Google Scholar 

Download references

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

  1. Centre for Quantum Computation and Intelligent Systems, University of Technology Sydney, P.O. Box 123, Broadway, NSW, 2007, Australia

    Haitham Yaish & Madhu Goyal

  2. Faculty of Engineering and Information Technology, University of Technology Sydney, P.O. Box 123, Broadway, NSW, 2007, Australia

    Haitham Yaish, Madhu Goyal & George Feuerlicht

  3. Unicorn College, Prague, Czech Republic

    George Feuerlicht

  4. University of Economics, Prague, Czech Republic

    George Feuerlicht

Authors
  1. Haitham Yaish
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Madhu Goyal
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. George Feuerlicht
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Haitham Yaish .

Editor information

Editors and Affiliations

  1. IRIT, Paul Sabatier University, Toulouse, France

    Abdelkader Hameurlain

  2. FAW, University of Linz, Linz, Austria

    Josef Küng

  3. FAW, University of Linz, Linz, Austria

    Roland Wagner

  4. King Saud bin Abdulaziz University for Health Sciences, Riyadh, Saudi Arabia

    Sherif Sakr

  5. Chinese Academy of Sciences, Beijing, China

    Lizhe Wang

  6. The University of Sydney, Sydney, Australia

    Albert Zomaya

Rights and permissions

Reprints 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)

Publish with us

Policies and ethics

Search

Navigation