Moat importantly, A DBMS is a programme that enables database creation, specification and manipulation, allowing users to easily store, process and analyse information.
DBMS provides one with an interface or a tool to conduct different operations, such as building databases, storing data in them, updating data, creating database tables, and much more.
The DBMS also provides databases with privacy and security. In the case of multiple users, it also ensures data consistency.
Example of DBMS :
- MySql
- Oracle
- SQL Server
- IBM DB2
Characteristics of DBMS
- Data stored into tables
- Reduced redundancy
- Query language
- Data consistency
- Security
- DBMS support transactions
- Support multiple user and concurrent access
Architecture
The architecture of a database management system influences its design. When dealing with a large number of PCs, web servers, database servers, and other network elements, the same client/server architecture is used.
In short, a client/server architecture is made up of several PCs and a workstation that are all linked by a network. The design of a database management system is determine by how users link to the database in order to complete their requests.
A single tier or multi-tier database architecture can be seen. However, database design can be divide into two categories: 2-tier architecture and 3-tier architecture.
1-tier Architecture :
The database is directly accessible to the user in this architecture. Meanwhile, the user can sit on the DBMS and use it directly. Moreover, any modifications made here will be applied directly to the database. In addition, it does not provide end users with a useful tool.
2-tier Architecture :
The 2-tier architecture is similar to the basic client-server architecture. In other words, Client-side applications can interact directly with the database on the server side in a two-tier architecture. APIs such as ODBC and JDBC is use for this interaction. The client-side runs the user interfaces and application programs.
3-tier Architecture :
Between the client and the server is another layer in the 3-tier architecture. Further, The client cannot communicate directly with the server in this architecture. Additionally, The client-side program communicates with an application server, which in turn communicates with the database system.
Interested in learning about similar topics? Here are a few hand-picked blogs for you!
- What is SQL?
- Describe Cryptography?
- What is sorting algorithm?
- Explain machine learning?
- What is cloud computing?