SimpleDB

See Also

EC2, RDS, SQS, AS2, Connect to Network, SQL Query, Stored Procedure, MSMQ, FTP, Execute Web Service, SharePoint

Description

Amazon SimpleDB is a web service for running queries on structured data in real time. This service works in close conjunction with Amazon Simple Storage Service (Amazon S3) and Amazon Elastic Compute Cloud (Amazon EC2), collectively providing the ability to store, process and query data sets in the cloud. These services are designed to make web-scale computing easier and more cost-effective for developers.

Amazon SimpleDB is easy to use and provides the core functionality of a database - real-time lookup and simple querying of structured data - without the operational complexity. Amazon SimpleDB requires no schema, automatically indexes your data and provides a simple API for storage and access. This eliminates the administrative burden of data modeling, index maintenance, and performance tuning. Developers gain access to this functionality within Amazon’s proven computing environment, are able to scale instantly, and pay only for what they use.

Action Category

Amazon

Available Activities

The following table briefly describes the available activities for this action arranged in alphabetical order. Click the appropriate link for more details regarding each activity.

Activity
Description

SimpleDB - Create Domain

Creates a new domain. Domains on SimpleDB are simply tables just like spreadsheets containing rows and columns that intersect to create cells.

SimpleDB - Create Session

Creates a unique session which can be used to associate subsequent Amazon SimpleDB steps. This provides a single task the ability to execute numerous SimpleDB operations associated to a specific session.

SimpleDB - Delete Attribute(s)

Deletes one or more attributes associated with the item. If all attributes of an item are deleted, the item is deleted. Similar to columns on a spreadsheet, attributes represent categories of data that can be assigned to items. Similar to rows on a spreadsheet, items represent individual objects that contain one or more value-attribute pairs.

SimpleDB - Delete Domain

Deletes a domain. Any items (and their attributes) in the domain are deleted as well.

SimpleDB - End Session

Ends a SimpleDB session created in a previous step with the use of the Create Session activity.

SimpleDB - Get Attribute(s)

Returns all of the attributes associated with the item and populates a dataset with the results. Optionally, the attributes returned can be limited to one or more specified attribute name parameters.

SimpleDB - Get Domain Metadata

Returns information about the domain, including when the domain was created, the number of items and attributes, and the size of attribute names and values and populates a dataset with the results.

SimpleDB - List Domains

Retrieves a list of domain names and populates a dataset with the results.

SimpleDB - Put Attribute(s)

Creates or replaces attributes in an item.

SimpleDB - Query

Returns a set of attributes for item names that match the Select expression. Select is similar to the standard SQL Query SELECT statement.