Optimizing multi-tenant database architecture for efficient
software as a service delivery
Dublin Core
Title
Optimizing multi-tenant database architecture for efficient
software as a service delivery
software as a service delivery
Subject
Cloud
Memory efficient
Multi-tenant database design
Query performance
Software as a service
Memory efficient
Multi-tenant database design
Query performance
Software as a service
Description
A multi-tenant database (MTDB) is the backbone for any cloud app that employs
a software as a service (SaaS) delivery paradigm. Every cloud-based SaaS
delivery strategy relies heavily on the architecture of multitenant databases. The
hardware and performance costs for quicker query execution and space savings
provided by the architecture of MTDBs are implementation costs. All tenants’
data may be kept in a single table with a common schema and database format,
making it the most cost-effective MTDB configuration. The arrangement
becomes congested if tenants have varying storage needs. In this research, we
present a space-saving architecture that improves transactional query execution
while avoiding the waste of space due to different attribute needs. Extensible
markup language (XML) and JavaScript object notation (JSON) compare the
proposed system against the state of the art. The suggested multitenant database
architecture reduces unnecessary space and improves query performance. The
experimental findings show that the suggested system outperforms the state-ofthe-
art extension table method.
a software as a service (SaaS) delivery paradigm. Every cloud-based SaaS
delivery strategy relies heavily on the architecture of multitenant databases. The
hardware and performance costs for quicker query execution and space savings
provided by the architecture of MTDBs are implementation costs. All tenants’
data may be kept in a single table with a common schema and database format,
making it the most cost-effective MTDB configuration. The arrangement
becomes congested if tenants have varying storage needs. In this research, we
present a space-saving architecture that improves transactional query execution
while avoiding the waste of space due to different attribute needs. Extensible
markup language (XML) and JavaScript object notation (JSON) compare the
proposed system against the state of the art. The suggested multitenant database
architecture reduces unnecessary space and improves query performance. The
experimental findings show that the suggested system outperforms the state-ofthe-
art extension table method.
Creator
Sanjeev Kumar Pippal1, Sumit Kumar2, Ruchi Rani3Journal homepage:
Source
Journal homepage: http://journal.uad.ac.id/index.php/TELKOMNIKA
Date
Aug 5, 2024
Contributor
PERI IRAWAN
Format
PDF
Language
ENGLISH
Type
TEXT
Files
Collection
Citation
Sanjeev Kumar Pippal1, Sumit Kumar2, Ruchi Rani3Journal homepage: , “Optimizing multi-tenant database architecture for efficient
software as a service delivery,” Repository Horizon University Indonesia, accessed February 3, 2026, https://repository.horizon.ac.id/items/show/10286.
software as a service delivery,” Repository Horizon University Indonesia, accessed February 3, 2026, https://repository.horizon.ac.id/items/show/10286.