Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [dynamodb]

Amazon DynamoDB is a NoSQL Database featured as a part of the AWS.

Quoting Wikipedia:

Amazon DynamoDB is a fully managed proprietary NoSQL database service that is offered by Amazon.com as part of the Amazon Web Services portfolio. DynamoDB exposes a similar data model and derives its name from Dynamo, but has a different underlying implementation. Dynamo had a multi-master design requiring the client to resolve version conflicts and DynamoDB use synchronous replication across multiple datacenters for high durability and availability.

39 questions
12
votes
1 answer

When to use multiple tables in DynamoDB?

The DyanmoDB best practices make it clear that: You should maintain as few tables as possible in a DynamoDB application. Most well designed applications require only one table. I find it amusing then that just about every single tutorial I've seen…
David Eyk
  • 537
  • 1
  • 5
  • 11
11
votes
2 answers

DynamoDB - Multiple range keys

Is it possible to have multiple fields as range key? Say I have a table where each row is uniquely identified by ------------------------------- A | B | C | D | E | ------------------------------- where A is the primary hash…
Thiyagu
  • 213
  • 1
  • 2
  • 6
7
votes
4 answers

Import CSV or JSON file into DynamoDB

I have 1000 CSV files. Each CSV file is between 1 and 500 MB and is formatted the same way (i.e. same column order). I have a header file for column headers, which match my DynamoDB table's column names. I need to import those files into a DynamoDB…
Franck Dernoncourt
  • 2,083
  • 13
  • 34
  • 52
4
votes
2 answers

Why are some write requests throttled whereas the average consumed write capacity is below the provisioned write capacity?

I see the following graphs in one of my DynamoDB table: Between 2/15 9:30 and 2/15 10:00 some write requests were throttled while the average consumed write capacity was below the provisioned write capacity. How comes?
Franck Dernoncourt
  • 2,083
  • 13
  • 34
  • 52
4
votes
2 answers

Using AWS DynamoDB Geospatial index with Python

Amazon's AWS DynamoDB features Geospatial Indexing, which facilitates geo queries: Query Support: Box queries return items that fall within a pair of geo points that define a rectangle as projected on a sphere. Radius queries return items that…
Adam Matan
  • 12,079
  • 30
  • 82
  • 96
4
votes
2 answers

DynamoDB: searching with primary key or range key, which way is faster?

To those familiar with DynamoDB, I'm trying to make a table where items only have 2 entries. For example, . Most of the time I'll be searching the user_id with a facebook_id on hand. Amazon's DynamoDB only provides the ability to search based on 2…
Xavier_Ex
  • 143
  • 1
  • 1
  • 5
4
votes
1 answer

How can I reuse a table name after deletion (in DynamoDB)?

I am working through a tutorial which requires creating a DynamoDB table with a specific name. On my first pass at creating the table I did something out sync with the tutorial, so I deleted the table with the intention of starting over again.…
Lucas Gonze
  • 171
  • 4
4
votes
1 answer

How should I use DynamoDB table

I have a list of items. Each item is attached to several urls and each url has a score number. So I have something like this : How should I organise this in dynamoDB? How should I format my Json file to update my data? Right now I'm using the first…
Simon Breton
  • 141
  • 2
3
votes
1 answer

Best way to store, query and update 300M rows of data

I'm struggling to find a solution (preferably DBaaS) that I can rely on for storing and querying some 300M rows of data (roughly 100GB). The data in question is pretty much numeric. There is also one "description" column that I would want to perform…
Milovan Zogovic
  • 1,463
  • 3
  • 15
  • 20
3
votes
3 answers

Storing ~700 Tb in SQL Db

I am a newbie to Db's on a whole, and I came across a tutorial, wherein we needed to store ~700 Tb of data over a few years. It was mentioned that scaling SQL for such limits of data is not the best approach, and hence in the tutorial they went…
Sanchay
  • 131
  • 4
2
votes
1 answer

How does an encrypted DynamoDB (the same question applies to RDS as well) query work?

I am trying to understand whether the primary key is encrypted when I choose to encrypt at rest for AWS DynamoDB If the primary key is encrypted, how does a primary-key lookup get performed under the hood? If the primary key is not encrypted,…
chen
  • 121
  • 1
2
votes
1 answer

How to update DynamoDB item by searching on GSI primary key?

Table has these columns on DynamoDB: primaryKey sortKey GSI_primaryKey data And there is GSI added with primary key GSI_primaryKey and sort key on primaryKey How to update column data if I have only the value of the GSI_primaryKey? With NodeJS…
Lukas Liesis
  • 391
  • 4
  • 14
2
votes
0 answers

NoSql - Dynamo db - when do you need multiple tables?

I'm experienced in RDBMS, but new to NoSql. This aws dynamodb design advice says that "most well designed applications require only one table". I'm trying to wrap my head around that. I don't see a useful single-table solution for anything but a…
Elroy Flynn
  • 121
  • 3
2
votes
1 answer

Best way to store a list of numbers where individual numbers can be deleted

I want to store a list of 50 or less nine digit numbers for each primary key in a DynamoDB. Usually I would be using a get request to retrieve the list for a specific primary key. Sometimes I would need to add or delete a number from the list.…
Ben Giles
  • 63
  • 4
2
votes
1 answer

Which AWS database services are designed for storing logging records like log4j or log4perl?

I have been using the file system for log4j and log4perl records and want to start using a database to store the information, especially to lookup records organized by pid. We are using MySQL RDS for most of our databases, so my initial reaction is…
David
  • 23
  • 3
1
2 3