Database Architecture is a representation of DBMS design. It uses programming languages to design a particular type of software for businesses or organizations. It focuses on the design, development, implementation, and maintenance of computer programs that store and organize information for businesses, agencies, and institutions.
A Database stores critical information and helps access data quickly and securely. Therefore, selecting the correct Architecture of DBMS helps in easy and efficient data management.
Types of DBMS Architecture
|Sr No.||2-Tier Architecture||3-Tier Architecture|
|1.||A 2-tier architecture is a database architecture where the presentation layer runs on a client and data is stored on a server called the second tier.||A 3-tier architecture is a client-server architecture in which the development and maintenance of functional processes, logic, data access, data storage, and the user interface are done independently.|
|2.||It is a client-server architecture.||It is a web-based application.|
|3.||It is easy to build and maintain.||It is complex to build and maintain.|
|4.||In a 2-tier architecture, one server is connected with different clients.||3-tier database architecture design is an extension of 2-tier client-server architecture.|
|5.||It runs slower.||It runs faster.|
|6.||It is less secure as clients can communicate directly to the database.||It is secured as the client is not allowed to communicate directly.|
|7.||It results in a loss of performance whenever users increase rapidly.||It results in performance loss when the system is running on the internet but gives the performance more than 2-tier architecture.|
|8.||For example, A contact management system was created using MS- Access.||For example Any large website on the internet|