multitenancy

What is the difference between multi-tenancy and multi-user solutions?

I believe I understand this in terms of hardware, where multiple individuals 'share' the same processing and memory for their solutions. But I've been looking at gmail and facebook, are those multi-tenanted solutions? Is it that as long as my solution can support multiple users, its multi-tenanted? ...

Entity Framework and multi-tenancy database design

I am looking at multi-tenancy database schema design for an SaaS concept. It will be ASP.NET MVC -> EF, but that isn't so important. Below you can see an example database schema (the Tenant being the Company). The CompanyId is replicated throughout the schema and the primary key has been placed on both the natural key, plus the tenant I...

CMS choices for multitenant ecommerce application in Java

I need help choosing a CMS product to suit an e-commerce application with some complex unique features. I'm considering using an existing CMS because I don't have the budget to build my own versions of: copy editor page layout tools site map editor (optional) I'd considered Spring.MVC and JBoss Seam as framework alternatives and JSP/...

Opaque tenant identification with SQL Server & NHibernate

Howdy! We're developing a nowadays-fashionable multi-tenanted SaaS app (shared database, shared schema), and there's one thing I don't like about it: public class Domain : BusinessObject { public virtual long TenantID { get; set; } public virtual string Name { get; set; } } The TenantID is driving me nuts, as it has ...

How to manage multi tenant web portal css using Asp.Net MVC

I am designing a multi tenants web portal application using MVC. Tenants will be identified by URL or tenant id. We are going to have a default set of skins and themes but per requirement each tenant can have its own skins and themes. What is the best way to handle/attach css for multi tenant web portal application? ...

Spring Security and Multitenancy / REST -> How? Best practice? Reference app?

Hi all I have been looking for a way to secure URLs like @RequestMapping("/owners/{ownerId}/pets/new") on user (not role) level, i.e. only owner with ID {ownerId} has access. Moreover, I want to secure RESTful design incl. async access to JSON services on owner level dynamically. My questions: How is this best done with Spring Se...

Multi-Tenant application - How to achieve Shared database separate schema implementation ?

I have to make a web application multi-tenant enabled using Shared database separate schema approach. Application is built using Java/J2EE and Oracle10g. I need to have one single appserver using a shared database with multiple schema, each schema per client. What is the best implementation approach to achieve this? - What needs to ...

Multi-tenancy - Create tables up-front or as needed?

Hi, I'm currently working on a SaaS type application, and for multi-tenancy I've settled on one database per user, with each database containing all tables required by the functionality the user is entitled to (have payed for). The application is designed to capture data (i.e. like web analytics) and present it for the user. The design ...

Multi-tenant User Model

In a multitenant system that hosts multiple organizations and applications, where an organization may use several applications hosted on the system, should my user and role model be such that a single user or role can exist across multiple applications and organizations? Or should I limit a user entity to a single organization/applicatio...

How to implement Tenant View Filter security pattern in a shared database using ASP.NET MVC2 and MS SQL Server

I am starting to build a SaaS line of business application in ASP.NET MVC2 but before I start I want to establish good architecture foundation. I am going towards a shared database and shared schema approach because the data architecture and business logic will be quite simple and efficiency along with cost effectiveness are key issues....

Multi-Tenant in windows azure asp.net MVC2

Hello, Anyone knows how can i start to develop a multitenant site in MVC2, in a way it run on Windows Azure? I search a lot about this question, and i allways find theoric explanations, everybody says it can be easily done, but i dont find any sample... Can someone explain me where to start? Thanks, João ...

How can I have a common user for Multitenant grails application?

Hi, I want to develop a multitenant grails application using grails plugin multitenant. I plan to have individual dbschema per tenant as per the requirement(backup and data security). Also I have a special case where a set of common users need to have access to data of all the tenants. With single database I hope it is easier to do. But...

How do I structure the domain architecture of my web app? - practical advice

So I am creating a web app, that will give each registered user a unique 'workspace'. This workspace should be accessible by anybody they give permission to. I have the main domain for my marketing website, but I am trying to figure out how to manage the nitty-gritty domain management of the web app itself. Should I buy generic domains...

Multi Presentation enterprise solution.

Hi, I am working on designing an enterprise web application which will have single codebase and single database (don't need any flexibility in database based on tenants) but different presentations based on clients. We might have 3 to 4 different clients (websites) utilizing same core logic and skeleton but client specific headers, foot...

Multi Tenancy and User Definable Forms

We are designing our new product, which will include multi-tenancy. It will be written in ASP.NET and C#, and may be hosted on Windows Azure or some other Cloud hosting solution. We’ve been looking at MVC and other technologies and, to be honest, we’re getting bogged down in various acronyms (MVC, EF, WCF etc. etc.). A particular requi...