• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Multi-Tenant Data Architecture
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Multi-Tenant Data Architecture


  • Subject: Re: Multi-Tenant Data Architecture
  • From: Klaus Berkling <email@hidden>
  • Date: Wed, 23 Sep 2009 08:13:53 -0700

FWIW

We uses an setup were access is organized by groups, sub-groups and sub-sub-groups, etc.

We have sales reps which manage channel partners, which manage clients or schools. In the schools are more groups. These are all group objects.

There are classes that relate to groups, students are related to one or more class. All the groups are in one table, then there is a classes table and students table.

The groups are the your tenants. One of our sites has 35819 groups.

A user is assigned a group and when the user logges into their group they are given a list of their sub-groups. Users are never aware of their login group, their parent groups or any other group above that. We keep track of their login group in the session.

There are certain safe-guards to block exposing objects who's group relationship is not a child of the users' login group.

This seems to work pretty well.

Issues arise when doing searches for data in a table that's shared with multiple tenants. A tenant should not take the penalty for someone else's large data set. There is a performance hit when combining the database your searching through with the group the tenant belongs to. If you have large tenants you'll need to considere getting them their own server, or at least their own instance(s) +database.

Thanks

kib

"We keep moving forward, opening new doors, and doing new things, because we're curious and curiosity keeps leading us down new paths."
Walt Disney


Klaus Berkling
Web Application Dev. & Systems Administrator
DynEd International, Inc.
www.dyned.com | www.eskimo.com/~kiberkli




_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (email@hidden) Help/Unsubscribe/Update your Subscription: This email sent to email@hidden
References: 
 >Multi-Tenant Data Architecture (From: Henrique Prange <email@hidden>)

  • Prev by Date: WO WebServices & Java 1.6
  • Next by Date: saving pdf's to the database
  • Previous by thread: Re: Multi-Tenant Data Architecture
  • Next by thread: Re: Multi-Tenant Data Architecture
  • Index(es):
    • Date
    • Thread