Solve mongoDB aggregation pipeline task

I need someone who helps me to create a mongoDB aggregation pipline. I tried on myself, but mongoDB is new to me and writing brackets drives me crazy. So please - mongo gurus to the rescue!

Find my attached data example with three records. Please really read it before bidding! I won´t accept bids that came a minute after posting the job.

The real database has now about 60.000 image records, but will soon have many hundred-thousands more. The collection is "images" and each image has many embedded "annotations".

Annotations were made by internal staff members as well as external freelancers. The annotations of internal staff people are my ground truth for the comparison of the work of freelancers.

I am collecting a "small amount" ~ 2000 -5000 annotations from internal users, to create a "ground truth sample". Having this, i want to compare the results of external freelancers (which will annotate the entire database) with the results from the internals to have a guess about the visual analysis ability of each external freelancer.

In the first record, the image was annotated by user1@[login to view URL] and two external users user1@[login to view URL] and

So, basically i need to check, if the image and its requested image feature was annotated the same way from the internal (master) and the external freelancer or differently. This needs to be expressed in some kind of a correlation value, or really simple, a percentage hitrate. I think the best would be to just receive an appropriate counter.

I wanted to solve this with an aggregation pipeline, but i am stuck in all these matches, filters, projections and groupings. I am working on a Rails app using the mongoid gem, but i am fine with the mongo shell script as a result. I want to create a function in my app and send the user and the feature as parameters.

For someone good in mongo, this should be a matter of few hours only.

Please check the attached files and when you are answering to my job post, please return the 4 magick words in the first line of the file [login to view URL]

Looking forward your bids!

Taidot: NoSQL Couch & Mongo

Näytä lisää: mongodb aggregation pipeline examples, mongodb aggregate match in array, mongodb aggregation operators, mongodb aggregation pipeline project, mongodb aggregation each, mongodb aggregation pipeline performance, mongodb aggregate count, mongodb aggregate array, sabre script - 08/06/2017 03:13 EDT, I would like to hire a CSS Designer - 16/06/2017 00:45 EDT, I would like to hire a CSS Designer - 16/06/2017 00:48 EDT, Design a T-Shirt - 14/06/2017 18:13 EDT , Powerpoint help - 08/06/2017 16:39 EDT, Get Data Entry Done - 04/06/2017 02:56 EDT, Get a Website Built -03/06/2017 03:18 EDT, Get a Website Built - 17/01/2017 02:14 EST, freelance df 01 06 2016, hq gen audit pp 06 2013 14 lm date 23.02 2015, http://elliottyoungcouk/2014/01/06/the-pros-and-cons-of-closed-source-software/, mongodb api aggregation

Tietoa työnantajasta:
( 11 arvostelua ) Hamburg, Germany

Projektin tunnus: #17089452

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


Hi, nice to meet you. Having experience of Mongo, I can do what you want. Let's discuss about your project with chat. Thanks.

€200 EUR 3 päivässä
(0 arvostelua)
€250 EUR 3 päivässä
(0 arvostelua)