ADVANCED DATABASE SYSTEMS (3 Credits)

Learning Outcomes:

On successful completion of this course, students will be able to: Appreciate that database are widespread nowadays. The course discusses the development of the database approach and introduces the DBMS environment. The course is also to introduce the terminology and concepts of the data warehousing, which is now the important system for business intelligence and applications; Understand the concepts of data warehousing and to discuss how these systems are capable of potentially delivering competitive advantage to an organization. The course also describes the relationship between data warehousing and Online Transaction Processing (OLAP) systems and to identify the main characteristics of this systems and to describe Online Analytical Processing (OLAP) and the main features associated with OLAP applications; Understand the purpose of the development life cycle and how this cycles relates to the database ware house development lifecycle. To describe the activities associates with each stage of the database ware house lifecycle. To introduce the dimensional modelling, a high-level conceptual data model, and to discuss the usefulness of this modelling technique in the data warehouse design; Describe the concept of Data Mining (DM) and the main features of DM applications, the main characteristics of data mining operations and associated techniques, and the process of DM and the main features of DM tools

Topics:

1. Introduction to Data Warehouse;
2. Decision Support and Business Intelligence Systems;
3. Elements of the Data Warehouse;
4. Basic Processes of the Data Warehouse;
5. Dimensional Modeling;
6. Business Requirement Definition;
7. Dimensional Design;
8. Data  Warehouse Architecture;
9. Metadata and the Metadata Catalog;
10. End User Applications