B.Sc.in Management and Information Technology (Interim)

BACHELOR OF SCIENCE IN MANAGEMENT AND INFORMATION TECHNOLOGY

IMIT 43016

Data Engineering

Status :  Core Pre-requisite :IMIT 12043 Co-requisite :None

 

On completion of this course, the student should be able to:

  • Explain the concepts of transaction processing in Database Management Systems and security of database systems
  • Explain the state-of-the-art of database technologies and use these techniques to develop database systems to exploit data as a corporate resource.

Relational Algebra. Query optimization: different approaches of building query, query trees, query graphs, database security. Concurrency & recovery: transaction, types of transaction, problems with uncontrolled concurrency, immediate update, differed update, check point, time stamping and locking. Distributed database architectures: distributed queries, data integration, interoperability, legacy systems. Object-oriented DBMSs. Parallel Databases. Data warehouses: data warehouse architectures, data warehouse design, Online Analytical Processing (OLAP). Data mining,
Lectures, supervised self-study and group work.
End-of- semester examination and continuous assessment.

  1. Connolly, T., Begg, C., Wesley, A., “Database Systems: A Practical Approach to Design, Implementation, and Management ”, 3rd Edition, , 2002.
  2. Kimble R., “Data Warehouse Toolkit”, 2rd Edition, 2002, John Wiley & Sons.

Back