People Innovation Excellence
 

Advanced Database Systems

Learning Outcomes

On successful completion of this Course, students will be able to: (1) Help the students 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 relational model, which is now the dominant system for business applications; (2) Understand the purpose of the development lifecycle and how this cycle relates to the database system development lifecycle. To describe the activities associates with each stage of the database systems development lifecycle. To introduce the entity relationship (ER) model, a high-level conceptual data model, and to discuss the usefulness of this modelling technique in the database design. (3) Understand the concepts of object-oriented DBMS and object-relational DBMS as a major trend of the developments in the database systems area, which overcome the relational model problems. The aim of this course is to examine the object-oriented DBMS (OODBMS). The course first provides an introduction to object-oriented data models and persistent languages. (4) Capable to examine the object-relational DBMS as an alternative products in the market, and provide a detailed overview of the object management features that have been added to the new release of the SQL standard. Also includes in this course, the integration of the DBMS into the Web environment, to examines the appropriateness of the Web as a database application platform. (5) 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 (6) 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. Overview of Relational Data Model
  2. Relational Database Development
  3. Object Oriented Data model
  4. Object Oriented Database Design
  5. Object Relational Database System
  6. Object Definition Language (ODL)
  7. Guest Lecturer : Object Relational Definition and Query Language
  8. Data Warehousing Concepts
  9. Data Warehousing Designs
  10. On Line Applications Processing
  11. Data Mining Concepts
  12. Data Mining Applications

 


Published at :

Periksa Browser Anda

Check Your Browser

Situs ini tidak lagi mendukung penggunaan browser dengan teknologi tertinggal.

Apabila Anda melihat pesan ini, berarti Anda masih menggunakan browser Internet Explorer seri 8 / 7 / 6 / ...

Sebagai informasi, browser yang anda gunakan ini tidaklah aman dan tidak dapat menampilkan teknologi CSS terakhir yang dapat membuat sebuah situs tampil lebih baik. Bahkan Microsoft sebagai pembuatnya, telah merekomendasikan agar menggunakan browser yang lebih modern.

Untuk tampilan yang lebih baik, gunakan salah satu browser berikut. Download dan Install, seluruhnya gratis untuk digunakan.

We're Moving Forward.

This Site Is No Longer Supporting Out-of Date Browser.

If you are viewing this message, it means that you are currently using Internet Explorer 8 / 7 / 6 / below to access this site. FYI, it is unsafe and unable to render the latest CSS improvements. Even Microsoft, its creator, wants you to install more modern browser.

Best viewed with one of these browser instead. It is totally free.

  1. Google Chrome
  2. Mozilla Firefox
  3. Opera
  4. Internet Explorer 9
Close