DBaaS (Database-as-a-service)

From Bauman National Library
This page was last modified on 20 December 2016, at 14:24.

Database as a service — the cloud-based way of storing and managing structured data. This is one of the most popular technologies in the field of information resources management. The essence of the concept of DBaaS is that the user does not need to establish and maintain a database, it is enough to make the request and receive the database. For its creation uses the resources of the private, public or hybrid cloud[1].

Some cloud platforms offer service databases, whereby it is possible to do without a virtual machine. The service provider takes responsibility for installing and maintaining the database. As an example, you can call Amazon Web Services. They provide three databases that are included in their cloud service: SimpleDBNoSQL, where the data is stored in pairs key-value, — Amazon Relational Database Service (and this is a SQL-oriented database MySQL-UI) and DynamoDB[2].

The user receives information resources, information collected in accordance with the parameters of your request, and can work with it as a database: save, edit, share, merge with other databases, and more.

DBaaS provides a database functionality similar to those that give a relational database management system (RDBMS) such as SQL Server, MySQL and Oracle. On the other hand, as a cloud, DBaaS provides a flexible, scalable platform on request that is directed to self-service and easy management, in particular from the point of view of initialization of a private business environment. DBaaS products typically provide enough monitoring capabilities to track performance and flow and to warn users about possible problems. Products can also produce the simplest analysis of the data.[3]

Advantages

  • Timely processing of requests of any complexity;
  • Reducing the cost of creating a database with a standard configuration, or under local tasks (e.g. for testing);
  • Optimization of development processes and testing;
  • Simple and rapid scaling of resources in the cloud[1].

Disadvantages

  • Lack of control of problems with network performance:
    • Unacceptable delays
    • Crashing apps
  • Some DBaaS solutions do not support typical database management system capabilities, e.g., data compression, and table partitioning.

Before you take on DBaaS, you need to soberly assess their requirements and make sure that they will all be acceptable satisfied[3].

Functionality

  • Automation of the process of creating and obtaining the model database upon user request;
  • Organization of accounting of consumption of resources and their payment;
  • Automatic deployment and retrieving records on the request of the user;
  • Fast creation of new databases based on templates;
  • Flexible tool for developers and testers, allowing you to maintain control of their work from the database administrators[1].

Distributors

Below is a list of the main suppliers of cloud database model "database as a service", with the separation of SQL and NoSQL[2]: SQL:

  • Amazon Relational Database Service (MySQL)
  • Microsoft SQL Azure (MS SQL)
  • GenieDB
  • Heroku PostgreSQL as a Service
  • Clustrix Database as a Service
  • Xeround Cloud Database — MySQL front-end
  • EnterpriseDB Postgres Plus Cloud Database
  • GaianDB
  • ClearDB ACID-comliant MySQL

NoSQL:

Sources

Cite error: Invalid <references> tag; parameter "group" is allowed only.

Use <references />, or <references group="..." />

Links

  • 1.0 1.1 1.2 ТрастИнфо [Электронный ресурс]: База данных как сервис / Дата обращения: 31.10.2016. — Режим доступа: http://www.trustinfo.ru/pages/dbas.
  • 2.0 2.1 Википедия [Электронный ресурс]: Облачные базы данных — материал из Википедии — свободной энциклопедии: Версия 68907279, сохранённая в 20:13 UTC 27 февраля 2015 / Авторы Википедии // Википедия, свободная энциклопедия. — Электрон. дан. — Сан-Франциско: Фонд Викимедиа, 2016. — Режим доступа: https://ru.wikipedia.org/w/index.php?title=Облачные_базы_данных&oldid=68907279 .
  • 3.0 3.1 TechTarget [Электронный ресурс]: R. Sheldon. What is Database as a Service / Дата обращения: 31.10.2016. — Режим доступа: http://whatis.techtarget.com/definition/Database-as-a-Service-DBaaS.