Last post Apr 07, 2011 12:56 PM by MisterFantastic
Apr 07, 2011 04:06 AM|tejp|LINK
I am trying to decide on what kind of architecture my web application will have.
Basically i want to go down the route of having a a multi tenancy system but to be more economical i would need to have a shared database and shared db for all users. Each user is unique.
But the main disadvantage of this is isolation of data for each user.
I know that salesforce.com and amazon amongest many others user this approach.
what i wanted to know is what is the best way to isolate data? would metadata be relevant to this scenairo?
basically would having a middle tier where data is isolated be a better approach?
i know this is a debatable question but any feedback would be great
Apr 07, 2011 08:28 AM|sudeep_13|LINK
I think Middle tier should be left only for business rules. You can use a separate layer for Data Isolation probably with Factory pattern which would create objects based on the DB schema design
Apr 07, 2011 12:56 PM|MisterFantastic|LINK
Here you need a local storage in client side. HTML5 has a good solution for that.
You can use this feature. or you can use a XML datastore at client side and sync them when online.