Implementing a Storage Pattern in the OR Mapping Framework

Khan, Muhammad Naeem; Shahid, Arsalan; Shafqat, Sarah

doi:10.14257/ijgdc.2013.6.5.03

Cited by 7 publications

(3 citation statements)

References 11 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…The three major approaches to manage data in multi-tenant databases are summarized in Table I, and discussed in detail in [3] [4]. In addition to, there are several multi-tenant database schema mapping techniques ware presented in [5], [6], the majority of these techniques are derived from the three major approaches of managing data in multi-tenant databases, in order to create a logical isolated database schema for every tenant in multi-tenant databases.…”

Section: Related Workmentioning

confidence: 99%

See 1 more Smart Citation

A Hybrid Multi-Tenant Database Schema for Multi-Level Quality of Service

Saleh¹,

Fouad²,

Abu-Elkheir³

2014

ijacsa

View full text Add to dashboard Cite

Abstract-Software as a Service (SaaS) providers can serve hundreds of thousands of customers using sharable resources to reduce costs. Multi-tenancy architecture allows SaaS providers to run a single application and a database instance, which support multiple tenants with various business needs and priorities. Until now, the database management systems (DBMSs) have not had the notion of multi-tenancy, and they have not been equipped to handle customization or scalability requirements, that are typical in multi-tenant applications. The multi-tenant database performance should adapt to tenants workloads and fit their special requirements. In this paper, we propose a new multitenant database schema design approach, that adapts to multitenant application requirements, in addition to tenants needs of data security, isolation, queries performance and response time speed. Our proposed methodology provides a trade-off between the performance and the storage space. This proposal caters for the diversity in tenants via defining multi-level quality of service for the different types of tenants, depending on tenant rate and system rate. The proposal presents a new technique to distribute data in a multi-tenant database horizontally to a set of allotment tables using an isolation point, and vertically to a set of extension tables using a merger point. Finally, we present a prototype implementation of our method using a real-world case study, showing that the proposed solution can achieve high scalability and increase performance for tenants who need speedy performance and economize storage space for tenants who do not have demanding quality of service.

show abstract

Section: Related Workmentioning

confidence: 99%

“…The shared tables schema is referred to as "pure multitenancy" in [4] [11]. By the same token, we depend mainly on this approach in our system, in addition to using some metrics to separate extensions tables, to get the desired performance for some tenants, who have a high workload.…”

Section: A Flexible Multi-tenant Database Schema Overviewmentioning

confidence: 99%

A Hybrid Multi-Tenant Database Schema for Multi-Level Quality of Service

Saleh¹,

Fouad²,

Abu-Elkheir³

2014

ijacsa

View full text Add to dashboard Cite

show abstract

“…Shahzad et al, [19] use database support for protection against zero-day malware attacks. Khan et al, [20] implemented storage pattern in the OR mapping framework, and Ali and Khan [21] proposed an ICT infrastructure framework for microfinance institutions. Shehzad and Khan [22] looked into the methods for integrating knowledge management with business intelligence processes.…”

Section: Literature Reviewmentioning

confidence: 99%