Teaching Responsibility
LJMU Schools involved in Delivery:
Computer Science and Mathematics
Learning Methods
Lecture
Practical
Tutorial
Module Offerings
7127COMP-JAN-CTY
Aims
To examine critically selected techniques for modelling the data requirements of database applications at the conceptual level.
To develop and understand contemporary advanced issues of database design, with specific interest in the context of business intelligence.
For example how core concepts in databases may be applied and developed to solve research problems such as handling Big Data and Temporal Data.
To develop an informed appreciation of significant, current issues and trends in database systems.
Learning Outcomes
1.
Apply a range of conceptual data modelling techniques for the specification of data requirements and be able to select from among them those which are most appropriate to given application problems.
2.
Apply advanced principles of the relational database model, data integrity and functional dependency to logical data design problems.
3.
Explain and evaluate in detail how advanced large-scale database systems support business intelligence.
4.
Critically evaluate the principles, problems and contributions of distributed database systems, object-oriented databases and further research topics in database systems.
Module Content
Outline Syllabus:Relational design and relational technology - DBMS architecture – functional dependency and normalisation (review) - approaches to lossless join, dependency preserving decomposition, normalization to BCNF - multivalued and join dependencies - 4NF, 5NF. - SQL standards. -Security, integrity, transaction management and recovery - file organisations - query processing - view processing - host and embedded languages.
Current issues and trends - distributed database management: distributed databases, locking, Business Intelligence Alternate DBMS / Big Data, commitment and concurrency.
Object-oriented databases: the object-oriented model - origins of object-oriented database languages - persistence - example OODB implementations and implementation considerations - modelling and design for OODBs. Object database standards. Object-relational model.
Research issues – data warehousing - data mining and business intelligence – Web searches – Big Data- Semantic Web.
Module Overview:
This module examines recent developments and current trends in databases both from the application and the technology view points. It aims to:
This module examines recent developments and current trends in databases both from the application and the technology view points. It aims to:
- examine critically selected techniques for modelling the data requirements of database applications at the conceptual level
- develop and understand contemporary advanced issues of database design
- develop an informed appreciation of significant, current issues and trends in database systems
Additional Information:This module examines recent developments and current trends in databases both from the application and the technology view points.
Assessments
Report
Essay