Evaluating the performance of multi-tenant Elastic Extension Tables

Yaish, H; Goyal, M; Feuerlicht, G

Evaluating the performance of multi-tenant Elastic Extension Tables

Yaish, H Goyal, M

Feuerlicht, G

Permalink

Publication Type:: Conference Proceeding
Citation:: Procedia Computer Science, 2014, 29 pp. 614 - 626
Issue Date:: 2014-01-01

Closed Access

	Filename	Description	Size
	2013006729OK.pdf		801.08 kB	Adobe PDF	View/Open

Copyright Clearance Process

Recently Added
In Progress
Closed Access

This item is closed access and not available.

Full metadata record

Field	Value	Language
dc.contributor.author	Yaish, H	en_US
dc.contributor.author	Goyal, M https://orcid.org/0000-0003-2853-9393	en_US
dc.contributor.author	Feuerlicht, G	en_US
dc.date.issued	2014-01-01	en_US
dc.identifier.citation	Procedia Computer Science, 2014, 29 pp. 614 - 626	en_US
dc.identifier.issn	1877-0509	en_US
dc.identifier.uri	http://hdl.handle.net/10453/29573
dc.identifier.uri	http://hdl.handle.net/10453/30440
dc.description.abstract	An important challenge in the design of databases that support multi-tenant applications is to provide a platform to manage large volumes of data collected from different businesses, social media networks, emails, news, online texts, documents, and other data sources. To overcome this challenge we proposed in our previous work a multi-tenant database schema called Elastic Extension Tables (EET) that combines multi-tenant relational tables and virtual relational tables in a single database schema. Using this approach, the tenants' tables can be extended to support the requirements of individual tenants. In this paper, we discuss the potentials of using EET multi-tenant database schema, and show how it can be used for managing physical and virtual relational data. We perform several experiments to measure the feasibility and effectiveness of EET by comparing it with a commercially availab le multi-tenant schema mapping technique used by SalesForce.com. We report significant performance improvements obtained using EET when compared to Universal Table Schema Mapping (UTSM), making the EET schema a good candidate for the management of multitenant data in Software as a Service (SaaS) and Big Data applications. © The Authors. Published by Elsevier B.V.	en_US
dc.relation.ispartof	Procedia Computer Science	en_US
dc.relation.isbasedon	10.1016/j.procs.2014.05.055	en_US
dc.title	Evaluating the performance of multi-tenant Elastic Extension Tables	en_US
dc.type	Conference Proceeding
utslib.citation.volume	29	en_US
utslib.for	0804 Data Format	en_US
utslib.for	08 Information and Computing Sciences	en_US
utslib.for	10 Technology	en_US
dc.location.activity	Cairns - Australia	en_US
pubs.embargo.period	Not known	en_US
pubs.organisational-group	/University of Technology Sydney
pubs.organisational-group	/University of Technology Sydney/Faculty of Engineering and Information Technology
pubs.organisational-group	/University of Technology Sydney/Faculty of Engineering and Information Technology/School of Computer Science
pubs.organisational-group	/University of Technology Sydney/Strength - CAI - Centre for Artificial Intelligence
pubs.organisational-group	/University of Technology Sydney/Strength - HCTD - Human Centred Technology Design
utslib.copyright.status	closed_access
pubs.publication-status	Published	en_US
pubs.volume	29	en_US

Abstract:

An important challenge in the design of databases that support multi-tenant applications is to provide a platform to manage large volumes of data collected from different businesses, social media networks, emails, news, online texts, documents, and other data sources. To overcome this challenge we proposed in our previous work a multi-tenant database schema called Elastic Extension Tables (EET) that combines multi-tenant relational tables and virtual relational tables in a single database schema. Using this approach, the tenants' tables can be extended to support the requirements of individual tenants. In this paper, we discuss the potentials of using EET multi-tenant database schema, and show how it can be used for managing physical and virtual relational data. We perform several experiments to measure the feasibility and effectiveness of EET by comparing it with a commercially availab le multi-tenant schema mapping technique used by SalesForce.com. We report significant performance improvements obtained using EET when compared to Universal Table Schema Mapping (UTSM), making the EET schema a good candidate for the management of multitenant data in Software as a Service (SaaS) and Big Data applications. © The Authors. Published by Elsevier B.V.

Please use this identifier to cite or link to this item:

http://hdl.handle.net/10453/29573