Multi-tenant Data Authentication Model for SaaS

Abstract

Abstract:In SaaS, most tenants rely on the service provider for data maintenance and computation. As tenants no longer possess their application and data locally, it is of critical importance for the tenants to ensure that their data are being correctly stored and maintained. However, the customized multi-tenants sharing storage mode makes it hard for tenants to guarantee their data integrity because multiple tenants' data is stored in one physical universal table and different data types may be stored into a flex column based on tenants' customization. Meanwhile to ensure performances of query, adequate pivot table is set up. These introduce new challenges to data integrity protection for tenants. This paper presents a review of the state of the art solutions and recent patents in the fields of data authentication, and puts forward a multitenant data authentication model (MTDA). MTDA is a composite structure that constructs pivot authentication tree (PAT) on the pivot table and combines it with signature set (S-set) built on universal table to ensure that malicious insiders can't modify the data in pivot table and universal table. The main contribution of MTDA is it can guarantee the tenant query result in one tree travels and return the verification object, corresponding to the result on pivot table and universal table. We demonstrate effectiveness of our model compared with direct adoption of the MB tree based approaches on pivot table and universal table through the experiment. MTDA shows a better performance on VO verification.

A native enhanced elastic extension tables multi-tenant database

“…The Selection operation is shown in Figure 7. The result shows that the execution time of the of NXD-E 3 T is approximately the same as the average of the execution time E 3 T even after the number of records increases the same time is taken in each method.…”

“…This cloud software approached is called software as a service (SaaS). SaaS is capable of presenting a single configurable software and computing environment for multiple tenants [2,3]. SaaS applications are deployed as hosted services and accessed from everywhere over the web.…”

“…The remainder of this paper is structured as follows. Section 2 reviews the background for multi-tenancy main approaches and the related work of multi-tenancy database techniques, section 3 describes the proposed Schema for NXD-E 3 proposes the results for the performance of our proposed method. Finally, section 5 concludes this paper and describes future work.…”

“…The UniversalTable is a table thatcontains extra columns of the basics application schema columns, which permits tenants to store their needed columns side by side. Storing such a dataset can potentially lower its performance due to the high number of NULL values it may contain.In Pivot Tables, each column of each row in a logical source table is converted to its record in the Pivot Table[3,16]. The rows in the Pivot Table represented by four columns: 'tenant_id', 'table_id', 'col', and 'row' which are used to identify each row in the logical source table.…”