Discuss the characteristics (subject-oriented, integrated, time-variant, non-volatile and support of management decision-making process) that differentiate data warehouses from other database systems supported by examples.

a) Discuss the characteristics (subject-oriented, integrated, time-variant, non-volatile and support of management decision-making process) that differentiate data warehouses from other database systems supported by examples. (10 marks)

(b) Use ONE detailed example to discuss and analyse why a company can benefit from data warehousing. You are expected to use the characteristics discussed in 1(a) to detail your discussion and analysis. (10 marks)

Question 2: [LO1 & LO3] [20 marks]

Describe and discuss THREE of the FOUR main categories of NoSQL database: Key value store, Column store, Document store and Graph database, giving a definition and overview of the key characteristics of each category, including comparative advantages of each category, and giving an example of an appropriate application area.

Question 3: [LO3 & LO4] [60 marks]

For Big Data task, you need to perform the required task for the given data set, following a Big Data architecture framework (Lecture- Big Data project development process and its stages):

Acquisition: Although we are providing the location of the dataset, you need to research how the data was assembled. (5 marks)

Storage: You are probably storing the data set in a local resource. So, for this point we are asking you to elaborate a brief What-if? Scenario and what you will need to do to store your data in a cloud-based system. (5 marks)

Analysis: This is the core of your assessment. You need to perform a full data analytics framework (based on the lectures and tutorials): (40 marks)

Last Completed Projects