Cloud database

A cloud database is a database running on Cloud Computing platform, such as Amazon EC2, GoGrid and Rackspace. There are two common deployment models: Users can run databases on the cloud independently, using a Virtual Machine image, or they can purchase access to a database service, maintained by a cloud database provider. Of the databases available on the cloud, some are SQL-based and some use a NoSQL data model.

Contents

Deployment Model

There are two primary methods to run a database on the cloud:

  • Virtual Machine Image - cloud platforms allow users to purchase virtual machine instances for a limited time. It is possible to run a database on these virtual machines. Users can either upload their own machine image with a database installed on it, or use ready-made machine images that already include an optimized installation of a database. For example, Oracle provides a ready-made machine image with an installation of Oracle Database 11g Enterprise Edition on Amazon EC2.[1]
  • Database as a Service - some cloud platforms offer options for using a database as a service, without physically launching a virtual machine instance for the database. In this configuration, application owners do not have to install and maintain the database on their own. Instead, the database service provider takes responsibility for installing and maintaining the database, and application owners pay according to their usage.[2] For example, Amazon Web Services provides two database services as part of its cloud offering, SimpleDB which is a NoSQL key-value store, and Amazon Relational Database Service which is an SQL-based database service with a MySQL interface.

A third option is managed database hosting on the cloud, where the database is not offered as a service, but the cloud provider hosts the database and manages it on the application owner's behalf. For example, cloud provider Rackspace offers managed hosting for MySQL databases.[3]

Architecture and Common Characteristics of Cloud Database Services

  • Most database services offer web-based consoles, which the end user can use to provision and configure database instances. For example, the Amazon Web Services web console enables users to launch database instances, create snapshots (similar to backups) of databases, and monitor database statistics.[4]
  • Database services consist of a database manager component, which controls the underlying database instances using a service API. The service API is exposed to the end user, and permits users to perform maintenance and scaling operations on their database instances. For example, the Amazon Relational Database Service's service API enables creating a database instance, modifying the resources available to a database instance, deleting a database instance, creating a snapshot (similar to a backup) of a database, and restoring a database from a snapshot.[5]
  • Database services take care of scalability and high availability of the database. Scalability features differ between vendors - some offer auto-scaling, others enable the user to scale up using an API, but do not scale automatically. There is typically a commitment for a certain level of high availability (e.g. 99.9% or 99.99%).

Data Model

It is also important to differentiate between cloud databases which are relational as opposed to non-relational or NoSQL:

  • SQL Databases, such as Oracle Database, Microsoft SQL Server and MySQL, are one type of database which can be run on the cloud (either as a Virtual Machine Image or as a service, depending on the vendor). SQL databases are difficult to scale, meaning they are not natively suited to a cloud environment, although cloud database services based on SQL are attempting to address this challenge.[6]
  • NoSQL Databases, such as Apache Cassandra, CouchDB and MongoDB, are another type of database which can run on the cloud. NoSQL databases are built to service heavy read/write loads and are able scale up and down easily,[7] and therefore they are more natively suited to running on the cloud. However, most contemporary applications are built around an SQL data model, so working with NoSQL databases often requires a complete rewrite of application code.[8]

Cloud Database Vendors

The following table provides main database vendors with a cloud database offering, organized by Machine Image vs. database as a service deployment, and by SQL vs. NoSQL data model. See the references next to the vendor names for more information.

Cloud database vendors by deployment and data model
Virtual Machine Deployment Database as a Service
SQL Data Model
  • Amazon Relational Database Service (MySQL)
  • Microsoft SQL Azure (MS SQL)[14]
  • Heroku PostgreSQL as a Service (shared and dedicated database options)[15]
  • Xeround Cloud Database - MySQL front-end[2]
NoSQL Data Model

See also

References

  1. ^ a b Amazon Machine Images - Oracle Database 11g Release 2 (11.2.0.1) Enterprise Edition - 64 Bit, Amazon Web Services, Retrieved 2011-11-9.
  2. ^ a b Klint Finley, "7 Cloud-Based Database Services", ReadWriteWeb, Retrieved 2011-11-9.
  3. ^ "MySQL Server Support at Rackspace", [www.rackspace.com Rackspace.com], Retrieved 2011-11-10.
  4. ^ "AWS Management Console, Amazon RDS Features", Amazon Web Services, Retrieved 2011-11-10.
  5. ^ "Amazon Relational Database Service, Features, Detailed Description", Amazon Web Services, Retrieved 2011-11-10.
  6. ^ Dave Rosenberg, Are databases in the cloud really all that different?, CNET, Retrieved 2011-11-6
  7. ^ Agrawal, Rakesh et al. (2008). "The Claremont report on database research". SIGMOD Record (ACM) 37 (3): 9–19. doi:http://doi.acm.org/10.1145/1462571.1462573. ISSN 0163-5808. http://db.cs.berkeley.edu/claremont/claremontreport08.pdf. 
  8. ^ Ken North, "SQL, NoSQL or SomeSQL?", Dr. Dobb's, Retrieved 2011-11-9.
  9. ^ "Oracle Database in the Cloud", Oracle.com, Retrieved 2011-11-9.
  10. ^ Deploy your database applications and projects on the cloud, IBM.com, Retrieved 2011-9-1
  11. ^ Chris Kanaracus, "Ingres rolls out cloud database offerings", Infoworld.com, Retrieved 2011-8-28.
  12. ^ Chris Kanaracus, "EnterpriseDB Adding New Cloud Option for PostgreSQL Database", PCWorld, retrieved 2011-8-28
  13. ^ "Running MySQL on Amazon EC2 with EBS (Elastic Block Store), Amazon Web Services, retrieved 2011-11-20
  14. ^ Noel Yuhanna, SQL Azure Raises The Bar On Cloud Databases, Forrester, Retrieved 2011-11-9.
  15. ^ "Announcing Heroku PostgreSQL Database Add-on", Heroku Blog, Retrieved 2011-11-9.
  16. ^ "Amazon Machine Images, CouchDB 0.10.x 32 bit Ubuntu", Amazon Web Services, Retrieved 2011-11-10.
  17. ^ "Amazon Machine Image, Hadoop AMI", Amazon Web Services, Retrieved 2011-11-10.
  18. ^ "Setting up Cassandra in the Cloud", Cassandra Wiki, Retrieved 2011-11-10.
  19. ^ "Neo4J in the Cloud", Neo4J Wiki, Retrieved 2011-11-10.
  20. ^ "Announcing Neo4J on Windows Azure", Neo4J Blog, Retrieved 2011-11-10.
  21. ^ "MongoDB on Amazon EC2, MongoDB.org, Retrieved 2011-11-10.
  22. ^ "MongoDB on Azure, MongoDB.org, Retrieved 2011-11-10.
  23. ^ Jeanette Borzo, "Salesforce to Offer 'Cloud' Database", Wall Street Journal, Retrieved 2011-8-28.
  24. ^ "Looking for CouchDB Hosted?", CouchBase, Retrieved 2011-11-10.
  25. ^ "MongoDB Hosting Center", MongoDB.org, Retrieved 2011-11-10.

Wikimedia Foundation. 2010.

Look at other dictionaries:

  • Cloud computing — logical diagram Cloud computing is the delivery of computing as a service rather than a product, whereby shared resources, software, and information are provided to computers and other devices as a utility (like the electricity grid) over a… …   Wikipedia

  • Cloud storage — is a model of networked online storage where data is stored on virtualized pools of storage which are generally hosted by third parties. Hosting companies operate large data centers; and people who require their data to be hosted buy or lease… …   Wikipedia

  • Database — A database is an organized collection of data for one or more purposes, usually in digital form. The data are typically organized to model relevant aspects of reality (for example, the availability of rooms in hotels), in a way that supports… …   Wikipedia

  • Database activity monitoring — (DAM) is a database security technology for monitoring and analyzing database activity that operates independently of the database management system (DBMS) and does not rely on any form of native (DBMS resident) auditing or native logs such as… …   Wikipedia

  • Cloud Creek crater — is an impact crater in Wyoming, United States.[1] The crater is located in Natrona County, about 48 miles northwest of Casper, near the center of a geological feature known as the Casper Arch.[2]:445 The Cloud Creek structure is circular with a… …   Wikipedia

  • Cloud API — Cloud APIs are application programming interfaces (APIs) used to build applications in the cloud computing market. Cloud APIs allow software to request data and computations from one or more services through a direct or indirect interface. Cloud… …   Wikipedia

  • Cloud Atlas (film) — Cloud Atlas Directed by Tom Tykwer The Wachowskis Produced by Tom Tykwer The Wachowskis Stefan Arndt Grant Hill Screenplay by Tom Tykwer The Wachowskis …   Wikipedia

  • Cloud Ten Pictures — (or C10) is a film production and distribution company located in St. Catharines, Ontario, Canada, specializing in Christian themed films. Contents 1 Overview 2 Movies 2.1 Documentaries 2.2 F …   Wikipedia

  • Cloud's Rider —   …   Wikipedia

  • Cloud-to-cloud integration — ( C2I ) allows users to connect disparate cloud computing platforms.[1] While Paas (Platform as a service) and Saas (Software as a service) continue to gain momentum, different vendors have different implementations for cloud computing, e.g.… …   Wikipedia


Share the article and excerpts

Direct link
Do a right-click on the link above
and select “Copy Link”

We are using cookies for the best presentation of our site. Continuing to use this site, you agree with this.