| CODE | CIS5005 | |||||||||
| TITLE | Database Models for Big Data | |||||||||
| UM LEVEL | 05 - Postgraduate Modular Diploma or Degree Course | |||||||||
| MQF LEVEL | 7 | |||||||||
| ECTS CREDITS | 5 | |||||||||
| DEPARTMENT | Computer Information Systems | |||||||||
| DESCRIPTION | This unit focuses on current research topics in database technology,data modelling, and meeting the growing demands of Big Data volumes. Considering the shortcomings of the relational model, this study-unit also investigates emerging and alternative data models and techniques which can be used to satisfy different needs in different application development contexts. For example many new applications, mostly based on the relational model, now have spatial data and functionality requirements. This study-unit will cover various data models including, object-oriented and graph based, semi-structured, spatial and the dimensional data model amongst others. A detailed analysis is given together with practical examples which will highlight each data model's advantages as well as possible shortcomings in different situations. For each data model the discussion will also address respective standards for the model's definition as well as for data access and management (e.g. through the latest SQL III standard). Study-unit Aims: - At the end of the course the student will be well equipped to make better decisions regarding the choice of a data model and its corresponding technologies when facing new projects data requirements in different contexts; - This unit aims at providing a deeper and wider understanding of emerging data models and corresponding programming languages interface; - The unit also aims at promoting further appreciation of quality of streaming and historical data. Modelling techniques together with relevant design patterns will help the students create and manage strategic data warehouses. Learning Outcomes: 1. Knowledge & Understanding By the end of the study-unit the student will be able to: - Identify the main components of various data modelling techniques; - Assess the work required to design, integrate and offer a basis for visualizing data coming from different sources; - Understand data model capabilities and their applicability to implement various constructs (e.g. the direct implementation of a binary many to many relationship in a graph based data model); - Verifying and validating of a data model design against the data requirements in any given IS scenario; - Appreciate data quality and the importance to identify data item providence; - Make reflection and self-assessment of their phase of study. 2. Skills By the end of the study-unit the student will be able to: - Understand requirements to develop such systems; - Design and develop systems based on emerging data models (e.g. graph and dimensional amongst others) applicable to the system's domain (e.g. scientific, tactical and strategic); - Query and manage data in different data models using the respective languages (e.g. SQLIII and well known extensions); - Develop artefacts using tools provided by suppliers reflecting the underlying data model chosen for the current context. Main Text/s and any supplementary readings: Main Text - Elmasri, R. and Navathe, S., 2016. Fundamentals of database systems. Addison-Wesley Publishing Company. Supplementary Readings - Zaniolo, C., 1997. Advanced database systems. Morgan Kaufmann. - Abiteboul, S., Hull, R. and Vianu, V., 1995. Foundations of databases: the logical level. Addison-Wesley Longman Publishing Co., Inc. - Hellerstein, J.M. and Stonebraker, M. eds., 2005. Readings in database systems. MIT Press. - Gray, J. and Reuter, A., 1992. Transaction processing: concepts and techniques. Elsevier. - Han, J., Pei, J. and Kamber, M., 2011. Data mining: concepts and techniques. Elsevier. - Inmon, W.H., Strauss, D. and Neushloss, G., 2010. DW 2.0: The architecture for the next generation of data warehousing. Elsevier. A number of academic and most cited papers are to be forwarded to candidates. |
|||||||||
| ADDITIONAL NOTES | Pre-Requisite Study-units: CIS3187 or similar | |||||||||
| STUDY-UNIT TYPE | Lecture, Independent Study & Tutorial | |||||||||
| METHOD OF ASSESSMENT |
|
|||||||||
| LECTURER/S | Joseph Vella |
|||||||||
|
The University makes every effort to ensure that the published Courses Plans, Programmes of Study and Study-Unit information are complete and up-to-date at the time of publication. The University reserves the right to make changes in case errors are detected after publication.
The availability of optional units may be subject to timetabling constraints. Units not attracting a sufficient number of registrations may be withdrawn without notice. It should be noted that all the information in the description above applies to study-units available during the academic year 2025/6. It may be subject to change in subsequent years. |
||||||||||