COMP08151 2018 Advanced Database Concepts

General Details

Full Title
Advanced Database Concepts
Transcript Title
Advanced Database Concepts
Code
COMP08151
Attendance
N/A %
Subject Area
COMP - Computing
Department
COEL - Computing & Electronic Eng
Level
08 - NFQ Level 8
Credit
05 - 05 Credits
Duration
Semester
Fee
Start Term
2018 - Full Academic Year 2018-19
End Term
9999 - The End of Time
Author(s)
John Weir, Padraig Harte
Programme Membership
SG_KSOFT_E08 201900 Certificate in Software Development SG_KSFTD_K08 201900 Bachelor of Science (Honours) in Computing in Software Development (Add On) SG_KSODV_K08 201900 Level 8 Honours Degree Add-on in Software Development SG_KSODV_H08 201900 Bachelor of Science (Honours) in Computing in Software Development SG_KCMPU_H08 201900 Bachelor of Science (Honours) in Computing
Description

This will focus on working with database objects such as triggers, user defined functions. It will further examine storing and manipulating non-relational data objects such as xml (producing data, schemas and schematrons), JSON and other non relational objects such as Spatial and Hierarchical data. How to model, develop and manipulate graph tables will also be covered.

Learning Outcomes

On completion of this module the learner will/should be able to;

1.

Design and create database triggers

2.

Design and create user defined functions

3.

Create and manipulate XML objects

4.

Store and manipulate other non relational data objects

5.

Model, create and manipulate complex data relationships using graph  tables

Teaching and Learning Strategies

Practical Approach to teaching ‑ problem based learning techniques will be applied where appropriate.

Virtual Machines will be used to allow flexibility and enhance learning

Module Assessment Strategies

 

50% continuous assessment. Students have to complete a project with staged submissions throughout the semester. The project will require the student to practically apply their learning to prescribed case study scenarios. There will be a final laboratory based exam at the end also worth 50%.

 

Repeat Assessments

Repeat exam to cover learning outcomes.

Indicative Syllabus

Design and create database triggers

  • Insert triggers.
  • Delete triggers.
  • Update triggers.
  • Instead of and recursive triggers.

Design and create user defined functions

  • Scalar functions.
  • In line functions.
  • Multi statement functions.

Create and manipulate XML objects

  • XML data and datatypes
  • XML schemas and schematron
  • Creating XML documents
  • Shredding xml documents

Store and manipulate other no-relational data objects

  • Storing and manipulating spatial Data
  • Storing and manipulating hierarchial data
  • Creating and shredding JSON

Model, create and manipulate complex data relationships using graph tables

  • Logical design nodes and edges for complex data relationships
  • Create graph tables
  • Interrogate graph tables

 

 

 

 

Coursework & Assessment Breakdown

Coursework & Continuous Assessment
50 %
End of Semester / Year Formal Exam
50 %

Coursework Assessment

Title Type Form Percent Week Learning Outcomes Assessed
1 Project Work in a laboratory environment requiring the student to practically apply their learning to prescribed case study scenarios. Continuous Assessment Project 50 % OnGoing 1,2,3,4
             
             

End of Semester / Year Assessment

Title Type Form Percent Week Learning Outcomes Assessed
1 Practical Evaluation End of Module Laboratory Exam Final Exam Open Book Exam 50 % End of Semester 1,2,3,4,5
             
             

Full Time Mode Workload


Type Location Description Hours Frequency Avg Workload
Lecture Not Specified Lectures advance database concepts 1 Weekly 1.00
Laboratory Practical Computer Laboratory Advance database implementation 2 Weekly 2.00
Independent Learning Not Specified Independent Learning 4 Weekly 4.00
Total Full Time Average Weekly Learner Contact Time 3.00 Hours

Online Learning Mode Workload


Type Location Description Hours Frequency Avg Workload
Lecture Distance Learning Suite Lecture 1.5 Weekly 1.50
Directed Learning Not Specified Directed Learning 1.12 Weekly 1.12
Independent Learning Not Specified Independent Learning 4.5 Weekly 4.50
Total Online Learning Average Weekly Learner Contact Time 2.62 Hours

Required & Recommended Book List

Recommended Reading
2013-07-26 Cloud Database Development and Management Auerbach Publications

Although todays job market requires IT professionals to understand cloud computing theories and have hands-on skills for developing real-world database systems, there are few books available that integrate coverage of both. Filling this void, Cloud Database Development and Management explains how readers can take advantage of the cloud environment to develop their own fully functioning database systems without any additional investment in IT infrastructure.

Filled with step-by-step instructions, examples, and hands-on projects, the book begins by providing readers with the required foundation in database systems and cloud-based database development tools. It supplies detailed instructions on setting up data storage on Windows Azure and also explains how readers can develop their own virtual machines with Windows Server 2012 as the guest operating system.

The books wide-ranging coverage includes database design, database implementation, database deployment to the cloud environment, SQL Database, Table Storage service, Blob Storage service, Queue Storage service, and database application development. The text deals with all three aspects of database design: conceptual design, logical design, and physical design. It introduces the SQL language, explains how to use SQL to create database objects, and introduces the migration of the database between Windows Azure and the on-premises SQL Server. It also discusses the management tasks that keep both SQL Database and Windows Azure running smoothly.

Detailing how to design, implement, and manage database systems in the cloud, the book provides you with tools that can make your cloud database development much more efficient and flexible. Its easy-to-follow instructions will help you develop the hands-on skills needed to store and manage critical business information and to make that data available anytime through the Internet.

Module Resources

Journal Resources

---

URL Resources

---

Other Resources

---

Additional Information

---