Database and query approach for big data email collection

Looking for someone whom can help develop the database schema and approach on Azure.

Project to capture and query emails in a database, we are only interested in whom is in contact with who, not the subject or content of the emails.

We are not looking for implementation, we are looking to get a recommendation on platform and database schema we would need as well as the user interface to query.

We need to store approximately 1,000,000 emails a month in a database from a companies exchange email platform. We have a way to extract the information from Exchange, but not a view on the database or tables required.

The database will need to be structured so queries display as follows:

If an email domain is queried it will show the people at that email domain whom have been in contact with our organisation. The result should be a summarised view from the most engaged email address to/from in the last 12 months to the least.

If an email address is then queried a list of the most recent contacts from our organisation from most contacted in the last 12 month to least most contacted would be displayed.

So a rolling record of emails between parties will be necessary

Special cases

Ability to have a restricted list : users within our company, recipients at a company and entire companies should not be returned in the results, this list should be editable.

The ability to have internal users allocated to groups and then only allow people to search their groups or allow other people to search a combination or all groups

It will need to run on Microsoft Azure infrastructure

Need to have a query and display mechanism for the results to staff whom have access

It will need a recommendation on a reasonable user interface for the query.


Search for company

“[login to view URL]”


[login to view URL]@[login to view URL] 120 engagements

[login to view URL]@[login to view URL] 112 engagements

[login to view URL]@[login to view URL] 110 engagements

[login to view URL]@[login to view URL] 87 engagements

[login to view URL]@[login to view URL] 81 engagements


Search for Individual

“ [login to view URL]@[login to view URL]”


[login to view URL]@[login to view URL] 120 engagements

People in my organisation whom have contacted:

[login to view URL]@[login to view URL] 59 engagements

[login to view URL]@[login to view URL] 41 engagements

[login to view URL]@[login to view URL] 20 engagements


To be considered for this assignment, your proposal needs to cover what experience you have with large datasets.

Habilidades: Azure, Administração de Bancos de Dados, Programação de Banco de Dados, Microsoft, Arquitetura de software

Veja mais: difference between structured and unstructured data with example, unstructured data vs structured data, relational database, database management system, best big data databases, types of database, examples of structured data, unstructured data in big data

Acerca do Empregador:
( 1 comentário ) North Narrabeen, Australia

ID do Projeto: #19634057

29 freelancers estão ofertando em média $1256 para esse trabalho


Hi, I can right a database script to get query emails in a database. It can be done with keyword checks. I have extesnive experience with large and elaborate data sets. Let's chat to get started Regards FA

$1500 AUD in 35 dias
(103 Comentários)

Hello - My name is Arvin. I’ve read your brief description and we can build the application you are looking for. We have extensive experience in gathering, normalising, querying and visualising big datasets. We have Mais

$2500 AUD in 40 dias
(22 Comentários)

Hello, Dear How are you? My name is Sundong. I have read your project description and am ready for discussing with you about project. I have experienced in developing Azure, Database Administration, Database Progr Mais

$1250 AUD in 20 dias
(41 Comentários)

Hello? I've seen your project details. I have a good skills in python, php, c# and vb.net. I think we can build the script or app by one of them. I can help you if you are interesting me. Thanks.

$1125 AUD in 7 dias
(85 Comentários)

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl Mais

$1300 AUD in 10 dias
(43 Comentários)

HI. As a web/mobile/desktop expert, I have experience with Azure as well. I can finish your project wonderfully. Please let me know your deadline and budget. Thanks.

$1500 AUD in 7 dias
(30 Comentários)

Hi there, We’re experts developers, having 10+ years experience developed 800+ websites/systems. Not only that, we’re also UI designers (FULL STACK). We have checked yours requirements and we’re available to work FAS Mais

$1063 AUD in 7 dias
(8 Comentários)

Hi. thanks for your posting. I'm very happy to have a chance of bidding your project. I have experience in development of the projects like yours If you hire me, I'll do my best for your project and finish greatly in a Mais

$1125 AUD in 7 dias
(31 Comentários)

Hello I have read the project detail. You want a email solution application for Microsoft Azure. We ca help you to build a application and deploy on Microsoft Azure. Please contact me on chat for more discussion. Thank Mais

$1500 AUD in 30 dias
(22 Comentários)

Hi, My name is Benjamin. I'm a database architect with over 9 years of experience. I have worked on a similar requirement, based on Exchange Online, where email ID data accumulated had to be summarized for analysis Mais

$1500 AUD in 20 dias
(16 Comentários)

Hi there, For this task, I'll connect you with my CTO. He'll first help you out with the platform selection & then if you need we can also implement it. I look forward to hear from you. Regards, Adeel

$1125 AUD in 7 dias
(8 Comentários)

Hello I read the description that you need help in develop the database schema and approach on [login to view URL] have strong skills in Azure, Database Administration, Database Programming, Microsoft, Software Architecture al Mais

$1000 AUD in 15 dias
(50 Comentários)

hello,how are you.i read your bid carefully. i am java/javafx expert and have full experience for 12 years. java/javafx is my top skill and passision. i can provide most quality and high speed. if you want to succe Mais

$1250 AUD in 20 dias
(9 Comentários)

Hello, Handling a total 12M e-mails won't seem a problem for Ms Sql db. However, querying on that amount of raw data will be slow if the data isn't indexed. In my opinion, you need a special indexing application that i Mais

$1500 AUD in 40 dias
(3 Comentários)

hello sir first you check my review so that you can understand .. i have ready this project i can show you demo i have 9 year experience in asp.net c# mvc web and window development I have read your requirem Mais

$1500 AUD in 20 dias
(6 Comentários)

I am web and app program Expert who knows the value of time, very hard working and always delivers the work on time. My Motive is to make my employer to feel the greatest satisfaction with low price. If you want to dev Mais

$750 AUD in 20 dias
(17 Comentários)

Hi. Thanks for reading my review once. Please give me a chance and then you will not disappoint about it. I am a new freelancer on freelancer.com, but I am a full stack developer with high skills. And I perfectly deal Mais

$1500 AUD in 10 dias
(14 Comentários)

Dear Employer, I have extensive experience in developing database schemas and apply all kinds of algorithms. I can perform any type of data analysis as per your request. Please let me know if you are interest Mais

$777 AUD in 15 dias
(29 Comentários)

Dear sir. I have read your description with great interest. I have experiences with lots of project. Also I am able to finish the task in time. If you send me a message, we can discuss more. I am waiting for your r Mais

$1500 AUD in 7 dias
(5 Comentários)

Hi,dear. I am a senior software developer. I have just checked your project description, I am able to complete this project. I am looking forward to your proposal. Thanks.

$1250 AUD in 20 dias
(3 Comentários)