Top 24 Free and Commercial SQL and No SQL Cloud Databases
Cloud database runs on a cloud computing platform and there are two common deployment models, one in which can be implemented using a virtual machine image and users can run databases on the cloud independently. The other option is to purchase access to a database service, maintained by a cloud database provider. Some of the cloud databases available on the cloud, are SQL-based and and some use a NoSQL data model.
Free SQL Data Model Virtual Machine Deployment : Free SQL Data Model Virtual Machine Deployment includes MySQL, MariaDB, PostgreSQL
Virtual Machine Deployment SQL Data Model : Virtual Machine Deployment SQL Data Model includes IBM DB2, Oracle Database, NuoDB, Ingres Database
Virtual Machine Deployment No SQL Data Model : Virtual Machine Deployment No SQL Data Model includes Apache Cassandra, Clusterpoint database, Apache CouchDB, Apache Hadoop, MarkLogic, MongoDB, Neo4j
Database as a Service SQL Data Model : Database as a Service SQL Data Model includes IBM dashDB, Microsoft Azure SQL Database, Amazon Relational Database, Clustrix, EnterpriseDB, Heroku.
Database as a Service NoSQL Data Model : Database as a Service NoSQL Data Model includes Amazon DynamoDB, Google App Engine, Cloudant, Amazon SimpleDB
Free SQL Data Model Virtual Machine Deployment
MySQL is an open-source relational database management system (RDBMS). MySQL is offered under two different editions: the open source MySQL Community Server and the proprietary Enterprise Server. MySQL Enterprise Server is differentiated by a series of proprietary extensions which install as server plugins, and shares the version numbering system and is built from the same code base.
MariaDB is a community-developed fork of the MySQL relational database management system intended to remain free under the GNU GPL. MariaDB intends to maintain high compatibility with MySQL, ensuring a "drop-in" replacement capability with library binary equivalency and exact matching with MySQL APIs and commands.It includes the XtraDB storage engine for replacing InnoDB, as well as a new storage engine, Aria, that intends to be both a transactional and non-transactional engine perhaps even included in future versions of MySQL.
PostgreSQL, is an object-relational database management system (ORDBMS) with an emphasis on extensibility and standards-compliance. It can handle workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent users.
Virtual Machine Deployment SQL Data Model
IBM DB2 is a family of database server products developed by IBM, all support the relational model, and some products have been extended to support object-relational features and non-relational structures like JSON and XML.
Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is an object-relational database management system. The Oracle RDBMS typically relies on a group of processes running simultaneously in the background and interacting to monitor and expedite database operations.
NuoDB database is SQL compliant and has a distributed object architecture that works in the cloud. The database scales out without sharding. The database distributes tasks amongst several processors to avoid bottlenecks of data. It uses peer-to-peer messaging to route tasks to nodes,and it is ACID compliant.
Ingres Database is a commercially supported, open-source SQL relational database management system intended to support large commercial and government applications. An Ingres installation (or instance) may support many databases, each being owned by any user known to the installation. The installation will allow many databases to be available concurrently. The number available is a configurable quantity.
Virtual Machine Deployment No SQL Data Model
Apache Cassandra is an open source distributed database management system designed to handle large amounts of data across many commodity servers, providing high availability with no single point of failure. Cassandra offers robust support for clusters spanning multiple datacenters, with asynchronous masterless replication allowing low latency operations for all clients. Apache Cassandra is available on Amazon EC2.
Clusterpoint database eliminates customer integration efforts among database, search and analytics platforms. Clusterpoint database replaces integrated multi-platform solutions with a single-platform and one-API solution, typically, where SQL RDBMS data is used in combination with an enterprise search engine to address performance and scalability needs of web and mobile applications.
Apache Hadoop is an open-source software framework for distributed storage and distributed processing of very large data sets on computer clusters built from commodity hardware. All the modules in Hadoop are designed with a fundamental assumption that hardware failures are common and should be automatically handled by the framework. The core of Apache Hadoop consists of a storage part, known as Hadoop Distributed File System (HDFS), and a processing part called MapReduce. Hadoop splits files into large blocks and distributes them across nodes in a cluster. Hadoop is available on Amazon EC2 or Rackspace.
MarkLogic provides an enterprise NoSQL database and is considered a multi-model NoSQL database for its ability to store, manage, and search JSON and XML documents and graph data (RDF triples). Organizations rely on the flexibility and agility of MarkLogic in order to integrate massive amounts of data and build large scale web applications. MarkLogic is available on Amazon EC2.
MongoDB is a cross-platform document-oriented database. Classified as a NoSQL database, MongoDB eschews the traditional table-based relational database structure in favor of JSON-like documents with dynamic schemas, making the integration of data in certain types of applications easier and faster. MongoDB is available on Amazon EC2,Microsoft Azure,or Rackspace.
Neo4j is a graph database management system and is an ACID-compliant transactional database with native graph storage and processing. Neo4j is implemented in Java and accessible from software written in other languages using the Cypher Query Language through a transactional HTTP endpoint.Neo4J is available on Amazon EC2 or Microsoft Azure.
Database as a Service SQL Data Model
IBM dashDB is a fully managed cloud data warehouse, purpose-built for analytics. It offers MPP scale, and compatibility with a wide range of BI tools. dashDB offers a simple and performant data warehouse, with the scale and agility of the cloud. IBM’s data warehouse-as-a-service delivers high speed insights, in-database analytics, and connects seamlessly with a wide ecosystem of business intelligence toolsets, including Watson Analytics and many third-party BI tools
16.Microsoft Azure SQL Database
Microsoft Azure SQL Database is a cloud-based service from Microsoft offering data-storage capabilities SQL Database allows users to make relational queries against stored data, which can either be structured or semi-structured, or even unstructured documents. SQL Database features querying data, search, data analysis and data synchronization.
Microsoft Azure SQL Database
17.Amazon Relational Database
Amazon Relational Database Service is a distributed relational database service by Amazon Web Services (AWS).It is a web service running "in the cloud" designed to simplify the setup, operation, and scaling of a relational database for use in applications.
Amazon Relational Database
Clustrix is a scale-out SQL database and part of what are often called the NewSQL databases .It supports workloads that involve scaling transactions and real-time analytics. It also has built in fault-tolerance features for high availability within a cluster. It has parallel backup and parallel replication among clusters for disaster recovery.
EnterpriseDB offers two distributions based on PostgreSQL that have additional features and commercial support. These distributions are available for free download and are supported on several different platforms, including Linux, Windows, Solaris and HP-UX. They include connectors for the most common programming languages and environments, including: JDBC, ODBC, .NET, ESQL / C++, Perl, Python and PHP.
Heroku is a cloud Platform-as-a-Service (PaaS) supporting several programming languages. Heroku supports the Ruby programming language, Java, Node.js, Scala, Clojure, Python, PHP, and Go.
Database as a Service NoSQL Data Model
Amazon DynamoDB is a NoSQL database service that is offered by Amazon.com as part of the Amazon Web Services portfolio. Dynamo had a multi-master design requiring the client to resolve version conflicts and DynamoDB uses synchronous replication across multiple datacenters for high durability and availability.
22.Google App Engine
Google App Engine is a platform as a service (PaaS) cloud computing platform for developing and hosting web applications in Google-managed data centers. App Engine offers automatic scaling for web applications as the number of requests increases for an application, App Engine automatically allocates more resources for the web application to handle the additional demand.
Google App Engine
Cloudant is an open source non-relational, distributed database service of the same name that requires zero-configuration. Cloudant is based on the Apache-backed CouchDB project and the open source BigCouch project. Cloudant's service provides integrated data management, search, and analytics engine designed for web applications.
Amazon SimpleDB is a distributed database. It is used as a web service in concert with Amazon Elastic Compute Cloud (EC2) and Amazon S3 and is part of Amazon Web Services.