Advanced Database Systems

  • Information Systems |
  • English

Description

This course is an extension of Database Systems course. It covers advanced topics and divergences in DB field. Advanced topics would include data warehousing, OLAP, data mining, web databases, XML databases, and mobile databases. This course will be studying how to develop robust transactional database applications using Java`s open-standard database connectivity JDBC 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 system MySQL.

Program

IS -144 CRs

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 databases.
    3. Develop Transactional database applications using Java`s open-standard database connectivity JDBC.
    4. Develop database application components using the open-source object-relational DB system MySQL.

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.