AWS DynamoDB/RDS/Redshift Database Schema Design -- 2

Decide on the best database to use and design the most cost-effective and appropriate database schema based on application needs. We use AWS to host all of our servers and prefer to continue using them for this database but ultimately want to use the best database for the job.

This database will be used to store all compromised user information found on the internet with the key identifier being a users email address. Each hack data inserted into the database may contain different information associated with a user. Similar services include [url removed, login to view] and [url removed, login to view] The following link described how one service did it with Azure. [url removed, login to view]

<b>Database Requirements:</b>

- Ability to scale to billions of rows

- Quickly return results for an email address. (results generated in milliseconds)

- Quickly return all the results for a given email domain. (results generated in milliseconds)

- Store all associated information related to the email address.

- Store lots of unstructured data related to the email address.

- Allow for detailed reporting of certain data points. (What is the most common password, what is the most common email domain, etc)

<b>Normal searches on the database:</b>

1. Search based on a specific email.

2. Search based on a specific email domain.


1. Suggested Database

2. Suggested Database Schema

3. How do we deal with multiple reported hacks on an individual email address? Do we only allow one "database row" for each email address or a new row every time a new hack is discovered? 20% - 30%+ of most emails are duplicates

4. Help setting up the initial database on AWS.

Evner: Amazon Web Services, Big Data Sales, Database Administration, Databaseudvikling, Ingeniørarbejde

Se mere: design database schema, database schema design colleges, database schema design, database schema design store multi language, airline reservation system database schema design, business partner design database, web design database photoshop, design database inventory chemicals, design database private taxi company, design database pedigrees, design database library system netbean, design database access, software design website design database, web page design database excel, design database pocket

Om arbejdsgiveren:
( 21 bedømmelser ) Orem, United States

Projekt ID: #11662248

Tildelt til:


I have extensive experience with Redshift database and I have processed billions of rows. You can find more information of my experience at linkedin by the name Khalid Hussain. [login to view URL] Flere

$250 USD in 3 dage
(0 bedømmelser)

4 freelancere byder i gennemsnit $221 på dette job


I can make your project a great success. I'm 31 year old talented PHP and open-source developer. I have 9 years of experience in Server Administration and Web Application Development. I'm expert in web application cust Flere

$222 USD in 8 dage
(4 bedømmelser)

Hi, We have expertise in amazon web services. We can setup aws ec2, aws s3 and other amazon products with best configuration. We have expert knowledge of below techniques:- 1. EC2 creation modification terminat Flere

$188 USD på 1 dag
(5 bedømmelser)

Hello, Along with my 8 yrs of experience I personally believe that I am good at creating DB schema. May be our further discussion on this can take us some where. I remain available on s.k.y.p.e. e-mails & phone c Flere

$222 USD in 5 dage
(0 bedømmelser)