Assignments

Assignment 1 (RDM and ER) (due week 5, ):SWEN435_Assignment1_24.pdf

Assignment 2 (RA + Optimsation) (due week 8, 3 May extended to 6 May ) Assignment 3 (DB design + Normalization) (due week 11) Project 1 (SQL) (due Week 7): Project 2 (due Week 12)
  • Project descriptions:
  • Data file:
  • Java files:

Book a session for demonstration

Essay

You will write an essay on No-SQL databases using the IEEE template. Your essay topic can be A Survey of NoSQL databases. The essay should be 3 to 4 pages (exclude references), and is due on 14 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) Template

You are expected to use the two-column IEEE conference article format. You may use either Word, LaTeX, or Overleaf (LaTeX) to produce your report, using the respective templates below: Please follow the referencing style (IEEEtran) specified by the template. You may include images and tables if they support the points you are making.

3) 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: