{"id":3422,"date":"2023-02-15T04:03:12","date_gmt":"2023-02-15T04:03:12","guid":{"rendered":"https:\/\/sagaratechnology.com\/blog\/?p=3422"},"modified":"2023-03-16T09:26:28","modified_gmt":"2023-03-16T09:26:28","slug":"get-to-know-about-dbms-and-its-functions-to-manage-database","status":"publish","type":"post","link":"https:\/\/sagaratechnology.com\/blog\/get-to-know-about-dbms-and-its-functions-to-manage-database\/","title":{"rendered":"Get to Know About DBMS and Its Functions to Manage Database"},"content":{"rendered":"\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/kdvxzjw9attrsOJoP2JbEg3kIATsx62y8yvTE8oNLF3t_CPEKfIiNxbEguS0q8au2H_-a0bqXkS7QCHjNLVNnBd0_4rXqWeuN-TZnzZqKLsz2A83P4xMmOGMRuaGvc1t5oUyR-tOHQENgpSAhpOD0nE\" alt=\"DBMS\"\/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>DBMS is software used to manage and operate programs and data requested by many users. Because of this, you need to know DBMS if you want to be a developer, a data analyst, or even a programmer.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_76 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-69e78d5c8ded1\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-69e78d5c8ded1\"  aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/sagaratechnology.com\/blog\/get-to-know-about-dbms-and-its-functions-to-manage-database\/#Definition_of_DBMS\" >Definition of DBMS<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/sagaratechnology.com\/blog\/get-to-know-about-dbms-and-its-functions-to-manage-database\/#DBMS_example\" >DBMS example<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/sagaratechnology.com\/blog\/get-to-know-about-dbms-and-its-functions-to-manage-database\/#DBMS_function\" >DBMS function<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/sagaratechnology.com\/blog\/get-to-know-about-dbms-and-its-functions-to-manage-database\/#DBMS_type\" >DBMS type<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/sagaratechnology.com\/blog\/get-to-know-about-dbms-and-its-functions-to-manage-database\/#Hierarchical_database\" >Hierarchical database<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/sagaratechnology.com\/blog\/get-to-know-about-dbms-and-its-functions-to-manage-database\/#Network_database\" >Network database<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/sagaratechnology.com\/blog\/get-to-know-about-dbms-and-its-functions-to-manage-database\/#Relational_database\" >Relational database<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/sagaratechnology.com\/blog\/get-to-know-about-dbms-and-its-functions-to-manage-database\/#DBMS_advantages_and_disadvantages\" >DBMS advantages and disadvantages<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/sagaratechnology.com\/blog\/get-to-know-about-dbms-and-its-functions-to-manage-database\/#Advantages_of_DBMS\" >Advantages of DBMS<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/sagaratechnology.com\/blog\/get-to-know-about-dbms-and-its-functions-to-manage-database\/#Disadvantages_of_DBMS\" >Disadvantages of DBMS<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Definition_of_DBMS\"><\/span><strong>Definition of DBMS<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>DBMS stands for Database Management System. Then what is the <a href=\"https:\/\/www.oracle.com\/id\/database\/what-is-database\/\" target=\"_blank\" rel=\"noreferrer noopener\">database<\/a>? A database is a collection of information stored in a computer and then processed with specific commands.<\/p>\n\n\n\n<p>Meanwhile, the definition of DBMS is a system or software designed to connect databases with users so that data can be appropriately processed. There are at least two languages commonly used in database programming: Database Definition Language (DDL) and Database Manipulation Language (DML).<\/p>\n\n\n\n<p>Database Definition Language (DDL) is the overall database design that allows the creation of new tables, specified indexes, and many other everyday database activities.<\/p>\n\n\n\n<p>Meanwhile, Database Manipulation Language (DML) is a language used to manipulate the collection of data available in the database, such as deleting and summing data.<\/p>\n\n\n\n<p>Read Also About <a href=\"https:\/\/sagaratechnology.com\/blog\/the-fundamentals-of-front-end-and-back-end-development\/\">Fundamentals of Front End and Back End Development<\/a><\/p>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"DBMS_example\"><\/span><strong>DBMS example<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>DBMS is beneficial in everyday life. If it can be used correctly, it can provide excellent benefits for its users. Some examples of DBMS implementation are as follows:<\/p>\n\n\n\n<ul>\n<li>Library management system<\/li>\n\n\n\n<li>Automatic system on the cash register<\/li>\n\n\n\n<li>Data recovery on computer<\/li>\n\n\n\n<li>Flight ticket reservation system<\/li>\n\n\n\n<li>Spare parts recording system<\/li>\n<\/ul>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"DBMS_function\"><\/span><strong>DBMS function<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Various DBMS functions are interesting for you to know so that you can use the it properly, friend. Some DBMS functions are:<\/p>\n\n\n\n<ul>\n<li>Defining and processing data<\/li>\n\n\n\n<li>Handle various user requests to manage and access data<\/li>\n\n\n\n<li>Handling data security and integrity<\/li>\n\n\n\n<li>Handle and monitor data updates<\/li>\n\n\n\n<li>Control access to data that is done together<\/li>\n\n\n\n<li>Supervision of database backups and restoration of database backups from errors<\/li>\n\n\n\n<li>Shows data dictionary<\/li>\n\n\n\n<li>Processing and accessing data as efficiently as possible<\/li>\n<\/ul>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"DBMS_type\"><\/span><strong>DBMS type<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>The DBMS extension mentioned earlier certainly makes you even more curious to find out what types of database processing systems this is. The following are some examples of DBMS types:<\/p>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Hierarchical_database\"><\/span><strong>Hierarchical database<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>A hierarchical database or hierarchical form database is a database in which the work system uses a hierarchical data form, that is, with a parent and child relationship structure.<\/p>\n\n\n\n<p>So, each database group will have its respective mothers and children. An example of data processing of this type is IMS-2 (Information Management System) in 1968 by IBM.<\/p>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Network_database\"><\/span><strong>Network database<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>A network database is a derivative of a hierarchical database. It is because this network structure will form the entities in it. In the following database, each mother and child may have a relationship with more than one other entity. IDMS (Integrated Database Management System) 1972 by Cullinet Software is an example of a network database.<\/p>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Relational_database\"><\/span><strong>Relational database<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>The processing in this database is done by grouping data relationships. To operate a relational database, such as adding, subtracting, deleting, and manipulating data, users need to use Structured Query Language (SQL).<\/p>\n\n\n\n<p>This database is often used because there is an ease in integrating data between one another. Examples of database processing are DBASE II by Ashton-Tate, 1981; ORACLE by Relational Software Inc., 1979; system-r by IBM Research, 1975; and INGRE by UN of CA &amp; Relational Tech., 1973.<\/p>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"DBMS_advantages_and_disadvantages\"><\/span><strong>DBMS advantages and disadvantages<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>There are various advantages and disadvantages of DBMS that you should know. This can be your consideration, so you can think carefully about whether you need to use it.<\/p>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Advantages_of_DBMS\"><\/span><strong>Advantages of DBMS<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul>\n<li>Reducing data repetition<\/li>\n\n\n\n<li>Can retrieve some data and information quickly<\/li>\n\n\n\n<li>Improve data security<\/li>\n\n\n\n<li>Balancing various needs and comparing them with economies of scale<\/li>\n\n\n\n<li>The data provided is consistent<\/li>\n\n\n\n<li>Faster recovery of damaged data<\/li>\n\n\n\n<li>Facilitate decision making<\/li>\n<\/ul>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Disadvantages_of_DBMS\"><\/span><strong>Disadvantages of DBMS<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul>\n<li>The software that applies to the majority is expensive<\/li>\n\n\n\n<li>The hardware configuration is quite large<\/li>\n\n\n\n<li>The usage is complex<\/li>\n\n\n\n<li>There are various additional costs, depending on the function and needs<\/li>\n\n\n\n<li>Performance degrades over time<\/li>\n\n\n\n<li>Have to update frequently<\/li>\n<\/ul>\n\n\n\n<p>Sagara Technology so well summarizes the definition of an effective DBMS. Its existence of it is essential for the data management of businesses. Similarly, if you own a business, database management will significantly assist you in determining the business&#8217;s performance.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>DBMS is software used to manage and operate programs and data requested by many users. Because of this, you need to know DBMS if you want to be a developer, a data analyst, or even a programmer. Definition of DBMS DBMS stands for Database Management System. Then what is the database? A database is a&#8230;<\/p>\n","protected":false},"author":26,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Get to Know About DBMS and Its Functions to Manage Database -<\/title>\n<meta name=\"description\" content=\"DBMS is software used to manage and operate programs and data requested by many users. You need to know DBMS if you want to be a developer.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/sagaratechnology.com\/blog\/get-to-know-about-dbms-and-its-functions-to-manage-database\/\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Get to Know About DBMS and Its Functions to Manage Database -\" \/>\n<meta name=\"twitter:description\" content=\"DBMS is software used to manage and operate programs and data requested by many users. You need to know DBMS if you want to be a developer.\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/lh3.googleusercontent.com\/kdvxzjw9attrsOJoP2JbEg3kIATsx62y8yvTE8oNLF3t_CPEKfIiNxbEguS0q8au2H_-a0bqXkS7QCHjNLVNnBd0_4rXqWeuN-TZnzZqKLsz2A83P4xMmOGMRuaGvc1t5oUyR-tOHQENgpSAhpOD0nE\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Syafira Nur Tazkia Abdillah\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Get to Know About DBMS and Its Functions to Manage Database -","description":"DBMS is software used to manage and operate programs and data requested by many users. You need to know DBMS if you want to be a developer.","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:\/\/sagaratechnology.com\/blog\/get-to-know-about-dbms-and-its-functions-to-manage-database\/","twitter_card":"summary_large_image","twitter_title":"Get to Know About DBMS and Its Functions to Manage Database -","twitter_description":"DBMS is software used to manage and operate programs and data requested by many users. You need to know DBMS if you want to be a developer.","twitter_image":"https:\/\/lh3.googleusercontent.com\/kdvxzjw9attrsOJoP2JbEg3kIATsx62y8yvTE8oNLF3t_CPEKfIiNxbEguS0q8au2H_-a0bqXkS7QCHjNLVNnBd0_4rXqWeuN-TZnzZqKLsz2A83P4xMmOGMRuaGvc1t5oUyR-tOHQENgpSAhpOD0nE","twitter_misc":{"Written by":"Syafira Nur Tazkia Abdillah","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sagaratechnology.com\/blog\/get-to-know-about-dbms-and-its-functions-to-manage-database\/#article","isPartOf":{"@id":"https:\/\/sagaratechnology.com\/blog\/get-to-know-about-dbms-and-its-functions-to-manage-database\/"},"author":{"name":"Syafira Nur Tazkia Abdillah","@id":"https:\/\/sagaratechnology.com\/blog\/#\/schema\/person\/8f2cf70c23b8163ad2c53138a38b58b0"},"headline":"Get to Know About DBMS and Its Functions to Manage Database","datePublished":"2023-02-15T04:03:12+00:00","dateModified":"2023-03-16T09:26:28+00:00","mainEntityOfPage":{"@id":"https:\/\/sagaratechnology.com\/blog\/get-to-know-about-dbms-and-its-functions-to-manage-database\/"},"wordCount":687,"commentCount":0,"publisher":{"@id":"https:\/\/sagaratechnology.com\/blog\/#organization"},"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sagaratechnology.com\/blog\/get-to-know-about-dbms-and-its-functions-to-manage-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sagaratechnology.com\/blog\/get-to-know-about-dbms-and-its-functions-to-manage-database\/","url":"https:\/\/sagaratechnology.com\/blog\/get-to-know-about-dbms-and-its-functions-to-manage-database\/","name":"Get to Know About DBMS and Its Functions to Manage Database -","isPartOf":{"@id":"https:\/\/sagaratechnology.com\/blog\/#website"},"datePublished":"2023-02-15T04:03:12+00:00","dateModified":"2023-03-16T09:26:28+00:00","description":"DBMS is software used to manage and operate programs and data requested by many users. You need to know DBMS if you want to be a developer.","breadcrumb":{"@id":"https:\/\/sagaratechnology.com\/blog\/get-to-know-about-dbms-and-its-functions-to-manage-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sagaratechnology.com\/blog\/get-to-know-about-dbms-and-its-functions-to-manage-database\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/sagaratechnology.com\/blog\/get-to-know-about-dbms-and-its-functions-to-manage-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sagaratechnology.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Uncategorized","item":"https:\/\/sagaratechnology.com\/blog\/category\/uncategorized\/"},{"@type":"ListItem","position":3,"name":"Get to Know About DBMS and Its Functions to Manage Database"}]},{"@type":"WebSite","@id":"https:\/\/sagaratechnology.com\/blog\/#website","url":"https:\/\/sagaratechnology.com\/blog\/","name":"Sagara Asia Blog","description":"Dapatkan Informasi Seputar Teknologi dan Bisnis","publisher":{"@id":"https:\/\/sagaratechnology.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sagaratechnology.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/sagaratechnology.com\/blog\/#organization","name":"Sagara Technology","url":"https:\/\/sagaratechnology.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/sagaratechnology.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/sagaratechnology.com\/blog\/wp-content\/uploads\/2021\/10\/sagara-logo.jpeg","contentUrl":"https:\/\/sagaratechnology.com\/blog\/wp-content\/uploads\/2021\/10\/sagara-logo.jpeg","width":200,"height":200,"caption":"Sagara Technology"},"image":{"@id":"https:\/\/sagaratechnology.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/company\/sagara-asia\/"]},{"@type":"Person","@id":"https:\/\/sagaratechnology.com\/blog\/#\/schema\/person\/8f2cf70c23b8163ad2c53138a38b58b0","name":"Syafira Nur Tazkia Abdillah","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/sagaratechnology.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/3e4cdb0cc36f3857c031f09bd895111f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3e4cdb0cc36f3857c031f09bd895111f?s=96&d=mm&r=g","caption":"Syafira Nur Tazkia Abdillah"}}]}},"_links":{"self":[{"href":"https:\/\/sagaratechnology.com\/blog\/wp-json\/wp\/v2\/posts\/3422"}],"collection":[{"href":"https:\/\/sagaratechnology.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sagaratechnology.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sagaratechnology.com\/blog\/wp-json\/wp\/v2\/users\/26"}],"replies":[{"embeddable":true,"href":"https:\/\/sagaratechnology.com\/blog\/wp-json\/wp\/v2\/comments?post=3422"}],"version-history":[{"count":2,"href":"https:\/\/sagaratechnology.com\/blog\/wp-json\/wp\/v2\/posts\/3422\/revisions"}],"predecessor-version":[{"id":3655,"href":"https:\/\/sagaratechnology.com\/blog\/wp-json\/wp\/v2\/posts\/3422\/revisions\/3655"}],"wp:attachment":[{"href":"https:\/\/sagaratechnology.com\/blog\/wp-json\/wp\/v2\/media?parent=3422"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sagaratechnology.com\/blog\/wp-json\/wp\/v2\/categories?post=3422"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sagaratechnology.com\/blog\/wp-json\/wp\/v2\/tags?post=3422"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}