Abstract
For SaaS applications which multiple tenants share sparse tables, fields of varying data types are stored in one flex column based on customization. Thus it is not practical to create native physical indices for tenants. In this paper, we put forward an indexing model for sparse table storage model based on pivot tables in multi-node environments. The core idea is copying field data to be indexed to another table and creating physical indices in that table. This model supports customization and isolation characteristics of multitenant applications, and provides load balance means in index subsystem, and controls the number of index data tables thus memory consuming reasonably.
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.
References
Weissman, C.D., Bobrowski, S.: The Design of the Force.com Multitenant Internet Application Development Platform. In: SIGMOD (2009)
Hui, M., Jiang, D., et al.: Supporting Database Applications as a Service. In: ICDE (2009)
Aulbach, S., Grust, T., Jacobs, D., Kemper, A., Rittinger, J.: Multi-Tenant Databases for Software as a Service: Schema-Mapping Techniques. In: SIGMOD (2008)
Aulbach, S., et al.: A Comparison of Flexible Schemas for SaaS. In: SIGMOD (2009)
wikipedia. Software as a service, http://en.wikipedia.org/wiki/Software_as_a_service
Wu, S., Jiang, D., Ooi, B.C., Wu, K.-L.: Efficient B-tree Based Indexing for Cloud Data Processing. PVLDB 3(1), 1207–1218 (2010)
Li, J., Zhang, S., Liu, Z., Kong, L.: A Data Rights Control Model for a SaaS Application Delivery Platform. In: Mao, E., Xu, L., Tian, W. (eds.) ECICE 2012. AISC, vol. 146, pp. 139–146. Springer, Heidelberg (2012)
Beckmann, J.L., Halverson, A., Krishnamurthy, R., Naughton, J.F.: Extending RDBMSs To Support Sparse Datasets Using An Interpreted Attribute Storage Format. In: ICDE (2006)
Chu, E., Beckmann, J., Naughton, J.: The Case for a Wide-Table Approach to Manage Sparse Relational Data Sets. In: SIGMOD (2007)
Chen, W., Zhang, S., Kong, L.: A Multiple Sparse Tables Approach for Multitenant Data Storage in SaaS. In: IIS (2010)
Lanju, K., et al.: A research on SaaS-oriented multitenant indexing model based on key-value pairs. Chinese Journal of Computers (2010)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2013 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Cheng, P., Qingzhong, L., Lanju, K. (2013). An Index Model for Multitenant Data Storage in SaaS. In: Wang, J., Xiong, H., Ishikawa, Y., Xu, J., Zhou, J. (eds) Web-Age Information Management. WAIM 2013. Lecture Notes in Computer Science, vol 7923. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-38562-9_43
Download citation
DOI: https://doi.org/10.1007/978-3-642-38562-9_43
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-38561-2
Online ISBN: 978-3-642-38562-9
eBook Packages: Computer ScienceComputer Science (R0)