Click here to close now.




















Welcome!

@CloudExpo Authors: Dana Gardner, Liz McMillan, Kevin Jackson, Pat Romanski, Bob Gourley

Related Topics: @CloudExpo, Microservices Expo

@CloudExpo: Article

SaaS - Multi-Tenant Database Design Options

Making the best out of dynamic infrastructure with database design

Cloud Business Profitability & Infrastructure Efficiency
Your survival as a SaaS provider depends on how efficient is your software service with respect to resource utilization, so that you spend the least on your capital and operational expenditure  and you can transform your cost benefits to your customers resulting in more recognition for your products and service.

We have also seen that most of the IaaS pricing, that is the platform you host your applications  are charged per the usage, based on the  instance power and the amount of data transferred, for example let us  see the factors in the Amazon EC2 pricing :

Standard On-Demand Instances

Linux/UNIX Usage

Windows Usage

Small (Default)

$0.085 per hour

$0.12 per hour

Large

$0.34 per hour

$0.48 per hour

Extra Large

$0.68 per hour

$0.96 per hour

Again an instance is considered Small, Large , Extra Large based on the amount of memory and  CPU usage .

Standard On-Demand Instances

CPU

Memory

Small (Default)

1 EC2 Compute Unit

1.7 GB

Large

4 EC2 Compute Unit

7.5 GB

Extra Large

8 EC2 Compute Unit

15 GB

 

With Amazon Elastic Block Store, you only pay for what you use. Volume storage is charged by the amount you allocate until you release it, and is priced at a rate of $0.10 per allocated GB per month Amazon EBS also charges $0.10 per 1 million I/O requests you make to your volume.

So the heavier your application is, the higher the cost of cloud computing for your application, and the multi-tenant database design plays a vital part here.

Three Options for Multi-Tenant Database Design

  1. Separate Database: Each of the tenants  is allocated a separate physical database  for storing their data.
  2. Separate Schema: Each of the tenants  is allocated a separate logical unit called Schema, within a single physical database .
  3. Separate Rows: Each of the tenants  is allocated  same physical database and schema, but their information is separated using  primary keys which are allocated as part of the data base design and all the information is kept within the same physical tables.

The following diagram provides a quick snapshot of these three models. Diagram utilizes the IaaS model of Amazon AWS on which you can host your SaaS applications.

Attributes Influencing The Cloud Database Multi Tenant Design
As evident, these three models  will fit the needs of a cloud service provider; however, the following attributes needs to considered before choosing either one of the model.

Attribute

Separate Database

Separate Schema

Separate Rows

Tenants are large enterprise customers who could store large amounts of data in TB or 100s of GB

Good

Fair

Poor

Tenants are individual consumers  with low or moderate storage of data like a  social networking site

Poor

Fair

Good

Rapid provisioning is the key, risk of losing business exists  if the response is not quick, customers select the service on the fly

Fair

Fair

Good

Customers can opt out of  (Cancel ) service at a faster rate and  space reclamation is not a concern

Good

Good

Fair

Customer can opt out of (Cancel) service at a faster rate and space reclamation is a concern

Good

Good

Poor

The business logic of your SaaS application is highly customized with respect to the Tenant

Good

Good

Poor

Application is prone to database locks

Good

Fair

Poor

Security and Legal Requirements require data separation, even if the application controls it

Good

Fair

Poor

Performance tuning is a concern and reports performance should be based on the volume of data

Good

Fair

Poor

Administration and maintenance of Schema and  database code is a concern

Poor

Poor

Good

Scalability is a concern

Good

Fair

Poor

Frequent Changes to the Application Possible

Poor

Poor

Good

Data is mission critical and Point In Time Recovery is needed in case of a crash

Good

Fair

Poor

The list is not complete and there could be more attributes, however  these major attributes play an important role in determining the multi tenant database design for your SaaS application.

More Stories By Srinivasan Sundara Rajan

Srinivasan is passionate about ownership and driving things on his own, with his breadth and depth on Enterprise Technology he could run any aspect of IT Industry and make it a success.

He is a seasoned Enterprise IT Expert, mainly in the areas of Solution, Integration and Architecture, across Structured, Unstructured data sources, especially in manufacturing domain.

He currently works as Technology Head For GAVS Technologies.

@CloudExpo Stories
Container technology is sending shock waves through the world of cloud computing. Heralded as the 'next big thing,' containers provide software owners a consistent way to package their software and dependencies while infrastructure operators benefit from a standard way to deploy and run them. Containers present new challenges for tracking usage due to their dynamic nature. They can also be deployed to bare metal, virtual machines and various cloud platforms. How do software owners track the usag...
In their session at 17th Cloud Expo, Hal Schwartz, CEO of Secure Infrastructure & Services (SIAS), and Chuck Paolillo, CTO of Secure Infrastructure & Services (SIAS), provide a study of cloud adoption trends and the power and flexibility of IBM Power and Pureflex cloud solutions. In his role as CEO of Secure Infrastructure & Services (SIAS), Hal Schwartz provides leadership and direction for the company.
There are many considerations when moving applications from on-premise to cloud. It is critical to understand the benefits and also challenges of this migration. A successful migration will result in lower Total Cost of Ownership, yet offer the same or higher level of robustness. In his session at 15th Cloud Expo, Michael Meiner, an Engineering Director at Oracle, Corporation, analyzed a range of cloud offerings (IaaS, PaaS, SaaS) and discussed the benefits/challenges of migrating to each offe...
SYS-CON Events announced today that the "Second Containers & Microservices Expo" will take place November 3-5, 2015, at the Santa Clara Convention Center in Santa Clara, CA. Containers and microservices have become topics of intense interest throughout the cloud developer and enterprise IT communities.
As organizations shift towards IT-as-a-service models, the need for managing and protecting data residing across physical, virtual, and now cloud environments grows with it. CommVault can ensure protection and E-Discovery of your data – whether in a private cloud, a Service Provider delivered public cloud, or a hybrid cloud environment – across the heterogeneous enterprise. In his session at 17th Cloud Expo, Randy De Meno, Chief Technologist - Windows Products and Microsoft Partnerships at Com...
The Software Defined Data Center (SDDC), which enables organizations to seamlessly run in a hybrid cloud model (public + private cloud), is here to stay. IDC estimates that the software-defined networking market will be valued at $3.7 billion by 2016. Security is a key component and benefit of the SDDC, and offers an opportunity to build security 'from the ground up' and weave it into the environment from day one. In his session at 16th Cloud Expo, Reuven Harrison, CTO and Co-Founder of Tufin,...
SYS-CON Events announced today that MobiDev, a software development company, will exhibit at the 17th International Cloud Expo®, which will take place November 3–5, 2015, at the Santa Clara Convention Center in Santa Clara, CA. MobiDev is a software development company with representative offices in Atlanta (US), Sheffield (UK) and Würzburg (Germany); and development centers in Ukraine. Since 2009 it has grown from a small group of passionate engineers and business managers to a full-scale mobi...
Between the compelling mockups and specs produced by your analysts and designers, and the resulting application built by your developers, there is a gulf where projects fail, costs spiral out of control, and applications fall short of requirements. In his session at @DevOpsSummit, Charles Kendrick, CTO and Chief Architect at Isomorphic Software, presented a new approach where business and development users collaborate – each using tools appropriate to their goals and expertise – to build mocku...
SYS-CON Events announced today that VividCortex, the monitoring solution for the modern data system, will exhibit at the 17th International Cloud Expo®, which will take place on November 3–5, 2015, at the Santa Clara Convention Center in Santa Clara, CA. The database is the heart of most applications, but it’s also the part that’s hardest to scale, monitor, and optimize even as it’s growing 50% year over year. VividCortex is the first unified suite of database monitoring tools specifically desi...
As Marc Andreessen says software is eating the world. Everything is rapidly moving toward being software-defined – from our phones and cars through our washing machines to the datacenter. However, there are larger challenges when implementing software defined on a larger scale - when building software defined infrastructure. In his session at 16th Cloud Expo, Boyan Ivanov, CEO of StorPool, provided some practical insights on what, how and why when implementing "software-defined" in the datacent...
Learn how you can use the CoSN SEND II Decision Tree for Education Technology to make sure that your K–12 technology initiatives create a more engaging learning experience that empowers students, teachers, and administrators alike.
Mobile, social, Big Data, and cloud have fundamentally changed the way we live. “Anytime, anywhere” access to data and information is no longer a luxury; it’s a requirement, in both our personal and professional lives. For IT organizations, this means pressure has never been greater to deliver meaningful services to the business and customers.
"We've just seen a huge influx of new partners coming into our ecosystem, and partners building unique offerings on top of our API set," explained Seth Bostock, Chief Executive Officer at IndependenceIT, in this SYS-CON.tv interview at 16th Cloud Expo, held June 9-11, 2015, at the Javits Center in New York City.
SYS-CON Events announced today that HPM Networks will exhibit at the 17th International Cloud Expo®, which will take place on November 3–5, 2015, at the Santa Clara Convention Center in Santa Clara, CA. For 20 years, HPM Networks has been integrating technology solutions that solve complex business challenges. HPM Networks has designed solutions for both SMB and enterprise customers throughout the San Francisco Bay Area.
Digital Transformation is the ultimate goal of cloud computing and related initiatives. The phrase is certainly not a precise one, and as subject to hand-waving and distortion as any high-falutin' terminology in the world of information technology. Yet it is an excellent choice of words to describe what enterprise IT—and by extension, organizations in general—should be working to achieve. Digital Transformation means: handling all the data types being found and created in the organizat...
Chuck Piluso presented a study of cloud adoption trends and the power and flexibility of IBM Power and Pureflex cloud solutions. Prior to Secure Infrastructure and Services, Mr. Piluso founded North American Telecommunication Corporation, a facilities-based Competitive Local Exchange Carrier licensed by the Public Service Commission in 10 states, serving as the company's chairman and president from 1997 to 2000. Between 1990 and 1997, Mr. Piluso served as chairman & founder of International Te...
With SaaS use rampant across organizations, how can IT departments track company data and maintain security? More and more departments are commissioning their own solutions and bypassing IT. A cloud environment is amorphous and powerful, allowing you to set up solutions for all of your user needs: document sharing and collaboration, mobile access, e-mail, even industry-specific applications. In his session at 16th Cloud Expo, Shawn Mills, President and a founder of Green House Data, discussed h...
One of the hottest areas in cloud right now is DRaaS and related offerings. In his session at 16th Cloud Expo, Dale Levesque, Disaster Recovery Product Manager with Windstream's Cloud and Data Center Marketing team, will discuss the benefits of the cloud model, which far outweigh the traditional approach, and how enterprises need to ensure that their needs are properly being met.
The Internet of Everything (IoE) brings together people, process, data and things to make networked connections more relevant and valuable than ever before – transforming information into knowledge and knowledge into wisdom. IoE creates new capabilities, richer experiences, and unprecedented opportunities to improve business and government operations, decision making and mission support capabilities.
Explosive growth in connected devices. Enormous amounts of data for collection and analysis. Critical use of data for split-second decision making and actionable information. All three are factors in making the Internet of Things a reality. Yet, any one factor would have an IT organization pondering its infrastructure strategy. How should your organization enhance its IT framework to enable an Internet of Things implementation? In his session at @ThingsExpo, James Kirkland, Red Hat's Chief Arch...