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
View Complete Post