User Id :    Password :      New Member   Forgot Password
 
Windows Azure Table Storage in detail
Description Windows Azure table storage provides two kind of storage 1) SQL Azure and other one is 2) Table,queue,blob and other storage like drives etc. In this blog post I am going to explain Table storage in details.   No. of Views     1466
  Rating     0
Author Jalpesh Vadgama   Posted On     08 Sep 2011
Tags ADO.NET,Windows Azure    

Sample Code   Download Code

Windows Azure table storage provides two kind of storage 1) SQL Azure and other one is 2) Table,queue,blob and other storage like drives etc. In this blog post I am going to explain Table storage in details.
What is Windows Azure Table Storage:

Windows Azure table storage is a service provided by Azure platform to store data in form relational tables in windows azure storage instead of normal RDBMS System. It is a structured storage provided by Azure platform. The table storage which you create with windows azure is Unique. An account of windows azure can have any number of table storage.
Table Storage in details:

There are three important aspects when you deal with windows azure table services. Table,Entities and Properties. Here table is similar to storing data in spread sheet or storing in table with relational databases. Entity represents particular row in the table and property represents a particular column or cell in row. There are three system properties of each entity.

   1. Partition Key
   2. Row Key
   3. Time Stamp

Partition Key:

The partition key is a unique key value that is used to group, or partition, related data on same storage node. As we all know that internally data will stored in hard disks in table storage so whenever your data grows then at that time your data may be partitioned into multiple hard drives. At that time this partition key will keep all the data on the same storage nodes. So partition key is used to organize data in storage.
Row Key:

Row key uniquely identifies a specific entities on a partition. Different partition keys may share the same row key, but the same partition may not have two entities with the same row key.The Row Key property is optional and may also be an empty string if all that is needed for uniqueness is the Partition Key value

The PartitionKey and RowKey properties both have String values (up to 1KB in size) and together they form a unique primary key for an entity in a table.
TimeStamp:

Time stamp property has a DateTime value maintained by the Windows Azure Table System to facilitate optimistic concurrency.
Column Types in Table Storage:

Table storage in windows azure support following types of columns.

   1. byte[]
   2. bool
   3. DateTime
   4. double
   5. Guid
   6. Int32 or Int
   7. Int64 or long
   8. String.

In next post I will create application for table storage. That’s it. Hope you like it. Stay tuned for more.. Till then happy programming..

 

About Author

About Author I am jalpesh vadgama an Microsoft MVP for Visual C# and BrainBench Certified ASP.NET Developer having more then 5 years of experience in .NET Technology.Please feel free to contact me for any queries via posting comments on my blog I will try to reply as early as possible. Please also visit my blog at http://jalpesh.blogspot.com/ Jalpesh Vadgama
No Photo
 
Country India
Company N/A
Home Page http://jalpesh.blogspot.com/

Rate this article

Rating options from poor, fair, good, very good to excelent.  
 

Comments

     
Write your comment here.  
Comment
Verification Code   
  
    
 
Section sponsored by