Module Descriptors
DATA STORAGE FOR BUSINESS
COIS71206
Key Facts
Digital, Technology, Innovation and Business
Level 7
15 credits
Contact
Leader: Murouj Aljamaeen
Hours of Study
Scheduled Learning and Teaching Activities: 36
Independent Study Hours: 114
Total Learning Hours: 150
Pattern of Delivery
- Occurrence A, Stoke Campus, PG Semester 1
- Occurrence B, Asia Pacific Institute of Information Technology Sri Lanka (Colombo), PG Semester 1
Sites
- Asia Pacific Institute of Information Technology Sri Lanka (Colombo)
- Stoke Campus
Assessment
- REPORT weighted at 70%
- PRACTICAL DEMONSTRATION weighted at 30%
Module Details
Module Learning Outcomes
1. DISCUSS CRITICALLY THE MAJOR DEVELOPMENTS IN DATA STORAGE WITH RESPECT TO DATA WAREHOUSING AND CLOUD SOLUTIONS
Enquiry
2. DISCUSS CRITICALLY THE USE OF DATA WITHIN ORGANISATIONS, WITH RESPECT TO DATA WAREHOUSING, AND QUALITY OF DATA ETC.
Knowledge & Understanding
3. ANALYSE, DESIGN AND BUILD AN APPROPRIATE SYSTEM UTILISING CURRENT DATA WAREHOUSING TECHNOLOGIES.
Analysis
Problem Solving
Enquiry
2. DISCUSS CRITICALLY THE USE OF DATA WITHIN ORGANISATIONS, WITH RESPECT TO DATA WAREHOUSING, AND QUALITY OF DATA ETC.
Knowledge & Understanding
3. ANALYSE, DESIGN AND BUILD AN APPROPRIATE SYSTEM UTILISING CURRENT DATA WAREHOUSING TECHNOLOGIES.
Analysis
Problem Solving
Module Indicative Content
This module will address:
An overview of Data Warehousing principles and techniques:
Architectures, schemas design, tuning, loading (ETL), staging areas, data marts, and operational data store etc.
Kinball v Inman, OLAP and OLTP
Logical v physical design
Dimensional modelling
Cloud storage, architectures and legislation
Issues with respect to mobile, complex data, and biometrics data
Structures to support CRM
Quality and Integrity of Data
An overview of Data Warehousing principles and techniques:
Architectures, schemas design, tuning, loading (ETL), staging areas, data marts, and operational data store etc.
Kinball v Inman, OLAP and OLTP
Logical v physical design
Dimensional modelling
Cloud storage, architectures and legislation
Issues with respect to mobile, complex data, and biometrics data
Structures to support CRM
Quality and Integrity of Data
Module Additional Assessment Details
A COURSEWORK weighted at 100%
The coursework will comprise two elements:-
An Individual Research Paper (70%) (2,000 words) (Learning Outcomes 1 and 2).
An Individual practical assignment (30%) (Learning Outcome 3).
The coursework will comprise two elements:-
An Individual Research Paper (70%) (2,000 words) (Learning Outcomes 1 and 2).
An Individual practical assignment (30%) (Learning Outcome 3).
Module Learning Strategies
The module uses 12 hours of formal lectures, and 24 hours of workshop based teaching which will include practical work, seminars and theoretical material. Extensive use is made of the VLE and of formative assessment.
Module Texts
Kang, U. and Ee-Peng, L. (2017) Trends and Applications in Knowledge Discovery and Data Mining: PAKDD 2017 Workshops, MLSDA, BDM, DM-BPM Jeju, South Korea, May 23, 2017, Revised Selected Papers (Lecture Notes in Computer Science), ISBN-10: 3319672738.
Krishnan, K. (2013) Data warehousing in the age of big data, Morgan Kaufmann, ISBN 970124058910.
Kinmball, R. et al, (2013) The data warehouse toolkit, Wiley, ISBN 9781118530801.
Bauer, S. (2013) Getting started with Amazon Redshirt, Packt, ISBN 978172178085.
Krishnan, K. (2013) Data warehousing in the age of big data, Morgan Kaufmann, ISBN 970124058910.
Kinmball, R. et al, (2013) The data warehouse toolkit, Wiley, ISBN 9781118530801.
Bauer, S. (2013) Getting started with Amazon Redshirt, Packt, ISBN 978172178085.
Module Resources
Oracle and SQLserver
Module Special Admissions Requirements
None
Web Descriptor
This module is concerned with how data and the quality of data can be utilised by organisations. Topics covered will include: data warehouse design, optimization, loading, and quality. By undertaking this module you will develop your knowledge of why data is important to a company and the best ways to store and access it.
Module Learning Strategies
The module uses 13 hours of formal lectures, and 26 hours of workshop based teaching which will include practical work, seminars and theoretical material. Extensive use is made of the VLE and of formative assessment.