Design a redis database to hold a list of ads

Assignment Help Computer Network Security

Reference no: EM131235948

Resids and mango DB homework assignment

1. Install Redis on your machine.

Mac OS: After downloading, open a terminal (click on Go and then on Utilities and then on terminal). Then, follow the following instructions:
https://jasdeep.ca/2012/05/installing-redis-on-mac-os-x/ and https://redis.io/topics/quickstart

Windows: Download executable from here: https://github.com/rgl/redis/downloads and https://stackoverflow.com/questions/6476945/how-do-i-run-redis-on-windows

New versions come out all the time. So, you will have to figure out what is not working on your machine. For example, if your machine does not have XCode on Mac, you may have to download it.

2. Design a Redis database to hold a list of ads and their attributes from statecollege.com auto listings.

3. Choose 4 ads. For example, consider the ad: https://www.statecollege.com/auto/dealers/statecollegemotors-com,6547/audi/a4/cars/WAUENAF40HN029405/. This can be one.

4. Choose the attributes and information present in the ads. You must store at least the following attributes:

(a) Title: 2017 Audi A4 at StateCollegeMotors.com

(b) Description: For example, https://www.statecollege.com/auto/dealers/sutliff-buick-gmc-cadillac,55999/buick/regal/cars/2G4GM5EX2H9116237/ has the

Description: BLUETOOTH!!!, REAR BACK UP CAMERA, 8 COLOR TOUCHSCREEN RADIO, ALL-WHEEL-DRIVE, NAVIGATION, HEATED LEATHER SEATS, and POWER SUNROOF. 2.0L 4-Cylinder DGI DOHC VVT Turbocharged, 6-Speed Automatic, AWD, Light Neutral With Cocoa Interior Accents, 2-Way Adjustable (Up/Down) Front Head Restraints, 2-Way Power Driver Lumbar Seat Adjuster, 4-Wheel Disc Brakes, 7-Speaker Audio System Feature, 8-Way Power Driver Seat Adjuster, ABS brakes, Alloy wheels, Brake assist, Dual front side impact airbags, Electronic Stability Control, Four wheel independent suspension, Front dual zone A/C, Front fog lights, Heated door mirrors, Heated front seats, Leather-Appointed Seat Trim, Outside temperature display, Overhead airbag, Power passenger seat, Power Tilt-Sliding Moonroof w/Sunshade, Radio: Buick IntelliLink AM/FM Stereo w/Navigation, Remote keyless entry, Single-Slot CD/MP3 Player, SiriusXM Satellite Radio, Speed control, Speed-sensing steering, Split folding rear seat, Steering wheel mounted audio controls, Telescoping steering wheel, Traction control, and Turn signal indicator mirrors.Be the talk of the town when you roll down the street in this wonderful 2017 Buick Regal. This spirited machine can turn the everyday driver into a gearhead as they experience a whole new kind of acceleration and exceptionally potent power.We are a Franchised BUICK Dealership for warranty, parts and service.

For ads where there are no descriptions, update your database accordingly. At least choose one ad with a description. If you cannot store very large text, make some assumptions and design decisions, and adjust accordingly. Let us know in your report what design decisions you had to make.

(d) Year of the Car

(e) Number of miles

(f) An attribute called seller with sub-attributes name, address and phone number

Report: (a) A design document telling us your database design and what choices you made and why, (b) Print out your program/screen shot of what you did and submit.

Homework 4: MongoDB

Problem 1. Run MongoDB Locally

Run a MongoDB instance on localhost so you can connect from a client

Task 1. Install MongoDB for you platform

1. Go to https://www.mongodb.org/downloads

2. Find you platform

3. Download

4. Follow the installer

Task 2. Run a server

If you are using windows and MongoDB is installed in Program Files you'd need to use Administrative role

1. Open command prompt as administrator

2. Navigate to MongoDB root

3. Create a folder "data"

4. Run "mongod -dbpath ../data"

Additional Information:

Here are some resources for installing mongodb on mac:

1) install homebrew (https://brew.sh/index.html)

2) install mongodb with home-brew (https://treehouse.github.io/installation-guides/mac/mongo-mac.html)

3) import restaurant data (https://docs.mongodb.com/getting-started/shell/import-data/)

4) I have tried the top 5 queries, and they look good.

To install mongodb on Windows:

https://docs.mongodb.com/manual/tutorial/install-mongodb-on-windows/#install-mongodb-community-edition

To log what you are doing on Unix, please use the script command. Do a "man -k script" to learn more about the script command. The default filename is typescript that is created in the current working directory. You can get the output of script going to a different file by using the command line option.

For logging scripts on windows use powershell:

https://sharepointjack.com/2013/simple-powershell-script-logging/

I do not care which logging script or screenshot you use, but, I need some evidence that all the tasks identified below are done.

Task 3. Practice all of the following exercises

https://www.w3resource.com/mongodb-exercises/

Submit the screenshot. You should do the exercise first and only if you cannot do it, look at the answers.

Task 4. Insert the data that you inserted in your redis database in Hw3 into this MongoDB database.

Task 5.Upsert data (e.g., one record from the car sales website) into your MongoDB database. Perform the same data into your redis database.

Task 6. Query your data from both databases.

Task 7. Query aggregate data for a query of this type. Find me Audis that are under 50,000 miles being sold by a dealer in State College for under $20,000 on both queries. Feel free to change "Audis" to whatever car makes are in your database. Perform the query for one car make in your database and for one car make not in your database.

Submission:

Submit a log of your work. Include a short writeup (if necessary) to help us understand what you did.

Reference no: EM131235948

Questions Cloud

Designit plans to relocate three servers already configured : DesignIT plans to relocate three servers already configured. DesignIT has requested the consideration of all interconnected devices and wiring, along with speeds, for best performance.

What percent of people have scores higher : IQ scores in the population have a mean of 100 and a standard deviation of 15. If Bob has an IQ of 83, what percent of people have scores lower than him? If Sally has an IQ of 97, what percent of people have scores higher than her?

Milk produced from a socially optimal perspective : Milk production requires the use of millions of cows. Cows release methane gas and waste piles that can cause major pollution problems. Is there too little, too much or the correct amount of milk produced from a socially optimal perspective?

Identifies and explains the strong points of the managers : Assesses how the overall management teams perform in terms of the four functions of management. Identifies and explains the strong points of the managers. Identifies and explains areas in which improvements are needed

Design a redis database to hold a list of ads : Design a Redis database to hold a list of ads and their attributes from statecollege.com auto listings. Choose the attributes and information present in the ads.

Why useful in helping to determine clinical significance : Confidence Intervals: Why are they useful in helping to determine clinical significance? There are many controversies surrounding the issue of clinical significance vs. statistical significance. Identify one of them and summarize it. Finish with ..

Calculate the implied arc price elasticity of demand : Arc Price Elasticity. Assume that amazon.com dropped the price on a men's Seiko watch (SGF719) from $120 to $60, and sales jumped from 50 to 100 units per day. Calculate the implied arc price elasticity of demand. Is a further price decrease warrante..

Construct the corresponding relative frequency distribution : Provide an appropriate response. The frequency distribution for the weekly incomes of students with part-time jobs is given below. Construct the corresponding relative frequency distribution.

What is the raw score associated : Suppose that in a particular sample, the mean is 70.07 and the standard deviation is 10.27. What is the raw score associated with a Z score of 1.88?

User Account

All Pages