BT

Your opinion matters! Please fill in the InfoQ Survey!

Multi-Tenant Data Architecture

| by Sean Alexander Follow 0 Followers on Jul 03, 2006. Estimated reading time: less than one minute |

The 2nd installment in a series of articles for creating Software as a Service, Multi-Tenant Data Architecture, is now available from the Microsoft Architecture Strategy Team on MSDN.

In this article, we look at the continuum between isolated data and shared data, and identify three distinct approaches for creating data architectures that fall at different places along the continuum. Next, we'll explore some of the technical and business factors to consider when deciding which approach to use. Finally, we'll present design patterns for ensuring security, creating an extensible data model, and scaling the data infrastructure.

Cost vs. Time
The article starts with an overview of the general approaches to a multi-tenant architecture and then asks both technical and business questions to help define the most appropriate plan, giving some useful SQL Server strategies to help plan for isolation and scalability. Overall it is a great first step at looking at the consideration of developing the data services required for SaaS.

Start with the first article in the series, Architecture Strategies for Catching the Long Tail, for an introduction if you are unfamiliar with the SaaS concepts.

Rate this Article

Adoption Stage
Style

Hello stranger!

You need to Register an InfoQ account or or login to post comments. But there's so much more behind being registered.

Get the most out of the InfoQ experience.

Tell us what you think

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Good Articles by Geoffrey Wiseman

This series of articles is quite well-written, both accessible and offering reasonably good coverage of the subject area. Like most 'patterns', the material may not be radically new to anyone who's had extensive experience with building software sold as a service, but it establishes useful nomenclature and gives a good introduction to someone just starting out in the area.

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

1 Discuss

Login to InfoQ to interact with what matters most to you.


Recover your password...

Follow

Follow your favorite topics and editors

Quick overview of most important highlights in the industry and on the site.

Like

More signal, less noise

Build your own feed by choosing topics you want to read about and editors you want to hear from.

Notifications

Stay up-to-date

Set up your notifications and don't miss out on content that matters to you

BT