"The important thing is not to stop questioning. Curiosity has its own reason for existing" Einstein

Wednesday, 9 November 2011

Managing Database as a Service

Before looking at Database-as-a-Service there are 3 concepts that cloud computing traditionally utilize within the ecosystem, virtualization, standardisation and automation. The essential concepts being:

Elasticity

Rapid provisioning

On demand self service

Resource pooling

Measurable service

Standardised reporting

Database-as-a-Service (DBaaS) is in its infancy and conceptually sits within the hierarchy of service layers Platform-as-a-Service (PaaS). DBaaS utilizes on premise software such as SQL Server to deliver a managed database service. The service layers are

Table: Examples of Service Offerings

IaaS- Infrastructure as a Service
PaaS – Platform as a Service
DBaaS - Database as a Service

Management of database services has now broaden with multiple owners. It is managed in the private cloud by database administrators. In the public cloud, the public create databases and provision the resources they require for scalability using services such as SQL Azure. This service framework aims to reduce
total cost of ownership by reducing the hardware footprint. This reduced number of SQL Server instances, reduces the number of servers requiring management and maintenance
within the database landscape. Consolidation of database services on a shared platform reduces what was known as database server sprawl.

DBaaS is agile as it has inbuilt processes for the quick provisioning of database services. The elasticity of the service is provided by instantly being able to expand and collapse capacity.

In the SQL Server MVP Deep Dives (2011) chapter by Peter Ward he discusses further what he calls SQL Service as a service. There he mentions that the SQL Server topology satisfies the following:

PaaS allows SQL Server to run physical or virtual servers to provide Relational Database Management Systems or Business Intelligence systems. Database-as-a-Service is a cloud service which instigates a new model for providing database services that is a deviation from the core managed database service.

In conclusion cloud computing and Database-as-a-Service are just a new way of presenting and managing services which provide the industry with reductions in total cost of ownership. However organizations will continue to need managed database services whether they are provided through traditional, cloud or hybrid managed services.