This post is part of a series of posts that aims to capture a number of emerging design patterns for the Windows Azure Platform. This series will begin with emerging design patterns for Windows Azure Table storage. The Chronological Query Pattern aims to support queries that must return data in chronological or reverse chronological order. Example Looking at a standard example of blog data, stored as: PartitionKey (User) RowKey Titl ... [Read more]

This post is part of a series of posts that aims to capture a number of emerging design patterns for the Windows Azure Platform. This series will begin by tackling emerging design patterns for Windows Azure Table storage. The Starts With Query Pattern enables performance optimised begins with partial match operations. Example Provide a fast search for articles that begins with the term “Metabolis” from a list of article titles, such as those found on Wikipedia. A subset is shown below: Me ... [Read more]

This post is part of a series of posts that aims to capture a number of emerging design patterns for the Windows Azure Platform. This series will begin by tackling emerging design patterns for Windows Azure Table storage. The Transactional Master-Item Record Pattern ensures that modifications to a master record and its item records are performed in a transactional way. Example Changes to an expense record with expense line items is an set of data that needs to be managed in a transaction w ... [Read more]

This post is part of a series of posts that aims to capture a number of emerging design patterns for the Windows Azure Platform. This series will begin with emerging design patterns for Windows Azure Table storage. The Table Name Key Pattern enables the key for an entity to be extended beyond the partition key and row key, to provide faster querying or deletion/archiving. Example Data with short lifetime such as log or diagnostic data or temporary working sets, are generally only needed fo ... [Read more]

The Hash Partitioning Pattern aims to improve the performance of parallel and batch queries. Example As part of the pre-processing done for Wikipedia Explorer, the HTML/XML representation of a Wikipedia page is converted in to a set of POCO objects and the incoming and outbound links are analysed. The core data is stored in a Windows Azure Table and is used when pre-processing a page, which is a massively CPU intensive operation. As optimisations this work is done in parallel and is also fo ... [Read more]

As a little treat for the developers and customers at Dot Net Solutions we’re buying a new coffee machine. We’re a pretty diverse bunch: several people have coffee machines at home and have emotional attachments to different brands, and there are tea drinkers who may be served adequately by some of the choices, or not at all by others. Not dissimilar from the situation some of our customers are in when agreeing features for a new software system. When evaluating competing architectures for a ... [Read more]