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.

Habilidades: Amazon Web Services, Big Data Sales, Administração de Bancos de Dados, Desenvolvimento de Banco de Dados, Engenharia

Veja mais: 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

Acerca do Empregador:
( 21 comentários ) Orem, United States

ID do Projeto: #11662248

Concedido a:


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] Mais

$250 USD em 3 dias
(0 Comentários)

4 freelancers estão ofertando em média $221 para esse trabalho


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 Mais

$222 USD in 8 dias
(4 Comentários)

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 Mais

$188 USD em 1 dia
(5 Comentários)

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 Mais

$222 USD in 5 dias
(0 Comentários)