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