We’re rewarding the question askers & reputations are being recalculated! Read more.

Questions tagged [dynamodb]

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

15 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2
votes
0answers
1k views

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 ...
1
vote
0answers
10 views

Dynamo get items from last X days using composite key

I have the following sort key in a dynamo db table: YYYY-MM-DD#<USER_ID>#<CATEGORY_ID> Im trying to solve the following two access patterns: get all item for a user in the last x days ...
1
vote
0answers
27 views

How to implement correctly from SQL to NoSQL (DynamoDB)?

I am just new in NoSQL and DynamoDB. I try to moving from using AWS RDS to DynamoDB. I have table user which can have more than one of work experiences and can have more than one of interest (table ...
1
vote
0answers
38 views

Most effective way of logging user query activity

We are logging and permanently storing all the queries performed about private persons in our database. Due to GDPR we need to be able to show all the entities who have requested personal data and the ...
1
vote
1answer
34 views

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 in rest for AWS DynamoDB If the primary key is encrypted, how does a primary-key look up get performed under ...
1
vote
0answers
30 views

DynamoDB query by flag which tells if it's time to re-process the item

I have a table of stuff and some of it needs to be processed with cron daily or every minute. On SQL table I would add column last_time_processed and save timestamp in it. The query would take rows ...
1
vote
0answers
54 views

DynamoDB how to best perform != query?

Within the key-value, hash-table DynamoDB we can only query for partition keys and optionally for a sorting key. My Question is: If a Table A has items with primary partition attribute aId and I've ...
1
vote
0answers
244 views

most efficient way to deal with real time gps data. S3 vs dynamoDB vs postgres

I have an application that is very write heavy. It saves GPS data every second. The way I handle it at the moment is to store the data locally and upload it to s3 every 5 minutes. The database (...
0
votes
0answers
5 views

Guidance on my NoSQL Schema

I'm working on an application in which I'm in need of a database. I chose NoSQL (DynamoDB) for the app. My Unique ID is set to a user sub but its payload is a list of objects. There are 191 of these ...
0
votes
0answers
45 views

replication type of dynamodb

What is the replication type of the DynamoDB system? Like is it master slave, peer to peer, multi master, or something else. I know that that for global tables, DynamoDB has cross replication with ...
0
votes
0answers
139 views

AWS DMS attribute-type list into DynamoDB?

I'm trying to use AWS DMS (Database Migration Service) to load data from a .csv file stored into S3 to AWS DynamoDB. One of the columns (the last one) in the csv file is a list. Sample data: ...
0
votes
1answer
366 views

Insert into DynamoDB when data has different attributes

Is there any way dynamodb can handle dynamic attributes? Depending on the request, I need to store different web query parameters in the same table. What I want to do is like this, if I make a java ...
0
votes
0answers
76 views

History of the provisioned write capacity in DynamoDB beyond the last two weeks

Is there any way to see the history of the provisioned write capacity for a DynamoDB table beyond the last two weeks? When I go to the Amazon AWS console, select a DynamoDB table and look at the ...
0
votes
0answers
507 views

Column order in a DynamoDB table browsed through RazorSQL

I use RazorSQL to navigate in a DynamoDB database. What's the rationale behind the column order? I am asking as the import tool uses the same order (which means if I import a CSV file it needs to be ...
0
votes
1answer
72 views

After modifying the throughput of a DynamoDB table, where can I see the new throughput value before it gets active?

After modifying the throughput of a table in DynamoDB, the "Modify Throughput" is greyed out: Where can I see the new throughput value before it gets active? Sometimes it takes a while for a ...