Re:Multi-tenant databases for software as a service: schema-...
by ra on Friday December 24, 2010 @06:48AM
(#2037121)
This paper describes a new schema-mapping technique for multi-tenancy called Chunk Folding, where the logical tables are vertically partitioned into chunks that are folded together into different physical multi-tenant tables and joined as needed. The database’s “meta-data budget” is divided between application-specific conventional tables and a large fixed set of generic structures called Chunk Tables.
Interesting idea.
It is a clear weakness with most (if not all?) popular frameworks that they don't support multi tenancy (of hosted business services) in any way what so ever.
Re:Multi-tenant databases for software as a service: schema-...
by cash_coleman on Friday December 24, 2010 @05:06AM
(#2037003)
We use a more secure model here at ClearDB to ensure that customers (and code) cannot accidentally mix between two different data sets. As such, we don't rely so much on meta programming at the business level. Food for thought though.
Interesting idea.
It is a clear weakness with most (if not all?) popular frameworks that they don't support multi tenancy (of hosted business services) in any way what so ever.