{"id":5037,"date":"2022-10-26T09:02:24","date_gmt":"2022-10-26T09:02:24","guid":{"rendered":"https:\/\/www.wikitechy.com\/interview-questions\/?p=5037"},"modified":"2022-10-26T09:02:24","modified_gmt":"2022-10-26T09:02:24","slug":"what-are-the-types-of-databases","status":"publish","type":"post","link":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-are-the-types-of-databases\/","title":{"rendered":"What are the types of databases ?"},"content":{"rendered":"<p style=\"text-align: justify;\">The different types of databases are:<\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone size-full wp-image-5038 aligncenter\" src=\"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/10\/types-of-databases.png\" alt=\"\" width=\"660\" height=\"300\" srcset=\"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/10\/types-of-databases.png 660w, https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/10\/types-of-databases-300x136.png 300w, https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/10\/types-of-databases-390x177.png 390w\" sizes=\"(max-width: 660px) 100vw, 660px\" \/><\/p>\n<h2 id=\"hierarchical-database\" style=\"text-align: justify;\"><strong>Hierarchical Database<\/strong><\/h2>\n<ul style=\"text-align: justify;\">\n<li>In this database data is organized in a tree like structure.<\/li>\n<li>Data is stored in the form of either top down or bottom up approach.<\/li>\n<li>Data in this database is represented in the form of parent-child relationship.<\/li>\n<li>In this database parents have many children but child can have only single parent.<\/li>\n<\/ul>\n<h2 id=\"network-database\" style=\"text-align: justify;\"><strong>Network Database<\/strong><\/h2>\n<ul style=\"text-align: justify;\">\n<li>In database children can have more than one parents.<\/li>\n<li>Many to many relationship complexities can be reduced in this database.<\/li>\n<li>Here entities are organized in a graphical format which can be accessed through several paths.<\/li>\n<\/ul>\n<h2 id=\"relational-database\" style=\"text-align: justify;\">\u00a0<strong>Relational Database<\/strong><\/h2>\n<ul style=\"text-align: justify;\">\n<li>One of the widely used and easy to use database is relational database.<\/li>\n<li>Normalizing of data in the row and column can be acheived using relational database.<\/li>\n<li>These relational models are stored in fixed structures and are manipulated using SQL.<\/li>\n<\/ul>\n<h2 id=\"object-oriented-database\" style=\"text-align: justify;\"><strong>Object Oriented Database<\/strong><\/h2>\n<ul style=\"text-align: justify;\">\n<li>Data in these database are stored in the form of objects.<\/li>\n<li>The structure that displays data within it is are called as classess.<\/li>\n<li>Class is a component of database that displays database as a collection of objects which can store both data members values and operations.<\/li>\n<\/ul>\n<h2 id=\"personal-database\" style=\"text-align: justify;\"><strong>Personal Database<\/strong><\/h2>\n<ul style=\"text-align: justify;\">\n<li>Collecting and storing data on a personal system is known as Personal Database.<\/li>\n<li>This database is designed only for a single user.<\/li>\n<li>These type of databases are very easy to handle.<\/li>\n<li>As the size of these database is very small, it needs less storage space.<\/li>\n<\/ul>\n<h2 id=\"operational-database\" style=\"text-align: justify;\"><strong>Operational Database<\/strong><\/h2>\n<ul style=\"text-align: justify;\">\n<li>Databases that gets created and updated in real time is called as Operational Database.<\/li>\n<li>These types of databases are designed for executing and handling daily operations like per day transactions of several business.<\/li>\n<\/ul>\n<h2 id=\"enterprise-database\" style=\"text-align: justify;\"><strong>Enterprise Database<\/strong><\/h2>\n<ul>\n<li style=\"text-align: justify;\">For managing huge amount of data organization or enterprise uses these types of database and it helps them to increase and improve their efficiency.<\/li>\n<li style=\"text-align: justify;\">Simultaneous access to multiple users can be done using these databases.<\/li>\n<li style=\"text-align: justify;\">We can use Multiple process on these type of databases.<\/li>\n<li style=\"text-align: justify;\">Parallel execution of queries on the system is allowed in these databases.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>The different types of databases are: Hierarchical Database In this database data is organized in a tree like structure. Data is stored in the form of either top down or bottom up approach. Data in this database is represented in the form of parent-child relationship. In this database parents have many children but child can [&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":[19005,19002,7162,18558,19004,18561,18560,18564,19003,19006,18559,7208],"class_list":["post-5037","post","type-post","status-publish","format-standard","hentry","category-dbms","tag-how-many-types-of-database","tag-types-of-database-in-dbms","tag-types-of-database-management-system","tag-types-of-database-system","tag-types-of-database-with-example","tag-types-of-databases","tag-types-of-dbms","tag-types-of-dbms-in-sql","tag-types-of-dbms-with-examples","tag-what-are-the-4-types-of-dbms","tag-what-are-the-different-types-of-dbms","tag-what-is-database-management-system"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>What are the types of databases ? - Types of Database in DBMS<\/title>\n<meta name=\"description\" content=\"What are the types of databases ? - Hierarchical Database - Network Database - Relational Database - Object Oriented Database\" \/>\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-are-the-types-of-databases\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What are the types of databases ? - Types of Database in DBMS\" \/>\n<meta property=\"og:description\" content=\"What are the types of databases ? - Hierarchical Database - Network Database - Relational Database - Object Oriented Database\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-are-the-types-of-databases\/\" \/>\n<meta property=\"og:site_name\" content=\"Wikitechy\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-26T09:02:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/10\/types-of-databases.png\" \/>\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-are-the-types-of-databases\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-are-the-types-of-databases\\\/\"},\"author\":{\"name\":\"webmaster\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#\\\/schema\\\/person\\\/f785ba3ecc599133e65ab6138042a3e4\"},\"headline\":\"What are the types of databases ?\",\"datePublished\":\"2022-10-26T09:02:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-are-the-types-of-databases\\\/\"},\"wordCount\":334,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-are-the-types-of-databases\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/types-of-databases.png\",\"keywords\":[\"how many types of database\",\"types of database in dbms\",\"types of database management system\",\"types of database system\",\"types of database with example\",\"types of databases\",\"types of dbms\",\"types of dbms in sql\",\"types of dbms with examples\",\"what are the 4 types of dbms\",\"what are the different types of dbms\",\"what is database management system\"],\"articleSection\":[\"DBMS\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-are-the-types-of-databases\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-are-the-types-of-databases\\\/\",\"url\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-are-the-types-of-databases\\\/\",\"name\":\"What are the types of databases ? - Types of Database in DBMS\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-are-the-types-of-databases\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-are-the-types-of-databases\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/types-of-databases.png\",\"datePublished\":\"2022-10-26T09:02:24+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#\\\/schema\\\/person\\\/f785ba3ecc599133e65ab6138042a3e4\"},\"description\":\"What are the types of databases ? - Hierarchical Database - Network Database - Relational Database - Object Oriented Database\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-are-the-types-of-databases\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-are-the-types-of-databases\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/types-of-databases.png\",\"contentUrl\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/types-of-databases.png\",\"width\":660,\"height\":300},{\"@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 are the types of databases ? - Types of Database in DBMS","description":"What are the types of databases ? - Hierarchical Database - Network Database - Relational Database - Object Oriented Database","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-are-the-types-of-databases\/","og_locale":"en_US","og_type":"article","og_title":"What are the types of databases ? - Types of Database in DBMS","og_description":"What are the types of databases ? - Hierarchical Database - Network Database - Relational Database - Object Oriented Database","og_url":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-are-the-types-of-databases\/","og_site_name":"Wikitechy","article_published_time":"2022-10-26T09:02:24+00:00","og_image":[{"url":"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/10\/types-of-databases.png","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-are-the-types-of-databases\/#article","isPartOf":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-are-the-types-of-databases\/"},"author":{"name":"webmaster","@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/f785ba3ecc599133e65ab6138042a3e4"},"headline":"What are the types of databases ?","datePublished":"2022-10-26T09:02:24+00:00","mainEntityOfPage":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-are-the-types-of-databases\/"},"wordCount":334,"commentCount":0,"image":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-are-the-types-of-databases\/#primaryimage"},"thumbnailUrl":"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/10\/types-of-databases.png","keywords":["how many types of database","types of database in dbms","types of database management system","types of database system","types of database with example","types of databases","types of dbms","types of dbms in sql","types of dbms with examples","what are the 4 types of dbms","what are the different types of dbms","what is database management system"],"articleSection":["DBMS"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-are-the-types-of-databases\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-are-the-types-of-databases\/","url":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-are-the-types-of-databases\/","name":"What are the types of databases ? - Types of Database in DBMS","isPartOf":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-are-the-types-of-databases\/#primaryimage"},"image":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-are-the-types-of-databases\/#primaryimage"},"thumbnailUrl":"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/10\/types-of-databases.png","datePublished":"2022-10-26T09:02:24+00:00","author":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/f785ba3ecc599133e65ab6138042a3e4"},"description":"What are the types of databases ? - Hierarchical Database - Network Database - Relational Database - Object Oriented Database","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-are-the-types-of-databases\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-are-the-types-of-databases\/#primaryimage","url":"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/10\/types-of-databases.png","contentUrl":"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/10\/types-of-databases.png","width":660,"height":300},{"@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\/5037","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=5037"}],"version-history":[{"count":1,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/5037\/revisions"}],"predecessor-version":[{"id":5039,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/5037\/revisions\/5039"}],"wp:attachment":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/media?parent=5037"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/categories?post=5037"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/tags?post=5037"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}