Advanced Database Systems

  • Information Systems |

Description

his 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 -132 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 Javas 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 , Bart Baesens Frontmatter, Principles of Database Management: The Practical Guide to Storing, Managing and Analyzing Big and Small Data, Cambridge University Press.

Course Content

content serial Description
1Introduction
2DB Design Methodology & Use of UML Diagram
3Data warehousing and business intelligence
4Data warehouse Modelling
5Multidimensional modelling and OLAP
6Introduction to Data Mining
7Introduction to Data Mining (cont.)
8Data Mining Techniques 1
9Data Mining Techniques 2
10Web DB Basics & Cloud Databases
11Approaches to Integrate Web and DBs
12NOSQL Databases
13NOSQL Databases (cont)
14Big Data and Hadoop, and Map Reduce
15Student Seminars.

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.