Advanced Database Systems

  • Computing & Information Technology |
  • English

Description

This course is an extension of Database Systems course. It covers advanced topics and divergences in DB field. Advanced topics would include business intelligence, data warehousing, OLAP, data mining, web databases, NOSQL databases, and cloud databases. This course will be studying how to develop robust transactional database applications using standard database connectivity ODBC and the role of persistence frameworks & application servers with a persistence service in DB application development. Personal and team projects on databases and database application components development will be key components of the course using the open-source object-relational DB systems.

Program

Information Systems Program.

Objectives

  • 1. Explain the concepts for modeling, designing, querying and managing large databases.
    2. Experiment with the modeling and design of data warehousing and OLAP, data mining, web databases, XML databases, and mobile cloud databases.
    3. Develop Transactional web-database applications using suitable database connectivity.
    4. Develop cloud database application com-ponents using the open-source DB systems.

Textbook

Wilfried Lemahieu, Seppe vanden Broucke, and Bart Baesens, Principles of Database Management, Cambridge University Press

Course Content

content serial Description
1Introduction
2DB Design Methodology & Use of UML Diag.
3Data warehousing and business intelligence
4Data warehouse Modelling
5Multidimensional modelling and OLAP
6Introduction to Data Mining
77th Week Exam
8Data Mining Techniques 1
9Data Mining Techniques 2
10Web DB Basics & Cloud Databases
11Approaches to Integrate Web and DBs
1212th Week Exam
13NOSQL Databases
14Big Data and Hadoop, and Map Reduce
15Student Seminars
16Final Exam

Markets and Career

  • Generation, transmission, distribution and utilization of electrical power for public and private sectors to secure both continuous and emergency demands.
  • Electrical power feeding for civil and military marine and aviation utilities.
  • Electrical works in construction engineering.

Start your application

Start The your journey to your new career.