CS2FD16-Advanced Databases

Module Provider: School of Mathematical, Physical and Computational Sciences
Number of credits: 10 [5 ECTS credits]
Level:5
Terms in which taught: Spring term module
Pre-requisites:
Non-modular pre-requisites:
Co-requisites: CS2DB16 Databases
Modules excluded:
Module version for: 2016/7

Module Convenor: Dr Hong Wei

Email: h.wei@reading.ac.uk

Summary module description:
An advanced module on databases.

Aims:
To extend the knowledge gained in CS2DB16 to provide the student with a deeper knowledge of data modelling, and non-relational database systems.

Assessable learning outcomes:
The student will be able to:
• Evaluate non-relational data models such as XML and RDF
• Define and validate an XML schema to represent a given data model
• Use XML tools to manipulate XML documents
• Define simple RDF schemas
• Query RDF data
• Distributed databases and multidimensional databases
• Be aware of the issues around the design, capture and use of metadata

Additional outcomes:
The student will be aware of the issues associated with managing many separate databases and large quantities of unstructured data.

Outline content:
An underlying theme of the module is the importance of identifying selection criteria for deciding when a particular tool or approach should be used. The indicative content includes
Advanced modelling, XML schema, RDF, OLAP and data warehousing.

Brief description of teaching and learning methods:
The theoretical part of the course will be delivered via lectures. The practicals will be used to develop alternative representations and extensions to the database model developed in CS2DB16.

Contact hours:
  Autumn Spring Summer
Lectures 18
Practicals classes and workshops 6
Guided independent study 76
       
Total hours by term 100.00
       
Total hours for module 100.00

Summative Assessment Methods:
Method Percentage
Written exam 70
Set exercise 30

Other information on summative assessment:

Formative assessment methods:

Penalties for late submission:
The Module Convenor will apply the following penalties for work submitted late, in accordance with the University policy.

  • where the piece of work is submitted up to one calendar week after the original deadline (or any formally agreed extension to the deadline): 10% of the total marks available for the piece of work will be deducted from the mark for each working day (or part thereof) following the deadline up to a total of five working days;
  • where the piece of work is submitted more than five working days after the original deadline (or any formally agreed extension to the deadline): a mark of zero will be recorded.

  • The University policy statement on penalties for late submission can be found at: http://www.reading.ac.uk/web/FILES/qualitysupport/penaltiesforlatesubmission.pdf
    You are strongly advised to ensure that coursework is submitted by the relevant deadline. You should note that it is advisable to submit work in an unfinished state rather than to fail to submit any work.

    Length of examination:
    One 2-hour examination paper in May/June.

    Requirements for a pass:
    A mark of 40% overall

    Reassessment arrangements:
    Examination only. One 2-hour examination paper in August/September.

    Additional Costs (specified where applicable):
    1) Required text books:
    2) Specialist equipment or materials:
    3) Specialist clothing, footwear or headgear:
    4) Printing and binding:
    5) Computers and devices with a particular specification:
    6) Travel, accommodation and subsistence:

    Last updated: 4 January 2017

    Things to do now