Skip to main content

DBMS Architecture | 1-tier | 2-tier | 3-tier architecture

Image
By

DBMS Architecture

DBMS Architecture (database management system architecture) 

Types of DBMS Architecture

1-tier architecture
2-tier architecture
3-tier architecture

DBMS Architecture

  • DBMS design depends on its architecture. Basic client/server architecture is used to deal with the large number of PCs, web servers, database servers and other components that are associated with the network.
  • Client/Server Architecture consists of multiple PCs and a workstation which are connected via a network.
  • The DBMS architecture depends on how the users are connected to the database to receive their requests.

Types of DBMS Architecture

Database Architecture can be viewed as single tier or multi-tier. But logically, there are two types of Database Architecture such as: 2-tier architecture and 3-tier architecture.

1-Tier Architecture

  • In this architecture, the database is directly available to the user. This means that the user can access the DBMS directly.
  • The changes made here will be done directly on the database itself. It does not provide handy tools for end users.
  • 1-tier architecture is used for local application development, where programmers can directly communicate with the database for quick response.

2-Tier Architecture

  • The 2-tier architecture is similar to the basic client-server. In 2-tier architecture, the applications on the client end can directly communicate with the database on the server side. For this interaction, API's such as: ODBC, JDBC are used.
  • User interface and application programs are run on the client-side.
  • Server side is responsible for providing functionalities such as: query processing and transaction management.
  • To communicate with the DBMS, the client-side application establishes a connection with the server side.
DBMS Architecture




3-Tier Architecture

  • In 3-Tier architecture, there is a layer between the client and the server. In this architecture, the client cannot communicate with the server directly.
  • At the client-end the application interacts with an application server which further communicates with the database system.
  • The end user has no idea about the existence of the database beyond the application server. The database does not contain any information about any other user beyond the application.
  • 3-tier architecture is used in case of large web applications.
3-Tier Architecture



Labels:

Comments

Post a Comment

Popular posts from this blog

Biography of Manohar Joshi

By
Biography of Manohar Joshi: Manohar Gajanan Joshi is an Indian politician who has played a significant role in Maharashtra state politics. Born on December 2, 1937, in a middle-class family in a village called Ganeshpeth in Ratnagiri district, Maharashtra, Joshi's journey into politics was marked by his association with the Shiv Sena, a right-wing regional political party in India. Joshi's political career began in the late 1960s when he joined the Shiv Sena, which was then led by its founder, Bal Thackeray. He quickly rose through the ranks of the party due to his organizational skills, dedication, and ideological alignment with the party's principles, which advocated for the interests of the Marathi-speaking population of Maharashtra. In 1972, Manohar Joshi won his first election to the Brihanmumbai Municipal Corporation (BMC), marking the beginning of his electoral career. He served as a corporator in the BMC and later became the Mayor of Mumbai in 1976. Joshi's tenu...
Post a Comment
Read more

Merry Christmas Messages and Statuses | History and Celebration Christmas - Happy Christmas Status and Messages for Social Media

By
Merry Christmas Messages and Statuses: Wishing you a Merry Christmas 2023! Here are some messages and statuses that you can share with your loved ones: "May your Christmas be filled with joy, laughter, and love. Wishing you a wonderful holiday season!". "Sending you warm wishes and good cheer this Christmas. Have a great time with your family and friends!". "May the spirit of Christmas fill your heart with peace and happiness. Merry Christmas!". "Wishing you a magical and blissful holiday season. Have a Merry Christmas and prosperous New Year!". "May this Christmas bring you all the love and luck in the world. Merry Christmas and a Happy New Year!". Wishing you a Merry Christmas 2023 Here are some Christmas messages that you can use to wish your friends and family a Merry Christmas: 1. Wishing you a Christmas filled with joy, love, and laughter. May the spirit of Christmas bring warmth to your heart and happiness to your home. 2. May y...
Post a Comment
Read more

Biography of Abbie Hoffman | Early Life and Political Activism - Later Years and Personal Life - Legacy of Abbie Hoffman

By
Biography of Abbie Hoffman: Abbie Hoffman (November 30, 1936 – April 12, 1989) was an American political and social activist known for his involvement in the counterculture and anti-war movements of the 1960s and 1970s. He was a key figure in the Youth International Party (Yippies) and was known for his theatrical and often humorous protests.  Here is a brief biography of Abbie Hoffman: Early Life of Abbie Hoffman: 1. Birth: Abbie Hoffman was born on November 30, 1936, in Worcester, Massachusetts, USA. 2. Education: He attended Brandeis University, where he earned a degree in psychology in 1959. Parada Kahanee Political Activism: 1. Civil Rights Movement: Hoffman began his activism by participating in the civil rights movement during the early 1960s. 2. Youth International Party (Yippies): In 1967, Hoffman, along with Jerry Rubin and others, co-founded the Yippies, a countercultural and anti-authoritarian political party known for its unconventional and theatrical protes...
Post a Comment
Read more