A multi-tenant database architecture design for software applications

Yaish, H; Goyal, M

A multi-tenant database architecture design for software applications

Yaish, H Goyal, M

Permalink

Publication Type:: Conference Proceeding
Citation:: Proceedings - 16th IEEE International Conference on Computational Science and Engineering, CSE 2013, 2013, pp. 933 - 940
Issue Date:: 2013-12-01

Closed Access

	Filename	Description	Size
	2013002272OK.pdf		374.16 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.date.issued	2013-12-01	en_US
dc.identifier.citation	Proceedings - 16th IEEE International Conference on Computational Science and Engineering, CSE 2013, 2013, pp. 933 - 940	en_US
dc.identifier.uri	http://hdl.handle.net/10453/27202
dc.description.abstract	Multi-tenant database is a new cloud computing paradigm that has recently attracted attention to deliver database functionalities for multiple tenants to create, store, and access their databases over the internet. This multi-tenant database should be highly configurable and secure to meet tenants' expectations and their different business requirements. In this paper, we propose an architecture design to build an intermediate database layer to be used between software applications and Relational Database Management Systems (RDBMS) to store and access multiple tenants' data in the Elastic Extension Table (EET) multi-tenant database schema. This database layer combines multi-tenant relational tables and virtual relational tables and makes them work together to act as one database for each tenant. This architecture design is suitable for multi-tenant database environment that can run any business domain database by using a combination of a database schema, which contains shared physical structured tables and virtual structured tenant's tables. Further, this multi-tenant database architecture design can be used as a base to build software applications in general and Software as a Service (SaaS) applications in particular. © 2013 IEEE.	en_US
dc.relation.ispartof	Proceedings - 16th IEEE International Conference on Computational Science and Engineering, CSE 2013	en_US
dc.relation.isbasedon	10.1109/CSE.2013.139	en_US
dc.title	A multi-tenant database architecture design for software applications	en_US
dc.type	Conference Proceeding
utslib.for	0806 Information Systems	en_US
dc.location.activity	Sydney, 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
utslib.copyright.status	closed_access
pubs.publication-status	Published	en_US

Abstract:

Multi-tenant database is a new cloud computing paradigm that has recently attracted attention to deliver database functionalities for multiple tenants to create, store, and access their databases over the internet. This multi-tenant database should be highly configurable and secure to meet tenants' expectations and their different business requirements. In this paper, we propose an architecture design to build an intermediate database layer to be used between software applications and Relational Database Management Systems (RDBMS) to store and access multiple tenants' data in the Elastic Extension Table (EET) multi-tenant database schema. This database layer combines multi-tenant relational tables and virtual relational tables and makes them work together to act as one database for each tenant. This architecture design is suitable for multi-tenant database environment that can run any business domain database by using a combination of a database schema, which contains shared physical structured tables and virtual structured tenant's tables. Further, this multi-tenant database architecture design can be used as a base to build software applications in general and Software as a Service (SaaS) applications in particular. © 2013 IEEE.

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

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