<abstract xmlns="http://www.w3.org/1999/xhtml"><p> Multi-tenant data management is an important part of supporting efficient operation of software as a service application. Multi-tenant data use shared schema to reduce resource usage cost. However, massive data of different tenants are stored in the same schema, which causes useless data of other tenants to be read when a tenant just need access its own disk data. In this paper we focus on disk storage method of multi-tenant data based on shared schema to address the above low efficiency of data access. According to isolation requirement of multitenant data, we store a tenant’s data in some contiguous disk blocks. The experimental results illustrate that query efficiency in range query and join query is 1.5–2 times the existing storage method, and no indexing query efficiency improves 10–70 times.</p></abstract>

Multi-tenant data management is an important part of supporting efficient operation of software as a service application. Multi-tenant data use shared schema to reduce resource usage cost. However, massive data of different tenants are stored in the same schema, which causes useless data of other tenants to be read when a tenant just need access its own disk data. In this paper we focus on disk storage method of multi-tenant data based on shared schema to address the above low efficiency of data access. According to isolation requirement of multitenant data, we store a tenant’s data in some contiguous disk blocks. The experimental results illustrate that query efficiency in range query and join query is 1.5–2 times the existing storage method, and no indexing query efficiency improves 10–70 times.

Isolated Storage of Multi-Tenant Data Based on Shared Schema

School of Computer Science and Technology, Shandong University, Jinan, Shandong, 250101 China

Cybernetics and Information Technologies

This work is licensed under the Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 License.

{"article-title":"Isolated Storage of Multi-Tenant Data Based on Shared Schema"}

Multi-tenant data management is an important part of supporting efficient operation of software as a service application. Multi-tenant data use shared schema...

Isolated Storage of Multi-Tenant Data Based on Shared Schema

Published Online: Aug 19, 2016

Page range: 91 - 103

DOI: https://doi.org/10.1515/cait-2016-0036

Keywords
Multi-tenant database, disk storage, shared schema, SaaS

© by Lida Zou

This work is licensed under the Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 License.

Isolated Storage of Multi-Tenant Data Based on Shared Schema

Published Online: Aug 19, 2016

Page range: 91 - 103

DOI: https://doi.org/10.1515/cait-2016-0036

KeywordsMulti-tenant database, disk storage, shared schema, SaaS

© by Lida Zou

This work is licensed under the Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 License.

Keywords
Multi-tenant database, disk storage, shared schema, SaaS