{"id":4385,"date":"2022-06-03T09:32:48","date_gmt":"2022-06-03T09:32:48","guid":{"rendered":"https:\/\/www.wikitechy.com\/interview-questions\/?p=4385"},"modified":"2022-06-03T09:33:01","modified_gmt":"2022-06-03T09:33:01","slug":"what-is-tier-3-architecture-in-dbms","status":"publish","type":"post","link":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-tier-3-architecture-in-dbms\/","title":{"rendered":"What is tier-3 architecture in DBMS ?"},"content":{"rendered":"<p><img fetchpriority=\"high\" decoding=\"async\" class=\"wp-image-4436 size-full aligncenter\" src=\"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/06\/3-Tier-DBMS-Architecture.jpg\" alt=\"\" width=\"579\" height=\"498\" srcset=\"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/06\/3-Tier-DBMS-Architecture.jpg 579w, https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/06\/3-Tier-DBMS-Architecture-300x258.jpg 300w, https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/06\/3-Tier-DBMS-Architecture-390x335.jpg 390w\" sizes=\"(max-width: 579px) 100vw, 579px\" \/><\/p>\n<p>\u00a0<\/p>\n<p>This architecture divides the entire system into a three inter related and independent modules.<\/p>\n<h3 id=\"physical-level\" style=\"text-align: justify;\"><strong>Physical Level:<\/strong><\/h3>\n<ul style=\"text-align: justify;\">\n<li>In data, <strong>information about the location of database objects in the data store is kept in this level.<\/strong><\/li>\n<li>Various DBMS users are unaware of the object locations.<\/li>\n<li>Information of data storage in secondary devices like disc, tapes\u00a0 are provided in the level.<\/li>\n<\/ul>\n<h3 id=\"conceptual-level\" style=\"text-align: justify;\"><strong>Conceptual Level:<\/strong><\/h3>\n<ul style=\"text-align: justify;\">\n<li>In this level data is represented in the form of <strong>database tables.<\/strong><\/li>\n<li>Example student database contain STUDENT and COURSE Table which is visible to users but they don`t\u00a0 know where data is stored.<\/li>\n<li>In this level, data is referred as <strong>logical schema<\/strong>, which describes the kind of data stored in the database.<\/li>\n<\/ul>\n<h3 id=\"external-level\" style=\"text-align: justify;\"><strong>External Level:<\/strong><\/h3>\n<ul>\n<li style=\"text-align: justify;\">Data in terms of conceptual level tables can be specified in this level.<\/li>\n<li style=\"text-align: justify;\">To cater the particular needs of user external level view is used.<\/li>\n<li style=\"text-align: justify;\">For Example, university FACULTY is interested in looking course details of students and STUDENTS are interested in looking at all details related to academics, accounts, courses and hostel details as well.<\/li>\n<li style=\"text-align: justify;\">Different user generates different views. So the main focus of external level is <strong>data abstraction.<\/strong><\/li>\n<\/ul>\n<h3 id=\"three-tier-architecture\">Three Tier Architecture<\/h3>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-4437\" src=\"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/06\/3-tier-architecture.png\" alt=\"\" width=\"1580\" height=\"628\" srcset=\"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/06\/3-tier-architecture.png 1580w, https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/06\/3-tier-architecture-300x119.png 300w, https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/06\/3-tier-architecture-1024x407.png 1024w, https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/06\/3-tier-architecture-768x305.png 768w, https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/06\/3-tier-architecture-1536x611.png 1536w, https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/06\/3-tier-architecture-390x155.png 390w, https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/06\/3-tier-architecture-820x326.png 820w, https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/06\/3-tier-architecture-1180x469.png 1180w\" sizes=\"(max-width: 1580px) 100vw, 1580px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u00a0 This architecture divides the entire system into a three inter related and independent modules. Physical Level: In data, information about the location of database objects in the data store is kept in this level. Various DBMS users are unaware of the object locations. Information of data storage in secondary devices like disc, tapes\u00a0 are [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7157],"tags":[17380,17379,17378,17382,17386,17388,17377,17381,17387,17384,17385,17383],"class_list":["post-4385","post","type-post","status-publish","format-standard","hentry","category-dbms","tag-1-tier-2-tier-3-tier-architecture","tag-2-tier-and-3-tier-architecture","tag-2-tier-and-3-tier-architecture-in-dbms","tag-2-tier-architecture-in-dbms","tag-3-schema-architecture-in-dbms","tag-3-schema-architecture-of-dbms-with-diagram","tag-dbms-architecture","tag-dbms-architecture-diagram","tag-dbms-architecture-diagram-with-explanation","tag-dbms-architecture-explanation","tag-dbms-architecture-three-level","tag-two-tier-v-s-three-tier-architecture"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>What is tier-3 architecture in DBMS ? - 3 Tier Architecture in DBMS<\/title>\n<meta name=\"description\" content=\"What is tier-3 architecture in DBMS ? - In data information about the location of database objects in the data store is kept in this level\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-tier-3-architecture-in-dbms\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What is tier-3 architecture in DBMS ? - 3 Tier Architecture in DBMS\" \/>\n<meta property=\"og:description\" content=\"What is tier-3 architecture in DBMS ? - In data information about the location of database objects in the data store is kept in this level\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-tier-3-architecture-in-dbms\/\" \/>\n<meta property=\"og:site_name\" content=\"Wikitechy\" \/>\n<meta property=\"article:published_time\" content=\"2022-06-03T09:32:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-06-03T09:33:01+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/06\/3-Tier-DBMS-Architecture.jpg\" \/>\n<meta name=\"author\" content=\"webmaster\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"webmaster\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-is-tier-3-architecture-in-dbms\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-is-tier-3-architecture-in-dbms\\\/\"},\"author\":{\"name\":\"webmaster\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#\\\/schema\\\/person\\\/f785ba3ecc599133e65ab6138042a3e4\"},\"headline\":\"What is tier-3 architecture in DBMS ?\",\"datePublished\":\"2022-06-03T09:32:48+00:00\",\"dateModified\":\"2022-06-03T09:33:01+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-is-tier-3-architecture-in-dbms\\\/\"},\"wordCount\":196,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-is-tier-3-architecture-in-dbms\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/3-Tier-DBMS-Architecture.jpg\",\"keywords\":[\"1 tier 2 tier 3 tier architecture\",\"2 tier and 3 tier architecture\",\"2 tier and 3 tier architecture in dbms\",\"2 tier architecture in dbms\",\"3 schema architecture in dbms\",\"3 schema architecture of dbms with diagram\",\"dbms architecture\",\"dbms architecture diagram\",\"dbms architecture diagram with explanation\",\"dbms architecture explanation\",\"dbms architecture three level\",\"two tier v\\\/s three tier architecture\"],\"articleSection\":[\"DBMS\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-is-tier-3-architecture-in-dbms\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-is-tier-3-architecture-in-dbms\\\/\",\"url\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-is-tier-3-architecture-in-dbms\\\/\",\"name\":\"What is tier-3 architecture in DBMS ? - 3 Tier Architecture in DBMS\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-is-tier-3-architecture-in-dbms\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-is-tier-3-architecture-in-dbms\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/3-Tier-DBMS-Architecture.jpg\",\"datePublished\":\"2022-06-03T09:32:48+00:00\",\"dateModified\":\"2022-06-03T09:33:01+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#\\\/schema\\\/person\\\/f785ba3ecc599133e65ab6138042a3e4\"},\"description\":\"What is tier-3 architecture in DBMS ? - In data information about the location of database objects in the data store is kept in this level\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-is-tier-3-architecture-in-dbms\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-is-tier-3-architecture-in-dbms\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/3-Tier-DBMS-Architecture.jpg\",\"contentUrl\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/3-Tier-DBMS-Architecture.jpg\",\"width\":579,\"height\":498},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#website\",\"url\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/\",\"name\":\"Wikitechy\",\"description\":\"Interview Questions\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#\\\/schema\\\/person\\\/f785ba3ecc599133e65ab6138042a3e4\",\"name\":\"webmaster\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/155b77fd8cdda3d0913fcb7e7ee63543b0c345d2d8f6dcebda5b0583ab61f967?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/155b77fd8cdda3d0913fcb7e7ee63543b0c345d2d8f6dcebda5b0583ab61f967?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/155b77fd8cdda3d0913fcb7e7ee63543b0c345d2d8f6dcebda5b0583ab61f967?s=96&d=mm&r=g\",\"caption\":\"webmaster\"},\"sameAs\":[\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\"],\"url\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/author\\\/webmaster\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"What is tier-3 architecture in DBMS ? - 3 Tier Architecture in DBMS","description":"What is tier-3 architecture in DBMS ? - In data information about the location of database objects in the data store is kept in this level","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-tier-3-architecture-in-dbms\/","og_locale":"en_US","og_type":"article","og_title":"What is tier-3 architecture in DBMS ? - 3 Tier Architecture in DBMS","og_description":"What is tier-3 architecture in DBMS ? - In data information about the location of database objects in the data store is kept in this level","og_url":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-tier-3-architecture-in-dbms\/","og_site_name":"Wikitechy","article_published_time":"2022-06-03T09:32:48+00:00","article_modified_time":"2022-06-03T09:33:01+00:00","og_image":[{"url":"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/06\/3-Tier-DBMS-Architecture.jpg","type":"","width":"","height":""}],"author":"webmaster","twitter_card":"summary_large_image","twitter_misc":{"Written by":"webmaster","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-tier-3-architecture-in-dbms\/#article","isPartOf":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-tier-3-architecture-in-dbms\/"},"author":{"name":"webmaster","@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/f785ba3ecc599133e65ab6138042a3e4"},"headline":"What is tier-3 architecture in DBMS ?","datePublished":"2022-06-03T09:32:48+00:00","dateModified":"2022-06-03T09:33:01+00:00","mainEntityOfPage":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-tier-3-architecture-in-dbms\/"},"wordCount":196,"commentCount":0,"image":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-tier-3-architecture-in-dbms\/#primaryimage"},"thumbnailUrl":"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/06\/3-Tier-DBMS-Architecture.jpg","keywords":["1 tier 2 tier 3 tier architecture","2 tier and 3 tier architecture","2 tier and 3 tier architecture in dbms","2 tier architecture in dbms","3 schema architecture in dbms","3 schema architecture of dbms with diagram","dbms architecture","dbms architecture diagram","dbms architecture diagram with explanation","dbms architecture explanation","dbms architecture three level","two tier v\/s three tier architecture"],"articleSection":["DBMS"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-tier-3-architecture-in-dbms\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-tier-3-architecture-in-dbms\/","url":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-tier-3-architecture-in-dbms\/","name":"What is tier-3 architecture in DBMS ? - 3 Tier Architecture in DBMS","isPartOf":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-tier-3-architecture-in-dbms\/#primaryimage"},"image":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-tier-3-architecture-in-dbms\/#primaryimage"},"thumbnailUrl":"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/06\/3-Tier-DBMS-Architecture.jpg","datePublished":"2022-06-03T09:32:48+00:00","dateModified":"2022-06-03T09:33:01+00:00","author":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/f785ba3ecc599133e65ab6138042a3e4"},"description":"What is tier-3 architecture in DBMS ? - In data information about the location of database objects in the data store is kept in this level","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-tier-3-architecture-in-dbms\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-tier-3-architecture-in-dbms\/#primaryimage","url":"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/06\/3-Tier-DBMS-Architecture.jpg","contentUrl":"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/06\/3-Tier-DBMS-Architecture.jpg","width":579,"height":498},{"@type":"WebSite","@id":"https:\/\/www.wikitechy.com\/interview-questions\/#website","url":"https:\/\/www.wikitechy.com\/interview-questions\/","name":"Wikitechy","description":"Interview Questions","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wikitechy.com\/interview-questions\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/f785ba3ecc599133e65ab6138042a3e4","name":"webmaster","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/155b77fd8cdda3d0913fcb7e7ee63543b0c345d2d8f6dcebda5b0583ab61f967?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/155b77fd8cdda3d0913fcb7e7ee63543b0c345d2d8f6dcebda5b0583ab61f967?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/155b77fd8cdda3d0913fcb7e7ee63543b0c345d2d8f6dcebda5b0583ab61f967?s=96&d=mm&r=g","caption":"webmaster"},"sameAs":["https:\/\/www.wikitechy.com\/interview-questions"],"url":"https:\/\/www.wikitechy.com\/interview-questions\/author\/webmaster\/"}]}},"_links":{"self":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/4385","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/comments?post=4385"}],"version-history":[{"count":5,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/4385\/revisions"}],"predecessor-version":[{"id":4439,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/4385\/revisions\/4439"}],"wp:attachment":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/media?parent=4385"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/categories?post=4385"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/tags?post=4385"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}