Document Details

WarmRhodolite

Uploaded by WarmRhodolite

University of Sadat City

2023

Dr. Ahmed Tealeb

Tags

database systems database architecture DBMS computer science

Summary

This document is a lecture on Database Systems-1, providing an overview of database models, architectures, and languages. It is part of the 1st Semester 2022-2023 curriculum at the University of Sadat City.

Full Transcript

1 University of Sadat City Faculty of Computers and Artificial Intelligence (FCAI) Database Systems-1 (IS301) Lecture 2 Presented By: Dr. Ahmed Tealeb Information Systems Department 1s...

1 University of Sadat City Faculty of Computers and Artificial Intelligence (FCAI) Database Systems-1 (IS301) Lecture 2 Presented By: Dr. Ahmed Tealeb Information Systems Department 1st Semester 2022-2023 Fundamentals of Database Systems Seventh Edition Chapter 2 Copyright © 2016, 2011, 2007 Pearson Education, Inc. All Rights Reserved Learning Objectives Copyright © 2016, 2011, 2007 Pearson Education, Inc. All Rights Reserved Data Models (1 of 2) – – – – Copyright © 2016, 2011, 2007 Pearson Education, Inc. All Rights Reserved Data Models (2 of 2) – – Copyright © 2016, 2011, 2007 Pearson Education, Inc. All Rights Reserved Categories of Data Models – ▪ – – – Copyright © 2016, 2011, 2007 Pearson Education, Inc. All Rights Reserved Schemas Versus Instances (1 of 2) – – – – Copyright © 2016, 2011, 2007 Pearson Education, Inc. All Rights Reserved Schemas Versus Instances (2 of 2) – – ▪ Copyright © 2016, 2011, 2007 Pearson Education, Inc. All Rights Reserved Database Schema V s Database State (1 of 2) ersu – – – Copyright © 2016, 2011, 2007 Pearson Education, Inc. All Rights Reserved Database Schema V s Database State (2 of 2) ersu – – Copyright © 2016, 2011, 2007 Pearson Education, Inc. All Rights Reserved Example of a Database Schema Copyright © 2016, 2011, 2007 Pearson Education, Inc. All Rights Reserved Example of a Database State (1 of 4) Figure 1.2 A database that stores student and course information. COURSE Copyright © 2016, 2011, 2007 Pearson Education, Inc. All Rights Reserved Example of a Database State (2 of 4) Copyright © 2016, 2011, 2007 Pearson Education, Inc. All Rights Reserved Example of a Database State (3 of 4) Copyright © 2016, 2011, 2007 Pearson Education, Inc. All Rights Reserved Example of a Database State (4 of 4) Copyright © 2016, 2011, 2007 Pearson Education, Inc. All Rights Reserved Three-Schema Architecture (1 of 3) – – Copyright © 2016, 2011, 2007 Pearson Education, Inc. All Rights Reserved Three-Schema Architecture (2 of 3) – ▪ – ▪ – ▪ Copyright © 2016, 2011, 2007 Pearson Education, Inc. All Rights Reserved Figure 2.2 The Three-Schema Architecture Copyright © 2016, 2011, 2007 Pearson Education, Inc. All Rights Reserved Three-Schema Architecture (3 of 3) – – Copyright © 2016, 2011, 2007 Pearson Education, Inc. All Rights Reserved Data Independence (1 of 2) – – – Copyright © 2016, 2011, 2007 Pearson Education, Inc. All Rights Reserved Data Independence (2 of 2) – Copyright © 2016, 2011, 2007 Pearson Education, Inc. All Rights Reserved DBMS Languages (1 of 3) – ▪ – ▪ Copyright © 2016, 2011, 2007 Pearson Education, Inc. All Rights Reserved DBMS Languages (2 of 3) – – – ▪ Copyright © 2016, 2011, 2007 Pearson Education, Inc. All Rights Reserved DBMS Languages (3 of 3) – – ▪ – Copyright © 2016, 2011, 2007 Pearson Education, Inc. All Rights Reserved Types of DML – – – – – Copyright © 2016, 2011, 2007 Pearson Education, Inc. All Rights Reserved User-Friendly DBMS Interfaces Copyright © 2016, 2011, 2007 Pearson Education, Inc. All Rights Reserved Other DBMS Interfaces Copyright © 2016, 2011, 2007 Pearson Education, Inc. All Rights Reserved Database System Utilities – – – – – – Copyright © 2016, 2011, 2007 Pearson Education, Inc. All Rights Reserved Other Tools (1 of 2) – – – Copyright © 2016, 2011, 2007 Pearson Education, Inc. All Rights Reserved Other Tools (2 of 2) – – – Copyright © 2016, 2011, 2007 Pearson Education, Inc. All Rights Reserved Typical DBMS Component Modules Copyright © 2016, 2011, 2007 Pearson Education, Inc. All Rights Reserved Centralized and Client-Server DBMS Architectures – – Copyright © 2016, 2011, 2007 Pearson Education, Inc. All Rights Reserved Figure 2.4 A Physical Centralized Architecture Copyright © 2016, 2011, 2007 Pearson Education, Inc. All Rights Reserved Basic 2-Tier Client-Server Architectures – – – – – Copyright © 2016, 2011, 2007 Pearson Education, Inc. All Rights Reserved Figure 2.5 Logical Two-Tier Client Server Architecture Copyright © 2016, 2011, 2007 Pearson Education, Inc. All Rights Reserved Clients – Copyright © 2016, 2011, 2007 Pearson Education, Inc. All Rights Reserved DBMS Server – – Copyright © 2016, 2011, 2007 Pearson Education, Inc. All Rights Reserved Two Tier Client-Server Architecture Copyright © 2016, 2011, 2007 Pearson Education, Inc. All Rights Reserved Three Tier Client-Server Architecture – – – – – – Copyright © 2016, 2011, 2007 Pearson Education, Inc. All Rights Reserved Three-Tier Client-Server Architecture Copyright © 2016, 2011, 2007 Pearson Education, Inc. All Rights Reserved Classification of DBMSs – – – – – Copyright © 2016, 2011, 2007 Pearson Education, Inc. All Rights Reserved Cost Considerations for DBMSs – – Copyright © 2016, 2011, 2007 Pearson Education, Inc. All Rights Reserved Other Considerations – – Copyright © 2016, 2011, 2007 Pearson Education, Inc. All Rights Reserved History of Data Models (Additional Material) Copyright © 2016, 2011, 2007 Pearson Education, Inc. All Rights Reserved History of Data Models – – – Copyright © 2016, 2011, 2007 Pearson Education, Inc. All Rights Reserved Network Model (1 of 2) – – – ▪ Copyright © 2016, 2011, 2007 Pearson Education, Inc. All Rights Reserved Network Model (2 of 2) – – ▪ Copyright © 2016, 2011, 2007 Pearson Education, Inc. All Rights Reserved History of Data Models (1 of 4) – – – – Copyright © 2016, 2011, 2007 Pearson Education, Inc. All Rights Reserved Hierarchical Model – – – ▪ – – – Copyright © 2016, 2011, 2007 Pearson Education, Inc. All Rights Reserved History of Data Models (2 of 4) – – – – – – Copyright © 2016, 2011, 2007 Pearson Education, Inc. All Rights Reserved History of Data Models (3 of 4) – – – – – Copyright © 2016, 2011, 2007 Pearson Education, Inc. All Rights Reserved History of Data Models (4 of 4) – – – – – Copyright © 2016, 2011, 2007 Pearson Education, Inc. All Rights Reserved Chapter Summary Copyright © 2016, 2011, 2007 Pearson Education, Inc. All Rights Reserved Copyright Copyright © 2016, 2011, 2007 Pearson Education, Inc. All Rights Reserved

Use Quizgecko on...
Browser
Browser