Advanced Database Systems

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.