Structure of a DBMS/Architecture of a DBMS

Structure of a DBMS/Architecture of a DBMS

• 1.
  Database Management Systems Structureof a DBMS/ Architecture of a DBMS by GOWRU BHARATH KUMAR M.Tech, (Ph.D) Assistant Professor You are My creator, But I am Your Master
• 2.
  DBMS Architecture • DBMSarchitecture depends upon how users are connected to the database to get their request done. • The DBMS design depends upon its architecture. The basic client/server architecture is used to deal with a large number of PCs, web servers, database servers and other components that are connected with networks. • The client/server architecture consists of many PCs and a workstation which are connected via the network. • Database architecture can be seen as a single tier or multi-tier. But logically, database architecture is of two types like: 2-tier architecture and 3-tier architecture.
• 3.
  Single tier architecture •In this architecture, the database is directly available to the user. It means the user can directly sit on the DBMS and uses it. • Any changes done here will directly be done on the database itself. It doesn't provide a handy tool for end users. • The 1-Tier architecture is used for development of the local application, where programmers can directly communicate with the database for the quick response.
• 4.
  Two-tier architecture • The2-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 the 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.
• 5.
  3-tier architecture • The3-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.
• 6.
  Based on theRelational Model The DBMS Architecture is Shown below
• 7.
  DBMS COMPONENT MODULES •Web forms (Unsophisticated users: Customers, Travel agents etc…) • Application front ends (The front-end is what a user sees and interacts with (user interface)) • SQL interface(Sophisticated users, application programmers, Database administrators) • SQL Commands • Plan Executor • Parser • Operator evaluator • Optimizer Standard Query Language Engine
• 8.
  DBMS COMPONENT MODULESCont… • Transaction manager • Lock manager • Files and Access methods • Buffer manager • Disk space manager • Recovery manager • Index files and Data Files • System catalog DBMS Database
• 9.
  For watching/ explanation •please click on https://www.youtube.com/watch?v=X7dE5bZLsXI&t=4s