Multi-tenant architecture

View previous topic View next topic Go down

Multi-tenant architecture

Post  aicrag on Thu Nov 13, 2014 11:31 am

Hi.
We're in the designing proccess of a datawarehouse, the environment has to be multitenant. Most of the approaches point to have a tenant table with the key "on every dimension".

It's really necesary to have every table with a tenant id?
Could it be on the fact tables only?,
If the tenant id is on every dimension table, we are talking about a snowflake schema?, we want to model using star schema.

Another approach is to do a database schema per tenant, but that would imply to have different tables all with the same structure per schema, and what about a structure change? or new requeriment?

We want to have a reports central repository, (the most of the reports could be shared accross all tenant) and then filter by tenant, the user logged would have that attribute.

Hope some one could guide through the right way or share some experience.

Thanks.

aicrag

Posts : 1
Join date : 2014-11-13

View user profile

Back to top Go down

Re: Multi-tenant architecture

Post  BoxesAndLines on Thu Nov 13, 2014 11:45 pm

I spoke with someone from a multi-tenant company the other day. They said the way to go is a common schema with all data instead of different schemas. I believe they used partitioning to physically separate the data. I wouldn't have thought that was the way to go but apparently keeping all the schemas in sync with the latest changes becomes quite cumbersome. You would want tenant id on all tables because not all reporting hits the fact tables. A pure customer report could run solely off of the customer dimension.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Multi-tenant architecture

Post  zoom on Fri Nov 14, 2014 1:55 pm

Create one conformed tenant dim and separating tenant with their type, for example Govt, small business etc. If you want to pivot out tenant data then create a tenant type dim and tenant dim and join it in a Fact table.

zoom

Posts : 97
Join date : 2010-08-23
Location : Chicago

View user profile

Back to top Go down

Re: Multi-tenant architecture

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum