#REQUEST.pageInfo.pagedescription#

Site Navigation

COMP8017 - Database Administration

banner1
Title:Database Administration
Long Title:Database Administration
Module Code:COMP8017
 
Credits: 5
NFQ Level:Intermediate
Field of Study: Computer Science
Valid From: Semester 1 - 2017/18 ( September 2017 )
Module Delivered in 2 programme(s)
Module Coordinator: TIM HORGAN
Module Author: ARTHUR TOBIN
Module Description: This module will provide students with a broad insight into the administration of a database management system. Every Database Management System (DBMS) requires database administration to ensure efficient and effective use of databases by users and applications.
Learning Outcomes
On successful completion of this module the learner will be able to:
LO1 Discuss database systems architecture and configuration concepts.
LO2 Describe and explain database management, data management, user management, optimisation concepts and server side processing (triggers and stored procedures).
LO3 Specify appropriate transaction controls for recovery and concurrency in a multi user database management system.
LO4 Apply concepts of recovery, concurrency, security and data management in a multi-user environment.
Pre-requisite learning
Module Recommendations
This is prior learning (or a practical skill) that is strongly recommended before enrolment in this module. You may enrol in this module if you have not acquired the recommended learning but you will have considerable difficulty in passing (i.e. achieving the learning outcomes of) the module. While the prior learning is expressed as named CIT module(s) it also allows for learning (in another module or modules) which is equivalent to the learning specified in the named module(s).
12704 COMP6041 Introduction to Databases
12847 SOFT7022 Database Design
Incompatible Modules
These are modules which have learning outcomes that are too similar to the learning outcomes of this module. You may not earn additional credit for the same learning and therefore you may not enrol in this module if you have successfully completed any modules in the incompatible list.
Moduleid 327, 3108
Co-requisite Modules
No Co-requisite modules listed
Requirements

This is prior learning (or a practical skill) that is mandatory before enrolment in this module is allowed. You may not enrol on this module if you have not acquired the learning specified in this section.

No requirements listed
Co-requisites
No Co Requisites listed
 

Module Content & Assessment

Indicative Content
Database Architecture
The architecture of a multi-user transaction based relational database systems. Alternatives to relational systems.
Data Management
Data integration and migration; Data fragmentation, clustering, compression techniques. System performance and monitoring. System catalogs. Query optimisation. Stored procedures, triggers. User management.
Concurrency
Transactions. Problems with interleaved transaction management in a database envirnoment. Locking. Serializability. Locking and protocols to effect serializability. Isolation levels. Intent Locking. SQL implementation(Cursors). Timestamping concurrency control, Optimistic concurrency
Recovery
Types of failure: Volatile and non volatile memory failure. Logs. Write ahead log strategy. Log implementations (dual and circular) and log management. Checkpoints (Transaction, Action and Fuzzy). Recovery procedures(Undo/Redo). Link between buffer management and recovery schemes (No Undo/redo etc). Non volatile failure and archival Databases/logs.
Assessment Breakdown%
Course Work30.00%
End of Module Formal Examination70.00%
Course Work
Assessment Type Assessment Description Outcome addressed % of total Assessment Date
Other A combination of practical/skills evaluation,short answer question, research and written report relating to the application of database recovery, concurrency, security and database administration in a multi-user database environment. 1,2,3,4 30.0 Every Week
End of Module Formal Examination
Assessment Type Assessment Description Outcome addressed % of total Assessment Date
Formal Exam End-of-Semester Final Examination. 1,2,3,4 70.0 End-of-Semester
Reassessment Requirement
Repeat examination
Reassessment of this module will consist of a repeat examination. It is possible that there will also be a requirement to be reassessed in a coursework element.

The institute reserves the right to alter the nature and timings of assessment

 

Module Workload

Workload: Full Time
Workload Type Workload Description Hours Frequency Average Weekly Learner Workload
Lecture Lecture underpinning learning outcomes. 2.0 Every Week 2.00
Lab Lab supporting content delivered in class. 2.0 Every Week 2.00
Independent & Directed Learning (Non-contact) Independent study. 3.0 Every Week 3.00
Total Hours 7.00
Total Weekly Learner Workload 7.00
Total Weekly Contact Hours 4.00
Workload: Part Time
Workload Type Workload Description Hours Frequency Average Weekly Learner Workload
Lecture Lecture underpinning learning outcomes. 2.0 Every Week 2.00
Lab Lab supporting content delivered in class. 2.0 Every Week 2.00
Independent & Directed Learning (Non-contact) Independent study. 3.0 Every Week 3.00
Total Hours 7.00
Total Weekly Learner Workload 7.00
Total Weekly Contact Hours 4.00
 

Module Resources

Recommended Book Resources
  • Connolly & Begg 2014, Database Systems, 6th Ed., Pearson [ISBN: 9780132943260]
Supplementary Book Resources
  • Elmasri & Navathe 2015, Fundamentals of Database Systems, 7th Ed., Pearson [ISBN: 9780133970777]
  • Craig S. Mullins 2012, Database Administration: The Complete Guide to Practices and Procedures, Addison-Wesley [ISBN: 9780321822949]
  • W. Curtis Preston 2007, Backup & Recovery, O'Reilly [ISBN: 9780596102463]
This module does not have any article/paper resources
Other Resources
 

Module Delivered in

Programme Code Programme Semester Delivery
CR_KITMN_8 Bachelor of Science (Honours) in IT Management 4 Mandatory
CR_KITSP_7 Bachelor of Science in Information Technology 4 Elective

Cork Institute of Technology
Rossa Avenue, Bishopstown, Cork

Tel: 021-4326100     Fax: 021-4545343
Email: help@cit.edu.ie