Research on Semi-Structured and Unstructured Data Storage and Management Model for Multi-Tenant

Research on Semi-Structured and Unstructured Data Storage and Management Model for Multi-Tenant

Xin Hu, Yabin Xu
Copyright: © 2019 |Pages: 14
DOI: 10.4018/JITR.2019010104
(Individual Articles)
No Current Special Offers


In order to solve the problem of data isolation and storage caused by the growth of semi-structured and unstructured data in SaaS mode, the multiple-universal table data storage and management model based on XML is proposed. XML management technology is introduced into the model, and using it to improve and optimize the multiple-universal table data storage model, and the model can effectively solve the problem of storage and management of semi-structured and unstructured data. Comparative experimental results show that, the method has high storage density and access rate, can be very good to meet the customized demand for multi-tenant data.
Article Preview

At present, many domestic and foreign scholars have done a lot of research work on the SaaS multi-tenant data storage and management, and the representative research results are as follows.

Frederick Chong et al. (2006) as early as 2006 put forward three kinds of data sharing approaches which are the separate databases model, the shared database separate schemas model, and the shared database shared schemas model. The shared database shared schemas model can reflect that the SaaS application is based on the characteristics of sharing to achieve customization.

Waters (2006) and Aulbach et al. (2008) proposed a private table storage mode. The scheme allocates private table for each tenant and stores all the data for the tenant. This approach has good isolation and security, but if the number of tenants is too large, it will produce too much redundant data, resulting in low efficiency and waste of resources.

Greg Gianforte (2005) presented an Extension table storage mode. In this storage scheme, a large number of data were extracted, and then placed in a shared base table, while the tenant's own custom data stored in an extension of the table, the two table are connected through the tenant key (Tenant ID) to connect. This scheme can effectively reduce data redundancy, and save more space. But due to the use of the extended table, when we need to implement the operation involving customized data, it is bound to be a multi table joint, this will lead to low efficiency.

The storage method of Universal table proposed by Craig D Weissman (2009) is a data sharing storage structure based on the metadata-driven, the core thought is to place all the tenants' data in a large universal table for shared storage. Because we need to store data for all tenants, so the number of columns of universal table should be greater than the number of columns of the tenant with the largest number of attributes. The parts of the custom differences between tenants are set to null values, namely, the field which is not required for the tenant is set to null. The custom operation in this scheme does not require multiple tables, but because the number of table columns cannot be predicted, the space left out will lead to the waste of storage space, and be detrimental to the extendibility.

Complete Article List

Search this Journal:
Volume 16: 1 Issue (2023): Forthcoming, Available for Pre-Order
Volume 15: 6 Issues (2022): 1 Released, 5 Forthcoming
Volume 14: 4 Issues (2021)
Volume 13: 4 Issues (2020)
Volume 12: 4 Issues (2019)
Volume 11: 4 Issues (2018)
Volume 10: 4 Issues (2017)
Volume 9: 4 Issues (2016)
Volume 8: 4 Issues (2015)
Volume 7: 4 Issues (2014)
Volume 6: 4 Issues (2013)
Volume 5: 4 Issues (2012)
Volume 4: 4 Issues (2011)
Volume 3: 4 Issues (2010)
Volume 2: 4 Issues (2009)
Volume 1: 4 Issues (2008)
View Complete Journal Contents Listing