Cloud Computing

TH22 How do you decide between Relational Database or Table Storage in the Cloud?

08/05/2010

3:15 PM - 4:30 PM

Level: Intermediate

Michael Stiefel

Michael Stiefel

President

Reliable Software, Inc.

When you put data in a computing cloud, the requirements of consistency, availability and partitioning can conflict. This means when building highly available and scalable applications, you may have to give up classic ACID database transactions and relational database features such as foreign keys, joins, and stored procedures. How do you then handle data versioning, and latency? The Microsoft cloud platform gives you two data technologies: Tables and Blobs, and SQL Azure. When do you use one or the other? This talk will talk about how to architect, design, and implement data storage in this new world.

You will learn:

  • The basics of Azure blobs and tables
  • The basics of SQL Azure
  • How to use Azure blobs, tables, and relational databases when appropriate
  • How to use transactions in cloud computing
  • How to partition data in cloud computing