Abstract
Multi-tenant database is a new cloud computing paradigm that has recently attracted attention to deliver database functionalities for multiple database users to create, store, and access their databases over the internet. However, such approach raises an issue in database performance, due to the fact that the multi-tenant database is shared between multiple tenants. Therefore, this contemporary database requires a special query method to optimize different query retrievals for multiple tenants who are using the same resources of a single multi-tenant database. In this paper, we are proposing a multi-tenant query optimization method based on multi-tenant database schema called Elastic Extension Tables (EET). This method estimates the cost of different query execution plans, to determine the optimal plan. Then uses this plan to execute a tenant’s query by using a code base solution that converts multi-tenant queries into traditional database queries and executes them by using a query optimizer of any Relational Database Management System (RDBMS).
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
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
Alzain, M.A., Pardede, E.: Using Multi Shares for Ensuring Privacy in Database-as-a-Service. In: System Sciences, pp. 1–9. IEEE Press, Hawaii (2011)
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)
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)
Dash, D., Alagiannis, I., Maier, C., Ailamaki, A.: Caching All Plans With Just One Optimizer Call. In: Data Engineering Workshops, pp. 105–110. IEEE Press, California (2010)
Du, J., Wen, H.Y., Yang, Z.J.: Research on Data Layer Structure of Multitenant E-commerce System. In: IEEE 17th International Conference on Industrial Engineering and Engineering Management, pp. 362–365, Xiamen (2010)
Elmore, A.J., Das, S., Agrawal, D., El Abbadi, A.: Towards an Elastic and Autonomic Multitenant Database. In: Proceedings of NetDB Workshop, Athens (2011)
Farahani, M.G., Sharifnejad, M., Shari, M.: An Enhanced Tuple Routing Strategy for Adaptive Processing of Continuous Queries. Journal of Information and Communication Technologies, 3146–3150 (2006)
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)
Gao, B., An, W., Sun, X., Wang, Z.H., Fan, L., Guo, C.J., Sun, W.: A Non-intrusive Multi-tenant Database Software for Large Scale SaaS Application. In: e-Business Engineering, pp. 324–328. IEEE Press, Beijing (2011)
Hacig, H., Iyer, B., Li, C., Mehrotra, S.: Executing SQL Over Encrypted Data in the Database-service-provider Model. In: SIGMOD, pp. 216–227. ACM, Madison (2002)
Mateljan, V., Cisic, D., Ogrizovic, D.: Cloud Database-as-a-Service (DaaS) - ROI. In: Proceedings of the 33rd International Convention, pp. 1185–1188. IEEE Press, Opatija (2010)
Raza, B., Mateen, A., Sher, M., Awais, M.M., Hussain, T.: Autonomic View of Query Optimizers in Database Management Systems. In: Software Engineering Research, Management and Applications, pp. 3–8. IEEE Press, Montreal (2010)
Wang, Z.H., Guo, C.J., Gao, B., Sun, W., Zhang, Z., An, W.: A Study and Performance Evaluation of The Multi-tenant Data Tier Design Patterns for Service Oriented Computing. In: e-Business Engineering, pp. 94–101. IEEE Press, Xi’an (2008)
Weissman, C., Moellenhoff, D., Wong, S., Nakada, P.: Multi-tenant Database System. U.S.Patent 8,280,874 (October 2, 2012)
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 Press, Sydney (2011)
Yaish, H., Goyal, M., Feuerlicht, G.: Proxy Service for Multi-tenant Database Access. In: The International Cross Domain Conference and Workshop, pp. 101–117, Regensburg (2013)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2014 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Yaish, H., Goyal, M., Feuerlicht, G. (2014). A Method of Optimizing Multi-tenant Database Query Access. In: Huang, Z., Liu, C., He, J., Huang, G. (eds) Web Information Systems Engineering – WISE 2013 Workshops. WISE 2013. Lecture Notes in Computer Science, vol 8182. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-54370-8_17
Download citation
DOI: https://doi.org/10.1007/978-3-642-54370-8_17
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-54369-2
Online ISBN: 978-3-642-54370-8
eBook Packages: Computer ScienceComputer Science (R0)