Question

Most SaaS application providers use a "shared database, shared schema" approach. Describe how this approach works and how it achieves data isolation for each tenants .

Answer 1

Most SaaS application providers use a "shared database, shared schema" approach. Describe how this approach works and how it achieves data isolation for each tenants .

ANSWER:

SaaS:

• Software as a Service.
• Process of hosting application through internet for multiple customers.
• It does not require any installation or running process.
• It is similar to application service provider which provide software for the end user through internet.

Shared database,shared schema:

• Multiple clients or users can use the same database.
• Tenant columns from each table are isolated and hence use the same set of tables.
• It requires very low hardware usage.
• Its backup cost is also considerable because large number of data is served form single set of tables.
• each tenants can be modified independently.

How does it works:

• By using the shared database, The tenants can access the data by executing the query with WHERE condition through which the data is recovered from the database.
• (i.e)Each tenants access data by using their individual tenant id.
• Data of each tenants can be identified and separated form the other tenants data in the same set of tables.
• Data for each tenants is accessed by using the id and it is separated by data isolation.

Data Isolation for each Tenants:

• Tenants are considered as unique identity through which we can get data from set of tables.
• We should define a tenant id column in the database for uniquely identify the data for set of tables.
• Each tenants should be separated each other for proper usage of data from the table.
• Each tenants should have separate id for accessing their individual data from database.
• We have to make sure that all the data are retrieved from database with the tenant id.