Cloud Programming


Cloud databases: who makes them and what they can do

Posted by eugene as Cloud Programming, Java

If you can recall, there were only two or three cloud platforms and about the same amount of cloud databases. Today clouds have become much more popular, and in this regard, the amount of database services built on them significantly increased. Honestly speaking, it becomes difficult to keep tracking their development and distribution! In this article we will represent the main available cloud databases and will briefly tell you about what they are and where do they move.

Note: we talk only about the automated databases except of those that require user administration.

SQL Services

  • Amazon Relational Database Service: Being one of the first cloud databases, Amazon Web Services RDS is also one of the most successful cloud databases. The same as the most AWS products, it’s connected with the control AWS interface and is compatible with a lot of other company cloud services. Moreover, if RDS earlier provided the opportunity to manage the databases located just on the AWS hosting, but now users can manage databases located by Microsoft SQL Server and Oracle Database.

  • Clustrix Database as a Service:Clustrix has recently entered the market but immediately gave the impression of a strong player. Its service which runs on Rackspace Cloud provides the user with the high-performance equipment and scalable opportunities of MySQL. The company claims that their equipment is suitable for OLTP, OLAP and for OLAP applications, and it monitors the state of the system immediately by 2500 values.

  • EnterpriseDB Postgres Plus Cloud Database: PostgreSQL database and its cloud version Postgres Plus. Focusing more on the corporate developers that on self-taught hackers, Postgres Plus Cloud includes such functions as high availability of clusters, large number of connections, compatibility with Oracle environment.

  • FathomDB: For those who doesn’t know – FathomDB still exists, but the company has made its original open-source technology in order to help the developers to make though-something-as-service. Now the company doesn’t provide any hosting and database, but its representatives claim that there’s the development of the database service of new generation./p>

  • Google Cloud SQL: is not the most functional database but it has its own benefits. For example, it’s simply integrated with all the rest Google cloud services. Moreover, Cloud SQL is geographically replicated for maximal availability. At present, however, it supports only Java and Python applications, and it has a limit of 10 gigabytes.

  • Heroku Postgres: This database is developed for information reliability and protection – Heroku claims that 99,99% of development time was consumed on achievement of 99,(9)% reliability – and it tries to bring their experience to those developers which cannot use their PaaS. One of the most interesting features of this database is Data Clips which allows users to send the SQL-queries results to somebody else via url.

  • HP Cloud Relational Database for MySQL: What else can you say about the service? Its name is definitely talking. At first, it’s necessary to note it’s still in beta stage, and so there’s so much more to finish and add. Also it should be noted that it’s designed on OpenStack which in theory should facilitate the process of transferring the database from one cloud to another.

  • IBM SmartCloud Application Services: The same as in the case of HP, the development of cloud IBM database is still not completed. Which will be the specific functions is also not clear, besides the fact that the service is based on DB2 Server technology and is part of the SmartCloud Application Services.

  • Microsoft SQL Database: SQL Database is the critical component of the new Microsoft strategy implying focus on the hybrid clouds. Yes, it can work as a self-cloud database but it also provides a common user interface of Microsoft SQL Server and the ability to share data via SQL server. Also there is the possibility to synchronize multiple databases.

  • Oracle Database Cloud Service: this service is intended not for all but only for the Oracle database users which want to try cloud hosting. Moreover, Oracle Database Cloud Service provides with all the functions of Oracle Database 11g Release 2 the amount of which is really huge. The price policy is not very clear but it’s the fact that it’s constructed on the basis of the database size.

  • Rackspace Cloud Databases: The last cloud suggestion from Rackspace, Cloud Databases – its first platform constructed on OpenStack. At the first time users will not receive SLA or any supplementary host functions (such as monitoring or GUI). But the users receive the promise of high performance and reliability due to container virtualization and special architecture.

  • Xeround: If there was no Amazon RDS, Xeround could not become the most popular cloud database. It posesses good flexibility: you can deploy it in any cloud in fact. The company claims the automatic scalability is one of the main benefits of their database, this is the new level of MySQL interface which in theory can support multiple different database parameters.

NoSQL Services

  • Amazon DynamoDB: DynamoDB is NoSQL service managed by AWS, based on the original Dynamo key-value system developed several years ago for the internal aims. Developed for the web and large applications, DynamoDB has the potential for scalability. DynamoDB is constructed on the SD architecture and is scaled automatically when adding information to the system.

  • Amazon ElastiCache: Technically it is not NoSQL service but ElastiCache supplements the system with the good caching which provides maximum access speed for users.

  • Cloudant: Although it is based on CouchDB, Cloudant is not NoSQL service but a Data Layer. Being designed on the basis of several cloud databases it offers not only the scalable NoSQL data store but also the analytic MapReduce engine. This is one of the main reasons that agricultural giant Monsanto is using it to support their infrastructure.

  • Independent database, is not quite NoSQL but rather a relational database. Its architecture reminds the “apartment” CRM and architecture. it supports a variety of data types, and is designed for applications that support the existing services.

  • Microsoft Windows Azure Table Storage: This is the NoSQL for Windows Azure data storage created for easy transferring terabytes of non-relational information. As a member of Windows Azure Storage, Table Storage gives you up to 100 terabytes of space.

  • MongoHQ/MongoLab: MongoDB is the most popular NoSQL database but it can be too large for locating in the cloud. As a result, there are exist several MongoDB services, though MongoHQ and MongoLab are more famous. The advantages of both are simple: fast deployment, thorough monitoring and reliability. Both services try to request to the wide circle of users, giving as general so and specific suggestions.

And what do you think about the represented above services? Which pros and cons can you distinguish? Maybe you think that some service has been forgotten to include.