Skip to main content

Three tier architecture -DBMS - Computer science fundamentals tutorial



Client server architecture (explains the client server architecture of DBMS/explains three tier architecture of DBMS)

    
Client server architecture is an architectural deployment style that describes separation of functionality into layers with each segment being tier that can be located on a physically separate computer. A client server architecture separate its tier from each other based on the complexity of user and how they used the data present in the database. It is the most widely used architecture to design a DBMS.  Client server architecture are divided into three part. Three part are A) Database tier  B) Application(middle) tier  C) Presentations (user) tier



A.Database tier: - At this tier database resides along with its query processing languages. We also have the relation that define the data and their constrains at this level.
       B.Application (middle) tier: - At this tier reside the application server and program that access database. For a user this application tier presents and abstracted view of database. Hence application tier/layer sits in the middle and acts as mediator between the end user and database.
       C.Presentations (user) tier: - End users operate on this tier and they know nothing about any existence of database beyond this layer. At this layer multiple views of the database can be provided by application. All views are generated by application that resides in application tier.

Comments

Popular posts from this blog

Important MCQ of RDBMS( Relational database management system)-FCST

Important MCQ of RDBMS  1. A RDBMS consists a collection of ? a. Tables b. Fields c. Records d. Keys  ANS/- a. table 2. The term attribute refers to a ___________ of a table a. Record b. Tuple c. Column d. Key   ans/- c. Column 3. In relational model, the row of table is known to be ?  a. Relation b. Entity field c. Tuple d. Attribute  ans/- C. Tuple 4. . Address field of a person should not be part of primary key, since it is likely to ? a. Dependent b. Too long c. Changed d. Not changed  ans/- c. Changed 5. The relational model is concerned with ? a. Data structure and Data integrity b. Data Manipulation c. Both a and b d. None of these  ans/- c. Both a and b 6. Which is the false statement from the following ? a. A veiw is a named derived table b. A name relation is variable c. A veiw is a named reation and is virtual d. None of these  ans/- d. None of these 7. The union of primary key...

Short notes on database schema & database independence- computer science fundamentals tutorial

            Database Schema &  Data Independence PDF version of this post also available. to download the click the link given at the end of this post.           Database Schema : -  A database schema   is the skeleton structure that represents the logical view of the entire database. It defines how the data is organized and how relat ion among them are associated.  Database schema  formulates all the constrains that are to be applied on the data. A database schema defines its entities and the relationship among them. It contains descriptive details of the database which can be described by means of schema diagram. A database schema can be divided into two categories.   I.     Physical database schema : - this schema contain to the actual storage of data and its form of storage like files, indices etc. It defines how the data will be stored in a secondary storage. ...

What is file system and advantage of DBMS over file system

  Definition of File system  &  it's advantage of DBMS over file system What is file system? Ans/- A file system is a database system that allows us access to single file at a time. In a file system data is directly stored in set of file. It contains flat file that have no relation to other file. Advantage of DBMS over file system :-       1)       Data redundancy : - Data redundancy refers to the duplication of data that means each data may have a single copy. A file system can’t control redundancy of data. In DBMS data redundancy removed by using of data normalization.        2)    Data inconsistency : - Data redundancy leads to data inconsistency. In DBMS data redundancy is taken care by data normalization and data in consistency also been taken care of as part of it.        3)     Data isolation : - In file system data stored are in various file and file...