Vidya pratishthans Arts Science and Commerce College Baramati
Vidya pratishthan’s Arts, Science and Commerce College, Baramati By Awate A. R. 1
Edgar F. Codd Edgar Frank "Ted" Codd (August 23, 1923 – April 18, 2003) was an English computer scientist who, while working for IBM, invented the relational model for database management . 2
What is a Data Base ? Collection of related files containing records of people, places, things, etc. Data base makes Data easy to access and manage. A Database Management System (DBMS) is a software package designed to store and manage databases. 3
Why do we need a Database ? A database is a place where you can store information related to a specific topic. Data security and integrity. Concurrent access, recovery. 4
Three level Data Abstraction View 1 ……. . . View 2 Logical Level Physical Level 5 View n
Architecture Client: The client are the user machine which request for the service to the server. It is also called as front end. Server: It is a machine which provide service to the client. It is also called as back end. 6
Two tier Architecture User Application Database System Application program are present in client Client machine and database are present at server and both are Network connected with interface like JDBC and ODBC Server. 7
Three Tier Architecture User Client Application Client Network Application Server Database System Server 8 In three tier architecture communicati on takes place from client to server and then application to database.
9
- Slides: 9