SQL Server Data Services: Microsoft's Answer to Amazon S3
SSDS you can think of as a structured data store in the cloud(building block service), which is accessed using Internet protocols using a basic data manipulation language. SSDS is for developers and businesses that need scalable, easily programmable, and cost-effective data storage with robust database query capabilities.
The SQL Server Data Services offer a flexible data model, which is structured as follows: Customer > Account > Authority > Container > Entity. Customers are companies or individuals that use SSDS. Each customer might open an arbitrary amount of accounts, which is connected with a unique Windows Live Id. Authorities are a concept analogous to namespaces, and are a in the context of billing and geo-location. Containers are a unit of consistency, defining boundaries for search and update operations. The smallest and fundamental data unit is the entity.
Neil Hudson describes this fundamental data unit as "a Flexible Entity Model, where no schema required and you can update name/value pairs (which is the smallest unit of storage)". The name/value pairs represent properties, whose type information can be changed on the fly. Properties maybe added at any time. SSDS supports "simple types such as decimal, string, bool, etc and all the properties are indexed".
Data can be accessed and altered in many ways:
- Microsoft Sync Framework (offline access)
- ADO.NET Data Services
Data can be manipulated by CRUD operations on authorities, containers, and entities. Queries can be executed based on a text base query language, whose syntax follows the LINQ pattern for C#.
Regarding the predominance of Amazon S3 on the web storage market Robert Scoble said:
It’s almost too late for the others to get into the game [of data storage on the web]. It’s amazing (or maybe it should be “amazoning”) to me that Ray Ozzie over at Microsoft has let Amazon have so much runway.
According to Jamie Thomson nothing's carved in stone, yet:
Can [Microsoft] stop Amazon? Who knows, it might slow them down a bit (when SSDS finally gets released - it hasn't even reached beta yet) but Amazon are already miles and miles ahead with this. Having said that, its difficult to know how far Amazon have got into the enterprise data storage market and that will be Microsoft's key battleground.
WS computer cloud and S3 surpassed the usage of all of Amazon.com's global
an interesting piece of information came out yesterday on the Seattle Times. Brier Dudley reported that:
Bandwidth usage by the AWS computer cloud and S3 storage services during the fourth quarter of 2007 surpassed the usage of all of Amazon.com's global Web sites. That's during the holiday shopping season.
If anyone doubt that this is real, this is yet another piece of evidence.
Good to have some competition
I really like these features of SSDS that SimpleDB is lacking
- Support for simple types: string, numeric, datetime, boolean
- Query language supports the retrieval of complete entities
- Use the same service interfaces for your storage needs at any scale (SimpleDB vs S3)
AWS outage notwithstanding the future is very "cloudy"
Mike Amundsen May 29, 2015
Ben Linders May 28, 2015