Assignments:

Assignment 1 (RDM and ER) (due week 5, 1 April): Assignment 2 (RA + Optimsation) (due week 8, Friday, 6 May 2022) Assignment 3 (DB design + Normalization) (due week 11)

Projects:

Project 1 (SQL) (due Week 7, 25 April) Project 2 (due Week 12, 3 June + 3 late days) SWEN304-439_Project2_final.pdf Please check Blackboard for a video of Project 2 demo

A possible way to remotely access demo or your program: a possible way.pdf:

Book a session for demonstration at: https://docs.google.com/spreadsheets/d/1uRq1cAVMTMZhJmGxUWBqJuMpZDi4WFABTUHpf9yiRco/edit?usp=sharing

Essay:

You will write an essay on No-SQL databases. Your essay topic can be A Survey of NoSQL databases. The essay should be around 1500 - 2000 words (3000 word limit), and is due at the end of the term: 21 June. Please submit your essay in pdf. Your essay should include references to support your statement. and arguments.

1) The structure of the essay will discuss:

  • The problem/issue
    • Describe the problem/issue/limitation that NoSQL databases are trying to address
    • Explain why it matters - where does the problem arise in practice.
  • Describe different families of NoSQL databases
    • Explain the solutions presented by each of the families
    • highlighting the similarities and differences between the families
  • Limitations
    • Discuss the limitations of each of the families - what they don't solve yet.
    • Briefly outline how the limitations are addressed by any other databases, if any.
  • Conclusion
    • Summarise the state of the art of NoSQL databases, saying what can be done now, and what issues are still open for future research.

2) To help you with the writing of the essay I provide you some readings for you to start with. You are encouraged to survey more papers to be used for your essay:

1. NoSQL Evaluation - Use Case-oriented Survey
http://ieeexplore.ieee.org/stamp/stamp.jsp?tp=&arnumber=6138544&tag=1

2. Can the elephants handle the NoSQL onslaught?
http://delivery.acm.org/10.1145/2370000/2367511/p1712-floratou.pdf?ip=130.195.199.196&id=2367511&acc=ACTIVE%20SERVICE&key=65D80644F295BC0D%2EF6524D9D8BB8931B%2E4D4702B0C3E38B35%2E4D4702B0C3E38B35&CFID=995782531&CFTOKEN=20538921&__acm__=1508375322_e939a6e8cfbb432d8b25bdae54cf8ba3

3. History repeats itself: sensible and NonsenSQL aspects of the NoSQL hoopla
http://delivery.acm.org/10.1145/2460000/2452378/p11-mohan.pdf?ip=130.195.199.196&id=2452378&acc=ACTIVE%20SERVICE&key=65D80644F295BC0D%2EF6524D9D8BB8931B%2E4D4702B0C3E38B35%2E4D4702B0C3E38B35&CFID=995782531&CFTOKEN=20538921&__acm__=1508375386_7b88b0c5c70b5455225a256a4c51d004

4. Cassandra - The NoSQL Column Store used by Facebook (https://dl.acm.org/citation.cfm?id=1773922)

5. MongoDB - The popular NoSQL Document Store (https://link.springer.com/chapter/10.1007/978-1-4302-3052-6_1)

6. Uniform Access to NoSQL Database Systems (http://www.sciencedirect.com/science/article/pii/S0306437913000719)

7. Benchmarking Scalability and Elasticity of NoSQL Database Systems
(https://dl.acm.org/citation.cfm?id=2732995)
also (https://www.datastax.com/wp-content/themes/datastax-2014-08/files/NoSQL_Benchmarks_EndPoint.pdf)
NuoDB - A popular NewSQL Database System (see also here)

If any of the links above do not work please google the paper and you should be able to find it easily.

Helpful Links:

I Attachment Action Size Date Who Comment
SWEN304_Assignment1_22_v5_final.docdoc SWEN304_Assignment1_22_v5_final.doc manage 183 K 16 Mar 2022 - 18:31 Main.hma  
SWEN304_Assignment1_22_v5_final.pdfpdf SWEN304_Assignment1_22_v5_final.pdf manage 250 K 16 Mar 2022 - 18:31 Main.hma  
Using_PostgreSQL_onStation.pdfpdf Using_PostgreSQL_onStation.pdf manage 69 K 28 Mar 2022 - 10:53 Main.hma  
remoteAccess_PostgreSQL.pdfpdf remoteAccess_PostgreSQL.pdf manage 310 K 28 Mar 2022 - 10:52 Main.hma