DBMS Architecture

-
  • 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.
  • DBMS architecture depends upon how users are connected to the database to get their request done.

टिप्पणियाँ

एक टिप्पणी भेजें

इस ब्लॉग से लोकप्रिय पोस्ट

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 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. Fig: 2-tier Architecture
और पढ़ें

Database management system

-
चित्र
Database management system is a software which is used to manage the database. For example: MySQL, Oracle, etc are a very popular commercial database which is used in different applications. DBMS provides an interface to perform various operations like database creation, storing data in it, updating data, creating a table in the database and a lot more. It provides protection and security to the database. In the case of multiple users, it also maintains data consistency.
और पढ़ें

Advantages of DBMS

-
Controls database redundancy:  It can control data redundancy because it stores all the data in one single database file and that recorded data is placed in the database. Data sharing:  In DBMS, the authorized users of an organization can share the data among multiple users. Easily Maintenance:  It can be easily maintainable due to the centralized nature of the database system. Reduce time:  It reduces development time and maintenance need. Backup:  It provides backup and recovery subsystems which create automatic backup of data from hardware and software failures and restores the data if required. multiple user interface:  It provides different types of user interfaces like graphical user interfaces, application program interfaces
और पढ़ें