Course Details
Course Information Package
Course Unit Title | DATA MANAGEMENT | ||||||||
Course Unit Code | ACSC526 | ||||||||
Course Unit Details | |||||||||
Number of ECTS credits allocated | 7 | ||||||||
Learning Outcomes of the course unit | By the end of the course, the students should be able to:
| ||||||||
Mode of Delivery | Face-to-face | ||||||||
Prerequisites | NONE | Co-requisites | NONE | ||||||
Recommended optional program components | NONE | ||||||||
Course Contents | 1. Emerging challenges on data management - Framework of data requirements for web and mobile systems - Mobile data systems – distributed environments, concurrency and integrity - Spatial Databases – implementation of spatial indices - Online and Streaming databases – Sensor data, queries for live data - Use of semi-structured data 2. Need for Data Analysis – Data Warehouses - Analytical vs Transactional Systems - Extraction of data from multiple sources. Existence of non-relational and semi-structured data - Data cleansing and transformation principles - Multi-dimensional models and applying aggregation levels in dimensions. Specifying measures. OLAP cubes. - Sparse data - Performance considerations. Indexing, optimization, data refreshing. 4. Data Visualisation - Linking OLAP data to reporting environments - Libraries for data visualization on the web - Interactive reports, design of effective dashboards: good and bad practices - Interfaces for Managerial Support – Dashboard Design for web systems - Web site Analytics (Google Analytics) 5. Web Databases - The Google File System - Bigtable: A Distributed Storage System for Structured Data - Working with XML databases - Mobile Databases: Implementation and Case Studies | ||||||||
Recommended and/or required reading: | |||||||||
Textbooks |
| ||||||||
References |
| ||||||||
Planned learning activities and teaching methods | The taught part of course is delivered to the students by means of lectures, conducted with the help of computer presentations. Lecture notes and presentations are available through the web for students to use in combination with the textbooks. Furthermore theoretical principles are explained by means of specific examples and solution of specific problems. Lectures are supplemented with supervised and unsupervised computer laboratory. Laboratories will include demonstrations of taught concepts and experimentation with related technologies. Additionally, during laboratory sessions, students apply their gained knowledge and identify the principles taught in the lecture sessions by means of working on different modelling tasks and evaluating simulation results. | ||||||||
Assessment methods and criteria |
| ||||||||
Language of instruction | English | ||||||||
Work placement(s) | NO |