W18 How Do You Decide Between Relational Database or Table Storage in the Cloud?

11/17/2010

3:15 pm - 4:30

Level: Intermediate

Prerequisite: None

Michael Stiefel

Michael Stiefel

President

Reliable Software, Inc.

Michael Stiefel, principal of Reliable Software, Inc. is a consultant on software architecture and development, and the alignment of information technology with business goals. His current work involves: o Distributed application development and implementation such as Software as a Service o Software best practices in Microsoft .NET o Technologies such as Windows Workflow Foundation, Windows Communication Foundation, and SQL Server. o Advising on IT strategy and planning, including budgeting, hiring, and growth management, including the appropriate use of Agile development o Requirements analysis and project planning As a member of an OASIS Technical Committee he helped develop a core SOA Reference Model and related Reference Architectures. He was a Lecturer in the Aeronautics and Astronautics Department at the Massachusetts Institute of Technology where his research and teaching focus was understanding how people build mental models in order to solve problems. As Adjunct faculty, Stiefel has taught graduate and undergraduate software engineering courses at Northeastern University and Framingham State University. Michael Stiefel's education is from Massachusetts Institute of Technology, with a Interdisciplinary Ph.D degree in Nuclear Engineering, Political Science, and History of Technology; M.S. in Nuclear Engineering; and B.S. in Electrical Engineering. He is an active member of the IEEE Consultants Network.

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