Amazon AWS – SimpleDB – simple NoSQL

Basic information about Amazon SimpleDB Service:

AWS Free Tier availability:

Developer Resources:

Functionality:

data-sets organized into domains (vs. tables in relational DB’s)
Domains are collections of items that are described by attribute-value pairs
automatically creates an index for every field in a domain
no need to pre-define a schema
scale-out by creating new domains on different instances
stores multiple geographically distributed copies of each domain to enable high availability and data durability.
a successful write (using PutAttributes, BatchPutAttributes, DeleteAttributes, BatchDeleteAttributes, CreateDomain or DeleteDomain) means that all copies of the domain will durably persist
by default, GetAttributes and Select perform an eventually consistent read (details below).
- a consistent read can potentially incur higher latency and lower read throughput therefore it is best to use it only when an application scenario mandates that a read operation absolutely needs to read all writes that received a successful response prior to that read. For all other scenarios the default eventually consistent read will yield the best performance.
allows specifying consistency settings for each individual read request, so the same application could have disparate parts following different consistency settings.
currently enables domains to grow up to 10 GB each
initial allocation of domains is limited to 250

API Summary:

CreateDomain — Create a domain that contains your dataset.
DeleteDomain — Delete a domain.
ListDomains — List all domains.
DomainMetadata — Retrieve information about creation time for the domain, storage information both as counts of item names and attributes, as well as total size in bytes.
PutAttributes — Add or update an item and its attributes, or add attribute-value pairs to items that exist already. Items are automatically indexed as they are received.
BatchPutAttributes — For greater overall throughput of bulk writes, perform up to 25 PutAttribute operations in a single call.
DeleteAttributes — Delete an item, an attribute, or an attribute value.
BatchDeleteAttributes — For greater overall throughput of bulk deletes, perform up to 25 DeleteAttributes operations in a single call.
GetAttributes — Retrieve an item and all or a subset of its attributes and values.
Select — Query the data set in the familiar, “select target from domain_name where query_expression” syntax. Supported value tests are: =, !=, <, > <=, >=, like, not like, between, is null, is not null, and every (). Example: select * from mydomain where every(keyword) = ‘Book’. Order results using the SORT operator, and count items that meet the condition(s) specified by the predicate(s) in a query using the Count operator.

Consistency Options:

Eventually Consistent Reads (Default) — the eventual consistency option maximizes read performance (in terms of low latency and high throughput). However, an eventually consistent read (using Select or GetAttributes) might not reflect the results of a recently completed write (using PutAttributes, BatchPutAttributes, DeleteAttributes, BatchDeleteAttributes). Consistency across all copies of data is usually reached within a second; repeating a read after a short time should return the updated data.
Consistent Reads — in addition to eventual consistency, SimpleDB also gives flexibility to request a consistent read if your application, or an element of your application, requires it. A consistent read (using Select or GetAttributes with ConsistentRead=true) returns a result that reflects all writes that received a successful response prior to the read.

Transactions:

Conditional Puts/Deletes — enable to insert, replace, or delete values for one or more attributes of an item if the existing value of an attribute matches the value specified. If the value does not match or is not present, the update is rejected. Conditional Puts/Deletes are useful for preventing lost updates when different sources write concurrently to the same item.
- Conditional puts and deletes are exposed via the PutAttributes and DeleteAttributes APIs by specifying an optional condition with an expected value.
- For example, if the application is reserving seats or selling tickets to an event, you might allow a purchase (i.e., write update) only if the specified seat was still available (the optional condition). These semantics can also be used to implement functionality such as counters, inserting an item only if it does not already exist, and optimistic concurrency control (OCC). An application can implement OCC by maintaining a version number (or a timestamp) attribute as part of an item and by performing a conditional put/delete based on the value of this version number

Limits:

Domain size: 10 GB per domain, 1 billion attributes per domain
Domain name: 3-255 characters (a-z, A-Z, 0-9, ‘_’, ‘-‘, and ‘.’)
Domains per account: 250
Attribute name-value pairs per item: 256
Attribute name length: 1024 bytes
Attribute value length: 1024 bytes
Item name length: 1024 bytes
Attribute name, attribute value, and item name allowed characters: All UTF-8 characters that are valid in XML documents. Control characters and any sequences that are not valid in XML are returned Base64-encoded. For more information, seeWorking with XML-Restricted Characters.
Attributes per PutAttributes operation: 256
Attributes requested per Select operation: 256
Items per BatchDeleteAttributes operation: 25
Items per BatchPutAttributes operation: 25
Maximum items in Select response: 2500
Maximum query execution time: 5 seconds
Maximum number of unique attributes per Select expression: 20
Maximum number of comparisons per Select expression: 20
Maximum response size for Select: 1MB

Resources:

mariuszprzydatek.com