COSC2407 : Database Systems - IT Assignment

Internal Code : MAS3184

IT assignment

Questions - Task 1: Load the data into MongoDB You are required to load the data into MongoDB. In your report: • explain how have you chosen to structure the data inserted in MongoDB • provide details of the time taken to load the data (The mongoimport is one utility will provide such information). Please note that a naive import into a flat structure in Mongodb will not accrue you a great mark. You need to analyse the data and consider appropriate ways to structure the data and then using any scripting, programming or other tools to format the data accordingly. • What alternative way or ways could you have organised the data when storing in Mon-goDB, and what advantages or disadvantages would these alternative designs have? Task 2: Load the data into Derby You are required to load the data into Derby. In your report: • explain how have you chosen to structure the Derby relational database and give reasons. • provide details of the time to load the data into Derby. The same criterion to think about how you structure your data applies and that this structure should reflect your understanding of database system theory applies. • What alternative way or ways could you have organised the data when storing in Derby,and what advantages or disadvantages would these alternative designs have? Task 3: Queries and timings Using both MongoDb and Derby, run the queries below 20 times: ten times after a fresh reboot and ten times after the server has been running for a while.Undertake the following queries (including timings when you run the queries, for compari-son): • Where is the sensor with ID number 3 located? • For how many days in 2017 has the City of Melbourne published the sensor data of pedestrian counts? • In 2015, what location had the most pedestrians and was the total number of pedestrians at that location across the whole year)? • What was the busiest day in the city in 2016 (give the date)? • What day of the week (i.e. Monday to Sunday) is the busiest? In your report provide the queries (code), details of the answers returned by the database system and query timings. The best approach would be to detail the timings in a table along with the mean and the standard deviations of these timings.In your report provide the queries, details of the answers returned by both database systems and query timings. Task 4: Evaluate and critically analyse results With reference to your experimental results above: • Are the timing results what you would have expected to see based on your theoretical understanding of these database systems? Explain why or why not? • How would you expect these results to have changed if you had used the alternative designs (considered in Tasks 1 and 2) for MongoDB and for Derby? Justify for answers. • Discuss the advantages and disadvantages of using MongoDB and Derby for this dataset.