When you use the Table Services API in Windows Azure what is really doing under the hood? I think I read somewhere that this is not using SQL Server. Is it doing a hash table and then filters are really running like map/reduce actions? I'm really new to this stuff and I'm curious to what it is really doing.
A:
If you use SQL Azure, its almost exactly like SQL Server and uses SQL Server under the hood if that's what's required.
see: http://msdn.microsoft.com/en-us/library/ee336241.aspx.
I think you're correct Tables Services isnt SQL Server. From FAQ:
"Windows Azure Table storage is a non-relational, scalable, simple structured storage (ISAM style) in the cloud. Since SQL Azure Database will offer database service for applications developed on Windows Azure, customers can pool these services based on the needs."
Mark Redman
2009-09-08 13:06:50
Table services != sql azure.
Will
2009-09-08 13:14:21
Updated, was thinking maybe the poster was looking for a SQL Server based service?
Mark Redman
2009-09-08 13:15:52
+1
A:
Azure Table Storage uses the EAV model. The Wikipedia page has more information.
The TableStorage examples map to REST calls using ADO.NET Data Services.
Slack
2009-09-21 03:26:37
Any good links to describe what you are talking about? I understand the EAV thing. But how does table storage abstract this away from you?
tyndall
2009-09-22 20:03:58