{"id":54,"date":"2017-02-13T16:33:30","date_gmt":"2017-02-13T16:33:30","guid":{"rendered":"http:\/\/fpmgonline.com\/blog\/?p=54"},"modified":"2018-12-15T23:53:18","modified_gmt":"2018-12-15T18:23:18","slug":"dbms-rdbms-similarities-differences","status":"publish","type":"post","link":"https:\/\/www.fpmgonline.com\/blog\/dbms-rdbms-similarities-differences\/","title":{"rendered":"DBMS and RDBMS &#8211; Similarities And Differences"},"content":{"rendered":"<p>In this article, we will first understand what a Database Management System (DBMS) really is and how it is helpful in dealing with databases. Then, we will look at what a Relational\u00a0Database Management System (RDBMS) and the <strong>differences between DBMS and RDBMS<\/strong>.<\/p>\n<p><!--more--><\/p>\n<h2>Database Management System (DBMS)<\/h2>\n<p>A Database Management System (DBMS) plays the\u00a0role of providing a user with the capability to interact with the data as needed, by acting as an intermediary interface. When it comes to interacting with a database, there are essentially four core basic ways of interacting with the data, best represented with the acronym CRUD where:<\/p>\n<ul>\n<li>C stands for Create<\/li>\n<li>R\u00a0stands for Read<\/li>\n<li>U\u00a0stands for Update<\/li>\n<li>D\u00a0stands for Delete<\/li>\n<\/ul>\n<p>So in other words, a DBMS\u00a0provides ways for software developers and system users to easily Create, Read, Update and Delete data from a database. This helps ensure that the data is easily accessible.and is organized consistently in a database.<\/p>\n<h2>Technical elements of a DBMS:<\/h2>\n<p>In the earlier paragraph, we have seen how a DBMS helps a user. Now, let us take a quick look at how it achieves this technically. \u00a0A DBMS is responsible for managing three vital elements. They are the:<\/p>\n<ul>\n<li>Database engine<\/li>\n<li>Database schema<\/li>\n<li>Data<\/li>\n<\/ul>\n<p>The Database engine helps in accessing data, modifying data and locking up the data while modification to ensure data integrity.<\/p>\n<p>Database schema provides the logical structure of the database.<\/p>\n<p>Data is the actual data that is being stored in the database.<\/p>\n<p>Apart from the main tasks as mentioned above, as data can be accessed by multiple users from multiple locations at the same time, a DBMS streamlines the data view in systematic and organized manner while maintaining the integrity of the data.<\/p>\n<p>DMBS can also help in performing other administrative tasks such as database backup and recovery, performance tuning and monitoring, data rollbacks\u00a0in an event existing data is compromised, activity logging and much more.<\/p>\n<p>A DBMS also helps make the data available only to specific authorized users and hides it from unauthorized users. It does this by providing us with Application Programming Interface (API) for the database. \u00a0This makes it practically feasible for software developers to focus on developing the software rather than worrying about how the data is stored and managed internally.<\/p>\n<h2>Relational Database Management System (RDBMS)<\/h2>\n<p>Relational Database Management Systems (RDBMS) were introduced because navigational databases could not be \u201csearched\u201d for data. It included the integration of the navigational model, along with a tabular and hierarchical model. It takes much experience and time to build an RDBMS because of their structure, but they are also more secure. They also impose certain restrictions that may not allow you to manipulate data in a way that compromises the system integrity. It achieves this target by implementing an API called SQL. SQL\u00a0is a standard programming language for defining, protecting and accessing data in an RDBMS.<\/p>\n<h2>Differences between DBMS and RDBMS<\/h2>\n<table class=\"table table-bordered\" style=\"width: 100%;\">\n<tbody>\n<tr>\n<td style=\"width: 375.65px; text-align: center;\"><strong>DBMS<\/strong><\/td>\n<td style=\"width: 422.35px; text-align: center;\"><strong>RDBMS<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 375.65px;\">Data is stored in files.<\/td>\n<td style=\"width: 422.35px;\">Data is stored in a tabular format.<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 375.65px;\">Data is stored in either a hierarchical form or a navigational form.<\/td>\n<td style=\"width: 422.35px;\">Data is stored in table rows. The tables have an identifier called primary key and the data values are stored in rows against the specific columns.<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 375.65px;\">\u00a0Data cannot be normalized.<\/td>\n<td style=\"width: 422.35px;\">\u00a0Data can be normalized.<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 375.65px;\">\u00a0Does not apply any security with regards to data integrity.<\/td>\n<td style=\"width: 422.35px;\">\u00a0Applies security restrictions by means of defining the integrity constraint.<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 375.65px;\">DBMS generally does not have tables. Even if they do, the tables do not have any relation between them.<\/td>\n<td style=\"width: 422.35px;\">Data is stored in tables and the tables can have a single or multiple relations between them.<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 375.65px;\">Examples: XML, File system, etc.<\/td>\n<td style=\"width: 422.35px;\">Examples: PostgreSQL, MySQL, SQLite, Oracle, etc.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2>Conslusion<\/h2>\n<p>From our discussion above, we have just seen what <strong>Database Management System (DBMS)<\/strong> and <strong>Relational Database Management System (RDBMS)<\/strong> are at their core and the differences between them. Moving forward, we will be exploring more on the basis of using MySQL as a RDBMS solution.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this article, we will first understand what a Database Management System (DBMS) really is and how it is helpful in dealing with databases. Then, we will look at what a Relational\u00a0Database Management System (RDBMS) and the differences between DBMS and RDBMS.<\/p>\n","protected":false},"author":1,"featured_media":232,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_analytify_skip_tracking":false,"footnotes":""},"categories":[6],"tags":[5,8],"post_mailing_queue_ids":[],"_links":{"self":[{"href":"https:\/\/www.fpmgonline.com\/blog\/wp-json\/wp\/v2\/posts\/54"}],"collection":[{"href":"https:\/\/www.fpmgonline.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fpmgonline.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fpmgonline.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fpmgonline.com\/blog\/wp-json\/wp\/v2\/comments?post=54"}],"version-history":[{"count":1,"href":"https:\/\/www.fpmgonline.com\/blog\/wp-json\/wp\/v2\/posts\/54\/revisions"}],"predecessor-version":[{"id":356,"href":"https:\/\/www.fpmgonline.com\/blog\/wp-json\/wp\/v2\/posts\/54\/revisions\/356"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fpmgonline.com\/blog\/wp-json\/wp\/v2\/media\/232"}],"wp:attachment":[{"href":"https:\/\/www.fpmgonline.com\/blog\/wp-json\/wp\/v2\/media?parent=54"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fpmgonline.com\/blog\/wp-json\/wp\/v2\/categories?post=54"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fpmgonline.com\/blog\/wp-json\/wp\/v2\/tags?post=54"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}