CT004-3.
5-3 Advanced Database Systems
Introduction & Overview
Topic & Structure of Lesson
In this lecture we will look at: Module overview Assessment requirements
CT004-3-3 ADVBS
Introduction & Overview
Slide 2 of 11
Learning Outcomes
By the end of this lesson you should be able to:
Explain and critically evaluate the architectures of commercially available DBMS Manage and configure a Database System Critically analyse and evaluate the facilities and limitations of a number of industry standard Query Languages Discuss the projected future directions of database technology in terms of Design, Hardware and Software Implementations
CT004-3-3 ADVBS
Introduction & Overview
Slide 3 of 11
Topics we will cover
Recap of data modeling Recap of SQL Advanced data modeling Advanced SQL Database Management Systems Database Administration Database Performance Issues
Introduction & Overview Slide 4 of 11
CT004-3-3 ADVBS
Topics we will cover
Security and validation Concurrency control Data warehousing and DSS Distributed database technologies Development in database technologies
CT004-3-3 ADVBS
Introduction & Overview
Slide 5 of 11
What is expected of you
Participation in class discussions Further reading and research Implementation of concepts learnt in the lab Attempt tutorial questions
Start work early on your assignment
CT004-3-3 ADVBS Introduction & Overview Slide 6 of 11
What support is available for you
Published consultation hours Email (abdallah@[Link])
CT004-3-3 ADVBS
Introduction & Overview
Slide 7 of 11
What support is available for you
Reference material: Date C J, Database Systems, (8th Ed), AddisonWesley (2003) Connolly T, Begg C, Database Systems: A Practical Approach to Design, Implementation and Management (5th Ed) Addison-Wesley (2009)
CT004-3-3 ADVBS
Introduction & Overview
Slide 8 of 11
What support is available for you
Reference material: Websites Conference papers Journals
e-books
CT004-3-3 ADVBS
Introduction & Overview
Slide 9 of 11
How you will be assessed
Group Assignment : 50% Exam: 50%
CT004-3-3 ADVBS
Introduction & Overview
Slide 10 of 11
Question & Answer Session
Q&A
CT004-3-3 ADVBS
Introduction & Overview
Slide 11 of 11
