2020/11/16 CMPUT 291 (LEC A1 A2 EA1 EA2 Fall 2020): Mini-project 2 spec
Clarifications:
CMPUT291 – Fall 2020 Mini Project II
(group project)
Due: Nov 25th at 5pm
You are responsible for monitoring the course discussion forum in eclass and this section of the project specification for more details or clarifications. No clarification will be posted after 5pm on Nov 23rd.
Introduction
The goal of this project is to teach the concept of working with data stored in files and NoSQL databases. This is done by building and operating on a document store, using MongoDB. Your job in this project is to write programs that store data in MongoDB and provide basic functions for searches and updates. 80% of the project mark would be assigned to your implementation, which would be assessed in a demo session, and is further broken down to two phases with 10% of the mark allocated for Phase 1 and 70% for Phase 2. Another 15% of the mark will be assigned for the documentation and quality of your source code and for your design document. 5% of the mark is assigned for your project task break-down and your group coordination.
Group work policy
You will be doing this project with one or two other partner from the 291 class. Register your group at the group registration page for mini-project 2. It is assumed that all group members contribute somewhat equally to the project, hence they would receive the same mark. In case of difficulties within a group and when a partner is not lifting his/her weight, make sure to document all your contributions. If there is a break-up, each group member will get credit only for his/her portion of the work completed (losing the mark for any work either not completed or completed by the partner). For the same reason, a break-up should be your last resort.
Task
You are given three json files named as Posts.json, Tags.json and Votes.json, which you will use to construct your collections in MongoDB. Here is a small sample of Posts.json, Tags.json and Votes.json (download and save them locally). The data includes posts made to stack exchange sites (including stack overflow). Your job is to create MongoDB collections, following Phase 1, and support searches and updates in Phases 2.
https://eclass.srv.ualberta.ca/mod/page/view.php?id=4329176
1/3
ot deen lliw yeht ,2 traP rof margorp rieht fo trap sa oslA .snoitautcnup ro/dna secaps etihw yb detarapes era smret taht dna ,gnirts retcarahc ciremunahpla na si mret a emussA .smret esoht no xedni na dliub dna ,noitcelloc stsoP ot smret deman yarra na sa smret esoht dda ,stsoP fo sdlefi ydob dna eltit ni erom ro sretcarahc 3 htgnel fo smret lla tcartxe ot ,1 esahP rof margorp rieht fo trap sa ,deen lliw 3 ezis fo spuorG
.srehto naht sdlefi ssel ro erom evah sdrocer emos dna dexfi ton era drocer a fo sdlefi eht ,atad elpmas eht ni eciton yam uoy sA .snoitcelloc eseht gnidliub retfa sdne esahp siht rof margorp ruoY .snoitcelloc wen etaerc dna meht pord dluohs margorp ruoy ,tsixe snoitcelloc esoht fI .nosj.setoV dna nosj.sgaT ,nosj.stsoP rof ylevitcepser setoV dna sgaT ,stsoP deman snoitcelloc eerht etaerc lliw neht margorp ruoY .)tsixe ton seod ti fi( bd192 deman esabatad a etaerc lliw dna revres eht ot tcennoc lliw ,gninnur si revres BDognoM eht hcihw rednu rebmun trop a tupni sa ekat lliw margorp ruoY .hcae rof noitcelloc a stcurtsnoc dna yrotcerid tnerruc eht ni )evoba deman sa( selfi nosj eerht eht sdaer taht margorp a etirW
ceps 2 tcejorp-iniM / rebmevoN 8 – rebmevoN 2 / )0202 llaF 2AE 1AE 2A 1A CEL( 192 TUPMC / sesruoc yM / draobhsaD )0202 llaF( tnemeganaM esabataD dna eliF – 192 TUPMC
erots tnemucod a gnidliuB :1 esahP
ceps 2 tcejorp-iniM
.enoN
2020/11/16 CMPUT 291 (LEC A1 A2 EA1 EA2 Fall 2020): Mini-project 2 spec
Write a program that supports the following operations on the MongoDB database created in Phase 1. Your program will take as input a port number under which the MongoDB server is running, and will connect to a database named 291db on the server. Your program should allow the users of the system to provide a user id (if they wish), which is a numeric field, formatted as shown in the sample json files. If a user id is provided, the user will be shown a report that includes (1) the number of questions owned and the average score for those questions, (2) the number of answers owned and the average score for those answers, and (3) the number of votes registered for the user. Users may also use the system without providing a user id, in which case no report is displayed.
Next, users should be able to perform the following tasks.
At development time, you will be testing your programs with your own data sets but conforming to the project specification.
At demo time, we will be testing your programs with our test data files that have the same names as given above. Using your submitted code, we will (1) build a MongoDB database in Phase 1, and (2) perform search and update operations in Phase 2. We typically follow a 5 minutes rule for Phase 1, meaning your database should be built in less than 5min. If not, we may have to use our own database, in which case you would lose the whole mark for Phase 1.
Every group will book a time slot convenient to all group members to demo their projects. At demo time, all group members must be present. Our TAs will be asking you for instruction to perform various tasks and to test how your application is handling each task. A mark will be assigned to your demo on the spot after the testing.
Here are some important details about our testing process and your choices (same as in Project 1):
Instructions for Submissions
Your submission includes (1) the application source code for phases 1 and 2, (2) README.txt, and (3) a short report named Report.pdf. Your source code must include at least two programs, i.e. one for each phase. Your program for Phase 2 would implement a simple query interface in your favourite programming language (e.g. Python, C or C++, Java).
https://eclass.srv.ualberta.ca/mod/page/view.php?id=4329176
2/3
.senihcam bal eht naht rehto enihcam yna no tcejorp ruoy omed tonnac uoy ,esiwrehtO .deniatbo eb tsum lavorppa na dna etad eud tcejorp eht erofeb llew rotcurtsni eht htiw dessucsid eb dluohs sesac esohT .potpal a no noitacilppa ruoy omed ot dewolla eb YAM uoy ,senihcam bal no elbaliava ton si taht loot ro egaugnal gnimmargorp lanoitidart ssel a gnisu noitacilppa ruoy gnipoleved era uoy fi si noitpecxe
ehT .noitpecxe eno ylno htiw enihcam bal eht naht rehto enihcam yna ro )sruo ro sruoy( potpal a no deomed eb tonnac edoc ruoY .4 .emit omed ruoy erofeb )yna fi( seussi elbissop tuoba nrael dna noitacilppa ruoy tset
ot ecnahc a evah uoy ,snaem sihT .semit omed ruo erofeb tub etad eud tcejorp eht retfa dehsilbup eb lliw sesac tset ruo dna atad tset ruO .3 .ytlanep ytfeh a tuohtiw edoc eht ot segnahc yna ekam ot dewolla
ton era uoY .esabatad nwo ruo gnisu dna senihcam dargrednu no tnuocca ruo rednu edoc ruoy nur dna elipmoc ot elba eb tsum eW .2 .tnuocca AT a rednu detset eb lliw noitacilppa ruoY .regral eb lliw tub )sepyt dna seman dlefi fo smret ni( selpmas eht sa gnittamrof emas eht wollof lliw selfi tset ehT .emit omed ta edoc ruoy egnahc ot tnaw t’nod uoy dna ,ecnavda ni nwonk ton si rebmun
trop eht ecnis noitacilppa ruoy ni rebmun trop eht edoc-drah t’noD .esle gnihton dna dettimbus edoc ecruos eht gnisu nur eb lliw omed ehT .1
.margorp eht dne ot noitpo na osla eb dluohs erehT .snoitarepo rehtruf rof unem niam eht ot nruter ot elba eb dluohs resu eht ,noitca hcae retfA
.eno yb esaercni osla lliw stsoP ni dlefi erocs eht ,etov hcae htiW .resu tnerruc eht ot tes si di resu eht ,suomynona ton si resu tnerruc eht fI .etad tnerruc eht ot tes etad noitaerc eht dna ,2 ot tes di epyt etov ,di rewsna/noitseuq eht ot tes di tsop eht ,metsys ruoy yb dengissa di etov euqinu a htiw setoV ni dedrocer eb dluohs etov ehT .)tniartsnoc on htiw etov nac sresu suomynona ;di resu a htiw sresu ot elbacilppa ylno si tniartsnoc siht(
tsop emas eht no ydaerla detov ton fi rewsna ro noitseuq detceles eht no etov ot elba eb dluohs resu ehT .etoV-noitca rewsnA/noitseuQ .5 .)txen dessucsid sa( noitca rewsna na mrofrep yam resu eht ,detceles si rewsna na retfA .stsoP morf rewsna eht fo sdlefi lla ees ot rewsna na tceles ot elba eb dluohs resu ehT .erocs eht dna ,etad noitaerc eht ,)sretcarahc ssel ro 08 htgnel fo si ti fi txet lluf eht ro( txet ydob eht fo sretcarahc 08 tsrfi eht yalpsid ,rewsna hcae roF .stsoP ni 2 fo di epyt tsop a evah srewsnA .rats a htiw dekram eb dluohs dna rewsna tsrfi eht sa nwohs eb tsum ti ,rewsna
detpecca eht sa dekram si rewsna na fI .noitseuq detceles a fo srewsna lla ees ot elba eb dluohs resu ehT .srewsna tsiL-noitca noitseuQ .4 .”5.2 AS-YB CC” ot tes si esnecil tnetnoc eht dna orez ot tes lla era tnuoCtnemmoC dna erocS seititnauq ehT .noitseuq eht fo di eht ot tes eb dluohs di tnerap ehT .)dedivorp si di resu a fi( ti gnitsop resu eht ot tes eb dluohs di resu renwo eht dna etad tnerruc eht ot tes eb dluohs etad noitaerc tsop eht ,)rewsna na si tsop eht taht etacidni ot( 2 ot tes eb dluohs di epyt tsop eht ,metsys ruoy yb tsop eht ot dengissa eb dluohs di euqinu A .txet dedivorp eht ot tes dlefi ydob htiw ,esabatad
eht otni detresni eb dluohs drocer rewsna nA .txet a gnidivorp yb noitseuq eht rewsna ot elba eb dluohs resu ehT .rewsnA-noitca noitseuQ .3 .)txen dessucsid sa( noitca noitseuq a mrofrep ot elba eb dluohs resu eht dna )stsoP ni( eno yb esaercni dluohs noitseuq eht fo tnuoc weiv eht ,detceles si noitseuq a retfA .stsoP morf noitseuq eht fo sdlefi lla ees ot noitseuq a tceles ot elba eb dluohs resu ehT .tnuoc rewsna eht dna ,erocs eht ,etad noitaerc eht ,eltit eht yalpsid ,noitseuq gnihctam hcae roF .stsoP ni 1 fo di epyt tsop a evah snoitseuQ .)evitisnesni-esac eb dluohs hctam eht( sdlefi gat ro ,ydob ,eltit ni rehtie drowyek eno tsael
ta niatnoc taht stsop lla eveirter dluohs metsys eht dna ,sdrowyek erom ro eno edivorp ot elba eb dluohs resu ehT .snoitseuq rof hcraeS .2 .”5.2 AS-YB CC” ot tes si esnecil tnetnoc eht dna orez ot tes lla era tnuoCetirovaF dna ,tnuoCtnemmoC ,tnuoCrewsnA ,tnuoCweiV ,erocS seititnauq ehT .)dedivorp si di resu a fi( ti gnitsop resu eht ot tes eb dluohs di resu renwo eht dna etad tnerruc eht ot tes eb dluohs etad noitaerc tsop eht ,)noitseuq a si tsop eht taht etacidni ot( 1 ot tes eb dluohs di epyt tsop eht ,metsys ruoy yb tsop eht ot dengissa eb dluohs di euqinu A .esabatad eht ni dedrocer ylreporp
eb dluohs tsop ehT .sgat erom ro orez dna ,txet ydob a ,txet eltit a gnidivorp yb noitseuq a tsop ot elba eb dluohs resu ehT .noitseuq a tsoP .1
erots tnemucod eht no gnitarepO :2 esahP
.esahp txen eht ni sdlefi ydob dna eltit eht gnihcraes nehw xedni siht esu
gnitseT
2020/11/16 CMPUT 291 (LEC A1 A2 EA1 EA2 Fall 2020): Mini-project 2 spec
The file README.txt is a text file that lists the names and ccids of all group members. This file must also include the names of anyone you collaborated with (as much as it is allowed within the course policy) or a line saying that you did not collaborate with anyone else. This is also the place to acknowledge the use of any source of information besides the course textbook and/or class notes. Your report must be type-written, saved as PDF and be included in your submission. Your report cannot exceed 3 pages.
The report should include (a) a general overview of your system with a small user guide, (b) a detailed design of your software with a focus on the components required to deliver the major functions of your application, (c) your testing strategy, and (d) your group work break-down strategy. The general overview of the system gives a high level introduction and may include a diagram showing the flow of data between different components; this can be useful for both users and developers of your application. The detailed design of your software should describe the responsibility and interface of each primary function or class (not secondary utility functions/classes) and the structure and relationships among them. Depending on the programming language being used, you may have methods, functions or classes. The testing strategy discusses your general strategy for testing, with the scenarios being tested and the coverage of your test cases. The group work strategy must list the break-down of the work items among partners, both the time spent (an estimate) and the progress made by each partner, and your method of coordination to keep the project on track. The report should also include any assumption you have made or any possible limitations your code may have.
https://eclass.srv.ualberta.ca/mod/page/view.php?id=4329176
3/3
▶ spuorg 2 tcejorP-iniM
…ot pmuJ gnikoob omed 1 tcejorp-iniM ◀
!)lacitnedi eb yam seipoc eht hguoht neve( seipoc nwo rieht timbus tsum puorg a ni srentrap llA .egap siht fo pot eht ta etad eud eht yb etis noissimbus tcejorp eht ni elfirat tcejorp ruoy timbuS .zgt.edoc2jrp elfi eht emaN .troper tcejorp ruoy )3( dna ,txt.EMDAER )2( ,edoc ecruos ruoy lla )1( htiw elfi rat deppizg elgnis a etaerC
)0202 llaF 2AE 1AE 2A 1A CEL( 192 TUPMC )tuo goL( uG eijiY sa ni deggol era uoY
MP 24:11 ,0202 rebmevoN 4 ,yadsendeW :defiidom tsaL