ITMC322 : Heterogeneous and Mobile Databases

Department

Department of Mobile Computing

Academic Program

Bachelor in Mobile Computing

Type

Compulsory

Credits

03

Prerequisite

ITGS228

Overview

This course extensively discusses multi-database systems (MDBS) and mobile data access systems (MDAS); moreover, it will studies traditional distributed database issues within the framework of MDBSs and MDASs. Topic include: introduction to Mobile Database System; Database System architectures; Distributed Database systems( Query, Transaction, Recovery and Concurrency control, Security) MDBS ( Definition, Issues in MDBS systems, Approaches to MDBS systems, Query Processing, Transaction Processing, Recovery and Concurrency Control, Security); Mobile Data Access systems( Mobility issues, On-demand services, Broadcast services, Transaction, Security). The course balance theory with practice; Students will gain experience working with databases for mobile devices.

Intended learning outcomes

Knowledge &understand 

  • For the student to explain the mini-project that he was assigned to by discussing it with the professor.
  • The student explains the question asked to him during the lecture and gives a satisfactory answer.
  • To familiarize the student with the components of the system he is working on through practical lectures.
  • The student draws models to design the required database.
  • To familiarize the student with different database engines and deal with different combinations of data.

mental skills

  • That the student relates the written events to prototypes of a required database.
  • The student analyzes the requirements and puts them in the form of a database model.
  • That the student compares between the traditional solution and the modern solution or method in creating a database.
  • The student proposes the appropriate solution according to the available requirements.
  • That the student solves an existing problem with the manual system and automate it to a proposed automated system.

Practical & professional skills

  • Ability to design a database in a mobile environment.
  • Work on different database engines, which are characterized by NoSQL.
  • Create applications that deal with different databases and datasets.

General and transferable skills

  • The student should be able to use modern technology in designing and implementing a database.
  • The student should be able to work in a team to create an integrated project that meets the work requirements.
  • The ability to use the computer and the Internet to search for a solution to a specific problem or a similar previous study.
  • Oral communication by making presentations on a specific topic assigned to the student.

Teaching and learning methods

  • Lectures
  • LAB Lectures
  • Problem-based learning
  • Mini-projects

Methods of assessments

  • Midterm exam = 30
  • Lab exam & Mini-project = 20
  • Final exam = 50

Course contents

  • Heterogeneous and Mobile Databases
  • Database Systems classification
  • Distributed Database
  • Issues in distributed databases
  • Distributed Database Recovery and Concurrency
  • Query optimization
  • Query optimization rules
  • NOSQL Database management system
  • Transactions in both RDBMS and NON-RDBMS
  • Basic Concepts, Techniques and Patterns IN NON-RDBMS
  • Document oriented Databases
  • Multidatabases and heterogeneity
  • Mobile Data Access systems
  • Graph Databases

Principles of Games Developments (ITMC404)
Parallel and Distributed Computing (ITMC403)
Mobile Multimedia (ITMC402)
Mobile 3D Graphics (ITMC401)
Mobile Commerce (ITMC304)
Programming Paradigms (ITMC302)
ARM microprocessor (ITMC301)
Arabic language 1 (ITAR111)
General English1 (ITEL111)
Physics (ITPH111)
Intro to Information Technology (ITGS111)
Problem solving Technic (ITGS113)
Mathematics I (ITMM111)
Arabic language 2 (ITAR122)
Mathematics II (ITMM122)
General English2 (ITEL122)
Introduction to Programming (ITGS122)
System Analysis and Design (ITGS124)
logic Circuit Design (ITGS126)
Introduction to Statistics (ITST211)
Object Oriented Programmin (ITGS211)
Introduction to Software Engineering (ITGS213)
Introduction to Networking (ITGS215)
Discrete Structures (ITGS217)
Numerical analysis (ITGS219)
Computer Architucture & Organization (ITGS223)
Data Structure (ITGS220)
Foundation of Information Systems (ITGS222)
Information Security (ITGS224)
Introduction to Internet Programming (ITGS226)
Introduction to Databases (ITGS228)
Mobile Applications Development (ITMC311)
Design and Analysis algorithms (ITGS301)
Operating System (ITGS302)
Principles of mobile communication networks (ITMC312)
IT Project Management (ITGS303)
Scientific Writing (ITGS304)
Cross-Platform Mobile App Development (Flutter) (ITMC323)
Heterogeneous and Mobile Databases (ITMC322)
Mobile Interaction Design (ITMC321)
Mobile Operating System (ITMC313)
Security in mobile computing (ITMC411)
Personal Area Networks (ITMC412)
Social Networking (ITMC413)
Networks Programming (ITMC414)
Fundamentals ubiquitous computing (ITMC421)
Cloud Computing (ITMC422)