Prerequisites for Module
None except for course entry requirements.
Corequisite Modules
None.
Precluded Modules
None.
Aims of Module
To provide systematic understanding of up-to-date issues, techniques and technologies for developing robust, usable and scalable database management systems for big data.
Learning Outcomes for Module
On completion of this module, students are expected to be able to:
| 1. |
Critically appraise relational database principles and practices in the context of transferability to complex large-scale data stores.
|
| 2. |
Develop robust and scalable systems that integrate web technologies for databases and database connectivity.
|
| 3. |
Critically appraise relational and schema-less database offerings (e.g. NoSQL) for a significant technical problem.
|
| 4. |
Design and implement a solution to a significant industry-focused problem providing insights and conclusions about challenges, opportunities and risks for big data management.
|
Indicative Module Content
Database analysis and design: Entity-Relationship modelling, Object-Oriented and Object-Relational databases.
Data management: data storage, standards and exchange. Data administration methods. File systems for Massively parallel processing, hashing and key-value pair representations;
Databases and the internet; modelling and design of data intensive web sites; web interfaces for DB systems; the XML language.
Indicative Student Workload
Contact Hours
| Part Time | Laboratories
| 24 | Lectures/ Tutorisls
| 24 |
Directed Study
| | Coursework Preparation
| 22 | Directed Reading
| 30 |
Private Study
| | Private Study and Reading
| 50 |
| Mode of Delivery
Key concepts are introduced and illustrated through lectures and directed reading. The understanding of the students is tested and further enhanced through interactive tutorials. In the laboratories the student will progress through a sequence of practical exercises to develop sufficient knowledge of database applications.
Assessment Plan
|
Learning Outcomes Assessed
| | Component 1 | 1,2,3,4
|
Component 1 - This is a coursework assignment consisting of two parts:
a relational DB development exercise contributing 50% of the total module assessment; and
a schema-less DB development exercise contributing 50% of the total module assessment.
Indicative Bibliography
| 1. | CONNOLLY, T. AND BEGG, C., 2015. Database Systems: A Practical Approach to Design, Implementation and Management. Pearsons.
| | 2. | DIETRICH, S.W. AND URBAN, S.D., 2005. An Advanced Course in Database Systems: Beyond Relational Databases. Pearson Prentice Hall.
| | 3. | GORDON, K., 2013. Principles of Data Management: Facilitating Information Sharing (2nd Edition). BCS
| | 4. | RUSSELL, J., 2014. Getting Started with Impala: Interactive SQL for Apache Hadoop. O’Reilly
| | 5. | CAPRIOLO, E., WAMPLER, D., RUTHERGLEN, J., 2012. Programming HIVE. O’Reilly
| | 6. | GUPTA, S., 2012. Oracle Advanced PL/SQL Developer Professional Guide. Packt
|
|