{"id":8390,"date":"2020-02-14T10:30:18","date_gmt":"2020-02-14T01:30:18","guid":{"rendered":"https:\/\/www.gigas-jp.com\/appnews\/?p=8390"},"modified":"2020-02-14T11:09:23","modified_gmt":"2020-02-14T02:09:23","slug":"introduction-to-database-dbms-systems","status":"publish","type":"post","link":"https:\/\/www.gigas-jp.com\/appnews\/archives\/8390","title":{"rendered":"Introduction To Database &amp; DBMS systems"},"content":{"rendered":"\n<p>Today I will talk about database and DMBS systems. Lets take a look.<\/p>\n\n\n\n<h3>Database<\/h3>\n\n\n\n<p>The database is a systematic collection of data. Databases\nsupport data storage and manipulation. Databases facilitate data management.\nLet&#8217;s discuss some examples.<\/p>\n\n\n\n<p>A Hospital would use a database to store patient\u2019s name,\nage, diseases,  contacts etc.<\/p>\n\n\n\n<p>Consider also facebook &amp; Instagram. You need to store,\nmanipulate and present data related to members, your friends, member\nactivities, messages, announcements and much more.<\/p>\n\n\n\n<p>We can provide countless examples of database usage.<\/p>\n\n\n\n<h3>Database management system (DBMS)<\/h3>\n\n\n\n<p>The Database Management System (DBMS) is a collection of programs\nthat allow its users to access the database, manipulate data, inform \/\nrepresent data.<\/p>\n\n\n\n<p>It also helps control access to the database.<\/p>\n\n\n\n<p>Charles Bachmen&#8217;s Integrated Data Store (IDS) is said to be\nthe first DBMS in history.<\/p>\n\n\n\n<p>Over time, database technologies evolved a lot, while the\nexpected use and functionality of databases has increased tremendously.<\/p>\n\n\n\n<h3><strong>Types of DBMS<\/strong><\/h3>\n\n\n\n<h4>Hierarchical<\/h4>\n\n\n\n<p>This type of DBMS uses the &#8220;parent-child&#8221; data storage relationship. This type of DBMS is rarely used today. Its structure is like a tree with nodes that represent records and branches that represent fields. The Windows registry used in Windows XP is an example of a hierarchical database. Configuration settings are stored as tree structures with nodes.<\/p>\n\n\n\n<h4>Network DBMS<\/h4>\n\n\n\n<p>This type of DBMS supports many to many relationships. This\ngenerally results in complex database structures. RDM Server is an example of a\ndatabase management system that implements the network model.<\/p>\n\n\n\n<h4>Relational DBMS<\/h4>\n\n\n\n<p>This type of DBMS defines database relationships in the form of tables, also known as relationships. Unlike network DBMS, RDBMS does not support many to many relationships. Relational DBMSs generally have predefined data types that they can support. This is the most popular type of DBMS in the market. Examples of relational database management systems include MariaDB, Oracle and the Microsoft SQL Server database.<\/p>\n\n\n\n<h4>Object-oriented relationship DBMS<\/h4>\n\n\n\n<p>this type supports the storage of new types of data. The data to be stored are in the form of objects. The objects that will be stored in the database have attributes (i.e. gender, ager) and methods that define what to do with the data. PostgreSQL is an example of an object-oriented relational DBMS.<\/p>\n\n\n\n<h3><strong>Summary<\/strong><\/h3>\n\n\n\n<ul><li>&#8211; DBMS stands for Database Management System.<\/li><li>&#8211; We have four major types of DBMSs namely Hierarchical, Network, Relational, Object Oriented.<\/li><li>&#8211; The most widely used DBMS is the relational model that saves data in table formats. It uses SQL as the standard query language.<\/li><\/ul>\n\n\n\n<p><\/p>\n\n\n\n<p>I will talk about<strong> SQL programming<\/strong> next week.<\/p>\n\n\n\n<p>By Yuuma<\/p>\n<div class='wp_social_bookmarking_light'>\n            <div class=\"wsbl_google_plus_one\"><g:plusone size=\"medium\" annotation=\"none\" href=\"https:\/\/www.gigas-jp.com\/appnews\/archives\/8390\" ><\/g:plusone><\/div>\n            <div class=\"wsbl_hatena_button\"><a href=\"\/\/b.hatena.ne.jp\/entry\/https:\/\/www.gigas-jp.com\/appnews\/archives\/8390\" class=\"hatena-bookmark-button\" data-hatena-bookmark-title=\"Introduction To Database &amp; DBMS systems\" data-hatena-bookmark-layout=\"standard\" title=\"\u3053\u306e\u30a8\u30f3\u30c8\u30ea\u30fc\u3092\u306f\u3066\u306a\u30d6\u30c3\u30af\u30de\u30fc\u30af\u306b\u8ffd\u52a0\"> <img src=\"\/\/b.hatena.ne.jp\/images\/entry-button\/button-only@2x.png\" alt=\"\u3053\u306e\u30a8\u30f3\u30c8\u30ea\u30fc\u3092\u306f\u3066\u306a\u30d6\u30c3\u30af\u30de\u30fc\u30af\u306b\u8ffd\u52a0\" width=\"20\" height=\"20\" style=\"border: none;\" \/><\/a><script type=\"text\/javascript\" src=\"\/\/b.hatena.ne.jp\/js\/bookmark_button.js\" charset=\"utf-8\" async=\"async\"><\/script><\/div>\n            <div class=\"wsbl_twitter\"><a href=\"https:\/\/twitter.com\/share\" class=\"twitter-share-button\" data-url=\"https:\/\/www.gigas-jp.com\/appnews\/archives\/8390\" data-text=\"Introduction To Database &amp; DBMS systems\" data-via=\"GIGASJAPAN_APPS\" data-lang=\"ja\">Tweet<\/a><\/div>\n            <div class=\"wsbl_facebook_like\"><div id=\"fb-root\"><\/div><fb:like href=\"https:\/\/www.gigas-jp.com\/appnews\/archives\/8390\" layout=\"button_count\" action=\"like\" width=\"100\" share=\"false\" show_faces=\"false\" ><\/fb:like><\/div>\n            <div class=\"wsbl_facebook_send\"><div id=\"fb-root\"><\/div><fb:send href=\"https:\/\/www.gigas-jp.com\/appnews\/archives\/8390\" colorscheme=\"light\" ><\/fb:send><\/div>\n    <\/div>\n<br class='wp_social_bookmarking_light_clear' \/>\n","protected":false},"excerpt":{"rendered":"<p>Today I will talk about database and DMBS systems. Lets take a look. Database The database is a systematic col [&hellip;]<\/p>\n","protected":false},"author":18,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[100],"tags":[],"acf":[],"_links":{"self":[{"href":"https:\/\/www.gigas-jp.com\/appnews\/wp-json\/wp\/v2\/posts\/8390"}],"collection":[{"href":"https:\/\/www.gigas-jp.com\/appnews\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gigas-jp.com\/appnews\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gigas-jp.com\/appnews\/wp-json\/wp\/v2\/users\/18"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gigas-jp.com\/appnews\/wp-json\/wp\/v2\/comments?post=8390"}],"version-history":[{"count":7,"href":"https:\/\/www.gigas-jp.com\/appnews\/wp-json\/wp\/v2\/posts\/8390\/revisions"}],"predecessor-version":[{"id":8401,"href":"https:\/\/www.gigas-jp.com\/appnews\/wp-json\/wp\/v2\/posts\/8390\/revisions\/8401"}],"wp:attachment":[{"href":"https:\/\/www.gigas-jp.com\/appnews\/wp-json\/wp\/v2\/media?parent=8390"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gigas-jp.com\/appnews\/wp-json\/wp\/v2\/categories?post=8390"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gigas-jp.com\/appnews\/wp-json\/wp\/v2\/tags?post=8390"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}