Ques What is DBMS . Explain the basic architecture of DBMS ? Database • • Database is a collection of inter-related data which is used to retrieve, insert and delete the data efficiently. It is also used to organize the data in the form of table, schema, views and reports etc. • For example: College Database organizes the data about the admin, staff, students and faculty etc. • Using the database, you can easily retrieve, insert and delete the information. Database Management System Database management system is software which is used to manage the database.
For example: MySQL, Oracle etc. are very popular commercial database which are used in different applications. DBMS allows users the following tasks: • • • • Data Definition: It is used for creation, modification and removal of definition that defines the organization of data in database. Data Updating: It is used for insertion, modification and deletion of the actual data in the database. Data Retrieval: It is used to retrieve the data from the database which can be used by applications for various purposes. User Administration: It is used for registering and monitoring users, maintain data integrity, enforcing data security, dealing with concurrency control, monitoring performance and recovering information corrupted by unexpected failure. Features of DBMS • • • • It is used to support manipulation and processing of data. It is used to provide security of data. It can view the database from different viewpoints according to the requirements of the user. It uses a digital repository established on a server to store and manage the information. DBMS Architecture ( system structure question is different) • • The DBMS design depends upon its architecture. Database architecture depends upon how users are connected to the database to get their request done. Types of DBMS Architecture
Database architecture can be seen as single tier or multi-tier. But logically, database architecture is of two types like: two tier architecture and three tier architecture. 1-Tier Architecture • • In the 1-Tier architecture, database is directly available to the user. It means user can directly sits on the DBMS and uses it. The 1-Tier architecture is used for development of local application, where programmers directly communicate with the database for quick response. 2-Tier Architecture • • • • • The 2-Tier architecture is same as basic client-server. In the two tier architecture, applications on the client end can directly communicate with the database at the server side. For this interaction, API's like: ODBC, JDBC are used. The user interfaces and application programs are run on client side. The server side is responsible to provide the functionalities like: query processing and transaction management. To communicate with the DBMS, client side application establishes a connection with the server side. 3-Tier Architecture • The 3-Tier architecture contains another layer between the client and server. In this architecture, client can't directly communicate with the server.
• • • The application on the client-end interacts with an application server which further communicates with the database system. End user has no idea about the existence of the database beyond the application server. The database also has no idea about any other user beyond the application. The 3-Tier architecture is used in case of large web application. Briefly explain about database system architecture? (2017)