MSc in Web and Smart Systems / Ступінь Магістра в Галузі Веб і Мобільних Систем

Course Details

Course Information Package

Course Unit TitleDATA MANAGEMENT
Course Unit CodeACSC526
Course Unit Details
Number of ECTS credits allocated7
Learning Outcomes of the course unitBy the end of the course, the students should be able to:
  1. Describe the emerging topics in database systems relevant to mobile and web technologies such as spatial data systems, streaming databases.
  2. Argue on the benefits of data analytics and its impact on decision making.
  3. Explain the process of data warehouse development, especially the Extract-Transform-Load process and design and construct efficient data warehouses through the use of specialized software or through direct SQL statements.
  4. Show the ability to design and present analytical information efficiently and visually effectively in web systems through the use of visualization libraries.
Mode of DeliveryFace-to-face
PrerequisitesNONECo-requisitesNONE
Recommended optional program componentsNONE
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
  • T Connolly C Begg (2009) Database Systems, Addison Wesley, 5th Ed
  • M Goldarelli, S Rizzi (2009) Data Warehouse Design: Modern Principles and Methodologies, McGraw-Hill.
References
  • R Kimbal et al. (2008), The Data Warehouse Lifecycle Toolkit 2nd ed John Wiley and Sons.
  • S Few (2006), Information Dashboard Design, O’Reily.
  • J Cutroni (2010) Google Analytics 1st ed, O-Reilly.
  • An extensive reading list of relevant academic papers.
Planned learning activities and teaching methodsThe 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
Assignments30%
Project work30%
Final Exam40%
Language of instructionEnglish
Work placement(s)NO

 Друк  E-mail