March 11, 2014 1 Comment
Eventual Consistency – is a consistency model used in distributed computing that informally guarantees that, if no new updates are made to a given data item, eventually all accesses to that item will return the last updated value.
Denormalized Data – is the process of attempting to optimize the read performance of a database by adding redundant data or by grouping data.
In earlier blog posts I wrote about Windows Azure SQL Database in regards to normalization and about our false perception that all our data is relational. Back then I urged my peers to put their database on a diet and exploit Windows Azure Blob Storage and Windows Azure Table Storage. Recently, I came to new conclusions pulled from the first version of "This Day on #Window Azure". This solution relied entirely on Windows Azure Table Storage and it was doing great until I started to accumulate a moderate amount of data. At this time I realized that my design was drastically flawed as one of my processes was pulling down the entire contents of a table. As the table grew, my solution came to a crawl.