jeudi 5 février 2015

Amazon AWS - DynamoDB - Schema Design

I have a current database with stock quotes in mySQL that I am moving to DynamoDB.


The SQL Schema is something like:



ID (auto incremented INT value)
symbol (GE, PG, IBM, etc)
date (YYYY-MM-DD)
price (80.21)


In DynamoDB, is there any way to create a table without having an attribute similar to ID?


I tried to use a hash-range of symbol-date where symbol is the hash (since there is only one closing price per stock per day), but that did not work.


Must I have a unique value for hash even if I use hash-range?


Aucun commentaire:

Enregistrer un commentaire