1.02k likes | 2.49k Views
Cloud Databases. Matt Gregg Bob Guidinger. Cloud 101. What do we mean by Cloud Databases? Why do we have them? Alternative to IT infrastructure investment (pay-as-you-go) Analytical Usage: Data warehousing, data mining (read-intensive)
E N D
Cloud Databases Matt Gregg Bob Guidinger
Cloud 101 • What do we mean by Cloud Databases? • Why do we have them? • Alternative to IT infrastructure investment(pay-as-you-go) • Analytical Usage: Data warehousing, data mining (read-intensive) • Huge, fast storage, grid computing, virtualization, N-tier architecture, robust networks. • Elasticity, scalability, high availability, price-per-usage and multi-tenancy (fault tolerance) • Access anywhere, at any time, from any device
Types • Cloud Storage • Files stored in the cloud • iCloud, Dropbox, etc. • Data as a Service (DaaS) • Data stored in the cloud • Backups • Database as a Service (DBaaS) • Data stored in the cloud • Full database management functionality • Common names • Amazon SimpleDB, Amazon RDS, Google BigTable, Yahoo Sherpa and Microsoft SQL Azure Database
Storage Architectures • Shared-nothing • Splits the data into independent sets stored physically on different servers • Easily scalable • Difficult to maintain in cloud with data partitioning (shipping latency) • Ex. Oracle, Hadoop, Amazon’s Simple DB • Shared-disk • Data stored on a SAN or NAS • Fewer, low-cost servers • Easy to virtualize • Access to all data
Challenges for Cloud Databases • ACID vs. BASE (Basically Available, Soft state, Eventually consistent) • Transaction processing • Data Consistency/Integrity • Database Security/Privacy • Analytical Processing Challenges • Developing Scalability • Querying a distributed database • Vender portability • Heterogeneous
Cloud Database Providers • Note: These are managed database services. • SQL Services • Amazon Rel. Database Service, Clustrix, EnterpriseDBPostgreSQL, Google Cloud, HP Cloud Rel. DB, IBM SmartCloud, Microsoft SQL Azure, Oracle DB Cloud, Xeround • NoSQL Services • Amazon DynamoDB, Amazon ElastiCache, Cloudant, Database.com, Microsoft Azure Table Storage, MongoHQ
Summary • Changing use of Databases • Benefits • Elastic, scalable, cheap, fault tolerant, access anywhere • Cloud Storage, DaaS, DBaaS • Shared Nothing vs. Shared Disk • BASE
References • Arora, Indu, and Anu Gupta. "Cloud Databases: A Paradigm Shift in Databases.” International Journal of Computer Science Issues. 9.4 (2012): 77-83. Web. 22 Apr. 2013. <http://ijcsi.org/papers/IJCSI-9-4-3-77-83.pdf>. • Harris, Derrick. "Cloud databases 101: Who builds ‘em and what they do." GIGOM. N.p., 20 JULY 2012. Web. 22 Apr 2013. <http://gigaom.com/2012/07/20/cloud-databases-101-who-builds-em-and-what-they-do/>. • Bridgwater, Adrian. "Cloud databases: are lazy developers cutting corners?." Cloud Pro, 13 MAR 2013. Web. 22 Apr. 2013. <http://www.cloudpro.co.uk/adrian-bridgwater/5378/cloud-databases-are-lazy-developers-cutting-corners>.