Module Descriptors
DATABASE TECHNOLOGY
COIS70409
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 100%
Module Details
Module Special Admissions Requirements
None.
Module Resources
Material on Blackboard
Oracle
Staffordshire University has subscriptions to electronic book services such as Safari Tech Books, Ebrary and Netlibrary. There are titles in each of the collections that will support students studying Database Technology. Staffordshire University has subscriptions to IEEExplore, ACM Digital Library, Elsevier Science Direct and Infotrac Computer Database all offering full text electronic access to journals and conference proceedings.
Oracle
Staffordshire University has subscriptions to electronic book services such as Safari Tech Books, Ebrary and Netlibrary. There are titles in each of the collections that will support students studying Database Technology. Staffordshire University has subscriptions to IEEExplore, ACM Digital Library, Elsevier Science Direct and Infotrac Computer Database all offering full text electronic access to journals and conference proceedings.
Module Additional Assessment Details
A COURSEWORK weighted at 100%, comprising two sections:-
Individual Research Paper (70%) (2,000 words) assessing Learning Outcomes 1 and 2
Individual practical assignment (30%) assessing Learning Outcome 3
Individual Research Paper (70%) (2,000 words) assessing Learning Outcomes 1 and 2
Individual practical assignment (30%) assessing Learning Outcome 3
Module Indicative Content
Data Mining - topics to include (not exhaustive): concepts, techniques, related disciplines (e.g. OLAP etc.), classification, clustering, Web, spatial and temporal mining.
Data Warehousing - architecture, star schema, tuning, loading, etc.
Customer Relationship Management - overview of, ECRM, MCRM etc. and Decision support systems
Quality and Integrity of Data
Principles of Extensible Mark-Up Language (XML) and structured data.
Principles of Web Databases using XML, use of data feeds, news feeds, XML applications (scalable vector graphics (SVG), voice xml etc)
Mobile databases: issues and technologies related to database technology
Advanced database querying languages.
Data Warehousing - architecture, star schema, tuning, loading, etc.
Customer Relationship Management - overview of, ECRM, MCRM etc. and Decision support systems
Quality and Integrity of Data
Principles of Extensible Mark-Up Language (XML) and structured data.
Principles of Web Databases using XML, use of data feeds, news feeds, XML applications (scalable vector graphics (SVG), voice xml etc)
Mobile databases: issues and technologies related to database technology
Advanced database querying languages.
Module Learning Strategies
2 lectures per week; 2 practicals per week (1:n)2,;(1:20)2.
Students will have participated in an award induction workshop where they will learn how to use the Virtual Learning Environment (VLE) employed for the study of this module. Subsequently students will work through the module material provided on the VLE at a pace suggested within the VLE for the module. The material will include activities and review questions that allow students to assimilate the concepts and skills required by the module. Students will be encouraged to discuss relevant aspects within discussion forums that are part of the VLE. The forums will allow discussion with a student's peer group as well as the module tutor.
Students will have participated in an award induction workshop where they will learn how to use the Virtual Learning Environment (VLE) employed for the study of this module. Subsequently students will work through the module material provided on the VLE at a pace suggested within the VLE for the module. The material will include activities and review questions that allow students to assimilate the concepts and skills required by the module. Students will be encouraged to discuss relevant aspects within discussion forums that are part of the VLE. The forums will allow discussion with a student's peer group as well as the module tutor.
Module Texts
Database Systems: A Practical Approach to Design, Implementation and Management, Connolly and Begg, Addison Wesley, 5th Edition, 16 April 2009, ISBN-10: 0321523067
Additional directed Online reading of papers from Oracle, Microsoft, User Group Meetings and Conferences, Journals, etc.
Additional directed Online reading of papers from Oracle, Microsoft, User Group Meetings and Conferences, Journals, etc.