Skip to main content

Database Architecture

Understanding DBMS Architecture

A Database Management system is not always directly available for users and applications to access and store data in it. A Database Management system can be centralised(all the data stored at one location), decentralised(multiple copies of database at different locations) or hierarchical, depending upon its architecture.
1-tier DBMS architecture also exist, this is when the database is directly available to the user for using it to store data. Generally such a setup is used for local application development, where programmers communicate directly with the database for quick response.
Database Architecture is logically of two types:
  1. 2-tier DBMS architecture
  2. 3-tier DBMS architecture

  1. 2-tier DBMS Architecture 
  2. 2-tier DBMS architecture includes an Application layer between the user and the DBMS, which is responsible to communicate the user's request to the database management system and then send the response from the DBMS to the user. An application interface known as ODBC(Open Database Connectivity) provides an API that allow client side program to call the DBMS. Most DBMS vendors provide ODBC drivers for their DBMS.
    2-tier dbms architecture 


    Such an architecture provides the DBMS extra security as it is not exposed to the End User directly. Also, security can be improved by adding security and authentication checks in the Application layer too.

    3-tier DBMS Architecture

    3-tier DBMS architecture is the most commonly used architecture for web applications.

    3-tier dbms architecture 


    It is an extension of the 2-tier architecture. In the 2-tier architecture, we have an application layer which can be accessed programatically to perform various operations on the DBMS. The application generally understands the Database Access Language and processes end users requests to the DBMS.
    In 3-tier architecture, an additional Presentation or GUI Layer is added, which provides a graphical user interface for the End user to interact with the DBMS.
    For the end user, the GUI layer is the Database System, and the end user has no idea about the application layer and the DBMS system.
    If you have used MySQL, then you must have seen PHPMyAdmin, it is the best example of a 3-tier DBMS architecture.

     


     

Comments

Post a Comment

Popular posts from this blog

ENRICHING THE ‘INTEGRATION AS A SERVICE’ PARADIGM FOR THE CLOUD ERA

ENRICHING THE ‘INTEGRATION AS A SERVICE’ PARADIGM FOR THE CLOUD ERA INTRODUCTION TO CLOUD INTEGRATION: Cloud Integration is about simplifying technology so that it could be adopted by a much broader audience.  Cloud integration is the process of configuring multiple application programs to share data in the cloud. In a network that incorporates cloud integration; various applications communicate either directly or through third-party software. Cloud integration is the linking of information flows between cloud-hosted applications and other applications hosted in different clouds or in the datacenter. Without integration, cloud applications can’t share data with the rest of the Company and that limits or even eliminates the utility of the cloud. ADVANTAGES OF CLOUD INTEGRATION: Cloud integration offers the following advantages over older, compartmentalized organizational methods: We propose the followi
10 comments
Read more

MIGRATING INTO A CLOUD

  MIGRATING INTO A CLOUD INTRODUCTION: Cloud computing is a disruptive model of IT whose innovation is part technology and part business model. In short a “disruptive techno-commercial model” of IT. This chapter focuses on the key issues and associated dilemmas faced by decision makers, architects, and systems managers in trying to understand and leverage cloud computing for their IT needs. We will discuss the key factors for each of the above questions and a Seven-Step Model of Migration into the Cloud. Several efforts have been made in the recent past to define the term “ cloud computing ” and many have not been able to provide a comprehensive one. We propose the following definition of cloud computing: “It is a techno-business disruptive model of using distributed large-scale data centers either private or public or hybrid offering customers a scalable virtualized infrastructure or an abstracted set of services qu
9 comments
Read more

introduction to cloud computing

CLOUD COMPUTING INTRODUCTION: Cloud Computing provides us a means by which we can access the applications as utilities , over the Internet . It allows us to create , configure , and customize applications online. With Cloud Computing users can access database resources via the internet from anywhere for as long as they need without worrying about any maintenance or management of actual resources. WHAT IS CLOUD? The term Cloud refers to a Network or internet . In other words, we can say that Cloud is something , which is present at remote location. Cloud can provide services over network, i.e., on public networks or on private networks , i.e., WAN, LAN or VPN. Applications such as e-mail, web conferencing, customer relationship management (CRM), all run in cloud. Cloud Computing refers to manipulating, configuring, and accessing the applications online. It offers
1 comment
Read more