Find Jobs
Hire Freelancers

Help designing a simple but scalable DynamoDB

$10-30 USD

Completed
Posted over 3 years ago

$10-30 USD

Paid on delivery
This is not a project per se, it's more an of questions for a project I am working on. I am designing a DynamoDB table that contains domain names (e.g: [login to view URL]) that were registered recently. This table must be updated once a day and usually grows at 100.000 to 200.000 records a day, grows at approximately 3 to 4 million records per month or up to 50 million records per year. I only have the following two attributes: * domain_name: This consists of the domain name, (e.g: [login to view URL], [login to view URL]). These values are MOSTLY unique however a domain name can expire and be registered again after one of a few years. * registration_date: This consists of the domain registration date (e.g: dd-mm-yyyy or 06-09-2020). These values are NOT unique. All domains inserted in the same day should have the same registration date. I need to conduct a lot of reading queries to this table and get results VERY FAST. I should be able to get all records between a date which can be millions. E.g: all records over the last 90 days. Questions to be answered. 1) What would be the best design strategy for this? OLAP vs OLTP? 2) Is the DynamoDB the right choice for a scalable and very fast database? 3) How this table should be designed? What must be the Primary/Sort key? 4) Since there a lot of users conducting the same results should DAX be advisable? 5) How can I build something can scales in performance but the AWS costs don't scale in the same proportion? Please feel free to share any other thoughts but please do not submit any answers before being accepted as the bidder, this will not make you the winning bidder.
Project ID: 27257530

About the project

3 proposals
Remote project
Active 4 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
AWS certified developer here, ping me in the chat and let's have a zoom call. I will answer all your queries regarding the dynamoDB (with the mentioned 5 as well). I will also provide you some metrices/reference to have a look upon. Ping me 'Hi' to get started. Thanks Shashank
$30 USD in 1 day
5.0 (2 reviews)
2.7
2.7
3 freelancers are bidding on average $28 USD for this job
User Avatar
I will do your work with 100% precision and your project i completed in 30 dollar . I am very kind and honest . share me the details of the work i am now ready to do your work.
$30 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of MOZAMBIQUE
Maputo, Mozambique
5.0
11
Member since Sep 17, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.