Suljettu

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.

EXAMPLE SEARCHES

Search for company

“[login to view URL]”

Results:

[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

etc……

Search for Individual

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

Results

[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

IMPORTANT

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

Taidot: Azure, Tietokannan hallinto, Tietokantaohjelmointi, Microsoft, tietojärjestelmäarkkitehtuuri

Näytä lisää: 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

Tietoa työnantajasta:
( 1 arvostelu ) North Narrabeen, Australia

Projektin tunnus: #19634057

30 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

arhamsoftltd

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 35 päivässä
(102 arvostelua)
8.5
UtopiaInt

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 Lisää

$2500 AUD 40 päivässä
(22 arvostelua)
7.7
mingxiao2008

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 Lisää

$1250 AUD 20 päivässä
(40 arvostelua)
7.1
polarjin2017

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 7 päivässä
(83 arvostelua)
6.6
progcgstar

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 7 päivässä
(28 arvostelua)
6.1
schoudhary1553

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 Lisää

$1300 AUD 10 päivässä
(42 arvostelua)
6.1
julianbagilet

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 Lisää

$1063 AUD 7 päivässä
(8 arvostelua)
5.7
adampohp79

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 Lisää

$1125 AUD 7 päivässä
(31 arvostelua)
5.5
rkmomin

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 Lisää

$1500 AUD 30 päivässä
(22 arvostelua)
5.4
bmartynvw

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 Lisää

$1500 AUD 20 päivässä
(14 arvostelua)
5.6
AdeelAslam4

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 7 päivässä
(8 arvostelua)
5.7
Max01

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 Lisää

$1000 AUD 15 päivässä
(49 arvostelua)
5.2
bluebear1888

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 Lisää

$750 AUD 20 päivässä
(15 arvostelua)
4.3
sanjaybhansali

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 Lisää

$1500 AUD 20 päivässä
(6 arvostelua)
4.4
fivestar10

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 Lisää

$1500 AUD 7 päivässä
(5 arvostelua)
4.2
HKaraarslan

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 Lisää

$1500 AUD 40 päivässä
(3 arvostelua)
4.3
mikeitexpert

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 Lisää

$777 AUD 15 päivässä
(27 arvostelua)
4.5
Victorier006

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 Lisää

$1250 AUD 20 päivässä
(5 arvostelua)
4.4
valiksoin

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 Lisää

$1500 AUD 10 päivässä
(8 arvostelua)
4.0
naishodayo

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 20 päivässä
(1 arvostelu)
3.4