Module Descriptors
ENTERPRISE DATABASE SYSTEMS
COIS70582
Key Facts
Faculty of Computing, Engineering and Sciences
Level 7
15 credits
Contact
Leader: Euan Wilson
Email: E.D.Wilson@staffs.ac.uk
Hours of Study
Scheduled Learning and Teaching Activities: 48
Independent Study Hours: 102
Total Learning Hours: 150
Assessment
- COURSEWORK weighted at 50%
- EXAMINATION - UNSEEN IN EXAMINATION CONDITIONS weighted at 50%
Module Details
Module Learning Strategies
Lectures, practical exercises, tutorials and software demonstrations will be used as appropriate to the material of the course.
(1:n)2 (1:20)2
(1:n)2 (1:20)2
Module Indicative Content
Theory and models of database management systems.
Discussion of the relational and the extended relational model (ORDBMS). Discussion of the Object-Oriented approach and comparison with relational systems. Design methodologies for database systems, links with the systems analysis and design processClient-Server architectures, Web-database architectures. Passive and active database systems.
Data Dictionaries
The need for dictionaries and their use in database applications. Intelligent dictionary systems.
Database security
System security. Backup and recovery strategies. Handling concurrency, locking protocols.
Database Administration
Organisation of database control. Database software selection and evaluation. Licensing and contractual agreements.
Distributed Databases
Centralisation versus decentralisation. Client/Server versus distributed database applications. Locking and transaction control (parallelism and serialisability). Recovery procedures. Modes of organisation.
Database Tuning
Query Optimisation. Database internals - controls and parameters. Query performance tools.
Data WarehousingWarehouse, legacy systems and data marts. Metadata. Optimisation of the warehouse (use of bit-mapped indexes). Schema designs (stars and snowflakes). Multi-Dimensional Databases and On-line Analytical processing.
Object-Oriented Databases
Types of object, persistence, inheritance, methods, encapsulation, overriding and late-binding. Examples of applications research trends and issues.
Discussion of the relational and the extended relational model (ORDBMS). Discussion of the Object-Oriented approach and comparison with relational systems. Design methodologies for database systems, links with the systems analysis and design processClient-Server architectures, Web-database architectures. Passive and active database systems.
Data Dictionaries
The need for dictionaries and their use in database applications. Intelligent dictionary systems.
Database security
System security. Backup and recovery strategies. Handling concurrency, locking protocols.
Database Administration
Organisation of database control. Database software selection and evaluation. Licensing and contractual agreements.
Distributed Databases
Centralisation versus decentralisation. Client/Server versus distributed database applications. Locking and transaction control (parallelism and serialisability). Recovery procedures. Modes of organisation.
Database Tuning
Query Optimisation. Database internals - controls and parameters. Query performance tools.
Data WarehousingWarehouse, legacy systems and data marts. Metadata. Optimisation of the warehouse (use of bit-mapped indexes). Schema designs (stars and snowflakes). Multi-Dimensional Databases and On-line Analytical processing.
Object-Oriented Databases
Types of object, persistence, inheritance, methods, encapsulation, overriding and late-binding. Examples of applications research trends and issues.
Module Texts
Essential Reading
An Introduction to Database Systems, Volume 1, C J Date, Addison-Wesley, 1994, ISBN: 0201824582
Database Systems Concepts, Korth and Silberschatz et. al., Osbourne McGraw Hill, 2001, ISBN: 0072283637
Database Systems: A Practical Approach to Design, Implementation and Management, 4th Edition, T M Connolly, C E Begg, Addison Wesley, 2004, ISBN: 0321210255
An Introduction to Database Systems, Volume 1, C J Date, Addison-Wesley, 1994, ISBN: 0201824582
Database Systems Concepts, Korth and Silberschatz et. al., Osbourne McGraw Hill, 2001, ISBN: 0072283637
Database Systems: A Practical Approach to Design, Implementation and Management, 4th Edition, T M Connolly, C E Begg, Addison Wesley, 2004, ISBN: 0321210255
Module Additional Assessment Details
Exam - 50% (3 hours) assessing Learning Outcomes 1 and 3
Individual practical assignment (30%) assessing Learning Outcomes 2 and 3
Individual theory element (20%) assessing Learning Outcome 4
Individual practical assignment (30%) assessing Learning Outcomes 2 and 3
Individual theory element (20%) assessing Learning Outcome 4
Module Resources
Oracle
ASP
IE
On-line Oracle ref www.w3schoolsonline.com
ASP
IE
On-line Oracle ref www.w3schoolsonline.com
Module Special Admissions Requirements
None