Definition
Amazon SimpleDB is a managed, highly available, schema‑less NoSQL data storage service provided by Amazon Web Services (AWS). It allows developers to store and retrieve structured data using a simple API based on attribute‑value pairs, without the need to manage underlying database infrastructure.
Overview
Launched in 2007, SimpleDB was one of AWS’s early data storage offerings, positioned as a lightweight alternative to relational databases and more complex NoSQL systems. The service automatically handles data replication across multiple servers and data centers to achieve fault tolerance and high availability. Clients interact with SimpleDB via HTTP requests, using either the AWS SDKs or the RESTful API. Data is organized into domains (analogous to tables), each containing items identified by a unique primary key, with each item composed of a set of attributes that can hold multiple string values.
SimpleDB’s design emphasizes simplicity and automatic scaling for modest workloads. It does not provide features such as advanced query languages, joins, or strong consistency guarantees; instead, it offers eventual consistency and a limited query capability based on attribute selection and range conditions. As of the early 2020s, Amazon encourages new projects to consider Amazon DynamoDB, which supersedes SimpleDB in performance and feature set, though SimpleDB remains available for legacy applications.
Etymology/Origin
The name “SimpleDB” reflects the service’s intent to provide a “simple” database solution. “DB” is a common abbreviation for “database.” The prefix “Amazon” denotes its affiliation with Amazon.com’s cloud computing division, AWS.
Characteristics
| Characteristic | Description |
|---|---|
| Data Model | Schema‑less, attribute‑value store; items are identified by a primary key. |
| Consistency Model | Eventual consistency for read operations; writes are propagated asynchronously across replicas. |
| Scalability | Automatic horizontal scaling; capacity limits are defined by the number of domains and items per domain. |
| Availability | Data is replicated across multiple physical locations within an AWS region. |
| Query Interface | Simple query language supporting attribute selection, comparison operators, and range queries; no support for joins or complex transactions. |
| Access Methods | RESTful HTTP API; SDKs available for major programming languages (Java, .NET, Python, Ruby, etc.). |
| Pricing | Charged based on data storage (GB‑months), data transfer, and request count (reads/writes). |
| Security | Integration with AWS Identity and Access Management (IAM) for authentication and permission control; supports SSL/TLS encryption for data in transit. |
Related Topics
- Amazon DynamoDB – A more feature‑rich, high‑performance NoSQL database service that has largely superseded SimpleDB for new development.
- Amazon S3 (Simple Storage Service) – Object storage service often used alongside SimpleDB for storing large binary assets.
- NoSQL Databases – A class of databases that store data without requiring a fixed schema, including key‑value stores, document stores, and wide‑column stores.
- AWS Identity and Access Management (IAM) – Service for managing user authentication and authorization across AWS resources, including SimpleDB.
- Eventual Consistency – Consistency model employed by many distributed storage systems, where updates propagate gradually to all replicas.
Note: As of the latest publicly available AWS documentation, Amazon SimpleDB remains a supported service but is considered legacy relative to newer offerings such as Amazon DynamoDB.