Aws - SimpleDB

Card Puncher Data Processing

About

SimpleDb is a Nosql database with a web services interface to:

  • create and store multiple data sets,
  • query data and return the results.

It may be used as a time serie database.

Amazon SimpleDB is not storing raw data. It transforms raw data into multiple indices and is then considered to be a column store database.

Pro/Cons

  • SimpleDB requires customers to manage their datasets in containers called Domains, which have a finite capacity in terms of storage (10 GB) and request throughput.
  • Indexes all attributes for each item stored in a domain:
    • pro: Simplifies the schema design and provides query flexibility
    • cons: No predictability particularly as dataset sizes grow.
      • No write predictability: every database write needs to update all attribute indices (regardless of whether the customer is using all the indices for querying).
      • No read predictability: working set does not always fit in memory.

Documentation





Discover More
Card Puncher Data Processing
Aws - DynamoDB

Amazon implementation inspired by dynamo Amazon DynamoDB is a nosql database that store its data as a key/value. DynamoDB was introduced to address the limitations of SimpleDB DynamoDb combine the...
Columnar Physical Table Representation
Database - Column Oriented (Storage|Store)

Storing data in columns is functionally similar to having a built-in index for each column. This data structure is used in analytics and NoSql database. Columnar storage is a popular data structure in...
Time Serie - Database

Time Serie Database. Tags allow users to add 1 to n additional dimensions to their metrics in the form of key value pairs. Relational databases can be used to store and analyze time series data,...



Share this page:
Follow us:
Task Runner